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) { 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) { 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) { 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) { cs_checkFiled PPHCheck = new cs_checkFiled(); string ajaxValue = PPHCheck.sql_getAjaxAnswer("SELECT top 1 Contact_Person FROM User_Profile where UserName='******'"); Response.Write(ajaxValue); }