| | |
| | | throw (e); |
| | | } |
| | | } |
| | | |
| | | //è¡å
³éåæ®ï¼è¡å
³éåæ§å¶ï¼(å
å«åå
¥æ¥å¿) 2024-01-31 |
| | | public bool CloseRow(Int64 lngBillKey, Int64 HEntryID, string HBillNo, string sUser, string procName, ref string sReturn) |
| | | { |
| | | DataSet ds; |
| | | try |
| | | { |
| | | oCn.BeginTran(); |
| | | string HCloseMan = sUser; |
| | | string HEntryCloseDate = ClsPub.GetServerDate(-1); |
| | | //åæ´è¡å
³éç¶æ |
| | | string sql = " Update " + MvarItemKeySub + " set HCloseMan='" + HCloseMan + "',HEntryCloseDate='" + HEntryCloseDate + "',HCloseType=1 Where HInterID=" + lngBillKey.ToString() + " and HEntryID = " + HEntryID; |
| | | oCn.RunProc(sql); |
| | | |
| | | //æ£æ¥åæ®å表ææè¡æ¯å¦é½å
³éï¼è¥é½å
³éåèªå¨å
³éåæ® |
| | | //sql = "select * from " + MvarItemKeySub + " where HInterID=" + lngBillKey + " and HCloseMan=''"; |
| | | //ds = oCn.RunProcReturn(sql, MvarItemKeySub); |
| | | //if(ds!=null && ds.Tables[0].Rows.Count == 0) |
| | | //{ |
| | | // sql = " Update " + MvarItemKey + " set HCloseMan='" + HCloseMan + "',HCloseDate=getdate(),HBillStatus=3,HCloseType = 0 Where HInterID=" + lngBillKey.ToString(); |
| | | // oCn.RunProc(sql); |
| | | //} |
| | | |
| | | //åå
¥æ¥å¿ |
| | | string WorkList = "è¡å
³éï¼åæ®å·ï¼" + HBillNo + "ï¼å表å
ç ï¼" + HEntryID; |
| | | string SystemName = "LMES-" + MvarReportTitle + "模å"; |
| | | oCn.RunProc("Insert into System_Log(GeginDate,userid,WorkstationName,WorkList,SystemName,NetUserName,State) values " + |
| | | "(getdate(),'" + sUser + "','" + ComputerName + "','" + WorkList + "','" + SystemName + "','" + IPAddress + "','è¡å
³é')" |
| | | ); |
| | | |
| | | |
| | | |
| | | //è¡å
³éåæ§å¶========================================= |
| | | string sql_afterClose = "exec " + procName + " " + lngBillKey + "," + HEntryID + ",'" + HBillNo + "','" + sUser + "'"; |
| | | DataSet ds_afterClose = oCn.RunProcReturn(sql_afterClose, procName); |
| | | if (ds_afterClose == null || ds_afterClose.Tables[0].Rows.Count <= 0) |
| | | { |
| | | sReturn = "è¡å
³é失败ï¼åå ï¼è¡å
³éåæ§å¶é误ï¼è¯·èç³»ç½ç»ç®¡ç人åï¼"; |
| | | |
| | | oCn.RollBack(); |
| | | |
| | | return false; |
| | | } |
| | | else |
| | | { |
| | | if (ds_afterClose.Tables[0].Rows[0]["HBack"].ToString() != "0") |
| | | { |
| | | sReturn = "å
³é失败ï¼åå ï¼" + ds_afterClose.Tables[0].Rows[0]["HRemark"].ToString(); |
| | | oCn.RollBack(); |
| | | |
| | | return false; |
| | | } |
| | | } |
| | | //========================================= |
| | | |
| | | |
| | | sReturn = "è¡å
³éæåï¼"; |
| | | oCn.Commit(); |
| | | return true; |
| | | } |
| | | catch (Exception e) |
| | | { |
| | | sReturn = e.Message; |
| | | oCn.RollBack(); |
| | | throw (e); |
| | | } |
| | | } |
| | | //è¡å
³éåæ®(å
å«åå
¥æ¥å¿) 2024-01-31 |
| | | public bool CloseRow(Int64 lngBillKey,Int64 HEntryID, string HBillNo, string sUser, ref string sReturn) |
| | | { |