public static DataTable GetuserSys()
{
string strSql = "select UserName'用户',UserPhone'电话',UserSys'模块权限',OtherSys'其他权限',DoTime'入职时间',Bz'备注',id from M_User order by id";
DataTable dt = SQLHelper.ExcuteTable(strSql);
return(dt);
}
public static DataTable GetInfoCheck()
{
string strSql = "select * from M_GenSetInfoCheck";
DataTable dt = SQLHelper.ExcuteTable(strSql);
return(dt);
}
public static DataTable GetMenuSet()
{
string strStr = "select ModuleName from M_MouduleMain order by Moduleid";
DataTable dt = SQLHelper.ExcuteTable(strStr);
return(dt);
}
public static DataTable IsGetMenuSet()
{
string strStr = "select * from M_MouduleMain";
DataTable dt = SQLHelper.ExcuteTable(strStr);
return(dt);
}
public static DataTable GetModulezhname()
{
string strStr = "select ModuleChName from M_Moudule order by id";
DataTable dt = SQLHelper.ExcuteTable(strStr);
return(dt);
}
public static DataTable GetContenPageSet()
{
string strSql = "select * from M_ContenPageSet order by id";
DataTable dt = SQLHelper.ExcuteTable(strSql);
return(dt);
}
public static void SeleModule()
{
DataTable dt = null;
string strSql = "select * from M_Moudule where ModuleChName=@ModuleChName";
SqlParameter p1 = new SqlParameter("@ModuleChName", T_addModule.T_moduleChName);
dt = SQLHelper.ExcuteTable(strSql, p1);
if (dt.Rows.Count > 0)
{
foreach (DataRow dr in dt.Rows)
{
T_addModule.T_moduleName = DESEncrypt.DesDecrypt(dr["ModuleName"].ToString());
T_addModule.T_moduleChName = dr["ModuleChName"].ToString();
T_addModule.T_moduleFileName = DESEncrypt.DesDecrypt(dr["ModuleFileName"].ToString());
T_addModule.T_moduleInt = dr["ModuleInt"].ToString();
T_addModule.T_moduleImgIdx = Convert.ToInt32(dr["ModuleImgIdx"].ToString());
}
return;
}
T_addModule.T_moduleName = "";
T_addModule.T_moduleChName = "";
T_addModule.T_moduleFileName = "";
T_addModule.T_moduleInt = "";
T_addModule.T_moduleImgIdx = 0;
}
public static DataTable GetInfoenterSql()
{
string strSql = "select * from M_GetSetLsInfo ";
DataTable dt = SQLHelper.ExcuteTable(strSql);
return(dt);
}
public static DataTable GetGensetPrint()
{
string strSql = "select * from M_genset ";
DataTable dt = SQLHelper.ExcuteTable(strSql);
return(dt);
}
public static void GetHouseGuiCs()
{
try {
string strSql = "select * from M_HouseSet where Houseid=@HouseID and HouseGui=@HouseGui";
SqlParameter p1 = new SqlParameter("@HouseID", V_HouseSetCs.Houseid);
SqlParameter p2 = new SqlParameter("@HouseGui", V_HouseSetCs.HouseGui);
DataTable dt = SQLHelper.ExcuteTable(strSql, p1, p2);
if (dt.Rows.Count > 0)
{
DataRow dr = dt.Rows[0];
V_HouseSetCs.HouseCol = Convert.ToInt32(dr["HouseCol"].ToString());
V_HouseSetCs.HouseRow = Convert.ToInt32(dr["HouseRow"].ToString());
V_HouseSetCs.Housebox = Convert.ToInt32(dr["HoseBoxCount"].ToString());
V_HouseSetCs.Housejuan = Convert.ToInt32(dr["HouseJuan"].ToString());
V_HouseSetCs.HouseboxMax = Convert.ToInt32(dr["MAXBOXSN"].ToString());
return;
}
V_HouseSetCs.HouseCol = 0;
V_HouseSetCs.HouseRow = 0;
V_HouseSetCs.Housebox = 0;
V_HouseSetCs.Housejuan = 0;
V_HouseSetCs.HouseboxMax = 0;
} catch {
V_HouseSetCs.HouseCol = 0;
V_HouseSetCs.HouseRow = 0;
V_HouseSetCs.Housebox = 0;
V_HouseSetCs.Housejuan = 0;
V_HouseSetCs.HouseboxMax = 0;
}
}
public static DataTable GetDataSplitExporTable()
{
string strSql = "select * from M_GenSetDataSplitTable";
DataTable dt = SQLHelper.ExcuteTable(strSql);
return(dt);
}
public static DataTable GetHouseName()
{
string strSql = "select id,HouseName from M_HouseName order by id";
DataTable dt = SQLHelper.ExcuteTable(strSql);
return(dt);
}
public static DataTable GetSysTable()
{
string strSql = "select * from M_sysTable ";
DataTable dt = SQLHelper.ExcuteTable(strSql);
return(dt);
}
public static DataTable GetborrTable()
{
string strSql = "select * from M_GenSetBorr ";
DataTable dt = SQLHelper.ExcuteTable(strSql);
return(dt);
}
public static DataTable GetTableName(string table)
{
string strSql = "SELECT NAME FROM SYSCOLUMNS WHERE ID = OBJECT_ID(@table)";
SqlParameter p1 = new SqlParameter("@table", table);
DataTable dt = SQLHelper.ExcuteTable(strSql, p1);
return(dt);
}
public static DataTable GetImportTable(string str)
{
string strSql = "select ImportInfoZd from M_GenSetImport where ImportTable=@table ";
SqlParameter p0 = new SqlParameter("@table", str);
DataTable dt = SQLHelper.ExcuteTable(strSql, p0);
return(dt);
}
public static DataTable GetOtherModule()
{
DataTable dt = null;
string strSql = "select OtherModule,id from M_OtherModuleSys order by id ";
dt = SQLHelper.ExcuteTable(strSql);
return(dt);
}
public static DataTable GetMenuSetid()
{
DataTable dt = null;
string strSql = "select ModuleName,Moduleid from M_MouduleMain ";
dt = SQLHelper.ExcuteTable(strSql);
return(dt);
}
public static DataTable GetModule()
{
DataTable dt = null;
string strSql = "select ModuleChName,ModuleInt from M_Moudule order by id ";
dt = SQLHelper.ExcuteTable(strSql);
return(dt);
}
public static DataTable GetUser()
{
DataTable dt = null;
string strSql = "select id,UserName,UserSys,OtherSys,Usermenu from M_User ";
dt = SQLHelper.ExcuteTable(strSql);
return(dt);
}
public static bool isHouseData()
{
string strSqlcz = "select top 1 HouseID from M_HouseSet where HouseID=@HouseID ";
SqlParameter p1 = new SqlParameter("@HouseID", V_HouseName.HouseSetid);
DataTable dt = SQLHelper.ExcuteTable(strSqlcz, p1);
if (dt.Rows.Count > 0)
{
return(true);
}
return(false);
}
public static DataTable GetConten(string moduel)
{
string strSql = "select * from M_GenSetConten where ContenModule=@table";
SqlParameter p0 = new SqlParameter("@table", moduel);
DataTable dt = SQLHelper.ExcuteTable(strSql, p0);
if (dt == null || dt.Rows.Count <= 0)
{
strSql = "select * from M_GenSetConten";
dt = SQLHelper.ExcuteTable(strSql);
}
return(dt);
}
public static DataTable GetHouseGui(int id)
{
DataTable dt = null;
try {
string strSql = "select * from M_HouseSet where Houseid=@HouseID order by HouseGui";
SqlParameter p1 = new SqlParameter("@HouseID", id);
dt = SQLHelper.ExcuteTable(strSql, p1);
return(dt);
} catch {
return(null);
}
}
public static DataTable IsGetModule(int id)
{
DataTable dt = null;
string strSql = "";
if (id == 0)
{
strSql = "select * from V_Getmodule order by id ";
}
else
{
strSql = "select * from V_Getmodule where ModuleSys is null order by id ";
}
dt = SQLHelper.ExcuteTable(strSql);
return(dt);
}
public static void SeleModuleSofte()
{
DataTable dt = null;
string strSql = "select * from M_Soid where Msoid=@Msoid";
SqlParameter p1 = new SqlParameter("@Msoid", T_addModule.T_id);
dt = SQLHelper.ExcuteTable(strSql, p1);
if (dt.Rows.Count > 0)
{
DataRow dr = dt.Rows[0];
T_addModule.T_sn = dr["Msosn"].ToString();
T_addModule.T_time = dr["Msotm"].ToString();
return;
}
T_addModule.T_sn = "";
T_addModule.T_time = "";
}
public static void Getsoid(string str)
{
try {
string strSql = "select * from M_soid where Msoid=@Msoid";
SqlParameter p1 = new SqlParameter("@Msoid", str);
DataTable dt = SQLHelper.ExcuteTable(strSql, p1);
if (dt.Rows.Count > 0)
{
DataRow dr = dt.Rows[0];
T_ConFigure.Mosn = dr["Msosn"].ToString();
T_ConFigure.Motm = dr["Msotm"].ToString();
T_ConFigure.Mwtime = dr["Mwtime"].ToString();
return;
}
T_ConFigure.Mosn = "";
T_ConFigure.Motm = "";
T_ConFigure.Mwtime = "";
} catch {
T_ConFigure.Mosn = "";
T_ConFigure.Motm = "";
T_ConFigure.Mwtime = "";
}
}
