/// <summary>
/// 根据卷烟编码查询计量单位信息
/// </summary>
/// <param name="product"></param>
/// <returns></returns>
public DataTable FindUnitListCode(string product)
{
using (PersistentManager pm = new PersistentManager())
{
DownUnitDao dao = new DownUnitDao();
return(dao.FindUnitListCOde(product));
}
}
/// <summary>
/// 获取单位系统表字段
/// </summary>
/// <returns></returns>
public DataTable GetUnitProduct()
{
using (PersistentManager pm = new PersistentManager())
{
DownUnitDao dao = new DownUnitDao();
return(dao.GetUnitProduct());
}
}
/// <summary>
/// 单位系列表插入数据
/// </summary>
/// <param name="ds"></param>
public void InsertLcUnit(DataTable lcUnitTable)
{
using (PersistentManager pm = new PersistentManager())
{
DownUnitDao dao = new DownUnitDao();
dao.InsertLcUnit(lcUnitTable);
}
}
/// <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>
/// <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 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);
}
}
}
