public void CHECKROUTE() { //WebServices.tPublicStoredproc.ProcedureKey Pdk = new WebServices.tPublicStoredproc.ProcedureKey(); //List<WebServices.tPublicStoredproc.ProcedureKey> LsPdk = new List<WebServices.tPublicStoredproc.ProcedureKey>(); //Pdk.Variable = "DATA"; //Pdk.Value = txt_sn.Text.ToUpper().Trim().ToString(); //LsPdk.Add(Pdk); //Pdk = new WebServices.tPublicStoredproc.ProcedureKey(); //Pdk.Variable = "MYGROUP"; //Pdk.Value = cbroute.Text.ToString(); //LsPdk.Add(Pdk); Dictionary <string, object> dic = new Dictionary <string, object>(); dic.Add("DATA", txt_sn.Text.ToUpper().Trim().ToString()); dic.Add("MYGROUP", cbroute.Text.ToString()); string ChkRes = PubStor.ExecuteProcedure("PRO_CHECKROUTE", MapListConverter.DictionaryToJson(dic)); SaveTxtLog(System.Environment.CurrentDirectory + "\\DCT_INPUT", "ESN", ChkRes, txt_sn.Text.ToUpper().Trim().ToString()); if (ChkRes == "OK") { SendPrgMsg(mLogMsgType.Normal, "SN:" + txt_sn.Text.ToUpper().Trim().ToString() + " 输入OK,请刷入KPSN……"); txt_sn.Enabled = false; txt_kpsn.Enabled = true; txt_kpsn.Focus(); } else { SendPrgMsg(mLogMsgType.Error, "流程检查错误!!->" + ChkRes); txt_sn.Focus(); txt_sn.SelectAll(); return; } }
private bool Check_EMP(string EMP) { Dictionary <string, object> dic = new Dictionary <string, object>(); dic.Add("DATA", EMP); //string ChkRes = PubStor.ExecuteProcedure("PRO_CHECKEMP", MapListConverter.DictionaryToJson(dic)); //WebServices.tPublicStoredproc.ProcedureKey Pdk = new WebServices.tPublicStoredproc.ProcedureKey(); //List<WebServices.tPublicStoredproc.ProcedureKey> LsPdk = new List<WebServices.tPublicStoredproc.ProcedureKey>(); //Pdk.Variable = "DATA"; //Pdk.Value = EMP; //LsPdk.Add(Pdk); string ChkRes = PubStor.ExecuteProcedure("PRO_CHECKEMP", MapListConverter.DictionaryToJson(dic)); if (ChkRes == "OK") { SendPrgMsg(mLogMsgType.Normal, "权限检验OK,请刷入SN号码……"); return(true); } else { SendPrgMsg(mLogMsgType.Error, "权限检验失败!!" + ChkRes); return(false); } }
private string CHECK_EMP(string DATA) { Dictionary <string, object> dic = new Dictionary <string, object>(); dic.Add("DATA", DATA); string ChkRes = PubStor.ExecuteProcedure("PRO_CHECKEMP", MapListConverter.DictionaryToJson(dic)); SendMsg(ChkRes == "OK" ? mLogMsgType.Normal : mLogMsgType.Error, string.Format("EMP: {0}", ChkRes)); return(ChkRes); }
public string Check_Route_ATE(string DATA, string Route, string WO) { string Storedproc = "pro_Check_Route_ATE"; IDictionary <string, object> dic = new Dictionary <string, object>(); dic.Add("DATA", DATA); dic.Add("MYGROUP", Route); dic.Add("WO", WO); return(mPro.ExecuteProcedure(Storedproc.ToUpper(), MapListConverter.DictionaryToJson(dic))); }
private string PRO_TEST_MAIN_ONLY(string DATA, string MYGROUP, string EMP, string EC, string LINE) { Dictionary <string, object> dic = new Dictionary <string, object>(); dic.Add("DATA", DATA); dic.Add("MYGROUP", MYGROUP); dic.Add("EMP", EMP); dic.Add("EC", string.IsNullOrEmpty(EC) ? "NA" : EC); dic.Add("LINE", LINE); string ChkRes = PubStor.ExecuteProcedure("PRO_TEST_MAIN_ONLY", MapListConverter.DictionaryToJson(dic)); SendMsg(ChkRes == "OK" ? mLogMsgType.Normal : mLogMsgType.Error, string.Format("SN: {0}", ChkRes)); return(ChkRes); }
private string CHECK_EC(string DATA) { //WebServices.tPublicStoredproc.ProcedureKey Pdk = new WebServices.tPublicStoredproc.ProcedureKey(); //List<WebServices.tPublicStoredproc.ProcedureKey> LsPdk = new List<WebServices.tPublicStoredproc.ProcedureKey>(); //Pdk.Variable = "DATA"; //Pdk.Value = DATA; //LsPdk.Add(Pdk); Dictionary <string, object> dic = new Dictionary <string, object>(); dic.Add("DATA", DATA); string ChkRes = PubStor.ExecuteProcedure("PRO_CHECKEC", MapListConverter.DictionaryToJson(dic)); SendMsg(ChkRes == "OK" ? mLogMsgType.Normal : mLogMsgType.Error, string.Format("EC: {0}", ChkRes)); return(ChkRes); }
public string CHECK_ROUTE_TOOLS_ATE(string DATA, string MYGROUP, string WO, string Tools) { string _StrErr = string.Empty; _StrErr = tet.CHECK_TOOLS(Tools); if (_StrErr.Contains("OK")) { string Storedproc = "pro_Check_Route_ATE".ToUpper(); Dictionary <string, object> dic = new Dictionary <string, object>(); dic.Add("DATA", DATA); dic.Add("MYGROUP", MYGROUP); dic.Add("WO", WO); _StrErr = mPro.ExecuteProcedure(Storedproc, MapListConverter.DictionaryToJson(dic)); } return(_StrErr); }
public string Insert_T_TESTRESULT_INFO(Entity.tT_TESTRESULT_INFO tti) { IDictionary <string, object> dic = new Dictionary <string, object>(); dic.Add("ESN", tti.ESN); dic.Add("WOID", tti.WOID); dic.Add("TESTSTATION", tti.TESTSTATION); dic.Add("TESTRESULT", tti.TESTRESULT); dic.Add("EQPID", tti.EQPID); dic.Add("EQPTYPE", tti.EQPTYPE); dic.Add("CUSER", tti.CUSER); dic.Add("FAILDESC", tti.FAILDESC); dic.Add("PARTNUMBER", tti.PARTNUMBER); dic.Add("PRODUCTNAME", tti.PRODUCTNAME); dic.Add("RepairFlag", tti.RepairFlag); return(testresult.Insert_T_TESTRESULT_INFO(MapListConverter.DictionaryToJson(dic))); }
public string TEST_MAIN_ONLY(string DATA, string MYGROUP, string EMP, string EC, string LINE) { string _StrErr = string.Empty; try { Dictionary <string, object> dic = new Dictionary <string, object>(); dic.Add("DATA", DATA); dic.Add("MYGROUP", MYGROUP); dic.Add("EMP", EMP); dic.Add("EC", EC); dic.Add("LINE", LINE); _StrErr = _DbPro.ExecuteProcedure("PRO_TEST_MAIN_ONLY", MapListConverter.DictionaryToJson(dic)); return(_StrErr); } catch (Exception ex) { return(ex.Message); } }
public string INS_ATE_BACK_INS_WIPKEYPARTS(string DATA, string MYGROUP, string EMP, string LINE, string diclswipkeypart, int Flag) { IList <IDictionary <string, object> > lsdic = MapListConverter.JsonToListDictionary(diclswipkeypart); string _StrErr = "OK"; if (Flag == 0) { _StrErr = wiptracking.InsertWipKeyParts(lsdic); } if (_StrErr == "OK") { Dictionary <string, object> dic = new Dictionary <string, object>(); dic.Add("DATA", DATA); dic.Add("MYGROUP", MYGROUP); dic.Add("EMP", EMP); dic.Add("LINE", LINE); _StrErr = mPro.ExecuteProcedure("PRO_INS_ATE_BACK", MapListConverter.DictionaryToJson(dic)); } return(_StrErr); }
public string InsertWoBomInfoList(string diclstwbom) { try { IList <IDictionary <string, object> > lsdic = MapListConverter.JsonToListDictionary(diclstwbom); string table = "SFCR.T_WO_BOM_INFO"; IAdminProvider dp = (IAdminProvider)DpFactory.Create(typeof(IAdminProvider), DpFactory.ADMIN); IDictionary <string, object> mst = new Dictionary <string, object>(); mst.Add("WOID", lsdic[0]["WOID"]); mst.Add("BLOCKED", 0); dp.DeleteData(table, mst); string err = string.Empty; foreach (Dictionary <string, object> itemBom in lsdic) { InsertWoBomInfo(MapListConverter.DictionaryToJson(itemBom), out err); } return(err); } catch (Exception ex) { return(ex.Message); } }
private void txt_kpsn_KeyDown(object sender, KeyEventArgs e) { if (e.KeyCode == Keys.Enter) { Dictionary <string, object> dic = new Dictionary <string, object>(); dic.Add("DATA", txt_kpsn.Text.ToUpper().Trim().ToString()); dic.Add("SN", txt_sn.Text.ToUpper().Trim().ToString()); dic.Add("WO", cbwo.Text.ToString()); string ChkRes = PubStor.ExecuteProcedure("PRO_CHECK_KPS_VALID", MapListConverter.DictionaryToJson(dic)); if (ChkRes == "OK") { INSERT_KEYPARTS(); } else { SendPrgMsg(mLogMsgType.Error, "输入的KPSN" + txt_kpsn.Text.ToUpper().Trim().ToString() + " 异常->" + change_messge(ChkRes)); txt_kpsn.Focus(); txt_kpsn.SelectAll(); return; } } }
private void INSERT_KEYPARTS() { Dictionary <string, object> dic = new Dictionary <string, object>(); dic.Add("DATA", txt_kpsn.Text.ToUpper().Trim().ToString()); dic.Add("SN", txt_sn.Text.ToUpper().Trim().ToString()); dic.Add("MYGROUP", cbroute.Text.ToString()); dic.Add("EMP", sEMP); dic.Add("LINE", txt_line.Text.ToString()); dic.Add("WO", cbwo.Text.ToString()); string ChkRes = PubStor.ExecuteProcedure("PRO_INSERT_KEYPARTS", MapListConverter.DictionaryToJson(dic)); SaveTxtLog(System.Environment.CurrentDirectory + "\\DCT_INPUT", "KPESN", ChkRes, txt_kpsn.Text.ToUpper().Trim().ToString()); if (ChkRes == "OK") { station_qty = (Convert.ToInt32(station_qty) + 1).ToString(); lab_name.Text = wo_qty + "/" + station_qty; SendPrgMsg(mLogMsgType.Normal, "KPSN:" + txt_kpsn.Text.ToUpper().Trim().ToString() + " OK,请刷入下一个SN……"); if (ToolPrintlabel.Checked) { PrintLabel(txt_sn.Text); } txt_sn.Enabled = true; txt_kpsn.Enabled = false; txt_kpsn.Text = ""; txt_sn.Text = ""; txt_sn.Focus(); } else { SendPrgMsg(mLogMsgType.Error, "KPSN:" + txt_kpsn.Text.ToUpper().Trim().ToString() + " 写入系统失败!!->" + change_messge(ChkRes)); txt_kpsn.Focus(); txt_kpsn.SelectAll(); return; } }
private void GetStationList() { this.Invoke(new EventHandler(delegate { Dictionary <string, object> dic = new Dictionary <string, object>(); DataTable dt = ReleaseData.arrByteToDataTable(craft.Get_Craft_Info(MapListConverter.DictionaryToJson(dic))); DataView dv = dt.DefaultView; dv.Sort = "craftname Asc"; DataTable dt2 = dv.ToTable(); foreach (DataRow dr in dt2.Rows) { if (dr["TESTFLAG"].ToString() == "0" || dr["TESTFLAG"].ToString() == "3") { cbroute.Items.Add(dr["craftname"].ToString()); } } if (cbroute.Items.Count > 0) { cbroute.SelectedIndex = 0; } })); }
private void txt_sn_KeyDown(object sender, KeyEventArgs e) { if (e.KeyCode == Keys.Enter) { Dictionary <string, object> dic = new Dictionary <string, object>(); dic.Add("DATA", txt_sn.Text.ToUpper().Trim().ToString()); dic.Add("MYGROUP", cbroute.Text.ToString()); dic.Add("LINE", txt_line.Text.ToString()); dic.Add("WO", cbwo.Text.ToString()); dic.Add("EMP", sEMP); string ChkRes = PubStor.ExecuteProcedure("PRO_SN_INPUT_WIPFIRST", MapListConverter.DictionaryToJson(dic)); if (ChkRes == "OK") { CHECKROUTE(); } else { SendPrgMsg(mLogMsgType.Error, "输入的SN: " + txt_sn.Text.ToUpper().Trim().ToString() + " 异常->" + ChkRes); txt_sn.Focus(); txt_sn.SelectAll(); return; } } }
private string CHECK_SN(string SN) { Dictionary <string, object> dic = new Dictionary <string, object>(); dic.Add("DATA", SN); string _StrErr = refWebProcedure.Instance.ExecuteProcedure("PRO_CHECKSN", MapListConverter.DictionaryToJson(dic)); if (_StrErr == "OK") { SendMsgPass("CHECK SN OK"); } else { SendMsgError(_StrErr); } return(_StrErr); }
private void Call_TEST_MAIN_ONLY(string STOCK_NO) { int Cur_Rec = 0; int Tot_Rec = 0; int Err_Rec = 0; Dictionary <string, object> mst = new Dictionary <string, object>(); mst.Add("STORENUMBER", STOCK_NO); DataTable dt = FrmBLL.publicfuntion.getNewTable(mWipTraking.GetWipTracking(mst, "ESN,WOID,LOCSTATION").Tables[0], string.Format("LOCSTATION<>'{0}'", MYGROUP)); if (dt.Rows.Count > 0) { DataTable dt_woinfo = FrmBLL.ReleaseData.arrByteToDataTable(refWebtWoInfo.Instance.GetWoInfo(dt.Rows[0]["WOID"].ToString(), null, "LOC")); if (dt_woinfo.Rows.Count <= 0) { throw new Exception("没有找到工单信息:" + dt.Rows[0]["WOID"].ToString()); } Loc = dt_woinfo.Rows[0]["LOC"].ToString(); } Tot_Rec = dt.Rows.Count; string _StrErr = string.Empty; foreach (DataRow dr in dt.Rows) { Dictionary <string, object> dic = new Dictionary <string, object>(); dic.Add("DATA", dr["ESN"].ToString()); dic.Add("MYGROUP", MYGROUP); dic.Add("SECTION_NAME", MySection); dic.Add("STATION_NAME", MyStation); dic.Add("EMP", mFrm.gUserInfo.userId + "-" + mFrm.gUserInfo.pwd); dic.Add("EC", "NA"); dic.Add("LINE", MyLine); _StrErr = refWebProcedure.Instance.ExecuteProcedure("PRO_TEST_MAIN_ONLY", MapListConverter.DictionaryToJson(dic)); // mProcedure.PRO_TEST_MAIN_ONLY(dr["ESN"].ToString(), MYGROUP, MySection, MyStation, mFrm.gUserInfo.userId + "-" + mFrm.gUserInfo.pwd, "NA",MyLine, out _StrErr); Cur_Rec = Cur_Rec + 1; progressBarX1.Value = (int)(Math.Round((decimal)Cur_Rec / Tot_Rec, 2) * 100); //Convert.ToInt32((Convert.ToDouble(Cur_Rec / Tot_Rec) * 100)); progressBarX1.Update(); progressBarX1.Text = (Tot_Rec - Cur_Rec).ToString(); progressBarX1.Update(); if (Cur_Rec % 50 == 0) { System.Threading.Thread.Sleep(200); this.Refresh(); } if (_StrErr != "OK") { Err_Rec = Err_Rec + 1; LabError.Visible = true; LabError.Text = "NG Count-->" + Err_Rec.ToString(); } } }
public string Get_Erp_WoList() { return(MapListConverter.DictionaryToJson(erpwo.Get_Erp_WoList())); }
private void txt_sn_KeyDown(object sender, KeyEventArgs e) { if (!string.IsNullOrEmpty(txt_sn.Text) && e.KeyCode == Keys.Enter) { if (My_InputGroup == MYGROUP) { Dictionary <string, object> dic = new Dictionary <string, object>(); dic.Add("DATA", txt_sn.Text); dic.Add("MYGROUP", MYGROUP); dic.Add("SECTION_NAME", MySection); dic.Add("STATION_NAME", MyStation); dic.Add("EMP", My_UserId + "-" + My_Password); dic.Add("EC", My_EC); dic.Add("LINE", MyLine); dic.Add("WO", My_MoNumber); string _StrErr = refWebProcedure.Instance.ExecuteProcedure("PRO_INPUT_SN_FIRST", MapListConverter.DictionaryToJson(dic)); if (_StrErr == "OK") { LabInputQty.Text = (Convert.ToInt32(LabInputQty.Text) + 1).ToString(); SendMsgPass(string.Format("SN[{0}] OK", txt_sn.Text)); } else { SendMsgError(string.Format("ERROR:[{0}] {1}", txt_sn.Text, _StrErr)); } My_EC = "NA"; sECFlag = false; } else { SendMsgError(string.Format("ERROR:选择途程[{0}]与工单投入途程[{1}]不一致", MYGROUP, My_InputGroup)); } } }
private string CHECK_EC(string EC) { Dictionary <string, object> dic = new Dictionary <string, object>(); dic.Add("DATA", EC); string _StrErr = refWebProcedure.Instance.ExecuteProcedure("PRO_CHECKEC", MapListConverter.DictionaryToJson(dic)); if (_StrErr == "OK") { SendMsgPass("EC OK"); LabStatusreject.Text = "OK"; LabStatusreject.ForeColor = Color.Green; } else { SendMsgError("EC ERROR: " + _StrErr); } return(_StrErr); }
private string TEST_MAIN_ONLY(string SN, string EC) { Dictionary <string, object> dic = new Dictionary <string, object>(); dic.Add("DATA", SN); dic.Add("MYGROUP", MYGROUP); dic.Add("SECTION_NAME", MySection); dic.Add("STATION_NAME", MyStation); dic.Add("EMP", MyUserId + "-" + MyPassword); dic.Add("EC", EC); dic.Add("LINE", MyLine); string _StrErr = refWebProcedure.Instance.ExecuteProcedure("PRO_TEST_MAIN_ONLY", MapListConverter.DictionaryToJson(dic)); if (_StrErr == "OK") { SendMsgPass(string.Format("SN[{0}] OK", SN)); } else { SendMsgError(string.Format("SN[{0}] {1}", SN, _StrErr)); } return(_StrErr); }
public static string DictionaryToJson(IDictionary <string, object> Dic) { return(MapListConverter.DictionaryToJson(Dic)); }
private void txt_ec_KeyDown(object sender, KeyEventArgs e) { if (!string.IsNullOrEmpty(txt_ec.Text) && e.KeyCode == Keys.Enter) { Dictionary <string, object> dic = new Dictionary <string, object>(); dic.Add("DATA", txt_ec.Text); string _StrErr = refWebProcedure.Instance.ExecuteProcedure("PRO_CHECKEC", MapListConverter.DictionaryToJson(dic)); if (_StrErr == "OK") { My_EC = txt_ec.Text; sECFlag = true; SendMsgPass("EC OK"); } else { My_EC = "NA"; txt_ec.Text = "NA"; sECFlag = false; // SendMsgError("EC ERROR: " + _StrErr); } } }