private void BindData()
{
string id = Request.QueryString["id"];
OutStockBLL bll = null;
OutStockBillView info = new OutStockBillView();
try
{
bll = BLLFactory.CreateBLL <OutStockBLL>();
if (string.IsNullOrEmpty(id) == false)
{
info.ID = id;
info = bll.GetViewInfo(info);
UIBindHelper.BindForm(this.Page, info);
foreach (OutStockDetailView detail in info.Details)
{
detail.UnitName = string.IsNullOrEmpty(detail.UnitName) == false ? detail.UnitName : detail.MainUnitName;
if (detail.OutAmount == 0)
{
detail.OutAmount = detail.MainUnitAmount;
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 OutStockBillView GetViewInfo(OutStockBillView info)
{
string sql = null;
List <DataParameter> parameters = new List <DataParameter>();
using (IDataSession session = AppDataFactory.CreateMainSession())
{
//获取基本信息
sql = @"select t1.ID,t1.BillNO,t1.BillDate,t2.Clientname as Client,t3.Description as OutStockMode,
t4.Description as Warehouse,u1.USERNAME as Header,u2.USERNAME as WHHeader,
u3.USERNAME as HandlePerson,t1.Remark
from T_WH_OutStockBill t1
left outer join T_WH_Client t2 on t1.ClientCode=t2.ID
left outer join T_WH_OutMode t3 on t1.OutStockMode=t3.ID
left outer join T_WH_Warehouse t4 on t1.Warehouse=t4.ID
left outer join T_USER u1 on t1.Header=u1.USERID
left outer join T_USER u2 on t1.WHHeader=u2.USERID
left outer join T_USER u3 on t1.HandlePerson=u3.USERID
where t1.ID=?ID";
info = session.Get <OutStockBillView>(sql, new DataParameter("ID", info.ID));
//获取明细信息
sql = @"select t1.ID,t1.Seq,t1.IDCode,t1.MatID,t2.MatCode as MatCode,t2.MatName as MatName,t1.MainUnitAmount,
t1.OutAmount,t1.OutPrice,t1.OutSum,t3.Description as SaveSite,t1.Remark,twms.Description as SpecCode,
twms.UnitName,t5.Description as MainUnitName
from T_WH_OutStockDetail t1
left outer join T_WH_Mat t2 on t1.MatID=t2.ID
left outer join T_WH_MatIDCode mic on t1.IDCode=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_Spec t4 on t2.SpecCode=t4.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 <OutStockDetailView>(sql, parameters.ToArray()).ToList();
}
return(info);
}
/// <summary>
/// 获取出库单浏览信息
/// </summary>
/// <param name="info">获取条件</param>
/// <returns>入库单浏览信息</returns>
public OutStockBillView GetViewInfo(OutStockBillView info)
{
return(new OutStockDAL().GetViewInfo(info));
}
