public void baseGridDetail_onLoadDataGrid(object sender, POS.Control.GridView.DataBindArgs e) { if (!(this.dsTranDetail != null && this.dsTranDetail.Tables.Count > 0 && this.dsTranDetail.Tables[0].Rows.Count > 0)) { this.dsTranDetail = ServiceProvider.TranDetailService.GetGridTranDetail(Converts.ParseLong(base.FormKeyCode)); } if (this.dsTranDetail.Tables.Count > 0) { foreach (DataRow dr in this.dsTranDetail.Tables[0].Rows) { string lotNo = dr["Lot No."].ToStringNullable(); if (!string.IsNullOrEmpty(lotNo)) { dr["Lot No."] = string.Format(Format.DecimalNumberFormat, lotNo.ToDouble()); } string quantity = dr["Quantity"].ToStringNullable(); if (!string.IsNullOrEmpty(quantity)) { dr["Quantity"] = string.Format(Format.DecimalNumberFormat, quantity.ToDouble()); } } } baseGridDetail.HiddenColumnName = new List <string>() { "tran_detail_id", "tran_head_id", "material_id", "warehouse_id_dest", "material_code" }; baseGridDetail.DataSourceDataSet = this.dsTranDetail; baseGridDetail.DataKeyName = new string[] { DataKeyName, "material_id", "warehouse_id_dest" }; }
public void grdBase_onLoadDataGrid(object sender, POS.Control.GridView.DataBindArgs e) { //hide the damn column grdBase.HiddenColumnName = new List <string>() { "stock_head_id" }; DataSet ds = ServiceProvider.StockHeadService.GetStockHead(); if (ds.Tables.Count > 0) { foreach (DataRow row in ds.Tables[0].Rows) { if (row["Status"].ToStringNullable() == TransactionStatus.IN.NormalCode) { row["Status"] = TransactionStatus.IN.NormalText; } else if (row["Status"].ToStringNullable() == TransactionStatus.IN.FinalCode) { row["Status"] = TransactionStatus.IN.FinalText; } row["Document Date"] = DateTime.Parse(row["Document Date"].ToString()).ConvertDateToDisplay(); row["Period"] = DateTime.Parse(row["Period"].ToString()).ConvertDateToDisplay(); } } grdBase.DataSourceDataSet = ds; grdBase.DataKeyName = new string[] { DataKeyName }; //try to set its visibility grdBase.btnDeleteEnable = false; grdBase.RearrangeButton(); }
public void grdBase_onLoadDataGrid(object sender, POS.Control.GridView.DataBindArgs e) { Material entity = new Material(); entity.material_code = txtMaterialCode.Text; entity.material_name = txtMaterialName.Text; grdBase.DataSourceDataSet = ServiceProvider.MaterialService.GetGridMaterial(entity); grdBase.DataKeyName = new string[] { DataKeyName }; }
public void grdBomDetail_onLoadDataGrid(object sender, POS.Control.GridView.DataBindArgs e) { //hide the damn column //grdBomHead.HiddenColumnName = new List<string>() { "ID" };//, "Supplier", "Warehouse" }; //grdBase.SetColumnFit(); grdBomDetail.DataSourceDataSet = ServiceProvider.KCSaleOrderDetailService.FindBOMDetailByOrderDetailId(globalMaterialID); //try to set its visibility grdBomDetail.btnDeleteEnable = false; grdBomDetail.btnAddEnable = false; grdBomDetail.btnSearchEnable = false; // grdBomHead.RearrangeButton(); }
public void grdBase_onLoadDataGrid(object sender, POS.Control.GridView.DataBindArgs e) { //hide the damn column grdBase.HiddenColumnName = new List <string>() { "tran_head_id" }; DataSet ds = ServiceProvider.TranHeadService.GetGridTranHeadIssueMaterial( txtDocNo.Text , dpDateFrom.Value , dpDateTo.Value , txtReferenceNo.Text , rdoWarehouse.Checked , rdoWaste.Checked , rdoOther.Checked , ddlWarehouse.SelectedValue.ToString() , txtOther.Text); if (ds.Tables.Count > 0) { foreach (DataRow row in ds.Tables[0].Rows) { if (row["Status"].ToStringNullable() == TransactionStatus.IN.NormalCode) { row["Status"] = TransactionStatus.IN.NormalText; } else if (row["Status"].ToStringNullable() == TransactionStatus.IN.FinalCode) { row["Status"] = TransactionStatus.IN.FinalText; } row["Document Date"] = DateTime.Parse(row["Document Date"].ToString()).ConvertDateToDisplay(); } } grdBase.DataSourceDataSet = ds; grdBase.DataKeyName = new string[] { DataKeyName }; //try to set its visibility grdBase.btnDeleteEnable = false; grdBase.RearrangeButton(); }
public void grdBase_onLoadDataGrid(object sender, POS.Control.GridView.DataBindArgs e) { //hide the damn column grdBomHead.HiddenColumnName = new List <string>() { "ID" }; grdBomHead.DataSourceDataSet = ServiceProvider.KCSaleOrderDetailService.FindBOMHeaderByOrderDetailId(globalMaterialID); grdBomHead.DataKeyName = new string[] { DataKeyName }; //try to set its visibility grdBomHead.btnDeleteEnable = false; grdBomHead.btnAddEnable = false; grdBomHead.btnSearchEnable = false; // grdBomHead.RearrangeButton(); }
public void baseGridDetail_onLoadDataGrid(object sender, POS.Control.GridView.DataBindArgs e) { if (base.FormMode == ObjectState.Edit) { this.dsStockDetail = ServiceProvider.StockDetailService.GetStockDetail(base.FormKeyCode.ToLong()); } else if (base.FormMode == ObjectState.Add) { this.dsStockDetail = ServiceProvider.StockDetailService.GetStockDetail(ddlPeriodGroup.SelectedValue.ToLong(), ddlWarehouse.SelectedValue.ToLong()); } if (this.dsStockDetail != null && this.dsStockDetail.Tables.Count > 0) { foreach (DataRow dr in this.dsStockDetail.Tables[0].Rows) { string lotNo = dr["Lot No."].ToStringNullable(); if (!string.IsNullOrEmpty(lotNo)) { dr["Lot No."] = string.Format(Format.DecimalNumberFormat, lotNo.ToDouble()); } string count = dr["Count"].ToStringNullable(); if (!string.IsNullOrEmpty(count)) { dr["Count"] = string.Format(Format.DecimalNumberFormat, count.ToDouble()); } string adjust = dr["Adjust"].ToStringNullable(); if (!string.IsNullOrEmpty(adjust)) { dr["Adjust"] = string.Format(Format.DecimalNumberFormat, adjust.ToDouble()); } } } baseGridDetail.HiddenColumnName = new List <string>() { "material_id", "stock_detail_id" }; baseGridDetail.DataSourceDataSet = this.dsStockDetail; baseGridDetail.DataKeyName = new string[] { DataKeyName, "material_id", "Lot No." }; }
public void grdBase_onLoadDataGrid(object sender, POS.Control.GridView.DataBindArgs e) { grdBase.DataSourceDataSet = ServiceProvider.PeriodGroupService.GetGridPeriodGroup(txtPeriodeGroupCode.Text, txtPeriodGroupName.Text); grdBase.DataKeyName = new string[] { DataKeyName }; }
public void grdBase_onLoadDataGrid(object sender, POS.Control.GridView.DataBindArgs e) { grdBase.DataSourceDataSet = ServiceProvider.BillOfMaterialHeadService.GetGridBOMHead(Converts.ParseLongNullable(ddlBOMGroup.SelectedValue.ToStringNullable()), txtBOMCode.Text, txtBOMName.Text); grdBase.DataKeyName = new string[] { DataKeyName }; }
public void grdBase_onLoadDataGrid(object sender, POS.Control.GridView.DataBindArgs e) { grdBase.DataSourceDataSet = ServiceProvider.SystemConfigGroupService.FindAllDataSet(false); grdBase.DataKeyName = new string[] { DataKeyName }; }
public void grdDetail_onLoadDataGrid(object sender, POS.Control.GridView.DataBindArgs e) { grdDetail.DataSourceDataSet = ServiceProvider.MenuMappingService.GetGridMenuMappingDetail(Converts.ParseLong(keyCode)); grdDetail.DataKeyName = new string[] { DataKeyName }; }
public void grdBase_onLoadDataGrid(object sender, POS.Control.GridView.DataBindArgs e) { grdBase.DataSourceDataSet = ServiceProvider.PeriodService.GetGridPeriod(txtPeriodCode.Text, dpPeriodDate.Value); grdBase.DataKeyName = new string[] { DataKeyName }; }
public void grdBase_onLoadDataGrid(object sender, POS.Control.GridView.DataBindArgs e) { grdBase.DataSourceTable = ServiceProvider.SystemConfigurationService.FindAll(true).ToList(); //DataTable dt = Converts.ConvertToDataTable(ServiceProvider.SystemConfigurationService.FindAll(true).ToArray()); //e.DataSource = ServiceProvider.SystemConfigurationService.FindAll(true); }
public void grdBase_onLoadDataGrid(object sender, POS.Control.GridView.DataBindArgs e) { grdBase.DataSourceDataSet = ServiceProvider.MenuMappingService.GetGridMenuMapping(txtName.Text); grdBase.DataKeyName = new string[] { DataKeyName }; }
public void grdBase_onLoadDataGrid(object sender, POS.Control.GridView.DataBindArgs e) { grdBase.DataSourceDataSet = ServiceProvider.EmployeeService.GetGridEmployee(txtEmployeeNo.Text, txtName.Text); grdBase.DataKeyName = new string[] { DataKeyName }; }