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