//更新用户密码
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));
}