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