| | |
| | | { |
| | | try |
| | | { |
| | | |
| | | ds = oCN.RunProcReturn("select * from Xt_grdAlignment_WMES where HModName='" + HModName + "' and HUserName='" + user + "'", "Xt_grdAlignment_WMES"); |
| | | |
| | | if (ds.Tables[0].Rows.Count == 0) |
| | | { |
| | | ds = oCN.RunProcReturn("select * from Xt_grdAlignment_WMES where HModName='" + HModName + "' and (HUserName='admin' or HUserName='Admin')", "Xt_grdAlignment_WMES"); |
| | | |
| | | if (ds.Tables[0].Rows.Count == 0) { |
| | | objJsonResult.code = "1"; |
| | | objJsonResult.count = 1; |
| | | objJsonResult.Message = "Sucessï¼"; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | } |
| | | |
| | | objJsonResult.code = "1"; |
| | | objJsonResult.count = 1; |
| | |
| | | |
| | | #endregion |
| | | |
| | | #region éèå设置 å é¤ |
| | | [Route("Xt_grdAlignment_WMES/DelgrdAlignmentWMES")] |
| | | [HttpGet] |
| | | public object DelgrdAlignmentWMES(string HModName, string user) |
| | | { |
| | | try |
| | | { |
| | | ds = oCN.RunProcReturn("select * from Xt_grdAlignment_WMES where HModName='" + HModName + "' and HUserName='" + user + "'", "Xt_grdAlignment_WMES"); |
| | | |
| | | if (ds.Tables[0].Rows.Count == 0) |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "æ¤äººæ æ¨¡åæ°æ®!"; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | |
| | | |
| | | oCN.BeginTran(); |
| | | |
| | | oCN.RunProc("delete from Xt_grdAlignment_WMES where HModName='" + HModName + "' and HUserName='" + user + "'"); |
| | | |
| | | oCN.Commit(); |
| | | |
| | | objJsonResult.code = "1"; |
| | | objJsonResult.count = 1; |
| | | objJsonResult.Message = "å 餿åï¼"; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | catch (Exception e) |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = e.ToString(); |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | } |
| | | #endregion |
| | | |
| | | |
| | | #region æé®è®¾ç½® å表 |
| | | [Route("Xt_ModuleButtonSet_WMES/moduleButtonSetWMESList")] |
| | |
| | | using System.Data; |
| | | using System.Data.SqlClient; |
| | | using System.Web.Http; |
| | | using System.Windows.Forms; |
| | | using WebAPI.Models; |
| | | |
| | | namespace WebAPI.Controllers |
| | |
| | | //å§å¤å·¥åºååºååºåå |
| | | string msg2 = "[" + sArray[0].ToString() + "]"; |
| | | string user = sArray[1].ToString(); |
| | | string HComputerName = SystemInformation.ComputerName; //设å¤åç§° |
| | | |
| | | //夿æ¯å¦æç¼è¾æé |
| | | if (!DBUtility.ClsPub.Security_Log("Cj_StationInBill_Edit", 1, false, user)) |
| | |
| | | ","+ HmaterOutqty + ") "); |
| | | |
| | | LogService.Write("ç¨æ·:" + user + ",æ¥æ:" + DateTime.Now + ",æ°å¢å·¥åºè¿ç«åæ®:" + HBillNo); |
| | | oCN.RunProc("Insert into System_log (GeginDate, userid, WorkstationName, WorkList, SystemName, NetuserName, State) select GETDATE(),'" + user + "','" + HComputerName + "','" + "æ°å¢å·¥åºè¿ç«åæ®ï¼" + HBillNo + "','LMES-å·¥åºè¿ç«æ¨¡å','" + DBUtility.ClsPub.IPAddress + "','æ°å¢åæ®'", ref DBUtility.ClsPub.sExeReturnInfo); |
| | | } |
| | | else if ("Modify".Equals(eventType)) |
| | | { |
| | |
| | | " where HInterID=" + HInterID); |
| | | |
| | | LogService.Write("ç¨æ·:" + user + ",æ¥æ:" + DateTime.Now + ",ä¿®æ¹å·¥åºè¿ç«åæ®:" + HBillNo); |
| | | oCN.RunProc("Insert into System_log (GeginDate, userid, WorkstationName, WorkList, SystemName, NetuserName, State) select GETDATE(),'" + user + "','" + HComputerName + "','" + "ä¿®æ¹å·¥åºè¿ç«åæ®ï¼" + HBillNo + "','LMES-å·¥åºè¿ç«æ¨¡å','" + DBUtility.ClsPub.IPAddress + "','ä¿®æ¹åæ®'", ref DBUtility.ClsPub.sExeReturnInfo); |
| | | } |
| | | else |
| | | { |
| | |
| | | { |
| | | try |
| | | { |
| | | string HComputerName = SystemInformation.ComputerName; //设å¤åç§° |
| | | //ç¼è¾æé |
| | | if (!DBUtility.ClsPub.Security_Log("Cj_StationInBill_Drop", 1, false, HDeleteMan)) |
| | | { |
| | |
| | | else |
| | | { |
| | | //åå
¥å 餿¥å¿ |
| | | LogService.Write("ç¨æ·:" + HDeleteMan + ",æ¥æ:" + DateTime.Now + ",å é¤å·¥åºæµè¿ç«åæ®:" + oBill.omodel.HBillNo); |
| | | LogService.Write("ç¨æ·:" + HDeleteMan + ",æ¥æ:" + DateTime.Now + ",å é¤å·¥åºè¿ç«åæ®:" + oBill.omodel.HBillNo); |
| | | oCN.RunProc("Insert into System_log (GeginDate, userid, WorkstationName, WorkList, SystemName, NetuserName, State) select GETDATE(),'" + HDeleteMan + "','" + HComputerName + "','" + "å é¤å·¥åºè¿ç«åæ®ï¼" + oBill.omodel.HBillNo + "','LMES-å·¥åºè¿ç«æ¨¡å','" + DBUtility.ClsPub.IPAddress + "','å é¤åæ®'", ref DBUtility.ClsPub.sExeReturnInfo); |
| | | |
| | | objJsonResult.code = "1"; |
| | | objJsonResult.count = 1; |
| | |
| | | using System.IO; |
| | | using System.Web; |
| | | using System.Web.Http; |
| | | using System.Windows.Forms; |
| | | using WebAPI.Models; |
| | | |
| | | namespace WebAPI.Controllers |
| | |
| | | //ååºåå |
| | | string msg2 = "[" + sArray[0].ToString() + "]"; |
| | | string user = sArray[1].ToString();//ç¨æ·å |
| | | string HComputerName = SystemInformation.ComputerName; //设å¤åç§° |
| | | |
| | | //夿æ¯å¦æç¼è¾æé |
| | | if (!DBUtility.ClsPub.Security_Log("Cj_StationOutBill_Edit", 1, false, user)) |
| | |
| | | ","+ HmaterOutqty + ") "); |
| | | |
| | | LogService.Write("ç¨æ·:" + user + ",æ¥æ:" + DateTime.Now + ",æ°å¢å·¥åºåºç«åæ®:" + HBillNo); |
| | | oCN.RunProc("Insert into System_log (GeginDate, userid, WorkstationName, WorkList, SystemName, NetuserName, State) select GETDATE(),'" + user + "','" + HComputerName + "','" + "æ°å¢å·¥åºåºç«åæ®ï¼" + HBillNo + "','LMES-å·¥åºåºç«æ¨¡å','" + DBUtility.ClsPub.IPAddress + "','æ°å¢åæ®'", ref DBUtility.ClsPub.sExeReturnInfo); |
| | | } |
| | | else if ("Modify".Equals(eventType)) |
| | | { |
| | |
| | | " where HInterID=" + HInterID); |
| | | |
| | | LogService.Write("ç¨æ·:" + user + ",æ¥æ:" + DateTime.Now + ",ä¿®æ¹å·¥åºåºç«åæ®:" + HBillNo); |
| | | oCN.RunProc("Insert into System_log (GeginDate, userid, WorkstationName, WorkList, SystemName, NetuserName, State) select GETDATE(),'" + user + "','" + HComputerName + "','" + "ä¿®æ¹å·¥åºåºç«åæ®ï¼" + HBillNo + "','LMES-å·¥åºåºç«æ¨¡å','" + DBUtility.ClsPub.IPAddress + "','ä¿®æ¹åæ®'", ref DBUtility.ClsPub.sExeReturnInfo); |
| | | } |
| | | else |
| | | { |
| | |
| | | { |
| | | try |
| | | { |
| | | |
| | | string HComputerName = SystemInformation.ComputerName; //设å¤åç§° |
| | | //ç¼è¾æé |
| | | if (!DBUtility.ClsPub.Security_Log("Cj_StationOutBill_Drop", 1, false, HDeleteMan)) |
| | | { |
| | |
| | | else |
| | | { |
| | | //åå
¥å 餿¥å¿ |
| | | LogService.Write("ç¨æ·:" + HDeleteMan + ",æ¥æ:" + DateTime.Now + ",å é¤å·¥åºæµåºç«åæ®:" + oBill.omodel.HBillNo); |
| | | LogService.Write("ç¨æ·:" + HDeleteMan + ",æ¥æ:" + DateTime.Now + ",å é¤å·¥åºåºç«åæ®:" + oBill.omodel.HBillNo); |
| | | oCN.RunProc("Insert into System_log (GeginDate, userid, WorkstationName, WorkList, SystemName, NetuserName, State) select GETDATE(),'" + HDeleteMan + "','" + HComputerName + "','" + "å é¤å·¥åºåºç«åæ®ï¼" + oBill.omodel.HBillNo + "','LMES-å·¥åºåºç«æ¨¡å','" + DBUtility.ClsPub.IPAddress + "','å é¤åæ®'", ref DBUtility.ClsPub.sExeReturnInfo); |
| | | |
| | | objJsonResult.code = "1"; |
| | | objJsonResult.count = 1; |
| | |
| | | using System.Data; |
| | | using System.Data.SqlClient; |
| | | using System.Web.Http; |
| | | using System.Windows.Forms; |
| | | using WebAPI.Models; |
| | | |
| | | namespace WebAPI.Controllers |
| | |
| | | SQLHelper.ClsCN oCN = new SQLHelper.ClsCN(); |
| | | DataSet ds; |
| | | Pub_Class.ClsXt_SystemParameter oSystemParameter = new Pub_Class.ClsXt_SystemParameter(); |
| | | |
| | | |
| | | #region[æ°å¢åæ®-ä¿åæé®] |
| | | /// <summary> |
| | |
| | | string msg3 = sArray[1].ToString(); |
| | | string msg4 = sArray[2].ToString(); |
| | | string msg5 = sArray[3].ToString(); |
| | | string HComputerName = SystemInformation.ComputerName; //设å¤åç§° |
| | | |
| | | string UserName = ""; |
| | | ListModels oListModels = new ListModels(); |
| | |
| | | LogService.Write("ç¨æ·:" + msg4 + ",æ¥æ:" + DateTime.Now + ",æ°å¢å·¥åºæµè½¬å¡åæ®:" + oBill.omodel.HBillNo); |
| | | // bResult = oBill.AddBill(ref DBUtility.ClsPub.sExeReturnInfo); |
| | | bResult = oBill.AddBill(ref DBUtility.ClsPub.sExeReturnInfo); |
| | | |
| | | oCN.RunProc("Insert into System_log (GeginDate, userid, WorkstationName, WorkList, SystemName, NetuserName, State) select GETDATE(),'" + msg4 + "','" + HComputerName + "','" + "æ°å¢å·¥åºæµè½¬å¡åæ®ï¼" + oBill.omodel.HBillNo + "','LMES-å·¥åºæµè½¬å¡æ¨¡å','" + DBUtility.ClsPub.IPAddress + "','æ°å¢åæ®'", ref DBUtility.ClsPub.sExeReturnInfo); |
| | | } |
| | | else |
| | | { |
| | | LogService.Write("ç¨æ·:" + msg4 + ",æ¥æ:" + DateTime.Now + ",ä¿®æ¹å·¥åºæµè½¬å¡åæ®:" + oBill.omodel.HBillNo); |
| | | bResult = oBill.ModifyBill(oBill.omodel.HInterID, ref DBUtility.ClsPub.sExeReturnInfo); |
| | | |
| | | oCN.RunProc("Insert into System_log (GeginDate, userid, WorkstationName, WorkList, SystemName, NetuserName, State) select GETDATE(),'" + msg4 + "','" + HComputerName + "','" + "ä¿®æ¹å·¥åºæµè½¬å¡åæ®ï¼" + oBill.omodel.HBillNo + "','LMES-å·¥åºæµè½¬å¡æ¨¡å','" + DBUtility.ClsPub.IPAddress + "','ä¿®æ¹åæ®'", ref DBUtility.ClsPub.sExeReturnInfo); |
| | | } |
| | | if (bResult) |
| | | { |
| | |
| | | string msg3 = sArray[1].ToString(); |
| | | string msg4 = sArray[2].ToString(); |
| | | string msg5 = sArray[3].ToString(); |
| | | string HComputerName = SystemInformation.ComputerName; //设å¤åç§° |
| | | |
| | | string UserName = ""; |
| | | ListModels oListModels = new ListModels(); |
| | |
| | | |
| | | //ä¿å宿¯åå¤ç |
| | | bool bResult; |
| | | |
| | | LogService.Write("ç¨æ·:" + msg4 + ",æ¥æ:" + DateTime.Now + ",æ°å¢å·¥åºæµè½¬å¡åæ®:" + oBill.omodel.HBillNo); |
| | | oCN.RunProc("Insert into System_log (GeginDate, userid, WorkstationName, WorkList, SystemName, NetuserName, State) select GETDATE(),'" + msg4 + "','" + HComputerName + "','" + "æ°å¢å·¥åºæµè½¬å¡åæ®ï¼" + oBill.omodel.HBillNo + "','LMES-å·¥åºæµè½¬å¡æ¨¡å','" + DBUtility.ClsPub.IPAddress + "','æ°å¢åæ®'", ref DBUtility.ClsPub.sExeReturnInfo); |
| | | |
| | | bResult = oBill.AddBill(ref sReturn); |
| | | if (bResult) |
| | |
| | | string msg4 = sArray[2].ToString();//å·¥èºè·¯çº¿ |
| | | string msg5 = sArray[3].ToString();//ç±»å |
| | | string msg6 = sArray[4].ToString();//ç¨æ· |
| | | string HComputerName = SystemInformation.ComputerName; //设å¤åç§° |
| | | |
| | | ListModels oListModels = new ListModels(); |
| | | |
| | |
| | | if (msg5 == "2") |
| | | { |
| | | LogService.Write("ç¨æ·:" + msg6 + ",æ¥æ:" + DateTime.Now + ",æ°å¢å·¥åºæµè½¬å¡åæ®:" + oBill.omodel.HBillNo); |
| | | oCN.RunProc("Insert into System_log (GeginDate, userid, WorkstationName, WorkList, SystemName, NetuserName, State) select GETDATE(),'" + msg6 + "','" + HComputerName + "','" + "æ°å¢å·¥åºæµè½¬å¡åæ®ï¼" + oBill.omodel.HBillNo + "','LMES-å·¥åºæµè½¬å¡æ¨¡å','" + DBUtility.ClsPub.IPAddress + "','æ°å¢åæ®'", ref DBUtility.ClsPub.sExeReturnInfo); |
| | | |
| | | bResult = oBill.AddBill(ref DBUtility.ClsPub.sExeReturnInfo); |
| | | } |
| | |
| | | return objJsonResult; |
| | | } |
| | | |
| | | string HComputerName = SystemInformation.ComputerName; //设å¤åç§° |
| | | |
| | | DAL.ClsSc_ProcessExchangeBill oBill = new DAL.ClsSc_ProcessExchangeBill(); |
| | | |
| | | string[] HBillNo = HInterID.Split(','); |
| | |
| | | HBillNo_S = HBillNo_S.Substring(0, HBillNo_S.Length - 1); |
| | | LogService.Write("ç¨æ·:" + user + ",æ¥æ:" + DateTime.Now + ",å é¤å·¥åºæµè½¬å¡åæ®:" + HBillNo_S); |
| | | |
| | | oCN.RunProc("Insert into System_log (GeginDate, userid, WorkstationName, WorkList, SystemName, NetuserName, State) select GETDATE(),'" + user + "','" + HComputerName + "','" + "å é¤å·¥åºæµè½¬å¡åæ®ï¼" + HBillNo_S + "','LMES-å·¥åºæµè½¬å¡æ¨¡å','" + DBUtility.ClsPub.IPAddress + "','å é¤åæ®'", ref DBUtility.ClsPub.sExeReturnInfo); |
| | | |
| | | foreach (var item in HBillNo) |
| | | { |
| | | bool IsDete = oBill.DeleteBill(long.Parse(item), ref DBUtility.ClsPub.sExeReturnInfo); |
| | |
| | | using System.IO; |
| | | using System.Web; |
| | | using System.Web.Http; |
| | | using System.Windows.Forms; |
| | | using WebAPI.Controllers.SCGL.æ¥è®¡å管ç; |
| | | using WebAPI.Models; |
| | | |
| | |
| | | //int hentryid = int.Parse(sArray[2].ToString());//å表ç顺åºid |
| | | int OperationType = int.Parse(sArray[2].ToString());//æ°æ®ç±»å 1æ·»å 3ä¿®æ¹ 2 å¤å¶ |
| | | string user = sArray[3].ToString();//ç¨æ·å |
| | | string HComputerName = SystemInformation.ComputerName; //设å¤åç§° |
| | | try |
| | | { |
| | | //夿æ¯å¦æç¼è¾æé |
| | |
| | | ",'" + HPicNumVer + "','" + HPicNumAssemble + "','" + HMaterTexture + "','" + HProductNum + "','" + HVerNum + "'," + HOrgID + ") "); |
| | | |
| | | LogService.Write("ç¨æ·:" + user + ",æ¥æ:" + DateTime.Now + ",æ°å¢å·¥èºè·¯çº¿åæ®:" + HBillNo); |
| | | oCN.RunProc("Insert into System_log (GeginDate, userid, WorkstationName, WorkList, SystemName, NetuserName, State) select GETDATE(),'" + user + "','" + HComputerName + "','" + "æ°å¢å·¥èºè·¯çº¿åæ®ï¼" + HBillNo + "','LMES-å·¥èºè·¯çº¿æ¨¡å','" + DBUtility.ClsPub.IPAddress + "','æ°å¢åæ®'", ref DBUtility.ClsPub.sExeReturnInfo); |
| | | } |
| | | else if (OperationType == 3 || ds.Tables[0].Rows.Count != 0) |
| | | { //ä¿®æ¹ |
| | |
| | | oCN.RunProc("delete from Gy_RoutingBillSub where HInterID='" + HInterID + "'"); |
| | | |
| | | LogService.Write("ç¨æ·:" + user + ",æ¥æ:" + DateTime.Now + ",ä¿®æ¹å·¥èºè·¯çº¿åæ®:" + HBillNo); |
| | | oCN.RunProc("Insert into System_log (GeginDate, userid, WorkstationName, WorkList, SystemName, NetuserName, State) select GETDATE(),'" + user + "','" + HComputerName + "','" + "ä¿®æ¹å·¥èºè·¯çº¿åæ®ï¼" + HBillNo + "','LMES-å·¥èºè·¯çº¿æ¨¡å','" + DBUtility.ClsPub.IPAddress + "','ä¿®æ¹åæ®'", ref DBUtility.ClsPub.sExeReturnInfo); |
| | | } |
| | | //ä¿åå表 |
| | | objJsonResult = AddBillSub(msg3, HInterID, OperationType); |
| | |
| | | using System.Data; |
| | | using System.Data.SqlClient; |
| | | using System.Web.Http; |
| | | using System.Windows.Forms; |
| | | using WebAPI.Models; |
| | | namespace WebAPI.Controllers |
| | | { |
| | |
| | | string ModRightNameCheck = "Gy_RoutingBill_Drop"; |
| | | try |
| | | { |
| | | string HComputerName = SystemInformation.ComputerName; //设å¤åç§° |
| | | //å 餿é |
| | | if (!DBUtility.ClsPub.Security_Log(ModRightNameCheck, 1, false, user)) |
| | | { |
| | |
| | | oCN.RunProc("delete from Gy_RoutingBillSub where HInterID=" + lngBillKey); |
| | | |
| | | LogService.Write("ç¨æ·:" + user + ",æ¥æ:" + DateTime.Now + ",å é¤å·¥èºè·¯çº¿åæ®:" + ds.Tables[0].Rows[0]["HBillNo"].ToString()); |
| | | oCN.RunProc("Insert into System_log (GeginDate, userid, WorkstationName, WorkList, SystemName, NetuserName, State) select GETDATE(),'" + user + "','" + HComputerName + "','" + "å é¤å·¥èºè·¯çº¿åæ®ï¼" + ds.Tables[0].Rows[0]["HBillNo"].ToString() + "','LMES-å·¥èºè·¯çº¿æ¨¡å','" + DBUtility.ClsPub.IPAddress + "','å é¤åæ®'", ref DBUtility.ClsPub.sExeReturnInfo); |
| | | |
| | | oCN.Commit();//æäº¤äºå¡ |
| | | objJsonResult.code = "0"; |
| | |
| | | using System.Data; |
| | | using System.Data.SqlClient; |
| | | using System.Web.Http; |
| | | using System.Windows.Forms; |
| | | using WebAPI.Models; |
| | | |
| | | namespace WebAPI.Controllers |
| | |
| | | int OperationType = int.Parse(sArray[1].ToString()); // æ°æ®ç±»å 1æ·»å 3ä¿®æ¹ |
| | | string user = sArray[2].ToString(); |
| | | int HEntryID = int.Parse(sArray[3].ToString()); |
| | | string HComputerName = SystemInformation.ComputerName; //设å¤åç§° |
| | | |
| | | try |
| | | { |
| | |
| | | ",'"+ HIsStockQty + "','"+ HRemark3 + "') "); |
| | | |
| | | LogService.Write("ç¨æ·:" + user + ",æ¥æ:" + DateTime.Now + ",æ°å¢ç产订ååæ®:" + HBillNo); |
| | | oCN.RunProc("Insert into System_log (GeginDate, userid, WorkstationName, WorkList, SystemName, NetuserName, State) select GETDATE(),'" + user + "','" + HComputerName + "','" + "æ°å¢ç产订ååæ®ï¼" + HBillNo + "','LMES-çäº§è®¢åæ¨¡å','" + DBUtility.ClsPub.IPAddress + "','æ°å¢åæ®'", ref DBUtility.ClsPub.sExeReturnInfo); |
| | | |
| | | } |
| | | else if (OperationType == 3 || ds.Tables[0].Rows.Count != 0) |
| | |
| | | oCN.RunProc("delete from Sc_ICMOBillSub where HInterID='" + HInterID + "' and HEntryID='" + HEntryID + "'"); |
| | | |
| | | LogService.Write("ç¨æ·:" + user + ",æ¥æ:" + DateTime.Now + ",ä¿®æ¹ç产订ååæ®:" + HBillNo); |
| | | oCN.RunProc("Insert into System_log (GeginDate, userid, WorkstationName, WorkList, SystemName, NetuserName, State) select GETDATE(),'" + user + "','" + HComputerName + "','" + "ä¿®æ¹ç产订ååæ®ï¼" + HBillNo + "','LMES-çäº§è®¢åæ¨¡å','" + DBUtility.ClsPub.IPAddress + "','ä¿®æ¹åæ®'", ref DBUtility.ClsPub.sExeReturnInfo); |
| | | } |
| | | //ä¿åå表 |
| | | objJsonResult = AddBillSub_NoTable(msg3, HInterID, OperationType, HEntryID); |
| | |
| | | { |
| | | try |
| | | { |
| | | string HComputerName = SystemInformation.ComputerName; //设å¤åç§° |
| | | |
| | | //夿æ¯å¦æå 餿é |
| | | if (!DBUtility.ClsPub.Security_Log("Sc_ICMOBill_Drop", 1, false, user)) |
| | | { |
| | |
| | | oCN.RunProc("delete from Sc_ICMOBillSub where HInterID=" + HInterID); |
| | | |
| | | LogService.Write("ç¨æ·:" + user + ",æ¥æ:" + DateTime.Now + ",å é¤ç产订ååæ®:" + ds.Tables[0].Rows[0]["HBillNo"].ToString()); |
| | | oCN.RunProc("Insert into System_log (GeginDate, userid, WorkstationName, WorkList, SystemName, NetuserName, State) select GETDATE(),'" + user + "','" + HComputerName + "','" + "å é¤ç产订ååæ®ï¼" + ds.Tables[0].Rows[0]["HBillNo"].ToString() + "','LMES-çäº§è®¢åæ¨¡å','" + DBUtility.ClsPub.IPAddress + "','å é¤åæ®'", ref DBUtility.ClsPub.sExeReturnInfo); |
| | | |
| | | oCN.Commit();//æäº¤äºå¡ |
| | | objJsonResult.code = "0"; |