Beispiel #1
0
        //更新用户密码
        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));
        }
Beispiel #2
0
        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));
        }
Beispiel #4
0
        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));
        }
Beispiel #5
0
        //判断机构编号是否重复
        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));
        }
Beispiel #6
0
        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));
        }
Beispiel #7
0
        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));
        }
Beispiel #8
0
        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));
        }
Beispiel #9
0
        //更新用户密码
        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));
        }
Beispiel #10
0
        //判断预案编号已被使用
        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));
        }
Beispiel #11
0
        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));
        }
Beispiel #12
0
        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));
        }
Beispiel #13
0
        //获取角色是否重复
        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));
        }
Beispiel #14
0
        //判断机构编号已被使用
        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));
        }
Beispiel #15
0
        //判断机构编号已被使用
        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));
        }
Beispiel #16
0
        //判断机构编号已被使用
        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));
        }
Beispiel #17
0
        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));
        }
Beispiel #18
0
        //更新用户密码
        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));
        }
Beispiel #19
0
        //更新用户密码
        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));
        }
Beispiel #20
0
        //更新用户密码
        public static Boolean CheckCustomPassword(int CustomID, string Password)
        {
            string sSqlText = "Select 1 From SysCustomField_Info Where Password='******' And ID=" + CustomID;

            return(SysGlobal.GetExecSqlIsExist(sSqlText));
        }
Beispiel #21
0
        //更新用户密码
        public static Boolean CheckCustomLoginPassword(string OpCode, string Password)
        {
            string sSqlText = "Select 1 From SysCustomField_Info Where Password='******' And OpCode='" + OpCode + "'";

            return(SysGlobal.GetExecSqlIsExist(sSqlText));
        }
Beispiel #22
0
        //判断工具编号是否重复
        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));
        }
Beispiel #23
0
        //查询无线电台编号是否重复
        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));
        }
Beispiel #24
0
        //判断单号是否重复
        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));
        }
Beispiel #25
0
        //判断工具编号是否重复
        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));
        }
Beispiel #26
0
        //判断机构编号是否重复
        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));
        }
Beispiel #27
0
        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));
        }
Beispiel #28
0
        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));
        }
Beispiel #29
0
        //判断机构编号是否重复
        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));
        }
Beispiel #30
0
        //判断工具编号是否重复
        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));
        }