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