private void lk_Product_Init() { //DataSet _ds = new DataSet(); ACMSLogic.StockRequest.StockRequest stockRequest = new ACMSLogic.StockRequest.StockRequest(); //string strSQL = "select * from tblproduct"; //SqlHelper.FillDataset(connection,CommandType.StoredProcedure,"UP_GETDATA",_ds,new string[] {"table"}, new SqlParameter("@strSQL", strSQL) ); //_ds.Tables[0]; DataTable dt = stockRequest.GetProductByBranch(this.lkBranchTo.EditValue.ToString()); //pr.GetProductByBranch(this.lkBranchTo.EditValue.ToString()); lk_Product.BestFit(); DevExpress.XtraEditors.Controls.LookUpColumnInfo[] col = new DevExpress.XtraEditors.Controls.LookUpColumnInfo[6]; col[0] = new DevExpress.XtraEditors.Controls.LookUpColumnInfo("strItemCode", "Item Code", 50, DevExpress.Utils.FormatType.None, "", true, DevExpress.Utils.HorzAlignment.Default, DevExpress.Data.ColumnSortOrder.None); col[1] = new DevExpress.XtraEditors.Controls.LookUpColumnInfo("strDescription", "Description", 50, DevExpress.Utils.FormatType.None, "", true, DevExpress.Utils.HorzAlignment.Default, DevExpress.Data.ColumnSortOrder.None); col[2] = new DevExpress.XtraEditors.Controls.LookUpColumnInfo("strStyle", "Style", 15, DevExpress.Utils.FormatType.None, "", true, DevExpress.Utils.HorzAlignment.Default, DevExpress.Data.ColumnSortOrder.None); col[3] = new DevExpress.XtraEditors.Controls.LookUpColumnInfo("strColor", "Color", 15, DevExpress.Utils.FormatType.None, "", true, DevExpress.Utils.HorzAlignment.Default, DevExpress.Data.ColumnSortOrder.None); col[4] = new DevExpress.XtraEditors.Controls.LookUpColumnInfo("strSize", "Size", 15, DevExpress.Utils.FormatType.None, "", true, DevExpress.Utils.HorzAlignment.Default, DevExpress.Data.ColumnSortOrder.None); col[5] = new DevExpress.XtraEditors.Controls.LookUpColumnInfo("nQuantity", "Quantity", 10, DevExpress.Utils.FormatType.None, "", true, DevExpress.Utils.HorzAlignment.Default, DevExpress.Data.ColumnSortOrder.None); try { new ACMS.XtraUtils.LookupEditBuilder.CommonLookupEditBuilder(lk_Product, dt, col, "strItemCode", "strItemCode", "Item Code"); } catch (Exception ex) { return; } }
private void LoadProductList() { this.repositoryItemLookUpEdit1.Columns.AddRange(new DevExpress.XtraEditors.Controls.LookUpColumnInfo[] { new DevExpress.XtraEditors.Controls.LookUpColumnInfo("strItemCode", "Product Code", 20, DevExpress.Utils.FormatType.None, "", true, DevExpress.Utils.HorzAlignment.Default, DevExpress.Data.ColumnSortOrder.None) }); ACMSLogic.StockRequest.StockRequest stockRequest = new ACMSLogic.StockRequest.StockRequest(); this.repositoryItemLookUpEdit1.DataSource = stockRequest.GetProductByBranch(this.terminalUser.Branch.Id); //pr.GetProductByBranch(this.lkBranchTo.EditValue.ToString()); this.repositoryItemLookUpEdit1.DisplayMember = "strItemCode"; this.repositoryItemLookUpEdit1.ValueMember = "strItemCode"; this.repositoryItemLookUpEdit1.NullText = "Select Product"; LookUpColumnInfoCollection col2 = repositoryItemLookUpEdit1.Columns; //a column to display values of the ProductID field //a column to display values of the ProductName field //col2.Add(new LookUpColumnInfo("Id","Product Code",20)); col2.Add(new LookUpColumnInfo("strBrand", "Brand", 50)); col2.Add(new LookUpColumnInfo("strDescription", "Description", 50)); col2.Add(new LookUpColumnInfo("strStyle", "Style", 50)); col2.Add(new LookUpColumnInfo("strColor", "Color", 50)); col2.Add(new LookUpColumnInfo("strSize", "Size", 50)); col2.Add(new LookUpColumnInfo("nQuantity", "Quantity", 50)); lkBranchTo.Properties.AutoSearchColumnIndex = 0; repositoryItemLookUpEdit1.BestFit(); repositoryItemLookUpEdit1.PopupWidth = 600; }
private void lk_Product_Init() { //DataSet _ds = new DataSet(); ACMSLogic.StockRequest.StockRequest stockRequest = new ACMSLogic.StockRequest.StockRequest(); //string strSQL = "select * from tblproduct"; //SqlHelper.FillDataset(connection,CommandType.StoredProcedure,"UP_GETDATA",_ds,new string[] {"table"}, new SqlParameter("@strSQL", strSQL) ); //_ds.Tables[0]; DataTable dt = stockRequest.GetProductByBranch(this.lkBranchTo.EditValue.ToString());//pr.GetProductByBranch(this.lkBranchTo.EditValue.ToString()); lk_Product.BestFit(); DevExpress.XtraEditors.Controls.LookUpColumnInfo[] col = new DevExpress.XtraEditors.Controls.LookUpColumnInfo[6]; col[0] = new DevExpress.XtraEditors.Controls.LookUpColumnInfo("strItemCode","Item Code",50,DevExpress.Utils.FormatType.None,"",true,DevExpress.Utils.HorzAlignment.Default,DevExpress.Data.ColumnSortOrder.None); col[1] = new DevExpress.XtraEditors.Controls.LookUpColumnInfo("strDescription","Description",50,DevExpress.Utils.FormatType.None,"",true,DevExpress.Utils.HorzAlignment.Default,DevExpress.Data.ColumnSortOrder.None); col[2] = new DevExpress.XtraEditors.Controls.LookUpColumnInfo("strStyle","Style",15,DevExpress.Utils.FormatType.None,"",true,DevExpress.Utils.HorzAlignment.Default,DevExpress.Data.ColumnSortOrder.None); col[3] = new DevExpress.XtraEditors.Controls.LookUpColumnInfo("strColor","Color",15,DevExpress.Utils.FormatType.None,"",true,DevExpress.Utils.HorzAlignment.Default,DevExpress.Data.ColumnSortOrder.None); col[4] = new DevExpress.XtraEditors.Controls.LookUpColumnInfo("strSize","Size",15,DevExpress.Utils.FormatType.None,"",true,DevExpress.Utils.HorzAlignment.Default,DevExpress.Data.ColumnSortOrder.None); col[5] = new DevExpress.XtraEditors.Controls.LookUpColumnInfo("nQuantity","Quantity",10,DevExpress.Utils.FormatType.None,"",true,DevExpress.Utils.HorzAlignment.Default,DevExpress.Data.ColumnSortOrder.None); try { new ACMS.XtraUtils.LookupEditBuilder.CommonLookupEditBuilder(lk_Product,dt,col,"strItemCode","strItemCode","Item Code"); } catch(Exception ex) { return; } }
private void LoadProductList() { this.repositoryItemLookUpEdit1.Columns.AddRange(new DevExpress.XtraEditors.Controls.LookUpColumnInfo[] { new DevExpress.XtraEditors.Controls.LookUpColumnInfo("strItemCode", "Product Code", 20, DevExpress.Utils.FormatType.None, "", true, DevExpress.Utils.HorzAlignment.Default, DevExpress.Data.ColumnSortOrder.None)}); ACMSLogic.StockRequest.StockRequest stockRequest = new ACMSLogic.StockRequest.StockRequest(); this.repositoryItemLookUpEdit1.DataSource = stockRequest.GetProductByBranch(this.terminalUser.Branch.Id);//pr.GetProductByBranch(this.lkBranchTo.EditValue.ToString()); this.repositoryItemLookUpEdit1.DisplayMember = "strItemCode"; this.repositoryItemLookUpEdit1.ValueMember="strItemCode"; this.repositoryItemLookUpEdit1.NullText="Select Product"; LookUpColumnInfoCollection col2 = repositoryItemLookUpEdit1.Columns; //a column to display values of the ProductID field //a column to display values of the ProductName field //col2.Add(new LookUpColumnInfo("Id","Product Code",20)); col2.Add(new LookUpColumnInfo("strBrand","Brand",50)); col2.Add(new LookUpColumnInfo("strDescription","Description",50)); col2.Add(new LookUpColumnInfo("strStyle","Style",50)); col2.Add(new LookUpColumnInfo("strColor","Color",50)); col2.Add(new LookUpColumnInfo("strSize","Size",50)); col2.Add(new LookUpColumnInfo("nQuantity","Quantity",50)); lkBranchTo.Properties.AutoSearchColumnIndex = 0; repositoryItemLookUpEdit1.BestFit(); repositoryItemLookUpEdit1.PopupWidth = 600; }