Ejemplo n.º 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));
        }
Ejemplo n.º 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));
        }
Ejemplo n.º 3
0
        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));
        }
Ejemplo n.º 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));
        }
Ejemplo n.º 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));
        }
Ejemplo n.º 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));
        }
Ejemplo n.º 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));
        }
Ejemplo n.º 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));
        }
Ejemplo n.º 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));
        }
Ejemplo n.º 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));
        }
Ejemplo n.º 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));
        }
Ejemplo n.º 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));
        }
Ejemplo n.º 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));
        }
Ejemplo n.º 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));
        }
Ejemplo n.º 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));
        }
Ejemplo n.º 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));
        }
Ejemplo n.º 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));
        }
Ejemplo n.º 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));
        }
Ejemplo n.º 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));
        }
Ejemplo n.º 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));
        }
Ejemplo n.º 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));
        }
Ejemplo n.º 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));
        }
Ejemplo n.º 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));
        }
Ejemplo n.º 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));
        }
Ejemplo n.º 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));
        }
Ejemplo n.º 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));
        }
Ejemplo n.º 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));
        }
Ejemplo n.º 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));
        }
Ejemplo n.º 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));
        }
Ejemplo n.º 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));
        }