| | |
| | | } |
| | | } |
| | | |
| | | |
| | | /// <summary> |
| | | /// 鏍规嵁鍐呯爜杩斿洖浠撲綅淇℃伅(骞跺垽鏂槸鍚﹀湪瀵瑰簲鐨勪粨搴撻噷) |
| | | /// </summary> |
| | | /// <param name="HSPID">浠撲綅鍐呯爜</param> |
| | | /// <param name="HWHID">浠撳簱鍐呯爜</param> |
| | | /// <param name="sErr">閿欒淇℃伅</param> |
| | | /// <returns></returns> |
| | | public DataSet GetInfoByID(long HSPID, long HWHID, long HORGID) |
| | | { |
| | | SQLHelper.ClsCN oCn = new SQLHelper.ClsCN(); |
| | | DataSet DS; |
| | | try |
| | | { |
| | | DS = oCn.RunProcReturn("Select * from h_v_IF_StockPlace Where HItemID=" + HSPID.ToString() + " and HWHID=" + HWHID.ToString(), "h_v_IF_StockPlace", ref DBUtility.ClsPub.sExeReturnInfo); |
| | | if (DS.Tables[0].Rows.Count == 0) |
| | | return null; |
| | | else |
| | | { |
| | | return DS; |
| | | } |
| | | } |
| | | catch (Exception e) |
| | | { |
| | | throw (e); |
| | | } |
| | | } |
| | | |
| | | |
| | | } |
| | | } |