/// <summary>
/// 获取所属单位编码
/// </summary>
/// <param name="productCode"></param>
/// <returns></returns>
public string QueryOrgCode()
{
using (PersistentManager persistentManager = new PersistentManager())
{
UpdateUploadDao dao = new UpdateUploadDao();
string sql = "SELECT SUBSTRING(ORG_CODE,0,5)+SUBSTRING(ORG_CODE,11,5) FROM DWV_OUT_ORG";
return(Convert.ToString(dao.GetDate(sql)));
}
}
/// <summary>
/// 根据卷烟编码查询名称
/// </summary>
/// <param name="productCode"></param>
/// <returns></returns>
public string QueryProduceName(string productCode)
{
using (PersistentManager persistentManager = new PersistentManager())
{
UpdateUploadDao dao = new UpdateUploadDao();
string sql = string.Format("SELECT PRODUCTNAME FROM WMS_PRODUCT WHERE PRODUCTCODE='{0}'", productCode);
return(Convert.ToString(dao.GetDate(sql)));
}
}