/// <summary>
/// 根据卷烟编码查询单位信息
/// </summary>
/// <param name="productCode"></param>
/// <returns></returns>
public DataTable FindProductCodeInfo(string productCode)
{
using (PersistentManager dbPm = new PersistentManager())
{
DownProductDao dao = new DownProductDao();
return(dao.FindProductCodeInfo(productCode));
}
}
/// <summary>
/// 查询卷烟产品编号
/// </summary>
/// <returns></returns>
public DataTable GetProductCode()
{
using (PersistentManager pm = new PersistentManager())
{
DownProductDao dao = new DownProductDao();
return(dao.GetProductCode());
}
}
/// <summary>
/// 把数据插入到数据库
/// </summary>
/// <param name="ds"></param>
public void Insert(DataSet ds)
{
using (PersistentManager pm = new PersistentManager())
{
DownProductDao dao = new DownProductDao();
dao.Insert(ds);
}
}
/// <summary>
/// 计量单位转换
/// </summary>
/// <param name="product"></param>
/// <returns></returns>
public DataTable ProductRate(string product)
{
using (PersistentManager pm = new PersistentManager())
{
DownProductDao dao = new DownProductDao();
dao.SetPersistentManager(pm);
return(dao.DownProductRate(product));
}
}
/// <summary>
/// 获取产品单位比例
/// </summary>
/// <param name="productCode"></param>
/// <returns></returns>
public DataTable DownProductRate(string productCode)
{
using (PersistentManager dbPm = new PersistentManager())
{
DownProductDao dao = new DownProductDao();
dao.SetPersistentManager(dbPm);
return(dao.DownProductRate(productCode));
}
}
/// <summary>
/// 下载卷烟产品信息表
/// </summary>
/// <returns></returns>
public DataTable GetProductInfo(string codeList)
{
using (PersistentManager dbPm = new PersistentManager("YXConnection"))
{
DownProductDao dao = new DownProductDao();
dao.SetPersistentManager(dbPm);
return(dao.GetProductInfo(codeList));
}
}
/// <summary>
/// 查询卷烟信息
/// </summary>
/// <returns></returns>
public DataTable ProductInfo()
{
using (PersistentManager pm = new PersistentManager())
{
DownProductDao dao = new DownProductDao();
dao.SetPersistentManager(pm);
return(dao.ProductInfo());
}
}
public DataTable GetProductCode(string code)
{
using (PersistentManager pm = new PersistentManager())
{
DownProductDao dao = new DownProductDao();
dao.SetPersistentManager(pm);
return(dao.GetProductCode(code));
}
}