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)); }