protected void Page_Load(object sender, EventArgs e)
{
// Set Permission
Permission.GetPermission(Convert.ToInt32(ConstantClass.SESSION_USER_GROUP_ID), PageName);
// Load Combobox Customer Group Data
SPlanetUtil.BindASPxComboBox(ref cboUserGroup, DataListUtil.DropdownStoreProcedureName.Security_User_Group);
// Setting height gridView
gridView.Settings.VerticalScrollableHeight = Convert.ToInt32(BasePage.SizeScreen);
//Bind Data into GridView
if (!Page.IsPostBack)
{
Session.Remove("SESSION_USER_PERMISSION");
dsResult = null;
BindGrid(true);
}
else
{
Page.ClientScript.RegisterStartupScript(this.GetType(), "SetCheckboxSwitch", "setTimeout(function() { setCheckboxSwitch() }, 150);", true);
dsResult = (DataSet)ViewState["dsResult"];
BindGrid(false);
}
}
protected void Page_Load(object sender, EventArgs e)
{
// Load Combobox Customer Data
SPlanetUtil.BindASPxComboBox(ref cboCustomerId, DataListUtil.DropdownStoreProcedureName.Customer);
// Load Combobox Thailand Geo Data
SPlanetUtil.BindASPxComboBox(ref cboGEO, DataListUtil.DropdownStoreProcedureName.Thailand_Geo);
// Setting height gridView
gridView.Settings.VerticalScrollableHeight = Convert.ToInt32(BasePage.SizeScreen);
//Bind Data into GridView
if (!Page.IsPostBack)
{
// Get Permission and if no permission, will redirect to another page.
if (!Permission.GetPermission())
{
Response.Redirect(ConstantClass.CONSTANT_NO_PERMISSION_PAGE);
}
dsResult = null;
BindGrid(true);
}
else
{
dsResult = (DataSet)ViewState["dsResult"];
BindGrid(false);
}
}
protected void Page_Load(object sender, EventArgs e)
{
// Load Combobox Thailand Geo Data
SPlanetUtil.BindASPxComboBox(ref cboGEO, DataListUtil.DropdownStoreProcedureName.Thailand_Geo);
cboGEO.Items.Insert(0, new ListEditItem("--โปรดเลือก--", "0"));
SPlanetUtil.BindASPxComboBox(ref cboSupplierBrand, DataListUtil.DropdownStoreProcedureName.Supplier_Brand);
cboSupplierBrand.Items.Insert(0, new ListEditItem("--โปรดเลือก--", "0"));
SPlanetUtil.BindASPxComboBox(ref cboSupplierGroup, DataListUtil.DropdownStoreProcedureName.Supplier_Group);
cboSupplierGroup.Items.Insert(0, new ListEditItem("--โปรดเลือก--", "0"));
// Setting height gridView
gridView.Settings.VerticalScrollableHeight = Convert.ToInt32(BasePage.SizeScreen);
gridView.SettingsBehavior.AllowFocusedRow = true;
//Bind Data into GridView
if (!Page.IsPostBack)
{
// Get Permission and if no permission, will redirect to another page.
if (!Permission.GetPermission())
{
Response.Redirect(ConstantClass.CONSTANT_NO_PERMISSION_PAGE);
}
dsResult = null;
BindGrid(true);
}
else
{
dsResult = (DataSet)Session["SESSION_SUPPLIER_MASTER"];
BindGrid(false);
}
}
protected void PrepareData()
{
SPlanetUtil.BindASPxComboBox(ref cbbIssue, DataListUtil.DropdownStoreProcedureName.Delivery_Order_Issue_Stock);
//txtDeliveryOrderDate.Value = DateTime.UtcNow.ToString("dd/MM/yyyy");
gridViewIssue.SettingsBehavior.AllowFocusedRow = true;
gridViewIssueMFG.SettingsBehavior.AllowFocusedRow = true;
}
protected void PrepareData()
{
try
{
SPlanetUtil.BindASPxComboBox(ref cbbCustomer, DataListUtil.DropdownStoreProcedureName.Customer);
}
catch (Exception ex)
{
throw ex;
}
}
protected void PrepareData()
{
// Load Combobox Product Category Data
//SPlanetUtil.BindASPxComboBox(ref cboCateID, DataListUtil.DropdownStoreProcedureName.Product_Category);
//// Load Combobox Product Unit Type Data
//SPlanetUtil.BindASPxComboBox(ref cboUnitType, DataListUtil.DropdownStoreProcedureName.Product_Unit);
// Load Combobox Product Brand Data
//SPlanetUtil.BindASPxComboBox(ref cboBrand, DataListUtil.DropdownStoreProcedureName.Product_Brand);
SPlanetUtil.BindASPxComboBox(ref cbbPartNoID, DataListUtil.DropdownStoreProcedureName.Part_No);
}
// ClientInstanceName that use in Script.js
protected void Page_Load(object sender, EventArgs e)
{
//Bind Data into GridView
if (!Page.IsPostBack)
{
// Get Permission and if no permission, will redirect to another page.
if (!Permission.GetPermission())
{
Response.Redirect(ConstantClass.CONSTANT_NO_PERMISSION_PAGE);
}
Session.Remove("EMPLOYEE_FORM_IMGPATH");
Session.Remove("EMPLOYEE_FORM_SIGN_IMGPATH");
// Load Combobox Employee Department Data
SPlanetUtil.BindASPxComboBox(ref cboDepartment, DataListUtil.DropdownStoreProcedureName.Employee_Department);
// Load Combobox Employee Position Data
SPlanetUtil.BindASPxComboBox(ref cboPosition, DataListUtil.DropdownStoreProcedureName.Employee_Position);
// Load Combobox Province Data
SPlanetUtil.BindASPxComboBox(ref cboProvince, DataListUtil.DropdownStoreProcedureName.Thailand_Province);
SPlanetUtil.BindASPxComboBox(ref cboUserGroup, DataListUtil.DropdownStoreProcedureName.Security_User_Group);
cboPrefix.Items.Add("นาย", "0");
cboPrefix.Items.Add("นางสาว", "1");
cboPrefix.Items.Add("นาง", "2");
cboPrefix.Items.Add("ไม่ระบุ", "3");
// Setting height gridView
gridView.Settings.VerticalScrollableHeight = Convert.ToInt32(BasePage.SizeScreen);
gridView.SettingsBehavior.AllowFocusedRow = true;
dsResult = null;
BindGrid(true);
}
else
{
//Page.ClientScript.RegisterStartupScript(this.GetType(), "setCheckboxSwitch", "setTimeout(function() { setCheckboxSwitch() }, 150);", true);
dsResult = (DataSet)Session["SESSION_EMPLOYEE_MASTER"];
BindGrid(false);
}
}
protected void PrepareData()
{
try
{
var dtSource = new DataTable();
dtSource.Columns.Add("data_value", typeof(string));
dtSource.Columns.Add("data_text", typeof(string));
dtSource.Rows.Add("RM", "Remind");
dtSource.Rows.Add("RE", "Repair");
cboNoticeType.DataSource = dtSource;
cboNoticeType.DataBind();
SPlanetUtil.BindASPxComboBox(ref cbbCustomerID, DataListUtil.DropdownStoreProcedureName.Customer);
// Setting height gridView
gridView.Settings.VerticalScrollableHeight = Convert.ToInt32(BasePage.SizeScreen);
}
catch (Exception ex)
{
throw ex;
}
}
protected void PrepareData()
{
try
{
if (!Page.IsPostBack)
{
SPlanetUtil.BindASPxComboBox(ref cbbCustomer, DataListUtil.DropdownStoreProcedureName.Customer);
//SPlanetUtil.BindASPxComboBox(ref cbbEmployee, DataListUtil.DropdownStoreProcedureName.Employee_List);
SPlanetUtil.BindASPxComboBox(ref cbbCustomerGroup, DataListUtil.DropdownStoreProcedureName.Customer_Group);
using (SqlConnection conn = new SqlConnection(SPlanetUtil.GetConnectionString()))
{
//Create array of Parameters
List <SqlParameter> arrParm = new List <SqlParameter>
{
new SqlParameter("@type", SqlDbType.VarChar, 2)
{
Value = "A"
},
};
conn.Open();
var dsResult = SqlHelper.ExecuteDataset(conn, "sp_dropdown_quotation_type", arrParm.ToArray());
conn.Close();
cbbQuotation.DataSource = dsResult;
cbbQuotation.TextField = "data_text";
cbbQuotation.ValueField = "data_value";
cbbQuotation.DataBind();
}
using (SqlConnection conn = new SqlConnection(SPlanetUtil.GetConnectionString()))
{
//Create array of Parameters
List <SqlParameter> arrParm = new List <SqlParameter>
{
new SqlParameter("@search_name", SqlDbType.VarChar, 200)
{
Value = ""
},
new SqlParameter("@id", SqlDbType.Int)
{
Value = 0
},
};
conn.Open();
var dsResult = SqlHelper.ExecuteDataset(conn, "sp_customer_list", arrParm.ToArray());
conn.Close();
cbbCustomerCode.DataSource = dsResult;
cbbCustomerCode.TextField = "customer_code";
cbbCustomerCode.ValueField = "customer_code";
cbbCustomerCode.DataBind();
}
var dtSource = new DataTable();
dtSource.Columns.Add("data_value", typeof(string));
dtSource.Columns.Add("data_text", typeof(string));
dtSource.Rows.Add("FL", "Follow");
dtSource.Rows.Add("CF", "Confirm");
dtSource.Rows.Add("PO", "PO");
dtSource.Rows.Add("DL", "Delivery");
dtSource.Rows.Add("CP", "Completed");
dtSource.Rows.Add("LS", "Lose");
cbbStatus.DataSource = dtSource;
cbbStatus.DataBind();
}
}
catch (Exception ex)
{
throw ex;
}
}
protected void PrepareData()
{
try
{
if (!Page.IsPostBack)
{
SPlanetUtil.BindASPxComboBox(ref cbbEmployee, DataListUtil.DropdownStoreProcedureName.Employee_List);
SPlanetUtil.BindASPxComboBox(ref cbbCustomerGroup, DataListUtil.DropdownStoreProcedureName.Customer_Group);
using (SqlConnection conn = new SqlConnection(SPlanetUtil.GetConnectionString()))
{
//Create array of Parameters
List <SqlParameter> arrParm = new List <SqlParameter>
{
new SqlParameter("@type", SqlDbType.VarChar, 2)
{
Value = "PO"
},
};
conn.Open();
var dsResult = SqlHelper.ExecuteDataset(conn, "sp_dropdown_quotation_type", arrParm.ToArray());
conn.Close();
cbbQuotation.DataSource = dsResult;
cbbQuotation.TextField = "data_text";
cbbQuotation.ValueField = "data_value";
cbbQuotation.DataBind();
}
using (SqlConnection conn = new SqlConnection(SPlanetUtil.GetConnectionString()))
{
//Create array of Parameters
List <SqlParameter> arrParm = new List <SqlParameter>
{
new SqlParameter("@cat_cade", SqlDbType.VarChar, 2)
{
Value = "AC"
},
};
conn.Open();
var dsResult = SqlHelper.ExecuteDataset(conn, "sp_dropdown_product_model", arrParm.ToArray());
conn.Close();
cbbAirCompressorModel.DataSource = dsResult;
cbbAirCompressorModel.TextField = "product_model";
cbbAirCompressorModel.ValueField = "product_model";
cbbAirCompressorModel.DataBind();
}
using (SqlConnection conn = new SqlConnection(SPlanetUtil.GetConnectionString()))
{
//Create array of Parameters
List <SqlParameter> arrParm = new List <SqlParameter>
{
new SqlParameter("@cat_cade", SqlDbType.VarChar, 2)
{
Value = "D"
},
};
conn.Open();
var dsResult = SqlHelper.ExecuteDataset(conn, "sp_dropdown_product_model", arrParm.ToArray());
conn.Close();
cbbAirDryerModel.DataSource = dsResult;
cbbAirDryerModel.TextField = "product_model";
cbbAirDryerModel.ValueField = "product_model";
cbbAirDryerModel.DataBind();
}
using (SqlConnection conn = new SqlConnection(SPlanetUtil.GetConnectionString()))
{
//Create array of Parameters
List <SqlParameter> arrParm = new List <SqlParameter>
{
new SqlParameter("@cat_cade", SqlDbType.VarChar, 2)
{
Value = "L"
},
};
conn.Open();
var dsResult = SqlHelper.ExecuteDataset(conn, "sp_dropdown_product_model", arrParm.ToArray());
conn.Close();
cbbLineFilterModel.DataSource = dsResult;
cbbLineFilterModel.TextField = "product_model";
cbbLineFilterModel.ValueField = "product_model";
cbbLineFilterModel.DataBind();
}
using (SqlConnection conn = new SqlConnection(SPlanetUtil.GetConnectionString()))
{
//Create array of Parameters
List <SqlParameter> arrParm = new List <SqlParameter>
{
new SqlParameter("@cat_cade", SqlDbType.VarChar, 2)
{
Value = "M"
},
};
conn.Open();
var dsResult = SqlHelper.ExecuteDataset(conn, "sp_dropdown_product_model", arrParm.ToArray());
conn.Close();
cbbMistFilterModel.DataSource = dsResult;
cbbMistFilterModel.TextField = "product_model";
cbbMistFilterModel.ValueField = "product_model";
cbbMistFilterModel.DataBind();
}
using (SqlConnection conn = new SqlConnection(SPlanetUtil.GetConnectionString()))
{
//Create array of Parameters
List <SqlParameter> arrParm = new List <SqlParameter>
{
new SqlParameter("@cat_cade", SqlDbType.VarChar, 2)
{
Value = "T"
},
};
conn.Open();
var dsResult = SqlHelper.ExecuteDataset(conn, "sp_dropdown_product_model", arrParm.ToArray());
conn.Close();
cbbAirTankModel.DataSource = dsResult;
cbbAirTankModel.TextField = "product_model";
cbbAirTankModel.ValueField = "product_model";
cbbAirTankModel.DataBind();
}
using (SqlConnection conn = new SqlConnection(SPlanetUtil.GetConnectionString()))
{
//Create array of Parameters
List <SqlParameter> arrParm = new List <SqlParameter>
{
new SqlParameter("@cat_cade", SqlDbType.VarChar, 2)
{
Value = "O"
},
};
conn.Open();
var dsResult = SqlHelper.ExecuteDataset(conn, "sp_dropdown_product_model", arrParm.ToArray());
conn.Close();
cbbOtherModel.DataSource = dsResult;
cbbOtherModel.TextField = "product_model";
cbbOtherModel.ValueField = "product_model";
cbbOtherModel.DataBind();
}
using (SqlConnection conn = new SqlConnection(SPlanetUtil.GetConnectionString()))
{
conn.Open();
var dsResult = SqlHelper.ExecuteDataset(conn, "sp_dropdown_product_pressure");
conn.Close();
cbbAirCompressorPresure.DataSource = dsResult;
cbbAirCompressorPresure.TextField = "pressure";
cbbAirCompressorPresure.ValueField = "pressure";
cbbAirCompressorPresure.DataBind();
}
using (SqlConnection conn = new SqlConnection(SPlanetUtil.GetConnectionString()))
{
//Create array of Parameters
List <SqlParameter> arrParm = new List <SqlParameter>
{
new SqlParameter("@search_name", SqlDbType.VarChar, 200)
{
Value = ""
},
new SqlParameter("@id", SqlDbType.Int)
{
Value = 0
},
};
conn.Open();
var dsResult = SqlHelper.ExecuteDataset(conn, "sp_customer_list", arrParm.ToArray());
conn.Close();
cbbCustomer.DataSource = dsResult;
cbbCustomer.TextField = "code_name";
cbbCustomer.ValueField = "id";
cbbCustomer.DataBind();
}
using (SqlConnection conn = new SqlConnection(SPlanetUtil.GetConnectionString()))
{
//Create array of Parameters
List <SqlParameter> arrParm = new List <SqlParameter>
{
new SqlParameter("@lang_id", SqlDbType.VarChar, 3)
{
Value = "tha"
},
new SqlParameter("@cat_type", SqlDbType.Int)
{
Value = "PP"
},
};
conn.Open();
var dsResult = SqlHelper.ExecuteDataset(conn, "sp_dropdown_product_category_export", arrParm.ToArray());
conn.Close();
cbbProductCat.DataSource = dsResult;
cbbProductCat.TextField = "data_text";
cbbProductCat.ValueField = "data_value";
cbbProductCat.DataBind();
}
var dtSource = new DataTable();
dtSource.Columns.Add("data_value", typeof(string));
dtSource.Columns.Add("data_text", typeof(string));
dtSource.Rows.Add("FL", "Follow");
dtSource.Rows.Add("CF", "Confirm");
dtSource.Rows.Add("PO", "PO");
dtSource.Rows.Add("DL", "Delivery");
dtSource.Rows.Add("CP", "Completed");
dtSource.Rows.Add("LS", "Lose");
cbbStatus.DataSource = dtSource;
cbbStatus.DataBind();
}
}
catch (Exception ex)
{
throw ex;
}
}
protected void PrepareData()
{
try
{
if (!Page.IsPostBack)
{
SPlanetUtil.BindASPxComboBox(ref cbbShelf, DataListUtil.DropdownStoreProcedureName.Shelf_List);
SPlanetUtil.BindASPxComboBox(ref cbbCustomerGroup, DataListUtil.DropdownStoreProcedureName.Customer_Group);
using (SqlConnection conn = new SqlConnection(SPlanetUtil.GetConnectionString()))
{
//Create array of Parameters
List <SqlParameter> arrParm = new List <SqlParameter>
{
new SqlParameter("@type", SqlDbType.VarChar, 2)
{
Value = "MSC"
},
};
conn.Open();
var dsResult = SqlHelper.ExecuteDataset(conn, "sp_dropdown_quotation_type", arrParm.ToArray());
conn.Close();
cbbQuotation.DataSource = dsResult;
cbbQuotation.TextField = "data_text";
cbbQuotation.ValueField = "data_value";
cbbQuotation.DataBind();
}
using (SqlConnection conn = new SqlConnection(SPlanetUtil.GetConnectionString()))
{
//Create array of Parameters
List <SqlParameter> arrParm = new List <SqlParameter>
{
new SqlParameter("@search_name", SqlDbType.VarChar, 200)
{
Value = ""
},
new SqlParameter("@id", SqlDbType.Int)
{
Value = 0
},
};
conn.Open();
var dsResult = SqlHelper.ExecuteDataset(conn, "sp_customer_list", arrParm.ToArray());
conn.Close();
cbbCustomer.DataSource = dsResult;
cbbCustomer.TextField = "code_name";
cbbCustomer.ValueField = "id";
cbbCustomer.DataBind();
}
using (SqlConnection conn = new SqlConnection(SPlanetUtil.GetConnectionString()))
{
//Create array of Parameters
List <SqlParameter> arrParm = new List <SqlParameter>
{
new SqlParameter("@lang_id", SqlDbType.VarChar, 3)
{
Value = "tha"
},
new SqlParameter("@cat_type", SqlDbType.Int)
{
Value = "SP"
},
};
conn.Open();
var dsResult = SqlHelper.ExecuteDataset(conn, "sp_dropdown_product_category_export", arrParm.ToArray());
conn.Close();
cbbProductCat.DataSource = dsResult;
cbbProductCat.TextField = "data_text";
cbbProductCat.ValueField = "data_value";
cbbProductCat.DataBind();
}
using (SqlConnection conn = new SqlConnection(SPlanetUtil.GetConnectionString()))
{
//Create array of Parameters
List <SqlParameter> arrParm = new List <SqlParameter>
{
new SqlParameter("@search_name", SqlDbType.VarChar, 200)
{
Value = ""
},
new SqlParameter("@customer_id", SqlDbType.Int)
{
Value = 0
},
};
conn.Open();
var dsResult = SqlHelper.ExecuteDataset(conn, "sp_customer_mfg_list", arrParm.ToArray());
conn.Close();
cbbModel.DataSource = dsResult;
cbbModel.TextField = "model";
cbbModel.ValueField = "model";
cbbModel.DataBind();
cbbMfg.DataSource = dsResult;
cbbMfg.TextField = "mfg";
cbbMfg.ValueField = "mfg";
cbbMfg.DataBind();
}
var dtSource = new DataTable();
dtSource.Columns.Add("data_value", typeof(string));
dtSource.Columns.Add("data_text", typeof(string));
dtSource.Rows.Add("FL", "Follow");
dtSource.Rows.Add("CF", "Confirm");
dtSource.Rows.Add("PO", "PO");
dtSource.Rows.Add("DL", "Delivery");
dtSource.Rows.Add("CP", "Completed");
dtSource.Rows.Add("LS", "Lose");
var dtSource1 = new DataTable();
dtSource1.Columns.Add("data_value", typeof(string));
dtSource1.Columns.Add("data_text", typeof(string));
dtSource1.Rows.Add("S", "Spare Part");
dtSource1.Rows.Add("M", "Maintenance");
dtSource1.Rows.Add("C", "Service Charge");
cbbproducttype.DataSource = dtSource1;
cbbproducttype.DataBind();
cbbStatus.DataSource = dtSource;
cbbStatus.DataBind();
}
}
catch (Exception ex)
{
throw ex;
}
}