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