예제 #1
0
        public bool CheckNameSup(string supName)
        {
            string sql = @"SELECT COUNT(*) FROM SUPPLIER WHERE SupName = @SupName";

            object[] obj = { "@SupName", supName };
            return(Db.GetCount(sql, obj) > 0);
        }
예제 #2
0
        public bool CheckPhone(string phoneNum)
        {
            string sql = @"SELECT COUNT(*) FROM SUPPLIER_PHONE WHERE Phone = @Phone";

            object[] obj = { "@Phone", phoneNum };
            return(Db.GetCount(sql, obj) > 0);
        }
 public bool CheckNameUnique(string DepName, string ID)
 {
     if (ID.Equals("CREATE"))
     {
         string   sql = @"SELECT COUNT(*) FROM DEPARTMENT WHERE REPLACE(DepName, ' ', '') = @DepName";
         object[] obj = { "@DepName", DepName };
         return(Db.GetCount(sql, obj) > 0);
     }
     else
     {
         string   sql = @"SELECT COUNT(*) FROM DEPARTMENT WHERE REPLACE(DepName, ' ', '') = @DepName and DepID != @DepID";
         object[] obj = { "@DepName", DepName, "@DepID", ID };
         return(Db.GetCount(sql, obj) > 0);
     }
 }
예제 #4
0
 public bool CheckUnique(string posName, string ID)
 {
     if (ID.Equals("CREATE"))
     {
         string   sql = @"SELECT COUNT(*) FROM POSITION WHERE REPLACE(PosName, ' ', '') = @PosName";
         object[] obj = { "@PosName", posName };
         return(Db.GetCount(sql, obj) > 0);
     }
     else
     {
         string   sql = @"SELECT COUNT(*) FROM POSITION WHERE REPLACE(PosName, ' ', '') = @PosName and PosID != @PosID";
         object[] obj = { "@PosName", posName, "@PosID", ID };
         return(Db.GetCount(sql, obj) > 0);
     }
 }
 public bool CheckNameUnique(string tradmarkName, string ID)
 {
     if (ID.Equals("CREATE"))
     {
         string   sql = @"SELECT COUNT(*) FROM TRADEMARK WHERE REPLACE(TrdName, ' ', '') = @TrdName";
         object[] obj = { "@TrdName", tradmarkName };
         return(Db.GetCount(sql, obj) > 0);
     }
     else
     {
         string   sql = @"SELECT COUNT(*) FROM TRADEMARK WHERE REPLACE(TrdName, ' ', '') = @TrdName and TrdID != @TrdID";
         object[] obj = { "@TrdName", tradmarkName, "@TrdID", ID };
         return(Db.GetCount(sql, obj) > 0);
     }
 }
예제 #6
0
 public bool CheckNameUnique(string brandName, string BrandID)
 {
     if (BrandID.Equals("CREATE"))
     {
         string   sql = @"SELECT COUNT(*) FROM BRAND WHERE REPLACE(BrandName, ' ', '') = @BrandName";
         object[] obj = { "@BrandName", brandName };
         return(Db.GetCount(sql, obj) > 0);
     }
     else
     {
         string   sql = @"SELECT COUNT(*) FROM BRAND WHERE REPLACE(BrandName, ' ', '') = @BrandName and BrandID != @BrandID";
         object[] obj = { "@BrandName", brandName, "@BrandID", BrandID };
         return(Db.GetCount(sql, obj) > 0);
     }
 }
예제 #7
0
 public bool CheckNameUnique(string colorName, string colorID)
 {
     if (colorName.Equals("CREATE"))
     {
         string   sql = @"SELECT COUNT(*) FROM COLOR WHERE REPLACE(ClrName, ' ', '') = @ClrName";
         object[] obj = { "@ClrName", colorName };
         return(Db.GetCount(sql, obj) > 0);
     }
     else
     {
         string   sql = @"SELECT COUNT(*) FROM COLOR WHERE REPLACE(ClrName, ' ', '') = @ClrName and ClrID != @ClrID";
         object[] obj = { "@ClrName", colorName, "@ClrID", colorID };
         return(Db.GetCount(sql, obj) > 0);
     }
 }
예제 #8
0
 public bool CheckNameUnique(string typeproductName, string ID)
 {
     if (ID.Equals("CREATE"))
     {
         string   sql = @"SELECT COUNT(*) FROM TYPEPRODUCT WHERE REPLACE(TypeName, ' ', '') = @TypeName";
         object[] obj = { "@TypeName", typeproductName };
         return(Db.GetCount(sql, obj) > 0);
     }
     else
     {
         string   sql = @"SELECT COUNT(*) FROM TYPEPRODUCT WHERE REPLACE(TypeName, ' ', '') = @TypeName and TypeProductID != @TypeProductID";
         object[] obj = { "@TypeName", typeproductName, "@TypeProductID", ID };
         return(Db.GetCount(sql, obj) > 0);
     }
 }
예제 #9
0
 public bool CheckName(string BnkAccNumber, string ID)
 {
     if (ID.Equals("CREATE"))
     {
         string   sql = @"SELECT COUNT(*) FROM BANK WHERE REPLACE(BnkAccNumber, ' ', '') = @BnkAccNumber";
         object[] obj = { "@BnkAccNumber", BnkAccNumber };
         return(Db.GetCount(sql, obj) > 0);
     }
     else
     {
         string   sql = @"SELECT COUNT(*) FROM BANK WHERE REPLACE(BnkAccNumber, ' ', '') = @BnkAccNumber and BnkAccNumber != @ID";
         object[] obj = { "@BnkAccNumber", BnkAccNumber, "@ID", ID };
         return(Db.GetCount(sql, obj) > 0);
     }
 }
예제 #10
0
        public bool CheckUnique(string roleName, string ID)
        {

            if (ID.Equals("CREATE"))
            {
                string sql = @"SELECT COUNT(*) FROM _ROLES WHERE REPLACE(ROLENAME, ' ', '') = @RoleName";
                object[] obj = { "@RoleName", roleName };
                return Db.GetCount(sql, obj) > 0;
            }
            else
            {
                string sql = @"SELECT COUNT(*) FROM _ROLES WHERE REPLACE(ROLENAME, ' ', '') = @RoleName and RoleID != @RoleID";
                object[] obj = { "@RoleName", roleName, "@RoleID", ID };
                return Db.GetCount(sql, obj) > 0;
            }
        }