public void RemoveKPList(Newtonsoft.Json.Linq.JObject requestValue, Newtonsoft.Json.Linq.JObject Data, MESStationReturn StationReturn) { MESDBHelper.OleExec SFCDB = this.DBPools["SFCDB"].Borrow(); List <string> ret = new List <string>(); try { Newtonsoft.Json.Linq.JToken names = Data["ListNames"]; for (int i = 0; i < names.Count(); i++) { KPListBase list = KPListBase.GetKPListByListName(names[i].ToString(), SFCDB); try { SFCDB.BeginTrain(); list.ReMoveFromDB(SFCDB); ret.Add(names[i].ToString()); SFCDB.CommitTrain(); } catch { SFCDB.RollbackTrain(); } } StationReturn.Data = ret; StationReturn.Status = StationReturnStatusValue.Pass; } catch (Exception ee) { this.DBPools["SFCDB"].Return(SFCDB); StationReturn.Status = StationReturnStatusValue.Fail; StationReturn.MessageCode = "MES00000037"; StationReturn.MessagePara.Add(ee.Message); return; } this.DBPools["SFCDB"].Return(SFCDB); }
public void UpLoadKPList(Newtonsoft.Json.Linq.JObject requestValue, Newtonsoft.Json.Linq.JObject Data, MESStationReturn StationReturn) { MESDBHelper.OleExec SFCDB = this.DBPools["SFCDB"].Borrow(); SFCDB.BeginTrain(); try { string Skuno = Data["SkuNo"].ToString(); string ListName = Data["ListName"].ToString(); Newtonsoft.Json.Linq.JToken ListData = Data["ListData"]; T_C_KP_LIST T = new T_C_KP_LIST(SFCDB, MESDataObject.DB_TYPE_ENUM.Oracle); string NewListID = T.GetNewID(this.BU, SFCDB); Row_C_KP_LIST R = (Row_C_KP_LIST)T.NewRow(); DateTime Now = DateTime.Now; T_C_KP_List_Item TItem = new T_C_KP_List_Item(SFCDB, MESDataObject.DB_TYPE_ENUM.Oracle); Row_C_KP_List_Item RItem = (Row_C_KP_List_Item)TItem.NewRow(); T_C_KP_List_Item_Detail TDetail = new T_C_KP_List_Item_Detail(SFCDB, MESDataObject.DB_TYPE_ENUM.Oracle); Row_C_KP_List_Item_Detail RDetail = (Row_C_KP_List_Item_Detail)TDetail.NewRow(); KPListBase oldList = KPListBase.GetKPListByListName(ListName, SFCDB); if (oldList != null) { oldList.ReMoveFromDB(SFCDB); } R.ID = NewListID; R.SKUNO = Skuno.Trim(); R.LISTNAME = ListName; R.EDIT_EMP = this.LoginUser.EMP_NO; R.EDIT_TIME = Now; SFCDB.ExecSQL(R.GetInsertString(MESDataObject.DB_TYPE_ENUM.Oracle)); //Item PartNO KPName Station QTY ScanType DataTable dt = new DataTable(); dt.Columns.Add("Item"); dt.Columns.Add("PartNO"); dt.Columns.Add("KPName"); dt.Columns.Add("Station"); dt.Columns.Add("QTY"); dt.Columns.Add("ScanType"); List <DataRow> ListItem = new List <DataRow>(); for (int i = 0; i < ListData.Count(); i++) { DataRow dr = dt.NewRow(); dr["Item"] = ListData[i]["Item"].ToString(); dr["PartNO"] = ListData[i]["PartNO"].ToString(); dr["KPName"] = ListData[i]["KPName"].ToString(); dr["Station"] = ListData[i]["Station"].ToString(); dr["QTY"] = ListData[i]["QTY"].ToString(); dr["ScanType"] = ListData[i]["ScanType"].ToString(); dt.Rows.Add(dr); ListItem.Add(dr); } Dictionary <string, string> Item = new Dictionary <string, string>(); for (int i = 0; i < dt.Rows.Count; i++) { if (!Item.ContainsKey(dt.Rows[i]["Item"].ToString())) { Item.Add(dt.Rows[i]["Item"].ToString(), dt.Rows[i]["PartNO"].ToString()); } } string[] itemNo = new string[Item.Keys.Count]; Item.Keys.CopyTo(itemNo, 0); for (int i = 0; i < itemNo.Length; i++) { List <DataRow> Items = ListItem.FindAll(TT => TT["Item"].ToString() == itemNo[i]); for (int j = 0; j < Items.Count; j++) { if (j == 0) { RItem.ID = TItem.GetNewID(BU, SFCDB); RItem.LIST_ID = NewListID; RItem.KP_NAME = Items[j]["KPName"].ToString(); RItem.KP_PARTNO = Items[j]["PartNO"].ToString(); RItem.STATION = Items[j]["Station"].ToString(); RItem.QTY = double.Parse(Items[j]["QTY"].ToString()); RItem.SEQ = i; RItem.EDIT_EMP = this.LoginUser.EMP_NO; RItem.EDIT_TIME = Now; SFCDB.ExecSQL(RItem.GetInsertString(MESDataObject.DB_TYPE_ENUM.Oracle)); } RDetail.ID = TDetail.GetNewID(BU, SFCDB); RDetail.ITEM_ID = RItem.ID; RDetail.SCANTYPE = Items[j]["ScanType"].ToString(); RDetail.SEQ = j + 1; RDetail.EDIT_EMP = RItem.EDIT_EMP; RDetail.EDIT_TIME = Now; SFCDB.ExecSQL(RDetail.GetInsertString(MESDataObject.DB_TYPE_ENUM.Oracle)); } } StationReturn.Status = StationReturnStatusValue.Pass; } catch (Exception ee) { SFCDB.RollbackTrain(); this.DBPools["SFCDB"].Return(SFCDB); StationReturn.Status = StationReturnStatusValue.Fail; StationReturn.MessageCode = "MES00000037"; StationReturn.MessagePara.Add(ee.Message); return; } SFCDB.CommitTrain(); this.DBPools["SFCDB"].Return(SFCDB); }
public void DataReceive(DataReceivedEventArgs args) { Newtonsoft.Json.Linq.JObject obj2 = Newtonsoft.Json.Linq.JObject.Parse(args.Html); Newtonsoft.Json.Linq.JToken source = obj2["result"]; int num = int.Parse(obj2["total"].ToString()); if (source.Count <Newtonsoft.Json.Linq.JToken>() <= 0) { Console.WriteLine("无获取数据"); } else { foreach (Newtonsoft.Json.Linq.JToken token2 in (IEnumerable <Newtonsoft.Json.Linq.JToken>)source) { try { BsonDocument bsonDoc = BsonSerializer.Deserialize <BsonDocument>(token2.ToString()); string guid = bsonDoc.Text("encodeEpNeedId"); if (!this.hasExistObj(guid)) { bsonDoc.Set("guid", bsonDoc.Text("encodeEpNeedId")); StorageData target = new StorageData { Name = this.DataTableName, Document = bsonDoc, Type = StorageType.Insert }; DBChangeQueue.Instance.EnQueue(target); Console.WriteLine(bsonDoc.Text("epNeedCompanyName") + UrlQueue.Instance.Count.ToString()); } } catch (Exception exception) { Console.WriteLine(exception); } } if (num >= 300) { Console.WriteLine("开始翻页"); string urlParam = GetUrlParam(args.urlInfo.PostData, "limit"); string distinct = GetUrlParam(args.urlInfo.PostData, "epNeedCompanyDistrict"); string s = GetUrlParam(args.urlInfo.PostData, "page"); string str5 = GetUrlParam(args.urlInfo.PostData, "start"); string str6 = GetUrlParam(args.urlInfo.PostData, "epNeedRound"); string industry = GetUrlParam(args.urlInfo.PostData, "epNeedIndustry"); if (string.IsNullOrEmpty(str6)) { foreach (BsonDocument document2 in this.allNeedRound) { string epNeedRound = document2.Text("dicId"); this.InitialUrl(urlParam, distinct, "0", "0", epNeedRound, industry); } } else { int num3 = int.Parse(s); int num4 = int.Parse(str5); int num2 = num3; num3 = num2 + 1; this.InitialUrl(urlParam, distinct, num3.ToString(), (num3 * this.pageSize).ToString(), str6, industry); } } } }