protected void MonthYear_Combo_Init(object sender, EventArgs e) { ASPxComboBox combo = sender as ASPxComboBox; combo.DataSource = POClass.MRPMonthYearTable(); ListBoxColumn l_value = new ListBoxColumn(); l_value.FieldName = "PK"; l_value.Width = 0; combo.Columns.Add(l_value); ListBoxColumn l_text = new ListBoxColumn(); l_text.FieldName = "MRPMonth"; l_text.Caption = "Month"; combo.Columns.Add(l_text); ListBoxColumn l_text2 = new ListBoxColumn(); l_text2.FieldName = "MRPYear"; l_text2.Caption = "Year"; combo.Columns.Add(l_text2); combo.ValueField = "PK"; combo.TextField = "MRPMonth"; combo.DataBind(); combo.TextFormatString = "{1} {2}"; }
protected void EntityCode_Init(object sender, EventArgs e) { DataTable dtRecord = GlobalClass.EntityTable(); ASPxComboBox combo = sender as ASPxComboBox; combo.DataSource = dtRecord; ListBoxColumn l_ValueField = new ListBoxColumn(); l_ValueField.FieldName = "ID"; l_ValueField.Caption = "CODE"; l_ValueField.Width = 30; combo.Columns.Add(l_ValueField); ListBoxColumn l_TextField = new ListBoxColumn(); l_TextField.FieldName = "NAME"; combo.Columns.Add(l_TextField); combo.ValueField = "ID"; combo.TextField = "NAME"; combo.DataBind(); combo.ItemStyle.Wrap = DevExpress.Utils.DefaultBoolean.True; GridViewEditFormTemplateContainer container = combo.NamingContainer.NamingContainer as GridViewEditFormTemplateContainer; //MRPClass.PrintString("exp:" + !container.Grid.IsNewRowEditing); if (!container.Grid.IsNewRowEditing) { combo.Value = DataBinder.Eval(container.DataItem, "EntityCode").ToString(); } }
protected void ComboBoxCustomer_Init(object sender, EventArgs e) { ASPxComboBox combo = sender as ASPxComboBox; combo.DataSource = HLSSOA.HLSSOACustomer(0, 0); ListBoxColumn lv = new ListBoxColumn(); lv.Width = 100; lv.FieldName = "CustAccount"; lv.Caption = "Customer Code"; combo.Columns.Add(lv); ListBoxColumn lt1 = new ListBoxColumn(); lt1.FieldName = "CustName"; lt1.Caption = "Customer Name"; lt1.Width = 200; combo.Columns.Add(lt1); combo.ValueField = "CustAccount"; combo.TextField = "CustName"; combo.DataBind(); combo.ItemStyle.Wrap = DevExpress.Utils.DefaultBoolean.True; //combo.ValueType = typeof(String); }
protected void UserStatus_Init(object sender, EventArgs e) { DataTable dtRecord = AccountClass.UserStatusTable(); ASPxComboBox combo = sender as ASPxComboBox; combo.DataSource = dtRecord; ListBoxColumn l_ValueField = new ListBoxColumn(); l_ValueField.FieldName = "ID"; l_ValueField.Caption = "CODE"; l_ValueField.Width = 0; combo.Columns.Add(l_ValueField); ListBoxColumn l_TextField = new ListBoxColumn(); l_TextField.FieldName = "NAME"; l_TextField.Caption = "STATUS"; combo.Columns.Add(l_TextField); combo.ValueField = "ID"; combo.TextField = "NAME"; combo.DataBind(); GridViewEditFormTemplateContainer container = combo.NamingContainer.NamingContainer as GridViewEditFormTemplateContainer; if (!container.Grid.IsNewRowEditing) { combo.Value = DataBinder.Eval(container.DataItem, "StatusKey").ToString(); } }
protected void SCMHead_Init(object sender, EventArgs e) { DataTable dtRecord = AccountClass.UserListTable(); ASPxComboBox combo = sender as ASPxComboBox; combo.DataSource = dtRecord; ListBoxColumn l_ValueField = new ListBoxColumn(); l_ValueField.FieldName = "ID"; l_ValueField.Caption = "CODE"; l_ValueField.Width = 0; combo.Columns.Add(l_ValueField); ListBoxColumn l_TextField = new ListBoxColumn(); l_TextField.FieldName = "NAME"; combo.Columns.Add(l_TextField); combo.ValueField = "ID"; combo.TextField = "NAME"; combo.DataBind(); combo.Value = sHeadKey.ToString(); //GridViewEditFormTemplateContainer container = combo.NamingContainer.NamingContainer as GridViewEditFormTemplateContainer; //MRPClass.PrintString("exp:" + !container.Grid.IsNewRowEditing); //if (!container.Grid.IsNewRowEditing) //{ // combo.Value = DataBinder.Eval(container.DataItem, "UserKey").ToString(); //} }
protected void BUCode_Init(object sender, EventArgs e) { DataTable dtRecord = GlobalClass.EntBUSSUTable(sEntCode); ASPxComboBox combo = sender as ASPxComboBox; combo.DataSource = dtRecord; ListBoxColumn l_ValueField = new ListBoxColumn(); l_ValueField.FieldName = "ID"; l_ValueField.Caption = "CODE"; l_ValueField.Width = 30; combo.Columns.Add(l_ValueField); ListBoxColumn l_TextField = new ListBoxColumn(); l_TextField.FieldName = "NAME"; l_TextField.Caption = "NAME"; combo.Columns.Add(l_TextField); combo.ValueField = "ID"; combo.TextField = "NAME"; combo.DataBind(); combo.Value = sBUCode; }
protected void ComboBoxCustomer_Callback(object sender, CallbackEventArgsBase e) { string sYear = ComboBoxYear.Text; string sWeekNum = ComboBoxWeekNum.Text; ASPxComboBox combo = sender as ASPxComboBox; if (!string.IsNullOrEmpty(sWeekNum)) { combo.DataSource = HLSSOA.HLSSOACustomer(Convert.ToInt32(sYear), Convert.ToInt32(sWeekNum)); } else { combo.DataSource = HLSSOA.HLSSOACustomer(Convert.ToInt32(sYear), 0); } ListBoxColumn lv = new ListBoxColumn(); lv.Width = 100; lv.FieldName = "CustAccount"; lv.Caption = "Customer Code"; combo.Columns.Add(lv); //ListBoxColumn lt1 = new ListBoxColumn(); //lt1.FieldName = "CustName"; //lt1.Caption = "Customer Name"; //lt1.Width = 200; //combo.Columns.Add(lt1); combo.ValueField = "CustAccount"; combo.TextField = "CustName"; combo.DataBind(); combo.ItemStyle.Wrap = DevExpress.Utils.DefaultBoolean.True; combo.TextFormatString = "{1}"; }
protected void Vendor_Init(object sender, EventArgs e) { ASPxComboBox combo = sender as ASPxComboBox; combo.DataSource = POClass.VendTableTable();; ListBoxColumn l_value = new ListBoxColumn(); l_value.FieldName = "ACCOUNTNUM"; l_value.Caption = "Vendor Code"; l_value.Width = 100; combo.Columns.Add(l_value); ListBoxColumn l_text = new ListBoxColumn(); l_text.FieldName = "NAME"; l_text.Caption = "Vendor Name"; l_text.Width = 350; combo.Columns.Add(l_text); combo.ItemStyle.Wrap = DevExpress.Utils.DefaultBoolean.True; combo.ValueField = "ACCOUNTNUM"; combo.TextField = "NAME"; combo.DataBind(); //combo.TextFormatString = "{0}{1}"; }
protected void BUHead_Init(object sender, EventArgs e) { DataTable dtRecord = AccountClass.UserList(); ASPxComboBox combo = sender as ASPxComboBox; combo.DataSource = dtRecord; ListBoxColumn l_ValueField = new ListBoxColumn(); l_ValueField.FieldName = "PK"; l_ValueField.Caption = "CODE"; l_ValueField.Width = 0; combo.Columns.Add(l_ValueField); ListBoxColumn l_TextField = new ListBoxColumn(); l_TextField.FieldName = "CompleteName"; l_TextField.Caption = "Employee Name"; combo.Columns.Add(l_TextField); combo.ValueField = "PK"; combo.TextField = "CompleteName"; combo.DataBind(); GridViewEditFormTemplateContainer container = combo.NamingContainer.NamingContainer as GridViewEditFormTemplateContainer; //MRPClass.PrintString("exp:" + !container.Grid.IsNewRowEditing); if (!container.Grid.IsNewRowEditing) { combo.Value = DataBinder.Eval(container.DataItem, "BUHead").ToString(); } }
protected void Code_Init(object sender, EventArgs e) { ASPxComboBox combo = sender as ASPxComboBox; combo.DataSource = POClass.PO_EntityCode_Table(); ListBoxColumn lv = new ListBoxColumn(); lv.FieldName = "ID"; lv.Caption = "Code"; lv.Width = 50; combo.Columns.Add(lv); ListBoxColumn lt = new ListBoxColumn(); lt.FieldName = "NAME"; lt.Caption = "Entity"; lt.Width = 250; combo.Columns.Add(lt); combo.ItemStyle.Wrap = DevExpress.Utils.DefaultBoolean.True; combo.ValueField = "ID"; combo.TextField = "NAME"; combo.DataBind(); GridViewEditItemTemplateContainer container = ((ASPxComboBox)sender).NamingContainer as GridViewEditItemTemplateContainer; if (!container.Grid.IsNewRowEditing) { combo.Value = DataBinder.Eval(container.DataItem, "Code").ToString(); combo.Text = DataBinder.Eval(container.DataItem, "Code").ToString(); } }
private void VendorCombo_Data() { ASPxComboBox combo = VendorCombo as ASPxComboBox; combo.Columns.Clear(); combo.DataSource = POClass.VendTableTable();; ListBoxColumn l_value = new ListBoxColumn(); l_value.FieldName = "ACCOUNTNUM"; l_value.Caption = "Vendor Code"; l_value.Width = 100; combo.Columns.Add(l_value); ListBoxColumn l_text = new ListBoxColumn(); l_text.FieldName = "NAME"; l_text.Caption = "Vendor Name"; l_text.Width = 350; combo.Columns.Add(l_text); combo.ItemStyle.Wrap = DevExpress.Utils.DefaultBoolean.True; combo.ValueField = "ACCOUNTNUM"; combo.TextField = "NAME"; combo.DataBind(); }
private void WarehouseCombo_Data() { ASPxComboBox combo = WarehouseCombo as ASPxComboBox; combo.Columns.Clear(); combo.Value = ""; combo.DataSource = POClass.InventSiteWarehouseTable(SiteCombo.Text.ToString()); ListBoxColumn l_value = new ListBoxColumn(); l_value.FieldName = "warehouse"; l_value.Caption = "Warehouse"; combo.Columns.Add(l_value); ListBoxColumn l_text = new ListBoxColumn(); l_text.FieldName = "NAME"; l_text.Caption = "Name"; combo.Columns.Add(l_text); combo.ItemStyle.Wrap = DevExpress.Utils.DefaultBoolean.True; combo.TextField = "NAME"; combo.ValueField = "warehouse"; combo.DataBind(); combo.ClientEnabled = true; }
protected void FixedAssetID_Init(object sender, EventArgs e) { string entCode = "", procCat = ""; entCode = CAPEXCIP.GetRowValues(CAPEXCIP.FocusedRowIndex, "EntCode").ToString(); procCat = CAPEXCIP.GetRowValues(CAPEXCIP.FocusedRowIndex, "ProcCat").ToString(); MRPClass.PrintString(entCode + " : " + procCat); DataTable dtRecord = GlobalClass.FixedAssetIDTable(entCode, procCat); ASPxComboBox combo = sender as ASPxComboBox; combo.DataSource = dtRecord; ListBoxColumn l_ValueField = new ListBoxColumn(); l_ValueField.FieldName = "ID"; l_ValueField.Caption = "CODE"; l_ValueField.Width = 125; combo.Columns.Add(l_ValueField); ListBoxColumn l_TextField = new ListBoxColumn(); l_TextField.FieldName = "NAME"; l_TextField.Width = 350; combo.Columns.Add(l_TextField); combo.ValueField = "ID"; combo.TextField = "ID"; combo.DataBind(); combo.Value = sFixedAssetID.ToString(); combo.Text = sFixedAssetID.ToString(); }
protected void ProdCat_ListBox_Init(object sender, EventArgs e) { string docnum = MOPNum_Combo.Text.ToString(); empty = string.IsNullOrEmpty(docnum); ASPxListBox list = sender as ASPxListBox; list.Columns.Clear(); list.Items.Clear(); //if (empty) list.DataSource = MRPClass.ProCategoryTable_WithoutAll(); //else //list.DataSource = MRPClass.ProCategoryTable_Filter(""); ListBoxColumn l_value = new ListBoxColumn(); l_value.FieldName = "NAME"; l_value.Caption = "Code"; l_value.Width = 100; list.Columns.Add(l_value); ListBoxColumn l_text = new ListBoxColumn(); l_text.FieldName = "DESCRIPTION"; l_text.Caption = "Description"; l_text.Width = 350; list.Columns.Add(l_text); list.ValueField = "NAME"; list.TextField = "DESCRIPTION"; list.DataBind(); list.ItemStyle.Wrap = DevExpress.Utils.DefaultBoolean.True; list.ClientEnabled = false; }
protected void POUOM_Init(object sender, EventArgs e) { ASPxComboBox combo = sender as ASPxComboBox; combo.DataSource = MRPClass.UOMTable(); combo.ItemStyle.Wrap = DevExpress.Utils.DefaultBoolean.True; ListBoxColumn l_value = new ListBoxColumn(); l_value.FieldName = "SYMBOL"; combo.Columns.Add(l_value); ListBoxColumn l_text = new ListBoxColumn(); l_text.FieldName = "description"; combo.Columns.Add(l_text); combo.ValueField = "SYMBOL"; combo.TextField = "description"; combo.DataBind(); combo.TextFormatString = "{0}"; GridViewEditItemTemplateContainer container = ((ASPxComboBox)sender).NamingContainer as GridViewEditItemTemplateContainer; if (!container.Grid.IsNewRowEditing) { combo.Value = DataBinder.Eval(container.DataItem, "POUOM").ToString(); } }
private void LocationCombo_Data() { ASPxComboBox combo = LocationCombo as ASPxComboBox; combo.Columns.Clear(); combo.Value = ""; combo.DataSource = POClass.InventSiteLocationTable(WarehouseCombo.Text.ToString()); ListBoxColumn l_value = new ListBoxColumn(); l_value.FieldName = "LocationCode"; combo.Columns.Add(l_value); //ListBoxColumn l_text = new ListBoxColumn(); //l_text.FieldName = "NAME"; //Location.Columns.Add(l_text); //Location.TextField = "NAME"; combo.ValueField = "LocationCode"; combo.DataBind(); combo.TextFormatString = "{0}"; combo.ClientEnabled = true; }
private void SiteCombo_Data() { ASPxComboBox combo = SiteCombo as ASPxComboBox; combo.Columns.Clear(); combo.DataSource = POClass.InventSiteTable(entity); ListBoxColumn l_value = new ListBoxColumn(); l_value.FieldName = "SITEID"; l_value.Caption = "Site ID"; combo.Columns.Add(l_value); ListBoxColumn l_text = new ListBoxColumn(); l_text.FieldName = "NAME"; l_text.Width = 200; l_text.Caption = "Name"; combo.Columns.Add(l_text); combo.ItemStyle.Wrap = DevExpress.Utils.DefaultBoolean.True; combo.TextField = "NAME"; combo.ValueField = "SITEID"; combo.DataBind(); }
protected void CreatorStatus_Init(object sender, EventArgs e) { DataTable dtRecord = AccountClass.UserStatusTable(); ASPxComboBox combo = sender as ASPxComboBox; combo.DataSource = dtRecord; ListBoxColumn l_ValueField = new ListBoxColumn(); l_ValueField.FieldName = "ID"; l_ValueField.Caption = "CODE"; l_ValueField.Width = 0; combo.Columns.Add(l_ValueField); ListBoxColumn l_TextField = new ListBoxColumn(); l_TextField.FieldName = "NAME"; l_TextField.Caption = "STATUS"; combo.Columns.Add(l_TextField); combo.ValueField = "ID"; combo.TextField = "NAME"; combo.DataBind(); combo.Value = sBUSSUCreatorStatusKey.ToString(); }
private void TermsCombo_Data() { //string query = "SELECT PAYMTERMID, DESCRIPTION FROM[dbo].[vw_AXVendTable] WHERE [ACCOUNTNUM] = '" + VendorCombo.Text.ToString() + "'"; string query = "SELECT dbo.vw_AXVendTable.PAYMTERMID, ISNULL(dbo.vw_AXPaymTerm.DESCRIPTION, N'') AS DESCRIPTION, dbo.vw_AXVendTable.ACCOUNTNUM FROM dbo.vw_AXVendTable LEFT OUTER JOIN dbo.vw_AXPaymTerm ON dbo.vw_AXVendTable.PAYMTERMID = dbo.vw_AXPaymTerm.PAYMTERMID WHERE(dbo.vw_AXVendTable.ACCOUNTNUM = '" + VendorCombo.Text.ToString() + "')"; ASPxComboBox combo = TermsCombo as ASPxComboBox; combo.Columns.Clear(); SqlConnection conn = new SqlConnection(GlobalClass.SQLConnString()); conn.Open(); SqlCommand cmd = new SqlCommand(query, conn); //SqlDataReader reader = cmd.ExecuteReader(); //while (reader.Read()) //{ // combo.Value = reader["PAYMTERMID"].ToString(); //} //reader.Close(); string value = "", text = ""; SqlDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { value = reader["PAYMTERMID"].ToString(); text = reader["DESCRIPTION"].ToString(); } reader.Close(); conn.Close(); combo.DataSource = null; combo.DataSource = POClass.PaymTermTable(); ListBoxColumn l_value = new ListBoxColumn(); l_value.FieldName = "PAYMTERMID"; l_value.Width = 100; combo.Columns.Add(l_value); ListBoxColumn l_text = new ListBoxColumn(); l_text.FieldName = "DESCRIPTION"; l_text.Width = 250; combo.Columns.Add(l_text); combo.ItemStyle.Wrap = DevExpress.Utils.DefaultBoolean.True; combo.ValueField = "PAYMTERMID"; combo.TextField = "DESCRIPTION"; combo.DataBind(); combo.ClientEnabled = true; combo.Value = value; combo.Text = value; combo.IsValid = (!string.IsNullOrEmpty(value)) ? true : false; TermsLbl.Text = text; //set text label of terms }
//protected void ProdCategory_Combo_Init(object sender, EventArgs e) //{ // ASPxComboBox combo = sender as ASPxComboBox; // combo.DataSource = MRPClass.ProCategoryTable(); // ListBoxColumn l_value = new ListBoxColumn(); // l_value.FieldName = "NAME"; // l_value.Caption = "CODE"; // l_value.Width = 100; // combo.Columns.Add(l_value); // ListBoxColumn l_text = new ListBoxColumn(); // l_text.FieldName = "DESCRIPTION"; // l_text.Width = 350; // combo.Columns.Add(l_text); // combo.ValueField = "NAME"; // combo.TextField = "DESCRIPTION"; // combo.DataBind(); // combo.TextFormatString = "{1}"; //} private void ProdCat_DataBind() { ASPxListBox list = ProdCat_ListBox as ASPxListBox; list.Columns.Clear(); list.Items.Clear(); string monthyear = MonthYear_Combo.Text; //if (!string.IsNullOrEmpty(monthyear) && ((MOPNum_Combo.Value != null) || (CheckboxAll.Checked))) //if ((!string.IsNullOrEmpty(monthyear) && MOPNum_Combo.Value != null) || (!string.IsNullOrEmpty(monthyear) && CheckboxAll.Checked)) if (!string.IsNullOrEmpty(monthyear)) { if (!string.IsNullOrEmpty(MOPNum_Combo.Text.ToString()) || CheckboxAll.Checked) { string[] strarr = monthyear.Split(' '); string month = strarr[0].ToString(); string year = strarr[1].ToString(); string docnum = ""; int monthindex = Convertion.MONTH_TO_INDEX(month); if (!string.IsNullOrEmpty(MOPNum_Combo.Text.ToString())) { docnum = MOPNum_Combo.Text.ToString(); } //MRPClass.PrintString("pass"); //MRPClass.PrintString(docnum); list.DataSource = MRPClass.ProCategoryTable_Filter_SelectItemPO(Convert.ToInt32(year), monthindex, docnum); ListBoxColumn l_value = new ListBoxColumn(); l_value.FieldName = "NAME"; l_value.Caption = "Code"; l_value.Width = 100; list.Columns.Add(l_value); ListBoxColumn l_text = new ListBoxColumn(); l_text.FieldName = "DESCRIPTION"; l_text.Caption = "Description"; l_text.Width = 350; list.Columns.Add(l_text); list.ValueField = "NAME"; list.TextField = "DESCRIPTION"; list.DataBind(); list.ItemStyle.Wrap = DevExpress.Utils.DefaultBoolean.True; list.ClientEnabled = true; } } }
protected void TaxGroup_Init(object sender, EventArgs e) { ASPxComboBox comboBox = (ASPxComboBox)sender; comboBox.DataSource = POClass.TaxGroupTable(); ListBoxColumn l_value = new ListBoxColumn(); l_value.FieldName = "TaxGroup"; comboBox.Columns.Add(l_value); comboBox.ValueField = "TaxGroup"; comboBox.TextField = "TaxGroup"; comboBox.DataBind(); }
private void CurrencyCombo_Data() { ASPxComboBox combo = CurrencyCombo as ASPxComboBox; combo.Columns.Clear(); string query = "SELECT dbo.vw_AXVendTable.VENDGROUP, dbo.vw_AXVendTable.PAYMTERMID, dbo.vw_AXVendTable.CURRENCY, dbo.vw_AXCurrency.TXT FROM dbo.vw_AXVendTable LEFT OUTER JOIN dbo.vw_AXCurrency ON dbo.vw_AXVendTable.CURRENCY = dbo.vw_AXCurrency.CURRENCYCODE WHERE[ACCOUNTNUM] = '" + VendorCombo.Text.ToString() + "'"; SqlConnection conn = new SqlConnection(GlobalClass.SQLConnString()); conn.Open(); SqlCommand cmd = new SqlCommand(query, conn); string value = "", text = ""; SqlDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { value = reader["CURRENCY"].ToString(); text = reader["TXT"].ToString(); } reader.Close(); conn.Close(); combo.DataSource = POClass.CurrencyTable();; ListBoxColumn l_value = new ListBoxColumn(); l_value.FieldName = "CURRENCYCODE"; l_value.Caption = "Currency Code"; l_value.Width = 100; combo.Columns.Add(l_value); ListBoxColumn l_text = new ListBoxColumn(); l_text.FieldName = "TXT"; l_text.Width = 250; l_text.Caption = "Currency Name"; combo.Columns.Add(l_text); combo.ItemStyle.Wrap = DevExpress.Utils.DefaultBoolean.True; combo.ValueField = "CURRENCYCODE"; combo.TextField = "TXT"; combo.DataBind(); combo.ClientEnabled = true; combo.Value = value; combo.Text = value + ";" + text; }
protected void ComboBoxWeekNum_Init(object sender, EventArgs e) { ASPxComboBox combo = sender as ASPxComboBox; combo.DataSource = HLSSOA.HLSSOAWeekNum(0); ListBoxColumn lv = new ListBoxColumn(); lv.Width = 0; lv.FieldName = "sWeekNum"; lv.Caption = "Select Week Number"; combo.Columns.Add(lv); combo.ValueField = "sWeekNum"; combo.TextField = "sWeekNum"; combo.DataBind(); combo.ItemStyle.Wrap = DevExpress.Utils.DefaultBoolean.True; }
protected void ComboBoxWeekNum_Callback(object sender, CallbackEventArgsBase e) { int sYear = Convert.ToInt32(ComboBoxYear.Text); ASPxComboBox combo = sender as ASPxComboBox; combo.DataSource = HLSSOA.HLSSOAWeekNum(sYear); ListBoxColumn lv = new ListBoxColumn(); lv.Width = 0; lv.FieldName = "sWeekNum"; lv.Caption = "Select Week Number"; combo.Columns.Add(lv); combo.ValueField = "sWeekNum"; combo.TextField = "sWeekNum"; combo.DataBind(); combo.ItemStyle.Wrap = DevExpress.Utils.DefaultBoolean.True; combo.TextFormatString = "{0}"; }
protected void BUCallback_Callback(object sender, CallbackEventArgsBase e) { //MRPClass.PrintString("callback"); string var = MRPmonthyear.Text.ToString(); pk = MRPmonthyear.Value.ToString(); int spaceindex = var.IndexOf(" "); int secondlength = var.Length - (spaceindex + 1); string monthvar = var.Substring(0, spaceindex); int monthIndex = Convert.ToDateTime("01-" + monthvar + "-2011").Month; month = monthIndex.ToString(); year = var.Substring(spaceindex + 1, secondlength); ASPxComboBox combo = BUCombo as ASPxComboBox; combo.Text = ""; combo.Columns.Clear(); combo.Items.Clear(); combo.DataSource = CapexCIP.BusinessUnit(EntityCombo.Value.ToString(), monthIndex, year); ListBoxColumn lv = new ListBoxColumn(); lv.FieldName = "ID"; lv.Caption = "Code"; lv.Width = 50; combo.Columns.Add(lv); ListBoxColumn lt = new ListBoxColumn(); lt.FieldName = "NAME"; lt.Caption = "Name"; combo.Columns.Add(lt); combo.ValueField = "ID"; combo.TextField = "NAME"; combo.DataBind(); combo.TextFormatString = "{1}"; combo.ItemStyle.Wrap = DevExpress.Utils.DefaultBoolean.True; }
protected void ProCategory_Init(object sender, EventArgs e) { ASPxComboBox combo = sender as ASPxComboBox; combo.DataSource = MRPClass.ProCategoryTable(); ListBoxColumn l_value = new ListBoxColumn(); l_value.FieldName = "NAME"; combo.Columns.Add(l_value); ListBoxColumn l_text = new ListBoxColumn(); l_text.FieldName = "DESCRIPTION"; combo.Columns.Add(l_text); combo.ValueField = "NAME"; combo.TextField = "DESCRIPTION"; combo.DataBind(); combo.SelectedIndex = 0; }
protected void LocationCallback_Callback(object sender, CallbackEventArgsBase e) { Location.Value = ""; Location.DataSource = POClass.InventSiteLocationTable(Warehouse.Text.ToString()); ListBoxColumn l_value = new ListBoxColumn(); l_value.FieldName = "LocationCode"; Location.Columns.Add(l_value); //ListBoxColumn l_text = new ListBoxColumn(); //l_text.FieldName = "NAME"; //Location.Columns.Add(l_text); //Location.TextField = "NAME"; Location.ValueField = "LocationCode"; Location.DataBind(); Location.TextFormatString = "{0}"; Location.ClientEnabled = true; }
protected void DocNumber_Init(object sender, EventArgs e) { ASPxComboBox combo = sender as ASPxComboBox; DataTable dtRecord = MRPClass.Master_MRP_List_DOCNUM(); combo.DataSource = dtRecord; ListBoxColumn l_ValueField = new ListBoxColumn(); l_ValueField.FieldName = "DocNumber"; l_ValueField.Caption = "MRP#"; l_ValueField.Width = 150; combo.Columns.Add(l_ValueField); ListBoxColumn l_TextField = new ListBoxColumn(); l_TextField.FieldName = "MRPMonth"; l_TextField.Caption = "Month/Year"; l_TextField.Width = 75; combo.Columns.Add(l_TextField); ListBoxColumn l_TextField2 = new ListBoxColumn(); l_TextField2.FieldName = "EntityCode"; l_TextField2.Caption = "Entity"; l_TextField2.Width = 150; combo.Columns.Add(l_TextField2); ListBoxColumn l_TextField3 = new ListBoxColumn(); l_TextField3.FieldName = "BUCode"; l_TextField3.Caption = "BU"; l_TextField3.Width = 250; combo.Columns.Add(l_TextField3); combo.ValueField = "DocNumber"; combo.TextField = "DocNumber"; combo.DataBind(); combo.TextFormatString = "{0}"; }
protected void TaxItemGroup_Init(object sender, EventArgs e) { ASPxComboBox combo = (ASPxComboBox)sender; combo.DataSource = POClass.TaxItemGroupTable(); ListBoxColumn l_value = new ListBoxColumn(); l_value.FieldName = "TaxItemGroup"; combo.Columns.Add(l_value); combo.ValueField = "TaxItemGroup"; combo.TextField = "TaxItemGroup"; combo.DataBind(); GridViewEditItemTemplateContainer container = combo.NamingContainer as GridViewEditItemTemplateContainer; if (!container.Grid.IsNewRowEditing) { combo.Value = DataBinder.Eval(container.DataItem, "TaxItemGroup").ToString(); } }
protected void MOPNum_Combo_Callback(object sender, CallbackEventArgsBase e) { ASPxComboBox combo = sender as ASPxComboBox; string monthyear = MonthYear_Combo.Text; if (!string.IsNullOrEmpty(monthyear)) { string[] strarr = monthyear.Split(' '); string month = strarr[0].ToString(); string year = strarr[1].ToString(); int monthindex = Convertion.MONTH_TO_INDEX(month); combo.DataSource = POClass.DocumentNumber_By_Month_Year(monthindex, year); } else { combo.DataSource = POClass.DocumentNumber_By_Month_Year(0, ""); } ListBoxColumn l_value = new ListBoxColumn(); l_value.FieldName = "PK"; l_value.Caption = "PK"; l_value.Width = 0; combo.Columns.Add(l_value); ListBoxColumn l_text = new ListBoxColumn(); l_text.FieldName = "DocumentNumber"; l_text.Caption = "Document Number"; combo.Columns.Add(l_text); combo.Value = "PK"; combo.Text = "DocumentNumber"; combo.DataBind(); combo.TextFormatString = "{1}"; }
// private DAL_ DAL = DAL_.Instance; protected void Page_Load(object sender, EventArgs e) { errorhandling.Visible = false; Success.Visible = false; if (!IsPostBack) { //ddlIndustry.cxBindCombo(DAL.Key.DbData.DataTable.Get_FromSP("FilterIndustrySp", "FilterIndustrySp", true), "IDIndustry", "Industry"); //ddlCompany.cxBindCombo(DAL.Key.DbData.DataTable.Get_FromSP("sp_LoadEventCompany", "sp_LoadEventCompany", true, "", new object[] { ddlIndustry.SelectedValue }), "IDCompany", "Company"); if (ddlCompany.Items.Count != 0) { //ddlSite.cxBindCombo(DAL.Key.DbData.DataTable.Get_FromSP("FilterSiteSp", "FilterSiteSp", true, "", new object[] { ddlCompany.SelectedValue }), "IDSite", "Site"); } else { ddlCompany.Items.Add("No Company Available"); ddlSite.Items.Clear(); ddlSite.Items.Add("No Sites Available"); } if (ddlCompany.Text != "No Company Available") { //ddlProduct.cxBindCombo(DAL.Key.DbData.DataTable.Get_FromSP("FilterProductsSp", "FilterProductsSp", true, "", new object[] { ddlCompany.SelectedValue }), "ProductID", "Product"); } else { ddlProduct.Items.Clear(); ddlProduct.Items.Add("No Products Available"); } if (ddlSite.Text != "No Sites Available") { //ddlDepartment.cxBindCombo(DAL.Key.DbData.DataTable.Get_FromSP("FilterDepartmentSp", "FilterDepartmentSp", true, "", new object[] { ddlSite.SelectedValue }), "IDDepartment", "Department"); } else { ddlDepartment.Items.Clear(); ddlDepartment.Items.Add("No Departments Available"); } if (ddlProduct.Items.Count == 0) { ddlProduct.Items.Add("No Products Available"); } if (ddlProduct.Text != "No Products Available") { //txtValue.Text = DAL.Key.DbData.DataTable.Get("FilterProductsSp").Rows[0][3].ToString(); txtValue.ReadOnly = true; } else { txtValue.Text = ""; } //if (DAL.Key.DbData.DataTable.Exists("FilterProductSp")) if (DAL.Key.DbData.DataTable.Get("FilterProductsSp").Rows.Count > 0) //{ // txtValue.Text = DAL.Key.DbData.DataTable.Get("FilterProductsSp").Rows[0][3].ToString(); // txtValue.ReadOnly = true; //} ListBoxColumn clm1 = new ListBoxColumn("ScreenName", "Screen Name"); ListBoxColumn clm2 = new ListBoxColumn("PersonName", "Name"); ListBoxColumn clm3 = new ListBoxColumn("PersonSurname", "Surame"); ScreenName.Columns.Add(clm1); ScreenName.Columns.Add(clm2); ScreenName.Columns.Add(clm3); lblPerson.Visible = false; ScreenName.Visible = false; } //ScreenName.DataSource = DAL.Key.DbData.DataTable.Get("contactPerson"); //ScreenName.TextField = DAL.Key.DbData.DataTable.Get("contactPerson").Columns["ScreenName"].ToString(); //ScreenName.ValueField = DAL.Key.DbData.DataTable.Get("contactPerson").Columns[0].ToString(); //ScreenName.DataBind(); }
protected void Page_Load(object sender, EventArgs e) { if (DAL.Key.DbData == null) DAL.Setup(null, new OleDbConnection(ConfigurationManager.ConnectionStrings["ManDash"].ConnectionString), loadTableSchemas: true); if (!IsPostBack) { //Databind Title ddl DAL.Key.DbData.DataTable.Get_FromSP("FilterTitleSp", "FilterTitleSp"); ddlTitle.DataSource = DAL.Key.DbData.DataTable.Get("FilterTitleSp"); ddlTitle.DataTextField = DAL.Key.DbData.DataTable.Get("FilterTitleSp").Columns[1].ToString(); ddlTitle.DataValueField = DAL.Key.DbData.DataTable.Get("FilterTitleSp").Columns[0].ToString(); ddlTitle.DataBind(); //string loginUser = (string) Session["login"]; ListBoxColumn clm1 = new ListBoxColumn("ScreenName", "Screen Name"); ListBoxColumn clm2 = new ListBoxColumn("PersonName", "Name"); ListBoxColumn clm3 = new ListBoxColumn("PersonSurname", "Surame"); ScreenName.Columns.Add(clm1); ScreenName.Columns.Add(clm2); ScreenName.Columns.Add(clm3); } ScreenName.DataSource = DAL.Key.DbData.DataTable.Get("contactPerson",true,true); ScreenName.TextField = DAL.Key.DbData.DataTable.Get("contactPerson").Columns["ScreenName"].ToString(); ScreenName.ValueField = DAL.Key.DbData.DataTable.Get("contactPerson").Columns[0].ToString(); ScreenName.DataBind(); ChangePass = false; confirmLabel.Visible = false; UserConfirmP.Visible = false; passwordLabel.Visible = false; UserPassword.Visible = false; // ddlDepartment.DataBind(); }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { depDiv.Visible = false; userDiv.Visible = false; ErrorMessage.Visible = false; DataTable FilterIndustrySp = new DataTable(); using (SqlConnection sqlcon = new SqlConnection(ConfigurationManager.ConnectionStrings["ManDash"].ConnectionString)) { using (SqlCommand cmd = new SqlCommand("FilterIndustrySp", sqlcon)) { cmd.CommandType = CommandType.StoredProcedure; using (SqlDataAdapter da = new SqlDataAdapter(cmd)) { da.Fill(FilterIndustrySp); } } } ddlIndustry.DataSource = FilterIndustrySp; ddlIndustry.DataTextField = FilterIndustrySp.Columns[1].ToString(); ddlIndustry.DataValueField = FilterIndustrySp.Columns[0].ToString(); ddlIndustry.DataBind(); DataTable sp_LoadEventCompany = new DataTable(); using (SqlConnection sqlcon = new SqlConnection(ConfigurationManager.ConnectionStrings["ManDash"].ConnectionString)) { using (SqlCommand cmd = new SqlCommand("sp_LoadEventCompany", sqlcon)) { cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@IndID", SqlDbType.VarChar).Value = ddlIndustry.SelectedValue; using (SqlDataAdapter da = new SqlDataAdapter(cmd)) { da.Fill(sp_LoadEventCompany); } } } ddlCompany.DataSource = sp_LoadEventCompany; ddlCompany.DataTextField = sp_LoadEventCompany.Columns[1].ToString(); ddlCompany.DataValueField = sp_LoadEventCompany.Columns[0].ToString(); ddlCompany.DataBind(); if (ddlCompany.Items.Count != 0) { DataTable FilterSiteSp = new DataTable(); using (SqlConnection sqlcon = new SqlConnection(ConfigurationManager.ConnectionStrings["ManDash"].ConnectionString)) { using (SqlCommand cmd = new SqlCommand("FilterSiteSp", sqlcon)) { cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@CompanyID", SqlDbType.VarChar).Value = ddlCompany.SelectedValue; using (SqlDataAdapter da = new SqlDataAdapter(cmd)) { da.Fill(FilterSiteSp); } } } ddlSite.DataSource = FilterSiteSp; ddlSite.DataTextField = FilterSiteSp.Columns[1].ToString(); ddlSite.DataValueField = FilterSiteSp.Columns[0].ToString(); ddlSite.DataBind(); } else { ddlCompany.Items.Add("No Company Available"); ddlSite.Items.Clear(); ddlSite.Items.Add("No Sites Available"); } if (ddlSite.Text != "No Sites Available") { DataTable FilterDepartmentSp = new DataTable(); using (SqlConnection sqlcon = new SqlConnection(ConfigurationManager.ConnectionStrings["ManDash"].ConnectionString)) { using (SqlCommand cmd = new SqlCommand("FilterDepartmentSp", sqlcon)) { cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@SiteID", SqlDbType.VarChar).Value = ddlSite.SelectedValue; using (SqlDataAdapter da = new SqlDataAdapter(cmd)) { da.Fill(FilterDepartmentSp); } } } ddlDepartment.DataSource = FilterDepartmentSp; ddlDepartment.DataTextField = FilterDepartmentSp.Columns[1].ToString(); ddlDepartment.DataValueField = FilterDepartmentSp.Columns[0].ToString(); ddlDepartment.DataBind(); } else { ddlDepartment.Items.Clear(); ddlDepartment.Items.Add("No Departments Available"); } ListBoxColumn clm1 = new ListBoxColumn("ScreenName", "Screen Name"); ListBoxColumn clm2 = new ListBoxColumn("PersonName", "Name"); ListBoxColumn clm3 = new ListBoxColumn("PersonSurname", "Surame"); ScreenName.Columns.Add(clm1); ScreenName.Columns.Add(clm2); ScreenName.Columns.Add(clm3); } DataTable contactPerson = new DataTable(); using (SqlConnection sqlcon = new SqlConnection(ConfigurationManager.ConnectionStrings["ManDash"].ConnectionString)) { using (SqlCommand cmd = new SqlCommand("Select * from contactPerson", sqlcon)) { cmd.CommandType = CommandType.StoredProcedure; using (SqlDataAdapter da = new SqlDataAdapter(cmd)) { da.Fill(contactPerson); } } } ScreenName.DataSource = contactPerson; ScreenName.TextField = contactPerson.Columns["ScreenName"].ToString(); ScreenName.ValueField = contactPerson.Columns[0].ToString(); ScreenName.DataBind(); }
//private DAL_ DAL = DAL_.Instance; protected void Page_Load(object sender, EventArgs e) { //if (DAL.Key.DbData == null) // DAL.Setup(null, new OleDbConnection(ConfigurationManager.ConnectionStrings["ManDash"].ConnectionString), loadTableSchemas: true); if (!IsPostBack) { //Databind Title ddl DataTable FilterTitleSp = new DataTable(); using (SqlConnection sqlcon = new SqlConnection(ConfigurationManager.ConnectionStrings["ManDash"].ConnectionString)) { using (SqlCommand cmd = new SqlCommand("FilterTitleSp", sqlcon)) { cmd.CommandType = CommandType.StoredProcedure; using (SqlDataAdapter da = new SqlDataAdapter(cmd)) { da.Fill(FilterTitleSp); } } } ddlTitle.DataSource = FilterTitleSp; ddlTitle.DataTextField = FilterTitleSp.Columns[1].ToString(); ddlTitle.DataValueField = FilterTitleSp.Columns[0].ToString(); ddlTitle.DataBind(); ListBoxColumn clm1 = new ListBoxColumn("ScreenName", "Screen Name"); ListBoxColumn clm2 = new ListBoxColumn("PersonName", "Name"); ListBoxColumn clm3 = new ListBoxColumn("PersonSurname", "Surame"); ScreenName.Columns.Add(clm1); ScreenName.Columns.Add(clm2); ScreenName.Columns.Add(clm3); } DataTable contactPerson = new DataTable(); using (SqlConnection sqlcon = new SqlConnection(ConfigurationManager.ConnectionStrings["ManDash"].ConnectionString)) { using (SqlCommand cmd = new SqlCommand("Select * from contactPerson", sqlcon)) { //cmd.CommandType = CommandType.StoredProcedure; using (SqlDataAdapter da = new SqlDataAdapter(cmd)) { da.Fill(contactPerson); } } } ScreenName.DataSource = contactPerson; ScreenName.TextField = contactPerson.Columns["ScreenName"].ToString(); ScreenName.ValueField = contactPerson.Columns[0].ToString(); ScreenName.DataBind(); ChangePass = true; confirmLabel.Visible = false; UserConfirmP.Visible = false; passwordLabel.Visible = false; UserPassword.Visible = false; }
//private DAL_ DAL = DAL_.Instance; protected void Page_Load(object sender, EventArgs e) { //if (DAL.Key.DbData == null) // DAL.Setup(null, new OleDbConnection(ConfigurationManager.ConnectionStrings["ManDash"].ConnectionString), loadTableSchemas: true); GridDiv.Visible = false; if (Request.QueryString["un"].ToLower() == "guest") { OpenEditButton.Visible = false; editLabel.Visible = false; } string name = Request.QueryString["un"]; string table = (string)(Session[name + "TableName"]); //if (DAL.Key.DbData.DataSet.Get.Tables.Contains(table)) //{ // EventGrid.DataSource = DAL.Key.DbData.DataTable.Get(table); // EventGrid.DataBind(); // EventGrid.KeyFieldName = "IDEvent"; // GridDiv.Visible = true; // EventGrid.Columns[0].Visible = false; //} if (ddlFilter.SelectedValue == "0") { SearchFilter.Visible = false; ddlSelection.Visible = false; GridDiv.Visible = false; } if (!IsPostBack) { ListBoxColumn clm1 = new ListBoxColumn("ScreenName", "Screen Name"); ListBoxColumn clm2 = new ListBoxColumn("PersonName", "Name"); ListBoxColumn clm3 = new ListBoxColumn("PersonSurname", "Surame"); ScreenName.Columns.Add(clm1); ScreenName.Columns.Add(clm2); ScreenName.Columns.Add(clm3); lblPerson.Visible = false; ScreenName.Visible = false; } //ScreenName.DataSource = DAL.Key.DbData.DataTable.Get("contactPerson"); //ScreenName.TextField = DAL.Key.DbData.DataTable.Get("contactPerson").Columns["ScreenName"].ToString(); //ScreenName.ValueField = DAL.Key.DbData.DataTable.Get("contactPerson").Columns[0].ToString(); //ScreenName.DataBind(); }
//private DAL_ DAL = DAL_.Instance; protected void Page_Load(object sender, EventArgs e) { string name = Request.QueryString["un"]; string tmpTableName = (string)(Session[name + "HistoryLoaded"]); //if (tmpTableName != null && DAL.Key.DbData.DataTable.Exists(tmpTableName)) //{ // DataTable table = DAL.Key.DbData.DataTable.Get(tmpTableName); // ASPxGV_History.DataSource = table; //} //if (DAL.Key.DbData == null) // DAL.Setup(null, new OleDbConnection(ConfigurationManager.ConnectionStrings["ManDash"].ConnectionString), loadTableSchemas: true); if (!IsPostBack) { ListBoxColumn clm1 = new ListBoxColumn("ScreenName", "Screen Name"); ListBoxColumn clm2 = new ListBoxColumn("PersonName", "Name"); ListBoxColumn clm3 = new ListBoxColumn("PersonSurname", "Surame"); cbxUser.Columns.Add(clm1); cbxUser.Columns.Add(clm2); cbxUser.Columns.Add(clm3); } //cbxUser.DataSource = DAL.Key.DbData.DataTable.Get("contactPerson"); //cbxUser.TextField = DAL.Key.DbData.DataTable.Get("contactPerson").Columns["ScreenName"].ToString(); //cbxUser.ValueField = DAL.Key.DbData.DataTable.Get("contactPerson").Columns[0].ToString(); //cbxUser.DataBind(); }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { depDiv.Visible = false; userDiv.Visible = false; ErrorMessage.Visible = false; DAL.Key.DbData.DataTable.Get_FromSP("FilterIndustrySp", "FilterIndustrySp"); ddlIndustry.DataSource = DAL.Key.DbData.DataTable.Get("FilterIndustrySp"); ddlIndustry.DataTextField = DAL.Key.DbData.DataTable.Get("FilterIndustrySp").Columns[1].ToString(); ddlIndustry.DataValueField = DAL.Key.DbData.DataTable.Get("FilterIndustrySp").Columns[0].ToString(); ddlIndustry.DataBind(); DAL.Key.DbData.DataTable.Get_FromSP("sp_LoadEventCompany", "sp_LoadEventCompany", false, "", new object[] {ddlIndustry.SelectedValue}); ddlCompany.DataSource = DAL.Key.DbData.DataTable.Get("sp_LoadEventCompany"); ddlCompany.DataTextField = DAL.Key.DbData.DataTable.Get("sp_LoadEventCompany").Columns[1].ToString(); ddlCompany.DataValueField = DAL.Key.DbData.DataTable.Get("sp_LoadEventCompany").Columns[0].ToString(); ddlCompany.DataBind(); if (ddlCompany.Items.Count != 0) { DAL.Key.DbData.DataTable.Get_FromSP("FilterSiteSp", "FilterSiteSp", false, "", new object[] {ddlCompany.SelectedValue}); ddlSite.DataSource = DAL.Key.DbData.DataTable.Get("FilterSiteSp"); ddlSite.DataTextField = DAL.Key.DbData.DataTable.Get("FilterSiteSp").Columns[1].ToString(); ddlSite.DataValueField = DAL.Key.DbData.DataTable.Get("FilterSiteSp").Columns[0].ToString(); ddlSite.DataBind(); } else { ddlCompany.Items.Add("No Company Available"); ddlSite.Items.Clear(); ddlSite.Items.Add("No Sites Available"); } if (ddlSite.Text != "No Sites Available") { DAL.Key.DbData.DataTable.Get_FromSP("FilterDepartmentSp", "FilterDepartmentSp", false, "", new object[] {ddlSite.SelectedValue}); ddlDepartment.DataSource = DAL.Key.DbData.DataTable.Get("FilterDepartmentSp"); ddlDepartment.DataTextField = DAL.Key.DbData.DataTable.Get("FilterDepartmentSp").Columns[1].ToString(); ddlDepartment.DataValueField = DAL.Key.DbData.DataTable.Get("FilterDepartmentSp").Columns[0].ToString(); ddlDepartment.DataBind(); } else { ddlDepartment.Items.Clear(); ddlDepartment.Items.Add("No Departments Available"); } ListBoxColumn clm1 = new ListBoxColumn("ScreenName", "Screen Name"); ListBoxColumn clm2 = new ListBoxColumn("PersonName", "Name"); ListBoxColumn clm3 = new ListBoxColumn("PersonSurname", "Surame"); ScreenName.Columns.Add(clm1); ScreenName.Columns.Add(clm2); ScreenName.Columns.Add(clm3); } ScreenName.DataSource = DAL.Key.DbData.DataTable.Get("contactPerson"); ScreenName.TextField = DAL.Key.DbData.DataTable.Get("contactPerson").Columns["ScreenName"].ToString(); ScreenName.ValueField = DAL.Key.DbData.DataTable.Get("contactPerson").Columns[0].ToString(); ScreenName.DataBind(); }