public DataSet GetGridPortfolioDetail(PortfolioHead entity)
{
StringBuilder sql = new StringBuilder();
sql.AppendLine(@" SELECT
material.material_id,
material.material_code,
material.material_name,
NULL AS warehouse_id,
'' AS warehouse_name,
uom.uom_name
FROM in_portfolio_detail AS detail
INNER JOIN in_material AS material ON detail.material_id = material.material_id
LEFT JOIN db_uom AS uom ON uom.uom_id = material.uom_id_receive
WHERE 1=1 ");
List <DbParameter> param = new List <DbParameter>();
if (entity.portfolio_head_id != 0)
{
sql.AppendLine(@" AND detail.portfolio_head_id = @PortfolioHeadID ");
param.Add(this.CreateParameter("@PortfolioHeadID", entity.portfolio_head_id));
}
return(base.ExecuteQuery(sql.ToString(), param.ToArray()));
}
private void grdBase_onLoadDataGrid(object sender, Control.GridView.DataBindArgs e)
{
PortfolioHead entity = new PortfolioHead();
entity.portfolio_head_name = txtName.Text;
entity.portfolio_head_code = txtCode.Text;
entity.portfolio_head_desc = txtDesc.Text;
grdBaseHead.DataSourceDataSet = ServiceProvider.PortfolioHeadService.GetGridPortfolioHead(entity);
grdBaseHead.DataKeyName = new string[] { DataKeyID };
grdBaseHead.HiddenColumnName = new List <string>()
{
"ID"
};
}
private void grdBase_onSelectedDataRow(object sender, Control.GridView.RowEventArgs e)
{
object result = base.OpenPopup <InPopupSelectWarehouse>();
if (result != null)
{
Dictionary <string, object> dataKey = (Dictionary <string, object>)sender;
PortfolioHead entity = new PortfolioHead();
entity.portfolio_head_id = dataKey[DataKeyID].ToLong();
DataSet dsPortfolioDetail = ServiceProvider.PortfolioDetailService.GetGridPortfolioDetail(entity);
ComboBoxDTO dto = (ComboBoxDTO)result;
if (dsPortfolioDetail.Tables.Count > 0)
{
foreach (DataRow dr in dsPortfolioDetail.Tables[0].Rows)
{
dr["warehouse_id"] = dto.Value.ToLong();
dr["warehouse_name"] = dto.Display;
}
}
this.ClosePopup(dsPortfolioDetail);
}
}
