| | |
| | | } |
| | | } |
| | | |
| | | //å é¤åæ®ï¼å é¤çäº§æ±æ¥åï¼å¹¶å é¤ç¸åºçWMS表记å½ï¼ |
| | | public virtual bool DeleteBillandWMS(Int64 lngBillKey,String HBillNo, String HERPMode, String HUpdateSourceInterID, ref string sReturn) |
| | | { |
| | | SQLHelper.ClsCN oCn = new SQLHelper.ClsCN(); |
| | | try |
| | | { |
| | | oCn.BeginTran(); |
| | | DataSet Ds = oCn.RunProcReturn("exec h_p_Sc_ICMOReportBill_Delete " + lngBillKey + ",'" + HBillNo + "','" + BillType + "','" + HERPMode + "','" + HUpdateSourceInterID + "'", "h_p_Sc_ICMOReportBill_Delete"); |
| | | if (Ds == null || Ds.Tables[0].Rows.Count == 0) |
| | | { |
| | | sReturn = "å é¤å夿é误ï¼å é¤åæ®å¤±è´¥ï¼"; |
| | | oCn.RollBack(); |
| | | return false; |
| | | } |
| | | if (DBUtility.ClsPub.isLong(Ds.Tables[0].Rows[0][0]) == 0) |
| | | { |
| | | sReturn = DBUtility.ClsPub.isStrNull(Ds.Tables[0].Rows[0]["HRemark"]); |
| | | oCn.Commit(); |
| | | return true; |
| | | } |
| | | else |
| | | { |
| | | sReturn = DBUtility.ClsPub.isStrNull(Ds.Tables[0].Rows[0]["HRemark"]); |
| | | oCn.RollBack(); |
| | | return false; |
| | | } |
| | | } |
| | | catch (Exception e) |
| | | { |
| | | sReturn = e.Message; |
| | | oCn.RollBack(); |
| | | return false; |
| | | } |
| | | } |
| | | |
| | | //æ«ç çæäº§éæ±æ¥åï¼æ æ¡ç åºå
¥åºè®°å½ï¼ |
| | | public bool AddBill_PDA2(ref string sReturn) |
| | | { |