/// <summary>
/// 获取实体数据
/// </summary>
/// <param name="SysNo">自动编号</param>
/// <returns></returns>
public override Model.Transport.CBDsWhGoodsManagement GetExtendsModBySysNo(int SysNo)
{
string sql = "select * from DsWhGoodsManagement where SysNo ='" + SysNo + "' ";
CBDsWhGoodsManagement cbManagement = Context.Sql(sql).QuerySingle <CBDsWhGoodsManagement>();
cbManagement.ModList = GetModListByPSysNo(SysNo);
return(cbManagement);
}
public override List <CBDsWhGoodsManagement> GetAllGoodsManageBySearch(CBDsWhGoodsManagement cbGoodsMan)
{
string sql = " select DsWhGoodsManagement.*,ToTalValue = (select sum(Quantiyt*GoodsPrice) from DsWhGoodsManagementList where PSysNo=DsWhGoodsManagement.SysNo) from DsWhGoodsManagement ";
if (!string.IsNullOrEmpty(cbGoodsMan.TotalWaybillNum))
{
sql += " where DsWhGoodsManagement.TotalWaybillNum='" + cbGoodsMan.TotalWaybillNum + "' ";
}
return(Context.Sql(sql).QueryMany <CBDsWhGoodsManagement>());
}
public abstract List <CBDsWhGoodsManagement> GetAllGoodsManageBySearch(CBDsWhGoodsManagement cbGoodsMan);
public List <CBDsWhGoodsManagement> GetAllGoodsManageBySearch(CBDsWhGoodsManagement cbGoodsMan)
{
return(IDsWhGoodsManagementDao.Instance.GetAllGoodsManageBySearch(cbGoodsMan));
}
