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