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);
}