| | |
| | | private json objJsonResult = new json(); |
| | | SQLHelper.ClsCN oCn = new SQLHelper.ClsCN(); |
| | | Pub_Class.ClsXt_SystemParameter oSystemParameter = new Pub_Class.ClsXt_SystemParameter(); |
| | | string ComputerName = SystemInformation.ComputerName; //设å¤åç§° |
| | | |
| | | |
| | | #region å¨å
·æ«ç 模åè°ç¨æ¹æ³ |
| | |
| | | /// <returns></returns> |
| | | [Route("MouldController/set_DeleteMouldBillList_Json")] |
| | | [HttpGet] |
| | | public object set_DeleteMouldBillList_Json(long HInterID, string HBillType) |
| | | public object set_DeleteMouldBillList_Json(long HInterID, string HBillNo, string HBillType, string HMaker, string MvarReportTitle) |
| | | { |
| | | try |
| | | { |
| | | string WorkList = "å é¤ç¼ååæ®ï¼åæ®å·ï¼" + HBillNo; |
| | | string SystemName = "WMS-" + MvarReportTitle + "模å"; |
| | | oCn.BeginTran(); |
| | | oCn.RunProc("Delete from Sc_MouldStockBillMain_Temp where HInterID=" + HInterID.ToString() + " and HBillType='" + HBillType + "'", ref DBUtility.ClsPub.sExeReturnInfo); |
| | | //åå
¥æ¥å¿ |
| | | oCn.RunProc("Insert into System_Log(GeginDate,userid,WorkstationName,WorkList,SystemName,NetUserName,State) values " + |
| | | "(getdate(),'" + HMaker + "','" + ComputerName + "','" + WorkList + "','" + SystemName + "','','å é¤')" |
| | | ); |
| | | oCn.Commit(); |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 1; |
| | | objJsonResult.Message = "å 餿å"; |
| | | objJsonResult.Message = "åæ®å·ï¼" + HBillNo + " å 餿å"; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | catch (Exception e) |
| | | { |
| | | oCn.RollBack(); |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "å é¤å¨å
·ç¼ååè¡¨åæ®å¤±è´¥ï¼" + e.ToString(); |