| | |
| | | using gregn6Lib; |
| | | using SQLHelper; |
| | | using DBUtility; |
| | | using Pub_Class; |
| | | |
| | | namespace Kanban |
| | | { |
| | |
| | | ClsCN SubCn = new ClsCN(); |
| | | string sSql = ""; |
| | | string sWhere = ""; |
| | | ClsIni oIni = new ClsIni(); |
| | | string sHWhName = ClsIni.ReadIni("Warehouse", "HWhName", Pub_Class.ClsPub.AppPath + @"\" + "HXErp_SY.ini"); |
| | | if (sHWhName == "æ²¡ææ¾å°ï¼") |
| | | { |
| | | sHWhName = ""; |
| | | } |
| | | //è¿æ»¤æ¡ä»¶ |
| | | //if (frmCondition.SqlStr.Trim().Length == 0) |
| | | // return; |
| | | //sSql = frmCondition.SqlStr + sWhere + " order by HStatus,HDate "; |
| | | sSql = "exec h_p_Sc_WGJCKKB"; |
| | | sSql = "exec h_p_Sc_WGJCKKB_New '" + sHWhName + "'"; |
| | | //sSql = "exec h_p_Sc_WGJCKKB_New " + DBUtility.ClsPub.isLong(sHWhID) + ",'" + sHWhName + "'"; |
| | | // |
| | | DSet = SubCn.RunProcReturn(sSql, ViewName, ref DBUtility.ClsPub.sExeReturnInfo); |
| | | //çæé¦è¡æ é¢ |