C# (CSharp) cs_checkFiled.sql_getAjaxAnswer Examples

Example #1

File: ajax_vnContactPoint.aspx.cs Project: parnupongk/primary

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

Example #2

File: vender_Submit.aspx.cs Project: parnupongk/primary

 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 + "')");
 }

Example #3

File: vat_rate.aspx.cs Project: parnupongk/primary

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

Example #4

File: master_fuelprice.aspx.cs Project: parnupongk/primary

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

Example #5

        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 + "')");
        }

Example #6

File: ajax_vnContactPoint.aspx.cs Project: parnupongk/primary

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