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);
}
}
}
}
