/// <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(); } }
/// <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(); } }
/// <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 string InsertVersionInfo(string WO, string lsVersionMark, string sId) { //OracleCommand cmd = new OracleCommand(); //cmd.CommandText = " DELETE FROM SFCB.B_VERSION_INFO WHERE WOID=:woid "; //cmd.Parameters.Add("woid", OracleDbType.Varchar2, 25).Value = WO; //BLL.BllMsSqllib.Instance.ExecteNonQuery(cmd); //foreach (Entity.tVersionMark item in lsVersionMark) //{ // cmd = new OracleCommand(); // cmd.CommandText = "insert into sfcb.b_version_info(woid,version_name,version_values,user_id,recdate)values(:woid,:version_name,:version_values,:sId,sysdate)"; // cmd.Parameters.Add("woid", OracleDbType.Varchar2, 20).Value = WO; // cmd.Parameters.Add("version_name", OracleDbType.Varchar2, 50).Value = item.VERSION_NAME; // cmd.Parameters.Add("version_values", OracleDbType.Varchar2, 100).Value = item.VERSION_VALUES; // cmd.Parameters.Add("sId", OracleDbType.Varchar2, 100).Value = sId; // BLL.BllMsSqllib.Instance.ExecteNonQuery(cmd); //} //return "OK"; IList <IDictionary <string, object> > VersionMark = MapListConverter.JsonToListDictionary(lsVersionMark); string table = "SFCB.B_VERSION_INFO"; IAdminProvider dp = (IAdminProvider)DpFactory.Create(typeof(IAdminProvider), DpFactory.ADMIN); IDictionary <string, object> parms = new Dictionary <string, object>(); parms.Add("WOID", WO); dp.DeleteData(table, parms); DbConnection conn = ProviderHelper.GetConnection(ProConfiguration.GetConfig().DatabaseType, ProConfiguration.GetConfig().DatabaseConnect); DbTransaction tx = ProviderHelper.BeginTransaction(conn); try { IDictionary <string, object> mst = new Dictionary <string, object>(); foreach (Dictionary <string, object> dic in VersionMark) { mst = new Dictionary <string, object>(); mst.Add("WOID", dic["WOID"]); mst.Add("VERSION_NAME", dic["VERSION_NAME"]); mst.Add("VERSION_VALUES", dic["VERSION_VALUES"]); mst.Add("user_id", sId); mst.Add("recdate", System.DateTime.Now); dp.AddData(tx, "sfcb.b_version_info", mst); } return("OK"); } catch (Exception ex) { tx.Rollback(); return(ex.Message); } finally { conn.Close(); conn.Dispose(); } }
/// <summary> /// 添加功能 /// </summary> /// <param name="lsfunlist"></param> public void AddFunctionList(string Lsdicstring) { IList <IDictionary <string, object> > LsDic = MapListConverter.JsonToListDictionary(Lsdicstring); IAdminProvider dp = (IAdminProvider)DpFactory.Create(typeof(IAdminProvider), DpFactory.ADMIN); foreach (IDictionary <string, object> mst in LsDic) { // MySqlCommand cmd = new MySqlCommand(); if (!ChkFunctionList(mst["PROGID"].ToString(), mst["FUNID"].ToString())) { //cmd.CommandText = "insert into SFCB.B_FUNCTION_LIST(funId,progid,funname,fundesc) values(@funId,@progid,@funname,@fundesc)"; //cmd.Parameters.Add("funId", MySqlDbType.VarChar, 25).Value = fls.funId; //cmd.Parameters.Add("progid", MySqlDbType.VarChar, 25).Value = fls.progid; //cmd.Parameters.Add("funname", MySqlDbType.VarChar, 25).Value = fls.funname; //cmd.Parameters.Add("fundesc", MySqlDbType.VarChar, 25).Value = fls.fundesc; //BLL.BllMsSqllib.Instance.ExecteNonQuery(cmd); dp.AddData("SFCB.B_FUNCTION_LIST", mst); } else { //cmd.CommandText = "update SFCB.B_FUNCTION_LIST set funname=@funname,fundesc=@fundesc where funid=@funid and progid=@progid"; //cmd.Parameters.Add("funId", MySqlDbType.VarChar, 25).Value = fls.funId; //cmd.Parameters.Add("progid", MySqlDbType.VarChar, 25).Value = fls.progid; //cmd.Parameters.Add("funname", MySqlDbType.VarChar, 25).Value = fls.funname; //cmd.Parameters.Add("fundesc", MySqlDbType.VarChar, 25).Value = fls.fundesc; //BLL.BllMsSqllib.Instance.ExecteNonQuery(cmd); dp.UpdateData("SFCB.B_FUNCTION_LIST", new string[] { "FUNID", "PROGID" }, mst); } } // foreach (Entity.tFunctionList fls in lsfunlist) // { //MySqlCommand cmd = new MySqlCommand(); //if (!ChkFunctionList(fls.progid, fls.funId)) //{ // cmd.CommandText = "insert into SFCB.B_FUNCTION_LIST(funId,progid,funname,fundesc) values(@funId,@progid,@funname,@fundesc)"; // cmd.Parameters.Add("funId", MySqlDbType.VarChar, 25).Value = fls.funId; // cmd.Parameters.Add("progid", MySqlDbType.VarChar, 25).Value = fls.progid; // cmd.Parameters.Add("funname", MySqlDbType.VarChar, 25).Value = fls.funname; // cmd.Parameters.Add("fundesc", MySqlDbType.VarChar, 25).Value = fls.fundesc; // BLL.BllMsSqllib.Instance.ExecteNonQuery(cmd); //} //else //{ // cmd.CommandText = "update SFCB.B_FUNCTION_LIST set funname=@funname,fundesc=@fundesc where funid=@funid and progid=@progid"; // cmd.Parameters.Add("funId", MySqlDbType.VarChar, 25).Value = fls.funId; // cmd.Parameters.Add("progid", MySqlDbType.VarChar, 25).Value = fls.progid; // cmd.Parameters.Add("funname", MySqlDbType.VarChar, 25).Value = fls.funname; // cmd.Parameters.Add("fundesc", MySqlDbType.VarChar, 25).Value = fls.fundesc; // BLL.BllMsSqllib.Instance.ExecteNonQuery(cmd); //} // } }
/// <summary> /// 添加工艺项目及参数(先删除所有存在的工艺项目Id) /// </summary> /// <param name="lsCraftItem"></param> /// <param name="err"></param> public void InsertCraftItem(string craftId, string Lsdicstring, out string err) { err = ""; IDictionary<string, object> dicCft = MapListConverter.JsonToDictionary(craftId); DeleteCraftItem(dicCft["CRAFTID"].ToString()); foreach (Dictionary<string,object> dic in MapListConverter.JsonToListDictionary(Lsdicstring)) { InsertCraftItem(dic, out err); if (!string.IsNullOrEmpty(err)) throw new Exception(err); } }
public string InserSnRule(string Lisdicsnrule, string ESN_TYPE) { IList <IDictionary <string, object> > Lsdicrule = MapListConverter.JsonToListDictionary(Lisdicsnrule); IDictionary <string, object> mst = null; IAdminProvider dp = (IAdminProvider)DpFactory.Create(typeof(IAdminProvider), DpFactory.ADMIN); DbConnection conn = ProviderHelper.GetConnection(ProConfiguration.GetConfig().DatabaseType, ProConfiguration.GetConfig().DatabaseConnect); DbTransaction tx = ProviderHelper.BeginTransaction(conn); try { mst = new Dictionary <string, object>(); mst.Add("WOID", Lsdicrule[0]["WOID"]); mst.Add("REVE", "1"); dp.DeleteData(tx, "SFCR.T_SN_RULE", mst); mst = new Dictionary <string, object>(); mst.Add("WOID", Lsdicrule[0]["WOID"]); dp.DeleteData(tx, "SFCR.T_WO_SN_RULE", mst); foreach (Dictionary <string, object> dicrule in Lsdicrule) { if (dicrule["SNTYPE"].ToString() != "NA") ////如果前台没有添加区间信息,判定SNTYPE=NA,则不增加区间 { dp.AddData(tx, "SFCR.T_WO_SN_RULE", dicrule); if (dicrule["SNTYPE"].ToString() == ESN_TYPE) { mst = new Dictionary <string, object>(); mst.Add("WOID", dicrule["WOID"]); mst.Add("SNPREFIX", dicrule["SNPREFIX"]); mst.Add("SNPOSTFIX", dicrule["SNPOSTFIX"]); mst.Add("SNSTART", dicrule["SNSTART"]); mst.Add("SNEND", dicrule["SNEND"]); mst.Add("REVE", "1"); mst.Add("VER", dicrule["VER"]); mst.Add("CURRSN", "NA"); dp.AddData(tx, "SFCR.T_SN_RULE", mst); } } } tx.Commit(); return("OK"); } catch (Exception ex) { tx.Rollback(); return(ex.Message); } finally { conn.Close(); conn.Dispose(); } }
public string InsertWoSnRule(string lswosnrule) { try { IAdminProvider dp = (IAdminProvider)DpFactory.Create(typeof(IAdminProvider), DpFactory.ADMIN); IList <IDictionary <string, object> > LsDic = MapListConverter.JsonToListDictionary(lswosnrule); dp.AddListData("SFCR.T_WO_SN_RULE", LsDic); return("OK"); } catch (Exception ex) { return(ex.Message); } }
public string InsertRouteAllItme(string dicrouteatt) { string _Sys_StrErr = string.Empty; try { IDictionary <string, object> dic = MapListConverter.JsonToDictionary(dicrouteatt); _Sys_StrErr = "Save PRO_INSERTROUTEATT Error"; string _StrErr = mPro.PRO_INSERTROUTEATT(dic["ROUTGROUPID"].ToString(), dic["ROUTGROUPDESC"].ToString(), dic["ROUTGROUPXMLCONTENT"].ToString());// .InsertRouteAtt(routeatt); if (_StrErr != "OK") { return("流程XML添加失败" + _StrErr); } _Sys_StrErr = "dic[LSROUTE] Error"; foreach (Dictionary <string, object> mst in MapListConverter.JsonToListDictionary(dic["LSROUTE"].ToString())) { _Sys_StrErr = "InsertRouteInfo Error"; if (!string.IsNullOrEmpty(mRouteinfo.InsertRouteInfo(mst))) { return("流程添加失败"); } _Sys_StrErr = "InsertRouteCraftParamerter Analysis of failure"; if (mst["LsRouteCraftparameter".ToUpper()] != null) { _Sys_StrErr = " Analysis of failure"; foreach (Dictionary <string, object> obj in MapListConverter.JsonToListDictionary(mst["LsRouteCraftparameter".ToUpper()].ToString())) //mst["LsRouteCraftparameter".ToUpper()] as List<Dictionary<string, object>>) { _Sys_StrErr = "InsertRouteCraftParamerter failed"; if (mPro.PRO_INSERTROUTECRAFTPARAMERTER(obj["ROUTGROUPID"].ToString(), obj["CRAFTID"].ToString(), Convert.ToInt32(obj["CRAFTITEM"].ToString()), obj["CRAFTPARAMETERDES"].ToString(), obj["UPPERLIMIT"].ToString(), obj["LOWERLIMIT"].ToString(), obj["OTHER"].ToString(), obj["URL"].ToString()) != "OK") { return("流程工艺及工艺项目添加失败"); } } } } return("OK"); } catch (Exception ex) { return(_Sys_StrErr + "\r\n" + ex.Message); } }
public string InsertKeyParts(string diclsWipKeyParts) { IList <IDictionary <string, object> > LsDic = MapListConverter.JsonToListDictionary(diclsWipKeyParts); string msg = string.Empty; try { foreach (Dictionary <string, object> item in LsDic) { mWipTracking.InsertWipKeyPart(item); } } catch (Exception ex) { msg = ex.Message; } return(msg); }
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); }
/// <summary> /// 新增工单上料打印料表信息 /// </summary> /// <param name="mp"></param> /// <param name="Err"></param> public string InsertWoBomPrintInfo(string LsDicstring) { string _err = string.Empty; IList <IDictionary <string, object> > lsdic = MapListConverter.JsonToListDictionary(LsDicstring); if (lsdic.Count > 0) { string table = "SFCR.T_MATERIAL_PREPARATION"; IAdminProvider dp = (IAdminProvider)DpFactory.Create(typeof(IAdminProvider), DpFactory.ADMIN); IDictionary <string, object> mst = new Dictionary <string, object>(); mst.Add("MASTERID", lsdic[0]["MASTERID"]); mst.Add("WOID", lsdic[0]["WOID"]); dp.DeleteData(table, mst); InsertWoBomPrintInfo(lsdic, out _err); return(_err); } else { _err = "No Data"; return(_err); } }
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); } }
public static IList <IDictionary <string, object> > JsonToListDictionary(string JosnStr) { return(MapListConverter.JsonToListDictionary(JosnStr)); }
public string Insert_Sn_UnBind(string ListJson) { IList <IDictionary <string, object> > ListMst = MapListConverter.JsonToListDictionary(ListJson); return(SnUnBind.Insert_Sn_UnBind(ListMst)); }
/// <summary> /// 新增工单信息 /// </summary> /// <param name="TWI"></param> /// <param name="Err"></param> public string InsertWoInfo(string dicwoinfo, string AteScript, string esn, string diclssnrule) { string err = ""; IDictionary <string, object> dicWO = MapListConverter.JsonToDictionary(dicwoinfo); IList <IDictionary <string, object> > lsdicsnrule = null; if (!string.IsNullOrEmpty(diclssnrule)) { lsdicsnrule = MapListConverter.JsonToListDictionary(diclssnrule); } DbConnection conn = ProviderHelper.GetConnection(ProConfiguration.GetConfig().DatabaseType, ProConfiguration.GetConfig().DatabaseConnect); DbTransaction tx = ProviderHelper.BeginTransaction(conn); try { #region 添加工单 string fieldlist = "COUNT(1)"; int count = 0; IAdminProvider dp = (IAdminProvider)DpFactory.Create(typeof(IAdminProvider), DpFactory.ADMIN); IDictionary <string, object> mst = new Dictionary <string, object>(); mst.Add("WOID", dicWO["WOID"]); DataTable dt = dp.GetData(table, fieldlist, mst, out count).Tables[0]; err = "[woinfo]"; if (dt.Rows[0][0].ToString() == "0") { dicWO.Add("RECDATE", System.DateTime.Now); dp.AddData(tx, table, dicWO); #region #endregion } else { dicWO.Add("RECDATE", System.DateTime.Now); dp.UpdateData(tx, table, new string[] { "WOID" }, dicWO); } err = "[AteScript]"; #region 脚本信息 if (!string.IsNullOrEmpty(AteScript)) { mst = new Dictionary <string, object>(); mst.Add("WOID", dicWO["WOID"]); DataTable dtate = dp.GetData("SFCB.B_ATE_SCRIPT", "COUNT(1)", mst, out count).Tables[0]; if (dtate.Rows[0][0].ToString() == "0") { mst = new Dictionary <string, object>(); mst.Add("WOID", dicWO["WOID"]); mst.Add("SCRIPT", AteScript); dp.AddData(tx, "SFCB.B_ATE_SCRIPT", mst); } else { mst = new Dictionary <string, object>(); mst.Add("WOID", dicWO["WOID"]); mst.Add("SCRIPT", AteScript); dp.UpdateData(tx, "SFCB.B_ATE_SCRIPT", new string[] { "WOID" }, mst); } } #endregion #endregion err = "[lsdicsnrule]"; #region 添加工单序列号区间 if (lsdicsnrule != null && lsdicsnrule.Count > 0) { err = "[lsdicsnrule_1]"; mst = new Dictionary <string, object>(); mst.Add("WOID", dicWO["WOID"]); mst.Add("REVE", "1"); dp.DeleteData(tx, "SFCR.T_SN_RULE", mst); mst = new Dictionary <string, object>(); mst.Add("WOID", lsdicsnrule[0]["WOID"]); dp.DeleteData("SFCR.T_WO_SN_RULE", mst); foreach (IDictionary <string, object> dic in lsdicsnrule) { dic.Add("RECDATE", System.DateTime.Now); } dp.AddListData(tx, "SFCR.T_WO_SN_RULE", lsdicsnrule); foreach (IDictionary <string, object> dic in lsdicsnrule) { if (dic["SNTYPE"].ToString() == esn.ToUpper()) { mst = new Dictionary <string, object>(); mst.Add("WOID", dic["WOID"]); mst.Add("SNPREFIX", dic["SNPREFIX"]); mst.Add("SNPOSTFIX", dic["SNPOSTFIX"]); mst.Add("SNSTART", dic["SNSTART"]); mst.Add("SNEND", dic["SNEND"]); mst.Add("REVE", "1"); mst.Add("VER", dic["VER"]); mst.Add("CURRSN", "NA"); mst.Add("RECDATE", System.DateTime.Now); dp.AddData(tx, "SFCR.T_SN_RULE", mst); } } } #endregion tx.Commit(); return("OK"); } catch (Exception ex) { tx.Rollback(); return(err + ex.Message); } finally { conn.Close(); conn.Dispose(); } }
public string InsertWipKeyParts(string diclsWipKeyPart) { IList <IDictionary <string, object> > lsdic = MapListConverter.JsonToListDictionary(diclsWipKeyPart); return(mWiptracking.InsertWipKeyParts(lsdic)); }