//更新车间信息 public static int UpdateSingleOrgan(int _ID, int _OrganType, string[] FieldValues) { string sSqlText = ""; if (_ID > 0) { sSqlText = "begin UPDATE SysOrgan_Info SET OrganType=" + _OrganType.ToString() + ",POrganID=" + FieldValues.GetValue(0) + ", OrganNo='" + FieldValues.GetValue(1) + "',OrganName='" + FieldValues.GetValue(2) + "',Description='" + FieldValues.GetValue(3) + "'"; sSqlText = sSqlText + ",SortID=" + FieldValues.GetValue(4) + " WHERE ID=" + _ID + "" + ";"; string sLogText = "更新 人员管理>机构部门:" + FieldValues.GetValue(2) + "记录。"; sSqlText += SysLogs.GetOperatorLogSQL(sLogText) + " end;"; } else { sSqlText = "begin Insert Into SysOrgan_Info (SystemID, OrganType, POrganID, OrganNo, OrganName, Description, SortID) Values(" + SysParams.GetPurviewSystemID().ToString() + "," + _OrganType.ToString() + "," + FieldValues.GetValue(0) + ",'" + FieldValues.GetValue(1) + "','" + FieldValues.GetValue(2) + "','" + FieldValues.GetValue(3) + "'," + FieldValues.GetValue(4) + ")" + ";"; string sLogText = "新增 人员管理>机构部门:" + FieldValues.GetValue(2) + "记录。"; sSqlText = sSqlText + SysLogs.GetOperatorLogSQL(sLogText) + " End;"; } //Del by lk 20151214 start //sSqlText += "Insert Into ToolStock_Info (OrganID, ToolID)" // + " select " // + " a.ID As OrganID, b.ID As ToolID from SysOrgan_Info a, Tool_Info b " // + " Where a.OrganType in (0, 1) and a.OrganNo='" + FieldValues.GetValue(1) + "' and a.OrganType in (" + OrganType_Value.ToString() + "," + WorkshopType_Value.ToString() + ")" // + " And Convert(varchar(10),a.ID) + '-' + Convert(varchar(10),b.ID) not in (" // + " Select Convert(varchar(10),a.OrganID) + '-' + Convert(varchar(10),a.ToolID) From ToolStock_Info a, SysOrgan_Info b " // + " where a.OrganID=b.ID and b.OrganNo='" + FieldValues.GetValue(1) + "')"; //Del by lk 20151214 end return(DataCommon.QueryData(sSqlText)); }
public static int UpdateSinglePrefixCode(int ID, string[] FieldValues) { string sSqlText = ""; if (ID > 0) { sSqlText = "begin update SysPrefixCode_Info set CodeName='" + FieldValues.GetValue(0) + "',TableName='" + FieldValues[1] + "" + "',PrefixCode='" + FieldValues[2] + "" + "',Description='" + FieldValues[3] + "'" + " WHERE ID =" + ID + ";"; string sLogText = "更新 系统管理>单号前缀管理:单号前缀列表:" + FieldValues.GetValue(0) + "记录。"; sSqlText += SysLogs.GetOperatorLogSQL(sLogText) + " end;"; } else { sSqlText = "begin Insert Into SysPrefixCode_Info(SystemID, CodeName, TableName, PrefixCode, Description)Values(" + SysParams.GetPurviewSystemID().ToString() + ",'" + FieldValues.GetValue(0) + "','" + FieldValues.GetValue(1) + "','" + FieldValues.GetValue(2) + "','" + FieldValues.GetValue(3) + "')" + ";"; string sLogText = "新增 系统管理>单号前缀管理:单号前缀列表:" + FieldValues.GetValue(0) + "记录。"; sSqlText = sSqlText + SysLogs.GetOperatorLogSQL(sLogText) + " End;"; } return(DataCommon.QueryData(sSqlText)); }
//更新添加无线电台档案信息 public static int UpdateSingleTools(int _ID, string[] FieldValues) { string sSqlText = ""; if (_ID > 0) { sSqlText = "begin UPDATE Tool_Info SET ToolNo='" + FieldValues.GetValue(0) + "',ToolName='" + FieldValues.GetValue(1) + "',Specification='" + FieldValues.GetValue(2) + "',MaterialCode='" + FieldValues.GetValue(3) + "',Unit='" + FieldValues.GetValue(4) + "',AliasesName='" + FieldValues.GetValue(5) + "',Description='" + FieldValues.GetValue(6) + "'"; sSqlText = sSqlText + ",SystemID=" + FieldValues.GetValue(7) + " WHERE ID=" + _ID + "" + ";"; string sLogText = "更新 人员管理>机构部门:" + FieldValues.GetValue(2) + "记录。"; sSqlText += SysLogs.GetOperatorLogSQL(sLogText) + " end;"; } else { sSqlText = "begin Insert Into Tool_Info ( ToolNo, ToolName, AliasesName, Specification,MaterialCode,Unit,Description,SystemID) Values('" + FieldValues.GetValue(0) + "','" + FieldValues.GetValue(1) + "','" + FieldValues.GetValue(5) + "','" + FieldValues.GetValue(2) + "','" + FieldValues.GetValue(3) + "','" + FieldValues.GetValue(4) + "','" + FieldValues.GetValue(6) + "'," + FieldValues.GetValue(7) + ")" + ";"; string sLogText = "新增 人员管理>机构部门:" + FieldValues.GetValue(2) + "记录。"; sSqlText = sSqlText + SysLogs.GetOperatorLogSQL(sLogText) + " End;"; } return(DataCommon.QueryData(sSqlText)); }
public static int DeleteRoleUser(int _ID)//=== { string sSQL = "begin Delete from SysRole_Info Where Status =0 And ID=" + _ID.ToString() + "; "; string sLogText = "删除 系统管理>角色下属人员:" + _ID.ToString() + "的记录。"; sSQL = sSQL + SysLogs.GetOperatorLogSQL(sLogText) + " End;"; return(DataCommon.QueryData(sSQL)); }
//锁定用户登录 public static int StopUserByUser(int UserID) { string sSqlText = "begin UPDATE SysUser_Info SET IsCanLogin=0 WHERE ID=" + UserID + "; "; string sLogText = "系统管理>权限管理> 锁定用户: " + UserID.ToString() + " 登录。"; sSqlText = sSqlText + SysLogs.GetOperatorLogSQL(sLogText) + " End;"; return(DataCommon.QueryData(sSqlText)); }
//锁定用户登录 public static int StopCustomByCustom(int CustomID) { string sSqlText = "begin UPDATE SysCustomField_Info SET IsCanLogin=0 WHERE ID=" + CustomID + "; "; string sLogText = "系统管理>权限管理> 锁定用户: " + CustomID.ToString() + " 登录。"; sSqlText = sSqlText + SysLogs.GetOperatorLogSQL(sLogText) + " End;"; return(DataCommon.QueryData(sSqlText)); }
public static int DeleteMainDictionaries(int _ID) { string sSQL = "begin Delete from SysBaseDetail_Info Where Status=0 And ID=" + _ID.ToString() + "; "; string sLogText = "删除 系统管理>人员管理 机构部门:ID:" + _ID.ToString() + "的记录。"; sSQL = sSQL + SysLogs.GetOperatorLogSQL(sLogText) + " End;"; return(DataCommon.QueryData(sSQL)); }
public static int DeleteSingleCustom(int _ID)//=== { string sSQL = "begin Delete from SysCustomField_Info Where Status =0 And ID=" + _ID.ToString() + "; "; string sLogText = "删除 系统管理>人员管理:" + _ID.ToString() + "的记录。"; sSQL = sSQL + SysLogs.GetOperatorLogSQL(sLogText) + " End;"; return(DataCommon.QueryData(sSQL)); }
//获取单个车间信息 public static int DeleteSingleToolsNotice(int _ID) { string sSQL = "begin Delete from Notice_Info Where Status=0 And ID=" + _ID.ToString() + "; "; string sLogText = "删除 系统管理>人员管理 机构部门:ID:" + _ID.ToString() + "的记录。"; sSQL = sSQL + SysLogs.GetOperatorLogSQL(sLogText) + " End;"; return(DataCommon.QueryData(sSQL)); }
//更新用户密码 public static int UpdateCustomPassword(int CustomID, string Password) { string sSqlText = "begin UPDATE SysCustomField_Info SET Password='******' WHERE ID=" + CustomID + "; "; string sLogText = "修改登录密码。"; sSqlText = sSqlText + SysLogs.GetOperatorLogSQL(sLogText) + " End;"; return(DataCommon.QueryData(sSqlText)); }
public static int DeleteSinglePrefixCode(int _ID) { string sSQL = "begin delete from SysPrefixCode_Info where Status =0 And IsNull(SystemID,0)=" + SysParams.GetPurviewSystemID().ToString() + " and ID=" + _ID.ToString() + "; "; string sLogText = "删除 系统管理>单号前缀管理:单号前缀列表:" + _ID.ToString() + "的记录。"; sSQL = sSQL + SysLogs.GetOperatorLogSQL(sLogText) + " End;"; return(DataCommon.QueryData(sSQL)); }
//获取单个车间信息 public static int DeleteSinglePackTools(int _IDs) { string sSQL = "begin Delete from Tool_Info Where Status=0 And ID in (" + _IDs.ToString() + "); "; sSQL = sSQL + " Delete from ToolMember_Info Where Status=0 And PackToolID in (" + _IDs.ToString() + ");"; sSQL += " Delete From ToolStock_Info Where ToolID in (" + _IDs.ToString() + ");"; string sLogText = "删除 系统管理>人员管理 机构部门:ID:" + _IDs.ToString() + "的记录。"; sSQL = sSQL + SysLogs.GetOperatorLogSQL(sLogText) + " End;"; return(DataCommon.QueryData(sSQL)); }
//删除部门 public static int DeleteSingleOrgan(string _IDs) { string sSQL = "begin Delete from SysOrgan_Info Where Status=0 "//And IsNull(SystemID,0)=" + SysParams.GetPurviewSystemID().ToString() + " And ID in (" + _IDs.ToString() + "); "; //Del by lk 20151214 start //sSQL += " Delete From ToolStock_Info Where OrganID in (" + _IDs.ToString() + ")"; //Del by lk 20151214 end string sLogText = "删除 系统管理>人员管理 机构部门:ID:" + _IDs.ToString() + "的记录。"; sSQL = sSQL + SysLogs.GetOperatorLogSQL(sLogText) + " End;"; return(DataCommon.QueryData(sSQL)); }
//系统登录 public static bool UserLogin(string sOpCode, string sPassword, System.Web.SessionState.HttpSessionState hsSession) { bool bSuccess = false; SqlDataReader sda = GetUserLogin(sOpCode, sPassword); if (sda.Read()) { UserInfo info = new UserInfo(); info.UserID = int.Parse(sda["ID"].ToString()); info.OpGuid = sda["Guid"].ToString(); info.OpCode = sda["OpCode"].ToString(); info.OpName = sda["OpName"].ToString(); //权限移到选择系统界面 //info.UserRolePurview = GetPurviewByUserID(info.UserID); info.Purview = info.UserRolePurview; info.UserRoles = sda["UserRoles"].ToString(); info.IsAdmin = sda["IsAdmin"].ToString() == "1"; if (sda["LastDate"].ToString().Length > 0) { info.LastDate = DateTime.Parse(sda["LastDate"].ToString()).ToString("yyyy年MM月dd日 HH:mm:ss"); } //info.PurviewSystemID = 0; info.LastIp = sda["LastIP"].ToString(); info.LastComputerName = sda["LastComputerName"].ToString(); if (sda["OrganID"].ToString().Length > 0) { info.OrganID = SysClass.SysOrgan.GetWorkShopByOrganID(int.Parse(sda["OrganID"].ToString())); } else { info.OrganID = SysClass.SysOrgan.GetTopOrganID(0); } CyxPack.UserCommonOperation.UserCommonOperation.StoreUserInfo(info); // string IP = HttpContext.Current.Request.UserHostAddress;//获取客户端电脑IP string IP = ""; System.Net.IPAddress[] addressList = Dns.GetHostByName(Dns.GetHostName()).AddressList; IP = addressList[0].ToString(); string ComputerName; ComputerName = System.Net.Dns.GetHostName(); //获取本地计算机的主机名 SysLogs.CreateUserLogin(info.UserID, info.OpCode, info.OpName, "用户登录系统。", IP, ComputerName); SysClass.SysGlobal.CurrentUserOrganID = SysGlobal.GetCurrentUserOrganID(); bSuccess = true; } sda.Close(); return(bSuccess); }
////更新用户信息 //public static int UpdateSingleUser(int UserID, string[] FieldValues) //{ // string sSqlText = ""; // if (UserID > 0) // { // sSqlText = "UPDATE SysUser_Info SET OpName='" // + FieldValues.GetValue(0) + "',OpCode='" // + FieldValues.GetValue(1) + "',RoleID=" // + FieldValues.GetValue(2) + ",Comment='" // + FieldValues[3] + "' WHERE ID=" + UserID; // } // else // { // sSqlText = "Insert Into SysUser_Info (OpName,OpCode,RoleID,Comment,Status, Password) Values('" // + FieldValues.GetValue(0) + "','" + FieldValues.GetValue(1) + "','" // + FieldValues.GetValue(2) + "','" + FieldValues.GetValue(3) + "'," // + "0,'111111' )"; // } // return DataCommon.QueryData(sSqlText); //} //更新用户信息 public static int UpdateSingleUserPurview(int UserID, string UserPurview) { string sSqlText = ""; sSqlText = "begin "; sSqlText = sSqlText + " if not Exists(Select 1 From User_Purview Where Status=0 And UserID=" + UserID.ToString() + ")"; sSqlText = sSqlText + " Insert into User_Purview (SystemID, UserID, Purview, SortID, Status) Values(" + SysParams.GetPurviewSystemID().ToString() + "," + UserID.ToString() + ",'" + UserPurview + "',0,0" + ");"; sSqlText = sSqlText + " else "; sSqlText = sSqlText + " Update User_Purview Set Purview='" + UserPurview + "' Where Status=0 and UserID=" + UserID.ToString() + "; "; string sLogText = " 更新 系统管理>权限管理: " + UserID.ToString() + " 记录。"; sSqlText = sSqlText + SysLogs.GetOperatorLogSQL(sLogText) + " End;"; return(DataCommon.QueryData(sSqlText)); }
public static int UpdateSingleUser(int ID, string[] FieldValues) { string sSqlText = "begin "; if (ID > 0) { sSqlText = sSqlText + "begin UPDATE SysUser_Info SET OpCode = '" + FieldValues.GetValue(0) + "',OpName='" + FieldValues.GetValue(1) + "',OrganID='" + FieldValues.GetValue(2) + "',Position='" + FieldValues.GetValue(3) + "',Place='" + FieldValues.GetValue(4) + "',Sex='" + FieldValues.GetValue(5) + "',Phone='" + FieldValues.GetValue(6) + "',TelNo='" + FieldValues.GetValue(7) + "',Address='" + FieldValues.GetValue(8) + "',UserDesc='" + FieldValues.GetValue(9) + "',IDNumber='" + FieldValues.GetValue(10) + "',ZipCode='" + FieldValues.GetValue(12) + "',IsCanLogin='******'"; sSqlText = sSqlText + " WHERE ID =" + ID + ";"; string sLogText = "更新 系统管理>人员管理 :" + FieldValues.GetValue(0) + "|" + FieldValues.GetValue(1) + " 记录。"; sSqlText = sSqlText + SysLogs.GetOperatorLogSQL(sLogText) + " End;"; } else { sSqlText = sSqlText + "begin Insert Into SysUser_Info(SystemID, Guid, OpCode, OpName," + " OrganID,Position,Place,Sex,Phone,TelNo,Address,UserDesc,IDNumber,Password,ZipCode, IsCanLogin, Status) " + " Values(" + SysParams.GetPurviewSystemID().ToString() + ",'" + FieldValues.GetValue(13) + "','" + FieldValues.GetValue(0) + "','" + FieldValues.GetValue(1) + "','" + FieldValues.GetValue(2) + "','" + FieldValues.GetValue(3) + "','" + FieldValues.GetValue(4) + "','" + FieldValues.GetValue(5) + "','" + FieldValues.GetValue(6) + "','" + FieldValues.GetValue(7) + "','" + FieldValues.GetValue(8) + "','" + FieldValues.GetValue(9) + "','" + FieldValues.GetValue(10) + "','" + FieldValues.GetValue(11) + "','" + FieldValues.GetValue(12) + "'," + FieldValues.GetValue(14); sSqlText = sSqlText + ",0 ); "; string sLogText = "新增 系统管理>人员管理 : " + FieldValues.GetValue(0) + "|" + FieldValues.GetValue(1) + " 记录。"; sSqlText = sSqlText + SysLogs.GetOperatorLogSQL(sLogText) + " End;"; } sSqlText = sSqlText + " end"; return(DataCommon.QueryData(sSqlText)); }
//更新添加工具档案信息 public static int UpdateSingleBaseDate(int _ID, string[] FieldValues) { string sSqlText = ""; if (_ID > 0) { sSqlText = "begin UPDATE SysBaseDetail_Info SET MainNo=" + FieldValues.GetValue(0) + ", DetailNo='" + FieldValues.GetValue(1) + "',DetailName='" + FieldValues.GetValue(2) + "',Description='" + FieldValues.GetValue(3) + "'"; sSqlText = sSqlText + ",SortID=" + FieldValues.GetValue(4) + " WHERE ID=" + _ID + "" + ";"; string sLogText = "更新 人员管理>机构部门:" + FieldValues.GetValue(2) + "记录。"; sSqlText += SysLogs.GetOperatorLogSQL(sLogText) + " end;"; } else { sSqlText = "begin Insert Into SysBaseDetail_Info ( MainNo, DetailNo, DetailName, Description,SortID) Values(" + FieldValues.GetValue(0) + ",'" + FieldValues.GetValue(1) + "','" + FieldValues.GetValue(2) + "','" + FieldValues.GetValue(3) + "'," + FieldValues.GetValue(4) + ")" + ";"; string sLogText = "新增 人员管理>机构部门:" + FieldValues.GetValue(2) + "记录。"; sSqlText = sSqlText + SysLogs.GetOperatorLogSQL(sLogText) + " End;"; } return(DataCommon.QueryData(sSqlText)); }
public static int UpdateSingleRole(int ID, string[] FieldValues) { string sSqlText = ""; if (ID > 0) { sSqlText = "begin update SysRole_Info set RoleName='" + FieldValues.GetValue(0) + "',Description='" + FieldValues[1] + "" + "',Purview='" + FieldValues[2] + "'" + " WHERE ID =" + ID + ";"; string sLogText = "更新 系统管理>角色管理:角色列表:" + FieldValues.GetValue(0) + "记录。"; sSqlText += SysLogs.GetOperatorLogSQL(sLogText) + " end;"; } else { sSqlText = "begin Insert Into SysRole_Info(SystemID, RoleName,Description, Purview,Status) Values(" + SysParams.GetPurviewSystemID().ToString() + ",'" + FieldValues.GetValue(0) + "','" + FieldValues.GetValue(1) + "','" + FieldValues.GetValue(2) + "',0 )" + ";"; string sLogText = "新增 系统管理>角色管理:角色列表:" + FieldValues.GetValue(0) + "记录。"; sSqlText = sSqlText + SysLogs.GetOperatorLogSQL(sLogText) + " End;"; } return(DataCommon.QueryData(sSqlText)); }
//更新添加工具档案信息 public static int UpdateSingleTools(int _ID, string[] FieldValues) { string sSqlText = ""; if (_ID > 0) { sSqlText = "begin UPDATE Tool_Info SET CategoryID=" + FieldValues.GetValue(0) + ", ToolNo='" + FieldValues.GetValue(1) + "',ToolName='" + FieldValues.GetValue(2) + "',AliasesName='" + FieldValues.GetValue(3) + "',Specification='" + FieldValues.GetValue(4) + "',MaterialCode='" + FieldValues.GetValue(5) + "',Unit='" + FieldValues.GetValue(6) + "',PurchasePrice=" + FieldValues.GetValue(7) + ",SalesPrice=" + FieldValues.GetValue(8) + ",IsCode=" + FieldValues.GetValue(9) + ",Description='" + FieldValues.GetValue(10) + "'"; sSqlText = sSqlText + " WHERE ID=" + _ID + "" + ";"; string sLogText = "更新 人员管理>机构部门:" + FieldValues.GetValue(2) + "记录。"; sSqlText += SysLogs.GetOperatorLogSQL(sLogText) + " end;"; } else { sSqlText = "begin Insert Into Tool_Info ( CategoryID, ToolNo, ToolName, AliasesName, Specification,MaterialCode,Unit,PurchasePrice,SalesPrice,IsCode, Description) Values(" + FieldValues.GetValue(0) + ",'" + FieldValues.GetValue(1) + "','" + FieldValues.GetValue(2) + "','" + FieldValues.GetValue(3) + "','" + FieldValues.GetValue(4) + "','" + FieldValues.GetValue(5) + "','" + FieldValues.GetValue(6) + "'," + FieldValues.GetValue(7) + "," + FieldValues.GetValue(8) + "," + FieldValues.GetValue(9) + ",'" + FieldValues.GetValue(10) + "')" + ";"; string sLogText = "新增 人员管理>机构部门:" + FieldValues.GetValue(2) + "记录。"; sSqlText = sSqlText + SysLogs.GetOperatorLogSQL(sLogText) + " End;"; } sSqlText += "Insert Into ToolStock_Info (OrganID, ToolID)" + " select " + " a.ID As OrganID, b.ID As ToolID from SysOrgan_Info a, Tool_Info b " + " Where a.OrganType in (0, 1) and b.ToolNo='" + FieldValues.GetValue(1) + "'" + " And Convert(varchar(10),a.ID) + '-' + Convert(varchar(10),b.ID) not in (" + " Select Convert(varchar(10),a.OrganID) + '-' + Convert(varchar(10),a.ToolID) From ToolStock_Info a, Tool_Info b " + " where a.ToolID=b.ID and b.ToolNo='" + FieldValues.GetValue(1) + "')"; return(DataCommon.QueryData(sSqlText)); }
//更新添加工具档案信息 public static int UpdateSinglePurchaseCredit(int _ID, string[] FieldValues) { string sSqlText = ""; if (_ID > 0) { sSqlText = "begin UPDATE PurchaseCredit_Info SET OrganID=" + FieldValues.GetValue(0) + ", PurchaseYear=" + FieldValues.GetValue(1) + ",TotalCredit=" + FieldValues.GetValue(2) + ",Credit1=" + FieldValues.GetValue(3) + ",Credit2=" + FieldValues.GetValue(4) + ",Credit3=" + FieldValues.GetValue(5) + ",Credit4=" + FieldValues.GetValue(6) + ",Credit5=" + FieldValues.GetValue(7) + ",Credit6=" + FieldValues.GetValue(8) + ",Credit7=" + FieldValues.GetValue(9) + ",Credit8=" + FieldValues.GetValue(10) + ",Credit9=" + FieldValues.GetValue(11) + ",Credit10=" + FieldValues.GetValue(12) + ",Credit11=" + FieldValues.GetValue(13) + ",Credit12=" + FieldValues.GetValue(14) + ",Description='" + FieldValues.GetValue(15) + "'"; sSqlText = sSqlText + ",SortID=" + FieldValues.GetValue(10) + " WHERE ID=" + _ID + "" + ";"; string sLogText = "更新 人员管理>机构部门:" + FieldValues.GetValue(2) + "记录。"; sSqlText += SysLogs.GetOperatorLogSQL(sLogText) + " end;"; } else { sSqlText = "begin Insert Into PurchaseCredit_Info ( OrganID, PurchaseYear, TotalCredit, Credit1, Credit2, Credit3, Credit4," + " Credit5, Credit6, Credit7, Credit8, Credit9, Credit10, Credit11, Credit12, Description) Values(" + FieldValues.GetValue(0) + "," + FieldValues.GetValue(1) + "," + FieldValues.GetValue(2) + "," + FieldValues.GetValue(3) + "," + FieldValues.GetValue(4) + "," + FieldValues.GetValue(5) + "," + FieldValues.GetValue(6) + "," + FieldValues.GetValue(7) + "," + FieldValues.GetValue(8) + "," + FieldValues.GetValue(9) + "," + FieldValues.GetValue(10) + "," + FieldValues.GetValue(11) + "," + FieldValues.GetValue(12) + "," + FieldValues.GetValue(13) + "," + FieldValues.GetValue(14) + ",'" + FieldValues.GetValue(15) + "')" + ";"; string sLogText = "新增 人员管理>机构部门:" + FieldValues.GetValue(2) + "记录。"; sSqlText = sSqlText + SysLogs.GetOperatorLogSQL(sLogText) + " End;"; } return(DataCommon.QueryData(sSqlText)); }