/// <summary> /// 把单位数据添加到数据库 /// </summary> /// <param name="ds"></param> public void InsertUlist(DataTable ulistCodeTable) { using (PersistentManager pm = new PersistentManager()) { DownUnitDao dao = new DownUnitDao(); dao.SetPersistentManager(pm); dao.InsertUlist(ulistCodeTable); } }
/// <summary> /// 下载单位数据 创联 /// </summary> /// <returns></returns> public DataTable GetUnitInfos(string unitCodeList) { using (PersistentManager dbPm = new PersistentManager("YXConnection")) { DownUnitDao dao = new DownUnitDao(); dao.SetPersistentManager(dbPm); return(dao.GetUnitInfos(unitCodeList)); } }
/// <summary> /// 查询计量单位系列编号 /// </summary> /// <returns></returns> public DataTable GetUlistCode() { using (PersistentManager pm = new PersistentManager()) { DownUnitDao dao = new DownUnitDao(); dao.SetPersistentManager(pm); return(dao.GetUlistCode()); } }
/// <summary> /// 下载计量单位系列编号 /// </summary> /// <returns></returns> public DataTable GetBrandUlist(string ulistCodeList) { using (PersistentManager pm = new PersistentManager("YXConnection")) { DownUnitDao dao = new DownUnitDao(); dao.SetPersistentManager(pm); return(dao.GetBrandUlistInfo(ulistCodeList)); } }
/// <summary> /// 根据模糊计量单位和卷烟编码去中间表取得对应的计量单位 /// </summary> /// <param name="unitcode"></param> /// <param name="product"></param> /// <returns></returns> public DataTable GetProductByUnitCode(string unitcode, string product) { using (PersistentManager pm = new PersistentManager()) { DownUnitDao dao = new DownUnitDao(); dao.SetPersistentManager(pm); return(dao.GetProductByUnitCode(unitcode, product)); } }
/// <summary> /// 根据计量单位编号查询数据 /// </summary> /// <param name="ulistCode"></param> /// <returns></returns> public DataTable FindUnitCode(string ulistCode) { using (PersistentManager pm = new PersistentManager()) { DownUnitDao dao = new DownUnitDao(); dao.SetPersistentManager(pm); return(dao.FindUnitCodeByUlistCode(ulistCode)); } }
/// <summary> /// 下载单位数据 /// </summary> /// <returns></returns> public DataTable GetUnitInfo() { using (PersistentManager dbPm = new PersistentManager("DB2Connection")) { DownUnitDao dao = new DownUnitDao(); dao.SetPersistentManager(dbPm); return(dao.GetUnitInfo()); } }
/// <summary> /// 把单位数据添加到数据库 /// </summary> /// <param name="ds"></param> public void Insert(DataSet unitCodeDs) { using (PersistentManager pm = new PersistentManager()) { DownUnitDao dao = new DownUnitDao(); dao.SetPersistentManager(pm); if (unitCodeDs.Tables["WMS_UNIT_INSERT"].Rows.Count > 0) { dao.InsertUnit(unitCodeDs.Tables["WMS_UNIT_INSERT"]); } } }
/// <summary> /// 把单位数据添加到数据库 /// </summary> /// <param name="ds"></param> public void Insert(DataSet unitds, DataSet productds) { using (PersistentManager pm = new PersistentManager()) { DownUnitDao dao = new DownUnitDao(); dao.SetPersistentManager(pm); if (unitds.Tables["WMS_UNIT_INSERT"].Rows.Count > 0) { dao.InsertUnit(unitds); } if (productds.Tables["WMS_UNIT_PRODUCT"].Rows.Count > 0) { dao.InsertUnitProduct(productds); } } }