private void BindData()
{
string id = Request.QueryString["id"];
InStockBLL bll = null;
InStockBillView info = new InStockBillView();
try
{
bll = BLLFactory.CreateBLL <InStockBLL>();
if (string.IsNullOrEmpty(id) == false)
{
info.ID = id;
info = bll.GetViewInfo(info);
UIBindHelper.BindForm(this.Page, info);
foreach (InStockDetailView detail in info.Details)
{
detail.UnitName = string.IsNullOrEmpty(detail.UnitName) == false ? detail.UnitName : detail.MainUnitName;
}
this.GvList.DataSource = info.Details;
this.GvList.DataBind();
}
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// 获取入库单浏览信息
/// </summary>
/// <param name="info">获取条件</param>
/// <returns>入库单浏览信息</returns>
public InStockBillView GetViewInfo(InStockBillView info)
{
string sql = null;
List <DataParameter> parameters = new List <DataParameter>();
using (IDataSession session = AppDataFactory.CreateMainSession())
{
//获取基本信息
sql = @"select t1.ID,t1.BillNO,t1.BillDate,t2.ProviderName as Provider,t3.Description as InStockMode,
t4.Description as Warehouse,u1.USERNAME as DeliveryPerson,u2.USERNAME as Receiver,
u3.USERNAME as WHHeader,t1.Remark
from T_WH_InStockBill t1
left outer join T_WH_Provider t2 on t1.ProviderID=t2.ID
left outer join T_WH_InMode t3 on t1.InStockMode=t3.ID
left outer join T_WH_Warehouse t4 on t1.Warehouse=t4.ID
left outer join T_USER u1 on t1.DeliveryPerson=u1.USERID
left outer join T_USER u2 on t1.Receiver=u2.USERID
left outer join T_USER u3 on t1.WHHeader=u3.USERID
where t1.ID=?ID";
info = session.Get <InStockBillView>(sql, new DataParameter("ID", info.ID));
//获取明细信息
sql = @"select t1.ID,t1.Seq,t1.MatBarCode,t1.MatID,t2.MatCode as MatCode,t2.MatName as MatName,t1.ProduceDate,
t1.InAmount,t1.InPrice,t1.InSum,t3.Description as SaveSite,t1.Remark,
twms.UnitName,t1.MatSpec,t5.Description as MainUnitName
from T_WH_InStockDetail t1
left outer join T_WH_Mat t2 on t1.MatID=t2.ID
left outer join T_WH_MatIDCode mic on t1.MatBarCode=mic.IDCode
left outer join T_WH_MatSpec twms on mic.MatSpec = twms.ID
left outer join T_WH_Site t3 on t1.SaveSite=t3.ID
left outer join T_WH_MatUnit t5 on t2.UnitCode=t5.ID
where t1.BillID=@BillID";
parameters.Add(new DataParameter("BillID", info.ID));
info.Details = session.GetList <InStockDetailView>(sql, parameters.ToArray()).ToList();
}
return(info);
}
/// <summary>
/// 获取入库单浏览信息
/// </summary>
/// <param name="info">获取条件</param>
/// <returns>入库单浏览信息</returns>
public InStockBillView GetViewInfo(InStockBillView info)
{
return(new InStockDAL().GetViewInfo(info));
}
