//更新用户密码 public static Boolean CheckUserNoExists(int _ID, string OpCode) { string sSqlText = "Select 1 From SysUser_Info Where OpCode='" + OpCode + "' "//And IsNull(SystemID,0)=" + SysParams.GetPurviewSystemID().ToString() + " And ID<>" + _ID.ToString(); return(SysGlobal.GetExecSqlIsExist(sSqlText)); }
public static Boolean CheckBackTestNoExists(int BackTestID, string BackTestNo) { string sSqlText = "Select 1 From BackTest_Info " + " Where BackTestNo='" + BackTestNo + "' And ID<>" + BackTestID.ToString(); return(SysGlobal.GetExecSqlIsExist(sSqlText)); }
public static Boolean CheckConsumeNoExists(int ConsumeID, string ConsumeNo) { string sSqlText = "Select 1 From InterPhoneInspection_Info Where ConsumeType=" + ConsumeType_ConsumeValue.ToString() + " And ConsumeNo='" + ConsumeNo + "' And ID<>" + ConsumeID.ToString(); return(SysGlobal.GetExecSqlIsExist(sSqlText)); }
public static Boolean CheckBorrowNoExists(int ConsumeID, string ConsumeNo) { string sSqlText = "Select 1 From Consume_Info Where ConsumeType=" + ConsumeType_BorrowValue.ToString() + " And ConsumeNo='" + ConsumeNo + "' And ID<>" + ConsumeID.ToString(); return(SysGlobal.GetExecSqlIsExist(sSqlText)); }
//判断机构编号是否重复 public static Boolean CheckOrganNoExists(int OrganID, string OrganNo) { string sSqlText = "Select 1 From SysOrgan_Info Where OrganNo='" + OrganNo //+ "' And IsNull(SystemID,0)=" + SysParams.GetPurviewSystemID().ToString() + "' And ID<>" + OrganID.ToString(); return(SysGlobal.GetExecSqlIsExist(sSqlText)); }
public static Boolean CheckSendServiceNoExists(int SendServiceID, string SendServiceNo) { string sSqlText = "Select 1 From SendService_Info " + " Where SendServiceNo='" + SendServiceNo + "' And ID<>" + SendServiceID.ToString(); return(SysGlobal.GetExecSqlIsExist(sSqlText)); }
public static Boolean CheckToolISNoExists(int ToolISID, string ToolISNo) { string sSqlText = "Select 1 From ToolIS_Info Where " + " ToolISNo='" + ToolISNo + "' And ID<>" + ToolISID.ToString(); return(SysGlobal.GetExecSqlIsExist(sSqlText)); }
public static Boolean CheckInventoryNoExists(int InventoryID, string InventoryNo) { string sSqlText = "Select 1 From Inventory_Info " + " Where InventoryNo='" + InventoryNo + "' And ID<>" + InventoryID.ToString(); return(SysGlobal.GetExecSqlIsExist(sSqlText)); }
//更新用户密码 public static Boolean CheckUserPassword(int UserID, string Password) { string sSqlText = "Select 1 From SysUser_Info Where "//IsNull(SystemID,0)=" + SysParams.GetPurviewSystemID().ToString() + " Password='******' And ID=" + UserID; return(SysGlobal.GetExecSqlIsExist(sSqlText)); }
//判断预案编号已被使用 public static bool CheckRoleIsUse(int RoleID) { string sSqlText = "Select top 1 1 From User_Info Where Status=0 "//And IsNull(SystemID,0)=" + SysParams.GetPurviewSystemID().ToString() + " And ','+UserRoles+',' Like '%," + RoleID.ToString() + ",%'"; return(SysGlobal.GetExecSqlIsExist(sSqlText)); }
public static Boolean CheckToolOutNoExists(int ToolOutID, string ToolOutNo) { string sSqlText = "Select 1 From ToolOut_Info Where ToolOutType=" + ToolOutType_ToolOutValue.ToString() + " And ToolOutNo='" + ToolOutNo + "' And ID<>" + ToolOutID.ToString(); return(SysGlobal.GetExecSqlIsExist(sSqlText)); }
public static Boolean CheckUserSalaryNoExists(int UserSalaryID, string UserSalaryNo) { string sSqlText = "Select 1 From UserSalary_Info Where UserSalaryType=" + UserSalaryType_UserSalaryValue.ToString() + " And UserSalaryNo='" + UserSalaryNo + "' And ID<>" + UserSalaryID.ToString(); return(SysGlobal.GetExecSqlIsExist(sSqlText)); }
//获取角色是否重复 public static bool CheckRoleNameExists(int ID, string RoleName) { string sSqlText = "select 1 from SysRole_Info where "//IsNull(SystemID,0)=" + SysParams.GetPurviewSystemID().ToString() + " RoleName ='" + RoleName.ToString() + "' and ID<>" + ID.ToString(); return(SysGlobal.GetExecSqlIsExist(sSqlText)); }
//判断机构编号已被使用 public static bool CheckToolsCategoryIsUse(int CategoryID) { string sSqlText = "Select top 1 1 From User_Info Where Status=0 And CategoryID=" + CategoryID.ToString() + " union all " + " Select top 1 1 From ToolCategory_Info Where Status=0 And PCategoryID=" + CategoryID.ToString(); return(SysGlobal.GetExecSqlIsExist(sSqlText)); }
//判断机构编号已被使用 public static bool CheckToolsNoticeIsUse(int NoticeID) { string sSqlText = "Select top 1 1 From User_Info Where Status=0 And NoticeID=" + NoticeID.ToString() + " union all " + " Select top 1 1 From Notice_Info Where Status=0 And PNoticeID=" + NoticeID.ToString(); return(SysGlobal.GetExecSqlIsExist(sSqlText)); }
//判断机构编号已被使用 public static bool CheckOrganIsUse(int OrganID) { string sSqlText = "Select top 1 1 From User_Info Where Status=0 "//And IsNull(SystemID,0)=" + SysParams.GetPurviewSystemID().ToString() + " And OrganID=" + OrganID.ToString() + " union all " + " Select top 1 1 From SysOrgan_Info Where Status=0"// And IsNull(SystemID,0)=" + SysParams.GetPurviewSystemID().ToString() + " And POrganID=" + OrganID.ToString(); return(SysGlobal.GetExecSqlIsExist(sSqlText)); }
public static Boolean CheckDeliveryNoExists(int DeliveryID, string DeliveryNo) { string sSqlText = "Select 1 From Delivery_Info Where DeliveryNo='" + DeliveryNo + "' And ID<>" + DeliveryID.ToString(); return(SysGlobal.GetExecSqlIsExist(sSqlText)); }
//更新用户密码 public static Boolean CheckCustomNoExists(int _ID, string OpCode) { string sSqlText = "Select 1 From SysCustomField_Info Where OpCode='" + OpCode + "' And ID<>" + _ID.ToString(); return(SysGlobal.GetExecSqlIsExist(sSqlText)); }
//更新用户密码 public static Boolean CheckFieldNameExists(int CustomID, string TableNo, string FieldName) { string sSqlText = "Select 1 From SysCustomField_Info Where TableNo='" + TableNo + "' And FieldName='" + FieldName + "' And ID<>" + CustomID; return(SysGlobal.GetExecSqlIsExist(sSqlText)); }
//更新用户密码 public static Boolean CheckCustomPassword(int CustomID, string Password) { string sSqlText = "Select 1 From SysCustomField_Info Where Password='******' And ID=" + CustomID; return(SysGlobal.GetExecSqlIsExist(sSqlText)); }
//更新用户密码 public static Boolean CheckCustomLoginPassword(string OpCode, string Password) { string sSqlText = "Select 1 From SysCustomField_Info Where Password='******' And OpCode='" + OpCode + "'"; return(SysGlobal.GetExecSqlIsExist(sSqlText)); }
//判断工具编号是否重复 public static Boolean CheckPackToolNoExists(int CategoryID, string ToolID) { string sSqlText = "Select 1 From Tool_Info Where ToolType = " + _PackToolType.ToString() + " And ToolNo='" + ToolID + "' And ID<>" + CategoryID.ToString(); return(SysGlobal.GetExecSqlIsExist(sSqlText)); }
//查询无线电台编号是否重复 public static Boolean CheckInterlOrderNoExistsOrder(int _OrderID, string OrderNo) { string sSqlText = "Select 1 From InListdetails_Info Where InListID<>" + _OrderID.ToString() + " And InterID='" + OrderNo + "'"; return(SysGlobal.GetExecSqlIsExist(sSqlText)); }
//判断单号是否重复 public static Boolean CheckInterlOrderNoExists(int OrderID, string OrderNo) { string sSqlText = "Select 1 From InterPhoneOrder_Info Where OrderNo='" + OrderNo + "' And ID<>" + OrderID.ToString(); return(SysGlobal.GetExecSqlIsExist(sSqlText)); }
//判断工具编号是否重复 public static Boolean CheckMainNoExists(int MainID, string MainNo) { string sSqlText = "Select 1 From SysBaseDetail_Info Where MainNo='" + MainNo + "' And ID<>" + MainID.ToString(); return(SysGlobal.GetExecSqlIsExist(sSqlText)); }
//判断机构编号是否重复 public static Boolean CheckCategoryNoExists(int CategoryID, string CategoryNo) { string sSqlText = "Select 1 From ToolCategory_Info Where CategoryNo='" + CategoryNo + "' And ID<>" + CategoryID.ToString(); return(SysGlobal.GetExecSqlIsExist(sSqlText)); }
public static bool CheckCanDeleteUser(String _IDs) { string sSqlText = "select top 1 1 from SysUser_Info a, UserSalary_Info b where a.OpCode=b.OpCode And a.ID in (" + _IDs + ")"; return(SysGlobal.GetExecSqlIsExist(sSqlText)); }
public static Boolean CheckPurchaseOrderNoExists(int PurchaseID, string OrderNo) { string sSqlText = "Select 1 From PurchaseOrder_Info Where OrderNo='" + OrderNo + "' And ID<>" + PurchaseID.ToString(); return(SysGlobal.GetExecSqlIsExist(sSqlText)); }
//判断机构编号是否重复 public static Boolean CheckNoticeNoExists(int NoticeID, string NoticeNo) { string sSqlText = "Select 1 From Notice_Info Where NoticeNo='" + NoticeNo + "' And ID<>" + NoticeID.ToString(); return(SysGlobal.GetExecSqlIsExist(sSqlText)); }
//判断工具编号是否重复 public static Boolean CheckCreditExists(int CreditID, int OrganID, int PurchaseYear) { string sSqlText = "Select 1 From PurchaseCredit_Info Where OrganID=" + OrganID + " And PurchaseYear=" + PurchaseYear + " And ID<>" + CreditID.ToString(); return(SysGlobal.GetExecSqlIsExist(sSqlText)); }