protected void Page_Load(object sender, EventArgs e) { cs_checkFiled checkDuplicate = new cs_checkFiled(); int afterCheckDuplicate = checkDuplicate.sql_checkDuplicate("SELECT top 1 Haulier_TaxID FROM Haulier_Info where Haulier_Abbr='" + Request.Form["var01"].ToString() + "'"); Response.Write(afterCheckDuplicate); }
protected void Page_Load(object sender, EventArgs e) { cs_checkFiled checkDuplicate = new cs_checkFiled(); int afterCheckDuplicate = checkDuplicate.sql_checkDuplicate("SELECT top 1 UserID FROM User_Profile where UserName='******'"); Response.Write(afterCheckDuplicate); }
protected void Page_Load(object sender, EventArgs e) { cs_checkFiled checkDuplicate = new cs_checkFiled(); string vendor_type = ""; if (Request.Form["var02"].ToString().Substring(0, 1) == "B") { vendor_type = "BH"; } else if (Request.Form["var02"].ToString().Substring(0, 1) == "F") { vendor_type = "FZ"; } else { vendor_type = "VD"; } int afterCheckDuplicate = checkDuplicate.sql_checkDuplicate("SELECT top 1 Vendor_TaxID FROM Vendor_Info where Vendor_Name_En='" + Request.Form["var01"].ToString() + "' and vendor_type='"+vendor_type+"'"); Response.Write(afterCheckDuplicate); }
protected void Page_Load(object sender, EventArgs e) { cs_checkFiled checkDuplicate = new cs_checkFiled(); string vendor_type = ""; if (Request.Form["var02"].ToString().Substring(0, 1) == "B") { vendor_type = "BH"; } else if (Request.Form["var02"].ToString().Substring(0, 1) == "F") { vendor_type = "FZ"; } else { vendor_type = "VD"; } int afterCheckDuplicate = checkDuplicate.sql_checkDuplicate("SELECT top 1 VendorID FROM Vendor_Group where Vendor_Code='" + Request.Form["var01"].ToString() + "' and vendor_type='" + vendor_type + "'"); Response.Write(afterCheckDuplicate); }
protected void Page_Load(object sender, EventArgs e) { cs_checkFiled checkDuplicate = new cs_checkFiled(); int afterCheckDuplicate = checkDuplicate.sql_checkDuplicate("SELECT top 1 DC_NO FROM DC_Info where DC_Name='" + Request.Form["var01"].ToString() + "'"); Response.Write(afterCheckDuplicate); }