///// <summary> ///// 获取最大的SN序号以及对应的工单号 ///// </summary> ///// <returns></returns> //public string[] GetMaxSn() //{ // return BLL.BllMsSqllib.Instance.GetMaxSn(); //} /// <summary> /// 更新跟踪序列号 /// </summary> /// <param name="snrule"></param> /// <param name="id"></param> public void UpdateSnRule(string Dicsnrule) { IAdminProvider dp = (IAdminProvider)DpFactory.Create(typeof(IAdminProvider), DpFactory.ADMIN); IDictionary <string, object> mst = MapListConverter.JsonToDictionary(Dicsnrule); dp.UpdateData("SFCR.T_SN_RULE", new string[] { "ROWID" }, mst); }
public string InsertSmtKpNormalLog(string distring, string ROWID, int cdata) { string err = "InsertSmtKpNormalLog Error "; IDictionary <string, object> mst = MapListConverter.JsonToDictionary(distring); string Trsn = mst["KP_SN"].ToString(); mSmtkpnormallog.InsertSmtKpNormalLog(mst, out err); if (err == "OK") { if (!string.IsNullOrEmpty(Trsn) && Trsn != "NA") { err = mPro.UPDATE_TR_SN(Trsn, "NA", mst["USERID"].ToString(), "7", "NA", "NA"); } if (err == "OK") { try { if (!string.IsNullOrEmpty(ROWID) && ROWID != "NA") { mSmtkpmonitor.EditSmtKpMonitorFlag(ROWID, cdata); } } catch (Exception ex) { err = ex.Message; } } } return(err); }
/// <summary> /// 更新钢网信息 /// </summary> /// <param name="partstoremodel"></param> /// <param name="trsn"></param> /// <returns></returns> public void UpdateGangInfo(string dicstring) { IAdminProvider dp = (IAdminProvider)DpFactory.Create(typeof(IAdminProvider), DpFactory.ADMIN); IDictionary <string, object> mst = MapListConverter.JsonToDictionary(dicstring); dp.UpdateData("SFCR.T_PART_STOREHOUSE_HAD", new string[] { "TRSN" }, mst); }
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); } }
/// <summary> /// 添加料站表数据 /// </summary> /// <param name="kpmaster">料站表头数据</param> /// <param name="lskpdetalt">料站表身数据列表</param> public void InsertMaterTable(string kpmaster, string lskpdetalt) { string outmasteridTemp; string Err; IDictionary <string, object> mst = MapListConverter.JsonToDictionary(kpmaster); IList <IDictionary <string, object> > Lsmst = MapListConverter.JsonToListDictionary(lskpdetalt); mPro.PRO_INSERT_SMT_KP_MASTER(mst["LINEID"].ToString(), mst["USERID"].ToString(), mst["PARTNUMBER"].ToString(), mst["MODELNAME"].ToString(), mst["BOMVER"].ToString(), mst["PCBSIDE"].ToString(), mst["RESERVE1"].ToString(), "0", out outmasteridTemp, out Err); if (Err != "OK") { throw new Exception(Err + " 料站表头数据增加失败,请检查"); } IAdminProvider dp = (IAdminProvider)DpFactory.Create(typeof(IAdminProvider), DpFactory.ADMIN); foreach (Dictionary <string, object> item in Lsmst) { item["MASTERID"] = outmasteridTemp; try { dp.AddData("SFCR.T_SMT_KP_DETALT", item); } catch (Exception ex) { throw new Exception(ex.Message + " 料站表身数据增加失败,请检查[" + item["STATIONNO"] + "]"); } } }
public void InsertSmtIoData(string dicskm) { IAdminProvider dp = (IAdminProvider)DpFactory.Create(typeof(IAdminProvider), DpFactory.ADMIN); IDictionary <string, object> mst = MapListConverter.JsonToDictionary(dicskm); dp.AddData("SFCR.T_SMT_KP_MONNITOR", mst); }
/// <summary> /// 新增工厂信息 /// </summary> /// <param name="facinfo"></param> public void InsertFacInfo(string dicFacinfo) { IAdminProvider dp = (IAdminProvider)DpFactory.Create(typeof(IAdminProvider), DpFactory.ADMIN); IDictionary <string, object> dic = MapListConverter.JsonToDictionary(dicFacinfo); dp.AddData(table, dic); }
/// <summary> /// 新增线体信息 /// </summary> /// <param name="lineinfo"></param> public void InsertLineInfo(string dicLineinfo) { IAdminProvider dp = (IAdminProvider)DpFactory.Create(typeof(IAdminProvider), DpFactory.ADMIN); IDictionary <string, object> dic = MapListConverter.JsonToDictionary(dicLineinfo); dp.AddData("SFCB.B_LINE_INFO", dic); }
public string AddStorehouse(string dicwarehouse) { try { //MySqlCommand cmd = new MySqlCommand(); //cmd.CommandText = "INSERT INTO SFCB.B_STOREHOUSE_INFO (STOREHOUSEID,STOREHOUSENAME,STOREHOUSEDESC,STOREHOUSEMAN,STOREHOUSETYPE,REMARK) " + // "VALUES (@STID,@STNAME,@STDESC,@STMAN,@STYPE,@sREMARK)"; //cmd.Parameters.AddRange(new MySqlParameter[]{ // new MySqlParameter("STID",MySqlDbType.VarChar){Value=warehouse.storehouseId} , // new MySqlParameter("STNAME",MySqlDbType.VarChar){Value=warehouse.storehousename}, // new MySqlParameter("STDESC",MySqlDbType.VarChar){Value=warehouse.storehousedesc}, // new MySqlParameter("STMAN",MySqlDbType.VarChar){Value=warehouse.storehouseman}, // new MySqlParameter("STYPE",MySqlDbType.VarChar){Value=warehouse.storehousetype}, // new MySqlParameter("sREMARK",MySqlDbType.VarChar){Value=warehouse.remark}, //}); //BLL.BllMsSqllib.Instance.ExecteNonQuery(cmd); IAdminProvider dp = (IAdminProvider)DpFactory.Create(typeof(IAdminProvider), DpFactory.ADMIN); IDictionary <string, object> mst = MapListConverter.JsonToDictionary(dicwarehouse); dp.AddData("SFCB.B_STOREHOUSE_INFO", mst); return(null); } catch (Exception ex) { return(ex.Message); } }
public void InsertBomNumber(string dicstring) { IAdminProvider dp = (IAdminProvider)DpFactory.Create(typeof(IAdminProvider), DpFactory.ADMIN); IDictionary <string, object> mst = MapListConverter.JsonToDictionary(dicstring); dp.AddData(table, mst); }
/// <summary> /// 修改部门信息根据部门名称 /// </summary> /// <param name="deptname"></param> /// <param name="deptinfo"></param> public void EditDeptInfo(string deptname) { IAdminProvider dp = (IAdminProvider)DpFactory.Create(typeof(IAdminProvider), DpFactory.ADMIN); IDictionary <string, object> mst = MapListConverter.JsonToDictionary(deptname); dp.UpdateData(table, new string[] { "deptname" }, mst); }
public byte[] WMS_get_R_Sap_Back_Shipping(string JsonStr) { _FileHelper.Insert_DB_Log("WMS_get_R_Sap_Back_Shipping--" + JsonStr); IDictionary <string, object> dic = MapListConverter.JsonToDictionary(JsonStr); return(_wmsMaterial.get_R_Sap_Back_Shipping(dic["WOID"].ToString(), dic["DEBCRED"].ToString())); }
public void UpdateKeyParts(string dickpt) { IAdminProvider dp = (IAdminProvider)DpFactory.Create(typeof(IAdminProvider), DpFactory.ADMIN); IDictionary <string, object> mst = MapListConverter.JsonToDictionary(dickpt); dp.UpdateData("SFCB.B_KEYPART", new string[] { "KPNUMBER" }, mst); }
public void InsertKeyParts(string dickpt) { IAdminProvider dp = (IAdminProvider)DpFactory.Create(typeof(IAdminProvider), DpFactory.ADMIN); IDictionary <string, object> dic = MapListConverter.JsonToDictionary(dickpt); dp.AddData("SFCB.B_KEYPART", dic); }
//新建一条记录 public void InserttCustomer(string Insp) { IAdminProvider dp = (IAdminProvider)DpFactory.Create(typeof(IAdminProvider), DpFactory.ADMIN); IDictionary <string, object> dic = MapListConverter.JsonToDictionary(Insp); dp.AddData(table, dic); }
public string AddStorehouseloction(string dicwarehouseloc) { try { //MySqlCommand cmd = new MySqlCommand(); //cmd.CommandText = "INSERT INTO sfcr.t_storehouse_loction_info (LOCID, UPLOCID, LOCTYPE, STOREHOUSEID, LOCDESC, LOCTOTAL, REMARK) " + // "VALUES (@sLOCID,@sUPLOCID,@sLOCTYPE,@sSTOREHOUSEID,@sLOCDESC,@sLOCTOTAL,@sREMARK)"; //cmd.Parameters.AddRange(new MySqlParameter[]{ // new MySqlParameter("sLOCID",MySqlDbType.VarChar){Value=warehouseloc.locId}, // new MySqlParameter("sUPLOCID",MySqlDbType.VarChar){Value=warehouseloc.uplocId}, // new MySqlParameter("sLOCTYPE",MySqlDbType.VarChar){Value=warehouseloc.loctype}, // new MySqlParameter("sSTOREHOUSEID",MySqlDbType.VarChar){Value=warehouseloc.storehouseId}, // new MySqlParameter("sLOCDESC",MySqlDbType.VarChar){Value=warehouseloc.locdesc}, // new MySqlParameter("sLOCTOTAL",MySqlDbType.VarChar){Value=warehouseloc.loctotal}, // new MySqlParameter("sREMARK",MySqlDbType.VarChar){Value=warehouseloc.remark} //}); //BLL.BllMsSqllib.Instance.ExecteNonQuery(cmd); IAdminProvider dp = (IAdminProvider)DpFactory.Create(typeof(IAdminProvider), DpFactory.ADMIN); IDictionary <string, object> mst = MapListConverter.JsonToDictionary(dicwarehouseloc); dp.AddData("sfcr.t_storehouse_loction_info".ToUpper(), mst); return(null); } catch (Exception ex) { return(ex.Message); } }
public void DeletePartKeyParts(string dicstring) { IAdminProvider dp = (IAdminProvider)DpFactory.Create(typeof(IAdminProvider), DpFactory.ADMIN); IDictionary <string, object> mst = MapListConverter.JsonToDictionary(dicstring); dp.DeleteData(table, mst); }
public string UpdateB_SNRULE_PARTNUMBER(string dicstring, int flag) { try { string[] TableKey = new string[1]; IAdminProvider dp = (IAdminProvider)DpFactory.Create(typeof(IAdminProvider), DpFactory.ADMIN); IDictionary <string, object> mst = MapListConverter.JsonToDictionary(dicstring); if (flag == 0) { TableKey[0] = "PARTNUMBER"; mst.Remove("RULE_TYPE"); } else { TableKey[0] = "RULE_TYPE"; mst.Remove("PARTNUMBER"); } dp.UpdateData("SFCB.B_SNRULE_PARTNUMBER", TableKey, mst); return("OK"); } catch (Exception ex) { return(ex.Message); } }
/// <summary> /// 添加整个工艺及对应的工艺项目 /// </summary> /// <param name="craftinfo"></param> /// <param name="lsCraftItem"></param> /// <param name="err"></param> public string InsertRefCraftInfo(string craftinfo, string lsCraftItem, out string err) { err = ""; try { IDictionary<string, object> mst = MapListConverter.JsonToDictionary(craftinfo); DataTable dt = GetCraftInfoByCraftId(mst["CRAFTNAME"].ToString()).Tables[0]; if (dt != null && dt.Rows.Count > 0) { IAdminProvider dp = (IAdminProvider)DpFactory.Create(typeof(IAdminProvider), DpFactory.ADMIN); mst.Remove("CRAFTID"); mst.Remove("BEWORKSEG"); mst.Remove("CRAFTPARAMETERURL"); dp.UpdateData(table, new string[] { "CRAFTNAME" }, mst); return "OK"; } string RES = InsertCraftInfo_SP(craftinfo); InsertCraftItem(craftinfo, lsCraftItem, out err); return RES; } catch (Exception EX) { return EX.Message; } }
public string Scrap_SN(string Json, string Json_scrap) { IDictionary <string, object> mst = MapListConverter.JsonToDictionary(Json); IDictionary <string, object> mst_scrap = MapListConverter.JsonToDictionary(Json_scrap); return(ReworkDetail.Scrap_SN(mst, mst_scrap)); }
/// <summary> /// 修改工厂信息 /// </summary> /// <param name="facId"></param> /// <param name="facinfo"></param> public void EditFacInfo(string dicFacinfo) { IAdminProvider dp = (IAdminProvider)DpFactory.Create(typeof(IAdminProvider), DpFactory.ADMIN); IDictionary <string, object> mst = MapListConverter.JsonToDictionary(dicFacinfo); dp.UpdateData(table, new string[] { "FACID" }, mst); }
public void UpdateErrorCode(string dicstring) { IDictionary <string, object> dic = MapListConverter.JsonToDictionary(dicstring); IAdminProvider dp = (IAdminProvider)DpFactory.Create(typeof(IAdminProvider), DpFactory.ADMIN); StringBuilder ofilter = new StringBuilder(); ofilter.Append("ERRORDESC = {0}, "); ofilter.Append("ERRORDESC2 = {1}, "); if (ProConfiguration.GetConfig().DatabaseType == SysModel.DataLinkType.MySql) { ofilter.Append("RECDATE =now() "); } if (ProConfiguration.GetConfig().DatabaseType == SysModel.DataLinkType.Oracle) { ofilter.Append("RECDATE =SYSDATE "); } IDictionary <string, object> modFields = new Dictionary <string, object>(); modFields.Add("ERRORDESC", dic["ERRORDESC"]); modFields.Add("ERRORDESC2", dic["ERRORDESC2"]); string filter = "ERRORCODE = {0}"; IDictionary <string, object> keyVals = new Dictionary <string, object>(); keyVals.Add("ERRORCODE", dic["ERRORCODE"]); dp.UpdateBatchData(table, ofilter.ToString(), modFields, filter, keyVals); }
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; } }
/// <summary> /// 修改用户信息 /// </summary> /// <param name="userId"></param> /// <param name="userInfo"></param> public void EditUserInfo(string dicuserInfo) { IAdminProvider dp = (IAdminProvider)DpFactory.Create(typeof(IAdminProvider), DpFactory.ADMIN); IDictionary <string, object> mst = MapListConverter.JsonToDictionary(dicuserInfo); dp.UpdateData("SFCB.B_USER_INFO", new string[] { "USERID" }, mst); }
public string ChktEditing(string Dicediting) { IDictionary <string, object> dic = MapListConverter.JsonToDictionary(Dicediting); try { string str = this.GettEditingInfo(dic["FUNNAME"].ToString(), dic["PRJ"].ToString()); if (string.IsNullOrEmpty(str)) { DeletetEditingByUserIdAndPrj(dic["USERID"].ToString(), dic["PRJ"].ToString()); return(this.InserttEditing(Dicediting)); } string[] arr = str.Split(','); if (arr[0].ToUpper() != dic["USERID"].ToString().ToUpper() || arr[2].ToUpper() != dic["PC_NAME"].ToString().ToUpper()) { return(string.Format("WARNING:{0}", str)); } else { return("OK"); } } catch (Exception ex) { return("ERROR:" + ex.Message); } }
/// <summary> /// 增加用户权限 /// </summary> /// <param name="ArrUserPopList"></param> public string AddUserJurisdiction(string LsDicstring) { //StringBuilder sql = new StringBuilder(); DbConnection conn = ProviderHelper.GetConnection(ProConfiguration.GetConfig().DatabaseType, ProConfiguration.GetConfig().DatabaseConnect); DbTransaction tx = ProviderHelper.BeginTransaction(conn); try { IList <IDictionary <string, object> > LsDic = MapListConverter.JsonToListDictionary(LsDicstring); string table = "SFCB.B_USER_POPLIST"; IAdminProvider dp = (IAdminProvider)DpFactory.Create(typeof(IAdminProvider), DpFactory.ADMIN); IDictionary <string, object> dic = new Dictionary <string, object>(); dic.Add("USERID", LsDic[0]["USERID"]); dp.DeleteData(tx, table, dic); dp.AddListData(tx, table, LsDic); tx.Commit(); return(null); } catch (Exception ex) { tx.Rollback(); return(ex.Message); } finally { conn.Close(); conn.Dispose(); } }
public string UPDATE_T_WO_Material(string JsonStr) { IDictionary <string, object> mst = MapListConverter.JsonToDictionary(JsonStr); mst.Add("RECDATE", System.DateTime.Now); return(woMaterial.UPDATE_T_WO_Material(mst)); }
/// <summary> /// 添加用户ATE权限 /// </summary> /// <param name="lsAteEmp"></param> /// <returns></returns> public string AddUserAteEmp(string lsAteEmp) { DbConnection conn = ProviderHelper.GetConnection(ProConfiguration.GetConfig().DatabaseType, ProConfiguration.GetConfig().DatabaseConnect); DbTransaction tx = ProviderHelper.BeginTransaction(conn); try { IList <IDictionary <string, object> > LsDic = MapListConverter.JsonToListDictionary(lsAteEmp); string table = "sfcb.b_Ate_Emp".ToUpper(); IAdminProvider dp = (IAdminProvider)DpFactory.Create(typeof(IAdminProvider), DpFactory.ADMIN); IDictionary <string, object> dic = new Dictionary <string, object>(); dic.Add("USERID", LsDic[0]["USERID"]); dp.DeleteData(tx, table, dic); dp.AddListData(tx, table, LsDic); tx.Commit(); return("OK"); } catch (Exception ex) { tx.Rollback(); return(ex.Message); } finally { conn.Close(); conn.Dispose(); } }
public void UpdateFixtureInfo(string dicFixtureinfo) { IAdminProvider dp = (IAdminProvider)DpFactory.Create(typeof(IAdminProvider), DpFactory.ADMIN); IDictionary <string, object> mst = MapListConverter.JsonToDictionary(dicFixtureinfo); dp.UpdateData("SFCR.T_FIXTURE_INFO", new string[] { "fixtureId" }, mst); }
//public List<string> GetSnListForAte(string sntype, string woId, int snqty) //{ // List<string> BarcodeList = new List<string>(); // MySqlCommand cmd = new MySqlCommand(); // cmd.CommandText = string.Format("select rowid,snval from SFCR.T_WO_SNLIST where woId=@woId and sntype=@sntype and status=0 and rownum<={0} order by seq", snqty); // cmd.Parameters.Add("woId", MySqlDbType.VarChar, woId.Length).Value = woId; // cmd.Parameters.Add("sntype", MySqlDbType.VarChar, sntype.Length).Value = sntype; // DataTable dt = BLL.BllMsSqllib.Instance.ExecuteDataSet(cmd).Tables[0]; // if (dt != null && dt.Rows.Count != 0) // { // if (dt.Rows.Count == snqty) // { // MySqlCommand[] cmdList = new MySqlCommand[100]; // List<MySqlCommand> lsCmd = new List<MySqlCommand>(); // BarcodeList.Add("OK"); // int x = 0; // foreach (DataRow dr in dt.Rows) // { // int y = x++; // cmdList[y] = new MySqlCommand(); // cmdList[y].CommandText = "Update SFCR.T_WO_SNLIST set status=@flag where rowid=@idx and status=0"; // cmdList[y].Parameters.Add("idx", MySqlDbType.VarChar, 50).Value = dr["rowid"].ToString(); // cmdList[y].Parameters.Add("flag", MySqlDbType.Int32).Value = 2; // lsCmd.Add(cmdList[y]); // BarcodeList.Add(dr["snval"].ToString()); // } // string msg = BLL.BllMsSqllib.Instance.ExecteNonQueryTransaction(lsCmd); // if (msg != "OK") // { // return GetSnListForAte(sntype, woId, snqty); // } // } // else // { // BarcodeList.Add("Bar code is not enough"); // } // } // else // { // BarcodeList.Add("FAIL"); // } // return BarcodeList; //} //public string UpdateStatusGetSnListForAte(string sntype, string woId, List<string> listsn, int sStatus) //{ // int Flag = 0; // if (sStatus == 1) // Flag = 1; // MySqlCommand[] cmd = new MySqlCommand[100]; // List<MySqlCommand> lsCmd = new List<MySqlCommand>(); // int x = 0; // for (int i = 0; i < listsn.Count; i++) // { // int y = x++; // cmd[y] = new MySqlCommand(); // cmd[y].CommandText = "Update SFCR.T_WO_SNLIST set status=@flag where woId=@woId and sntype=@sntype and snval=@snval"; // cmd[y].Parameters.Add("flag", MySqlDbType.Int32).Value = Flag; // cmd[y].Parameters.Add("sntype", MySqlDbType.VarChar, sntype.Length).Value = sntype; // cmd[y].Parameters.Add("woId", MySqlDbType.VarChar, woId.Length).Value = woId; // cmd[y].Parameters.Add("snval", MySqlDbType.VarChar, listsn[i].Length).Value = listsn[i]; // lsCmd.Add(cmd[y]); // } // return BLL.BllMsSqllib.Instance.ExecteNonQueryTransaction(lsCmd); //} #endregion //#region 产品跟踪序列号 /// <summary> /// 添加序列号区间 /// </summary> /// <param name="snrule"></param> public void InsetSnRule(string dicstring) { IAdminProvider dp = (IAdminProvider)DpFactory.Create(typeof(IAdminProvider), DpFactory.ADMIN); IDictionary <string, object> mst = MapListConverter.JsonToDictionary(dicstring); dp.AddData("SFCR.T_SN_RULE", mst); }