21 lines
764 B
C#
21 lines
764 B
C#
using System;
|
|
using System.Collections.Generic;
|
|
using System.Linq;
|
|
using System.Web;
|
|
|
|
namespace NGTools.Tools
|
|
{
|
|
public class stringSQL
|
|
{
|
|
//查询用户表格
|
|
public static string strSQL_User = "select * from user where user_Name='";
|
|
//查询主窗口的左菜单
|
|
public static string strSQL_Menu = "select * from system_menu order by showorder";
|
|
public static string strSQL_Org = "select * from organization order by ID";
|
|
public static string strSQL_Org_Parent_ID = "select * from organization where org_parent_id='";
|
|
public static string strSQL_Device_Type = "select * from Device_Type order by parent_ID, showOrder";
|
|
public static string strSQL_Device_Type_Parent_ID = "select * from Device_Type where parent_id='";
|
|
|
|
|
|
}
|
|
} |