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 PPHCheck = new cs_checkFiled(); string ajaxValue = PPHCheck.sql_getAjaxAnswer("SELECT top 1 Contact_Person FROM User_Profile where UserName='******'"); Response.Write(ajaxValue); }
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) { main_function PPHfunction = new main_function(); cs_checkFiled getLast = new cs_checkFiled(); string vnID = getLast.sql_getAjaxAnswer("SELECT VendorID FROM Vendor_Info order by VendorID desc"); int m = Int32.Parse(vnID); string vendor_type = ""; if (Request.Form["var04"].ToString().Substring(0, 1) == "B") { vendor_type = "BH"; } else if (Request.Form["var04"].ToString().Substring(0, 1) == "F") { vendor_type = "FZ"; } else { vendor_type = "VD"; } PPHfunction.QueryExecuteNonQuery("insert into Vendor_Info (VendorID, Vendor_TaxID, Vendor_Name_En, Vendor_Name_Th, StampTime, vendor_type) values ('" + (m + 1) + "', '" + Request.Form["var01"].ToString() + "','" + Request.Form["var02"].ToString() + "','" + Request.Form["var03"].ToString() + "','" + DateTime.Now + "','" + vendor_type + "')"); }
protected void Page_Load(object sender, EventArgs e) { main_function PPHfunction = new main_function(); cs_checkFiled getLast = new cs_checkFiled(); //string vnID = getLast.sql_getAjaxAnswer("SELECT VendorID FROM Vendor_Info where Vendor_TaxID ='" + Request.Form["var02"].ToString() + "'"); string vendor_type = ""; if (Request.Form["var04"].ToString().Substring(0, 1) == "B") { vendor_type = "BH"; } else if (Request.Form["var04"].ToString().Substring(0, 1) == "F") { vendor_type = "FZ"; } else { vendor_type = "VD"; } string vnID = Request.Form["var02"].ToString(); PPHfunction.QueryExecuteNonQuery("insert into Vendor_Group (VendorID, Vendor_Code, vendor_type) values ('" + vnID + "', '" + Request.Form["var01"].ToString() + "', '" + vendor_type + "')"); }
protected void Page_Load(object sender, EventArgs e) { try { if (!IsPostBack) { cs_checkFiled getLast = new cs_checkFiled(); string frValue = getLast.sql_getAjaxAnswer("SELECT top 1 VAT_Rate FROM VAT_Default "); txtVatRate.Text = frValue; } } catch (Exception ex) { lblErr.Text = ex.Message; PH_ExceptionManager.WriteError(ex.Message); } }
protected void Page_Load(object sender, EventArgs e) { try { if (!IsPostBack) { cs_checkFiled getLast = new cs_checkFiled(); string frValue = getLast.sql_getAjaxAnswer("SELECT top 1 Fuel_Rate FROM Fuel_Rate_Default"); txtFuelRate.Text = frValue; } } catch (Exception ex) { lblErr.Text = ex.Message; PH_ExceptionManager.WriteError(ex.Message); } }
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); }