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