public static DataSet SelectInfoById(string UserId)
{
SqlParameter[] para = new SqlParameter[1];
para[0] = new SqlParameter("@userid", UserId);
return(DbAccess.DataAdapterByCmd(CommandType.StoredProcedure, "Users_SelectInfoByUserId", para));
}
//select all moduleID
public static DataSet SelectAllModuleID(string IsWeb)
{
SqlParameter[] para = new SqlParameter[1];
para[0] = new SqlParameter("@IsWeb", IsWeb);
return(DbAccess.DataAdapterByCmd(CommandType.StoredProcedure, "Module_SelectAllModuleID", para));
}
//Select MainPageRule by groupID
public static DataSet SelectRuleForMainForm(string groupID)
{
SqlParameter[] para = new SqlParameter[1];
para[0] = new SqlParameter("groupID", groupID);
return(DbAccess.DataAdapterByCmd(CommandType.StoredProcedure, "GroupPermission_SelectRuleForMainForm", para));
}
public static DataSet SelectInfoByKey(string mID)
{
SqlParameter[] para = new SqlParameter[1];
para[0] = new SqlParameter("@mID", mID);
return(DbAccess.DataAdapterByCmd(CommandType.StoredProcedure, "Module_SelectInfoByKey", para));
}
public static Dictionary <string, bool> QMS_SelectRulesForForm(string post, string menuName)
{
Dictionary <string, bool> dictionary = new Dictionary <string, bool>();
SqlParameter[] para = new SqlParameter[2];
para[0] = new SqlParameter("@post", post);
para[1] = new SqlParameter("@menuName", menuName);
DataTable dt = DbAccess.DataAdapterByCmd(CommandType.StoredProcedure, "QMS_SelectRulesForForm", para).Tables[0];
if (dt.Rows.Count > 0)
{
for (int i = 0; i < dt.Columns.Count; i++)
{
dictionary.Add(dt.Columns[i].ColumnName, (bool)dt.Rows[0][i]);
}
}
else
{
dictionary.Add("hasQuery", false);
dictionary.Add("hasInsert", false);
dictionary.Add("hasUpdate", false);
dictionary.Add("hasDelete", false);
dictionary.Add("hasPrint", false);
dictionary.Add("hasAudit", false); // hasQuery,hasInsert,hasUpdate,hasDelete,hasPrint,hasAudit
}
return(dictionary);
}
///////////////////////////////////////////////////////
//// 以下是自定义的方法
//////////////////////////////////////////////////////
//select userInfo by DeptId
public static DataSet SelectUsersByGroupId(string groupId, string deptid)
{
SqlParameter[] para = new SqlParameter[2];
para[0] = new SqlParameter("@groupid", groupId);
para[1] = new SqlParameter("@deptid", deptid);
return(DbAccess.DataAdapterByCmd(CommandType.StoredProcedure, "Users_SelectUsersByGroupId", para));
}
public static DataSet User_login(string userId, string password)
{
SqlParameter[] para = new SqlParameter[2];
para[0] = new SqlParameter("@userid", userId);
para[1] = new SqlParameter("@password", password);
return(DbAccess.DataAdapterByCmd(CommandType.StoredProcedure, "Users_LoginIn", para));
}
//select module by module left join on groupPemmision
public static DataSet SelectModulesByPermission(string groupID, string deptid, string IsWeb)
{
SqlParameter[] para = new SqlParameter[3];
para[0] = new SqlParameter("@groupID", groupID);
para[1] = new SqlParameter("@deptid", deptid);
para[2] = new SqlParameter("@IsWeb", IsWeb);
return(DbAccess.DataAdapterByCmd(CommandType.StoredProcedure, "Module_SelectModulesByPermission", para));
}
//select info by condition
public static DataSet SelectInfoByCondition(string mID, string mName, string IsWeb)
{
SqlParameter[] para = new SqlParameter[3];
para[0] = new SqlParameter("@mID", mID);
para[1] = new SqlParameter("@mName", mName);
para[2] = new SqlParameter("@IsWeb", IsWeb);
return(DbAccess.DataAdapterByCmd(CommandType.StoredProcedure, "Module_SelectInfoByCondition", para));
}
//select info by condition
public static DataSet SelectInfoByCondition(string deptid, string deptname, string state)
{
SqlParameter[] para = new SqlParameter[3];
para[0] = new SqlParameter("@deptid", deptid);
para[1] = new SqlParameter("@deptname", deptname);
para[2] = new SqlParameter("@state", state);
return(DbAccess.DataAdapterByCmd(CommandType.StoredProcedure, "Dept_SelectInfoByCondition", para));
}
public static DataSet SelectAll(string groupid, string deptid, string IsWeb)
{
SqlParameter[] para = new SqlParameter[3];
para[0] = new SqlParameter("@groupid", groupid);
para[1] = new SqlParameter("@deptid", deptid);
para[2] = new SqlParameter("@IsWeb", IsWeb);
return(DbAccess.DataAdapterByCmd(CommandType.StoredProcedure, "Groups_SelectAllRecord", para));
}
//select info by condition
public static DataSet SelectByConditon(string userid, string username, string deptid)
{
SqlParameter[] para = new SqlParameter[3];
para[0] = new SqlParameter("@userid", userid);
para[1] = new SqlParameter("@username", username);
para[2] = new SqlParameter("@deptid", deptid);
return(DbAccess.DataAdapterByCmd(CommandType.StoredProcedure, "Users_SelectByCondition", para));
}
public static DataSet MailOperate(string action, string dept, string username, string mailType)
{
SqlParameter[] para = new SqlParameter[9];
para[0] = new SqlParameter("@operType", action);
para[1] = new SqlParameter("@deptid", dept);
para[2] = new SqlParameter("@username", username);
para[3] = new SqlParameter("@usermail", "");
para[4] = new SqlParameter("@sendtype", "");
para[5] = new SqlParameter("@loginuser", "");
para[6] = new SqlParameter("@id", "");
para[7] = new SqlParameter("@mailType", mailType);
para[8] = new SqlParameter("@resultMsg", SqlDbType.VarChar, 200);
para[8].Direction = ParameterDirection.Output;
return(DbAccess.DataAdapterByCmd(CommandType.StoredProcedure, "SYS_ProdRepair_Mail", para));
}
public static DataSet GetProdTestInfo(string sn, string wo, string mo, string model, string shipaddress, string checkuser, string startcheckdate, string checkresult, string endcheckdate)
{
SqlParameter[] para = new SqlParameter[9];
para[0] = new SqlParameter("@sn", sn);
para[1] = new SqlParameter("@wo", wo);
para[2] = new SqlParameter("@mo", mo);
para[3] = new SqlParameter("@model", model);
para[4] = new SqlParameter("@shipaddress", shipaddress);
para[5] = new SqlParameter("@checkuser", checkuser);
para[6] = new SqlParameter("@startcheckdate", startcheckdate);
para[7] = new SqlParameter("@checkresult", checkresult);
para[8] = new SqlParameter("@endcheckdate", endcheckdate);
return(DbAccess.DataAdapterByCmd(CommandType.StoredProcedure, "SYS_ProdTest_Select", para));
}
//Select Rule by groupID & FormID
public static Dictionary <string, bool> SelectRulesForForm(string moduleID, string groupID)
{
Dictionary <string, bool> dictionary = new Dictionary <string, bool>();
SqlParameter[] para = new SqlParameter[2];
para[0] = new SqlParameter("@moduleID", moduleID);
para[1] = new SqlParameter("@groupID", groupID);
DataTable dt = DbAccess.DataAdapterByCmd(CommandType.StoredProcedure, "GroupPermission_SelectRulesForForm", para).Tables[0];
if (dt.Rows.Count > 0)
{
for (int i = 0; i < dt.Columns.Count; i++)
{
dictionary.Add(dt.Columns[i].ColumnName, (bool)dt.Rows[0][i]);
}
}
return(dictionary);
}
//select all information
public static DataSet SelectAll()
{
return(DbAccess.DataAdapterByCmd(CommandType.StoredProcedure, "Module_SelectAll", null));
}
//选择生产部门
public static DataSet SelectProductDept()
{
return(DbAccess.DataAdapterByCmd(CommandType.Text, "select deptid,deptname from dept where state='Y'", null));
}
