// /// <summary>
// /// 未入库重工使用
// /// </summary>
// /// <param name="ClearWip"></param>
// /// <param name="ESN"></param>
// /// <param name="LocGroup"></param>
// /// <param name="WipGroup"></param>
// /// <param name="ReworkNo"></param>
// /// <returns></returns>
// public string UpdateDataForRework(List<string> ClearWip, List<string> Listsn, string LocGroup, string WipGroup, string ReworkNo, int Total)
// {
// string Msg = "";
// string ESN = "";
// if (Listsn.Count != Total)
// {
// return string.Format("传入资料异常,传入ESN数量{0}个,实际应该是{1}", Listsn.Count.ToString(), Total.ToString());
// }
// else
// {
// for (int xi = 0; xi < Listsn.Count; xi++)
// {
// try
// {
// ESN = Listsn[xi].ToString();
// List<string> WipKeyparts = new List<string>();
// MySqlCommand[] cmd = new MySqlCommand[100];
// List<MySqlCommand> lsCmd = new List<MySqlCommand>();
// string ColnumWip = "";
// int y = 0;
// for (int i = 0; i < ClearWip.Count; i++)
// {
// string str = ClearWip[i].ToString();
// int x = str.IndexOf('-');
// string Flag = str.Substring(0, x);
// string Colnum = str.Substring(x + 1, str.Length - x - 1);
// if (Flag == "0")
// {
// ColnumWip += string.Format("{0}='NA',", Colnum);
// }
// if (Flag == "1")
// {
// WipKeyparts.Add(string.Format("sntype='{0}'", Colnum));
// }
// }
// ColnumWip = ColnumWip + "Locstation=@loc,wipstation=@wip,";
// ColnumWip = ColnumWip.Substring(0, ColnumWip.Length - 1);
// string colnum = @"esn,woid,partnumber,productname,versioncode,type,locstation,stationname,wipstation,nextstation,userid,recdate,errflag,
// scrapflag,sn,mac,imei,cartonnumber,trayno,palletnumber,mcartonnumber,mpalletnumber,line,sectionname,routgroupid,storenumber,
// weightqty,qa_no,qa_result,track_no,ate_station_no,in_line_time,bomnumber";
// cmd[y] = new MySqlCommand();
// cmd[y].CommandText = string.Format("insert into SFCR.T_WIP_UNDO ({0},reworkno) select {0},@rewno from sfcr.T_WIP_TRACKING_ONLINE where esn=@esn", colnum);
// cmd[y].Parameters.Add("rewno", MySqlDbType.VarChar, ReworkNo.Length).Value = ReworkNo;
// cmd[y].Parameters.Add("esn", MySqlDbType.VarChar, ESN.Length).Value = ESN;
// lsCmd.Add(cmd[y]);
// y++;
// cmd[y] = new MySqlCommand();
// cmd[y].CommandText = "Update sfcr.T_WIP_TRACKING_ONLINE set reworkno=@rewno,nextstation=@next," + ColnumWip + " where esn=@esn";
// cmd[y].Parameters.Add("rewno", MySqlDbType.VarChar, ReworkNo.Length).Value = ReworkNo;
// cmd[y].Parameters.Add("next", MySqlDbType.VarChar, WipGroup.Length).Value = WipGroup;
// cmd[y].Parameters.Add("loc", MySqlDbType.VarChar, LocGroup.Length).Value = LocGroup;
// cmd[y].Parameters.Add("wip", MySqlDbType.VarChar, WipGroup.Length).Value = WipGroup;
// cmd[y].Parameters.Add("esn", MySqlDbType.VarChar, ESN.Length).Value = ESN;
// lsCmd.Add(cmd[y]);
// if (WipKeyparts.Count != 0)
// {
// for (int x = 0; x < WipKeyparts.Count; x++)
// {
// string colnumKeyPart = "esn,woId,sntype,snval,station,kpno,recdate";
// y++;
// cmd[y] = new MySqlCommand();
// cmd[y].CommandText = string.Format("insert into SFCR.T_WIP_KEYPART_UNDO ({1}) select {1} from SFCR.T_WIP_KEYPART_ONLINE where esn=@esn and {0}", WipKeyparts[x].ToString(), colnumKeyPart);
// cmd[y].Parameters.Add("esn", MySqlDbType.VarChar, ESN.Length).Value = ESN;
// lsCmd.Add(cmd[y]);
// y++;
// cmd[y] = new MySqlCommand();
// cmd[y].CommandText = string.Format("Delete FROM SFCR.T_WIP_KEYPART_ONLINE where esn=@esn and {0}", WipKeyparts[x].ToString());
// cmd[y].Parameters.Add("esn", MySqlDbType.VarChar, ESN.Length).Value = ESN;
// lsCmd.Add(cmd[y]);
// y++;
// cmd[y] = new MySqlCommand();
// cmd[y].CommandText = string.Format("update SFCR.T_WO_SNLIST set snval='0' where snval=(select snval from SFCR.T_WIP_KEYPART_ONLINE where esn=@esn and {0} and rownum=1)", WipKeyparts[x].ToString());
// cmd[y].Parameters.Add("esn", MySqlDbType.VarChar, ESN.Length).Value = ESN;
// lsCmd.Add(cmd[y]);
// }
// }
// if (ColnumWip.ToUpper().IndexOf("CARTONNUMBER") > -1)
// {
// y++;
// cmd[y] = new MySqlCommand();
// cmd[y].CommandText = "update SFCR.T_CARTON_INFO_HAD set num=num-1,flag='0' where cartonId=(select cartonid from SFCR.T_CARTON_INFO_DTA where esn=@esn and rownum=1)";
// cmd[y].Parameters.Add("esn", MySqlDbType.VarChar, ESN.Length).Value = ESN;
// lsCmd.Add(cmd[y]);
// y++;
// cmd[y] = new MySqlCommand();
// cmd[y].CommandText = "Delete FROM SFCR.T_CARTON_INFO_DTA where esn=@esn";
// cmd[y].Parameters.Add("esn", MySqlDbType.VarChar, ESN.Length).Value = ESN;
// lsCmd.Add(cmd[y]);
// }
// //try
// //{
// BLL.BllMsSqllib.Instance.ExecteNonQueryArr(lsCmd);
// Msg = "OK";
// }
// catch (Exception ex)
// {
// Msg = ex.Message + "ESN:" + ESN;
// }
// }
// return Msg;
// }
// }
// /// <summary>
// /// 未入库重工使用------单个产品一过
// /// </summary>
// /// <param name="ClearWip"></param>
// /// <param name="Listsn"></param>
// /// <param name="LocGroup"></param>
// /// <param name="WipGroup"></param>
// /// <param name="ReworkNo"></param>
// /// <returns></returns>
// public string UpdateDataForReworkSigle(List<string> ClearWip, string Listsn, string LocGroup, string WipGroup, string ReworkNo)
// {
// string Msg = "";
// string ESN = "";
// try
// {
// ESN = Listsn;
// List<string> WipKeyparts = new List<string>();
// MySqlCommand[] cmd = new MySqlCommand[100];
// List<MySqlCommand> lsCmd = new List<MySqlCommand>();
// string ColnumWip = "";
// int y = 0;
// for (int i = 0; i < ClearWip.Count; i++)
// {
// string str = ClearWip[i].ToString();
// int x = str.IndexOf('-');
// string Flag = str.Substring(0, x);
// string Colnum = str.Substring(x + 1, str.Length - x - 1);
// if (Flag == "0")
// {
// ColnumWip += string.Format("{0}='NA',", Colnum);
// }
// if (Flag == "1")
// {
// WipKeyparts.Add(string.Format("sntype='{0}'", Colnum));
// }
// }
// ColnumWip = ColnumWip + "Locstation=@loc,wipstation=@wip,";
// ColnumWip = ColnumWip.Substring(0, ColnumWip.Length - 1);
// string colnum = @"esn,woid,partnumber,productname,versioncode,type,locstation,stationname,wipstation,nextstation,userid,recdate,errflag,
// scrapflag,sn,mac,imei,cartonnumber,trayno,palletnumber,mcartonnumber,mpalletnumber,line,sectionname,routgroupid,storenumber,
// weightqty,qa_no,qa_result,track_no,ate_station_no,in_line_time,bomnumber";
// cmd[y] = new MySqlCommand();
// cmd[y].CommandText = string.Format("insert into SFCR.T_WIP_UNDO ({0},reworkno) select {0},@rewno from sfcr.T_WIP_TRACKING_ONLINE where esn=@esn", colnum);
// cmd[y].Parameters.Add("rewno", MySqlDbType.VarChar, ReworkNo.Length).Value = ReworkNo;
// cmd[y].Parameters.Add("esn", MySqlDbType.VarChar, ESN.Length).Value = ESN;
// lsCmd.Add(cmd[y]);
// y++;
// cmd[y] = new MySqlCommand();
// cmd[y].CommandText = "Update sfcr.T_WIP_TRACKING_ONLINE set reworkno=@rewno,nextstation=@next," + ColnumWip + " where esn=@esn";
// cmd[y].Parameters.Add("rewno", MySqlDbType.VarChar, ReworkNo.Length).Value = ReworkNo;
// cmd[y].Parameters.Add("next", MySqlDbType.VarChar, WipGroup.Length).Value = WipGroup;
// cmd[y].Parameters.Add("loc", MySqlDbType.VarChar, LocGroup.Length).Value = LocGroup;
// cmd[y].Parameters.Add("wip", MySqlDbType.VarChar, WipGroup.Length).Value = WipGroup;
// cmd[y].Parameters.Add("esn", MySqlDbType.VarChar, ESN.Length).Value = ESN;
// lsCmd.Add(cmd[y]);
// if (WipKeyparts.Count != 0)
// {
// for (int x = 0; x < WipKeyparts.Count; x++)
// {
// string colnumKeyPart = "esn,woId,sntype,snval,station,kpno,recdate";
// y++;
// cmd[y] = new MySqlCommand();
// cmd[y].CommandText = string.Format("insert into SFCR.T_WIP_KEYPART_UNDO ({1}) select {1} from SFCR.T_WIP_KEYPART_ONLINE where esn=@esn and {0}", WipKeyparts[x].ToString(), colnumKeyPart);
// cmd[y].Parameters.Add("esn", MySqlDbType.VarChar, ESN.Length).Value = ESN;
// lsCmd.Add(cmd[y]);
// y++;
// cmd[y] = new MySqlCommand();
// cmd[y].CommandText = string.Format("DELETE FROM SFCR.T_WIP_KEYPART_ONLINE where esn=@esn and {0}", WipKeyparts[x].ToString());
// cmd[y].Parameters.Add("esn", MySqlDbType.VarChar, ESN.Length).Value = ESN;
// lsCmd.Add(cmd[y]);
// y++;
// cmd[y] = new MySqlCommand();
// cmd[y].CommandText = string.Format("update SFCR.T_WO_SNLIST set snval='0' where snval=(select snval from SFCR.T_WIP_KEYPART_ONLINE where esn=@esn and {0} and rownum=1)", WipKeyparts[x].ToString());
// cmd[y].Parameters.Add("esn", MySqlDbType.VarChar, ESN.Length).Value = ESN;
// lsCmd.Add(cmd[y]);
// }
// }
// if (ColnumWip.ToUpper().IndexOf("CARTONNUMBER") > -1)
// {
// y++;
// cmd[y] = new MySqlCommand();
// cmd[y].CommandText = "update SFCR.T_CARTON_INFO_HAD set num=num-1,flag='0' where cartonId=(select cartonid from SFCR.T_CARTON_INFO_DTA where esn=@esn and rownum=1)";
// cmd[y].Parameters.Add("esn", MySqlDbType.VarChar, ESN.Length).Value = ESN;
// lsCmd.Add(cmd[y]);
// y++;
// cmd[y] = new MySqlCommand();
// cmd[y].CommandText = "DELETE FROM SFCR.T_CARTON_INFO_DTA where esn=@esn";
// cmd[y].Parameters.Add("esn", MySqlDbType.VarChar, ESN.Length).Value = ESN;
// lsCmd.Add(cmd[y]);
// }
// //try
// //{
// ExecteNonQueryArr(lsCmd);
// Msg = "OK";
// }
// catch (Exception ex)
// {
// Msg = ex.Message + "ESN:" + ESN;
// }
// // }
// return Msg;
// //}
// }
//public void ExecteNonQueryArr(List<MySqlCommand> cmd)
//{
// using (MySqlConnection cn = new MySqlConnection(ProConfiguration.GetConfig().DatabaseConnect))
// {
// cn.Open();
// MySqlTransaction sTran = cn.BeginTransaction();
// try
// {
// foreach (MySqlCommand _cmd in cmd)
// {
// _cmd.Connection = cn;
// _cmd.Transaction = sTran;
// _cmd.CommandTimeout = 84100;
// _cmd.ExecuteNonQuery();
// _cmd.Dispose();
// }
// sTran.Commit();
// }
// catch (Exception ex)
// {
// sTran.Rollback();
// throw ex;
// }
// finally
// {
// cn.Close();
// cn.Dispose();
// }
// }
//}
// /// <summary>
// /// 已经入库使用
// /// </summary>
// /// <param name="ClearWip"></param>
// /// <param name="ESN"></param>
// /// <param name="LocGroup"></param>
// /// <param name="WipGroup"></param>
// /// <param name="ReworkNo"></param>
// /// <returns></returns>
// public string UpdateDataForReworkWareHouse(List<string> ClearWip, List<string> Listsn, string LocGroup, string WipGroup, string ReworkNo, int Total)
// {
// string Msg = "";
// if (Listsn.Count != Total)
// {
// return string.Format("传入资料异常,传入ESN数量{0}个,实际应该是{1}", Listsn.Count.ToString(), Total.ToString());
// }
// else
// {
// for (int xi = 0; xi < Listsn.Count; xi++)
// {
// string ESN = Listsn[xi].ToString();
// List<string> WipKeyparts = new List<string>();
// MySqlCommand[] cmd = new MySqlCommand[100];
// List<MySqlCommand> lsCmd = new List<MySqlCommand>();
// string ColnumWip = "";
// int y = 0;
// for (int i = 0; i < ClearWip.Count; i++)
// {
// string str = ClearWip[i].ToString();
// int x = str.IndexOf('-');
// string Flag = str.Substring(0, x);
// string Colnum = str.Substring(x + 1, str.Length - x - 1);
// if (Flag == "0")
// {
// ColnumWip += string.Format("{0}='NA',", Colnum);
// }
// if (Flag == "1")
// {
// WipKeyparts.Add(string.Format("sntype='{0}'", Colnum));
// }
// }
// ColnumWip = ColnumWip + "Locstation=@loc,wipstation=@wip,";
// ColnumWip = ColnumWip.Substring(0, ColnumWip.Length - 1);
// string colnum = @"esn,woid,partnumber,productname,versioncode,type,locstation,stationname,wipstation,nextstation,userid,recdate,errflag,
// scrapflag,sn,mac,imei,cartonnumber,trayno,palletnumber,mcartonnumber,mpalletnumber,line,sectionname,routgroupid,storenumber,
// weightqty,qa_no,qa_result,track_no,ate_station_no,in_line_time,bomnumber";
// cmd[y] = new MySqlCommand();
// cmd[y].CommandText = string.Format("insert into SFCR.T_WIP_UNDO ({0},@rewno) select {0},@rewno from sfcr.T_WIP_TRACKING_ONLINE where esn=@esn", colnum);
// cmd[y].Parameters.Add("esn", MySqlDbType.VarChar, ESN.Length).Value = ESN;
// cmd[y].Parameters.Add("rewno", MySqlDbType.VarChar, ReworkNo.Length).Value = ReworkNo;
// lsCmd.Add(cmd[y]);
// y++;
// cmd[y] = new MySqlCommand();
// cmd[y].CommandText = "Update sfcr.T_WIP_TRACKING_ONLINE set nextstation=@nextwip,reworkno=@rewno," + ColnumWip + " where esn=@esn";
// cmd[y].Parameters.Add("rewno", MySqlDbType.VarChar, ReworkNo.Length).Value = ReworkNo;
// cmd[y].Parameters.Add("esn", MySqlDbType.VarChar, ESN.Length).Value = ESN;
// cmd[y].Parameters.Add("loc", MySqlDbType.VarChar, LocGroup.Length).Value = LocGroup;
// cmd[y].Parameters.Add("wip", MySqlDbType.VarChar, WipGroup.Length).Value = WipGroup;
// cmd[y].Parameters.Add("nextwip", MySqlDbType.VarChar, WipGroup.Length).Value = WipGroup;
// lsCmd.Add(cmd[y]);
// y++;
// string whcolnum = @"esn,woid,partnumber,productname,versioncode,type,locstation,stationname,wipstation,nextstation,userid,recdate,errflag,
// scrapflag,sn,mac,imei,cartonnumber,trayno,palletnumber,mcartonnumber,mpalletnumber,line,sectionname,routgroupid,storenumber,
// weightqty,qa_no,qa_result,track_no,ate_station_no,in_line_time,bomnumber,lotin,storehouseid,locid,lotout,recdate1,status";
// cmd[y] = new MySqlCommand();
// cmd[y].CommandText = string.Format(" insert into sfcr.z_whs_tracking_undo ({0},reworkno) select {0},@rewno sfcr.Z_WHS_TRACKING where esn=@esn", whcolnum);
// cmd[y].Parameters.Add("esn", MySqlDbType.VarChar, ESN.Length).Value = ESN;
// cmd[y].Parameters.Add("rewno", MySqlDbType.VarChar, ReworkNo.Length).Value = ReworkNo;
// lsCmd.Add(cmd[y]);
// y++;
// cmd[y] = new MySqlCommand();
// cmd[y].CommandText = "DELETE FROM sfcr.Z_WHS_TRACKING where esn=@esn";
// cmd[y].Parameters.Add("esn", MySqlDbType.VarChar, ESN.Length).Value = ESN;
// lsCmd.Add(cmd[y]);
// if (WipKeyparts.Count != 0)
// {
// for (int x = 0; x < WipKeyparts.Count; x++)
// {
// y++;
// string colnumKeyPart = "esn,woId,sntype,snval,station,kpno,recdate";
// cmd[y] = new MySqlCommand();
// cmd[y].CommandText = string.Format("insert into SFCR.T_WIP_KEYPART_UNDO ({1}) select {1} from SFCR.T_WIP_KEYPART_ONLINE where esn=@SN and {0}", WipKeyparts[x].ToString(), colnumKeyPart);
// cmd[y].Parameters.Add("SN", MySqlDbType.VarChar, ESN.Length).Value = ESN;
// lsCmd.Add(cmd[y]);
// y++;
// cmd[y] = new MySqlCommand();
// cmd[y].CommandText = string.Format("DELETE FROM SFCR.T_WIP_KEYPART_ONLINE where esn=@esn and {0}", WipKeyparts[x].ToString());
// cmd[y].Parameters.Add("esn", MySqlDbType.VarChar, ESN.Length).Value = ESN;
// lsCmd.Add(cmd[y]);
// }
// }
// y++;
// cmd[y] = new MySqlCommand();
// cmd[y].CommandText = string.Format("insert into SFCR.z_whs_keypart_undo (esn,woId,sntype,snval,station,kpno,recdate) select esn,woId,sntype,snval,station,kpno,recdate from SFCR.Z_WHS_KEYPART where esn=@esn ");
// cmd[y].Parameters.Add("esn", MySqlDbType.VarChar, ESN.Length).Value = ESN;
// // cmd[y].Parameters.Add("rewno", MySqlDbType.VarChar, ReworkNo.Length).Value = ReworkNo;
// lsCmd.Add(cmd[y]);
// y++;
// cmd[y] = new MySqlCommand();
// cmd[y].CommandText = string.Format("DELETE FROM SFCR.Z_WHS_KEYPART where esn=@esn ");
// cmd[y].Parameters.Add("esn", MySqlDbType.VarChar, ESN.Length).Value = ESN;
// lsCmd.Add(cmd[y]);
// if (ColnumWip.ToUpper().IndexOf("CARTONNUMBER") > -1)
// {
// y++;
// cmd[y] = new MySqlCommand();
// cmd[y].CommandText = "update SFCR.T_CARTON_INFO_HAD set num=num-1 where cartonId=(select cartonid from tCartonInfodta where esn=@esn)";
// cmd[y].Parameters.Add("esn", MySqlDbType.VarChar, ESN.Length).Value = ESN;
// lsCmd.Add(cmd[y]);
// y++;
// cmd[y] = new MySqlCommand();
// cmd[y].CommandText = "DELETE FROM SFCR.T_CARTON_INFO_DTA where esn=@esn";
// cmd[y].Parameters.Add("esn", MySqlDbType.VarChar, ESN.Length).Value = ESN;
// lsCmd.Add(cmd[y]);
// }
// try
// {
// BLL.BllMsSqllib.Instance.ExecteNonQueryArr(lsCmd);
// Msg = "OK";
// }
// catch (Exception ex)
// {
// Msg = ex.Message + "ESN:" + ESN;
// }
// }
// return Msg;
// }
// }
public string Release_Bound(string ESN, string INPUTGROUP, string ReworkNo)
{
DbConnection conn = ProviderHelper.GetConnection(ProConfiguration.GetConfig().DatabaseType, ProConfiguration.GetConfig().DatabaseConnect);
DbTransaction tx = ProviderHelper.BeginTransaction(conn);
try
{
IAdminProvider dp = (IAdminProvider)DpFactory.Create(typeof(IAdminProvider), DpFactory.ADMIN);
IDictionary <string, object> mst = new Dictionary <string, object>();
int count = 0;
mst.Add("LOCSTATION", INPUTGROUP);
mst.Add("STATIONNAME", INPUTGROUP);
mst.Add("WIPSTATION", INPUTGROUP);
mst.Add("NEXTSTATION", INPUTGROUP);
mst.Add("REWORKNO", ReworkNo);
mst.Add("ESN", ESN);
dp.UpdateData(tx, "SFCR.T_WIP_TRACKING_ONLINE", new string[] { "ESN" }, mst);
mst = new Dictionary <string, object>();
mst.Add("ESN", ESN);
DataSet ds = dp.GetData("SFCR.T_WIP_KEYPART_ONLINE", "ESN,WOID,SNTYPE,SNVAL,STATION,KPNO,RECDATE", mst, out count);
foreach (DataRow dr in ds.Tables[0].Rows)
{
if (dr["SNTYPE"].ToString() == "KPESN")
{
mst = new Dictionary <string, object>();
mst.Add("ESN", dr["SNVAL"].ToString());
mst.Add("WIPSTATION", "MB_Repair");
dp.UpdateData(tx, "SFCR.T_WIP_TRACKING_ONLINE", new string[] { "ESN" }, mst);
}
mst = new Dictionary <string, object>();
mst.Add("ESN", dr["ESN"].ToString());
mst.Add("WOID", dr["WOID"].ToString());
mst.Add("SNTYPE", dr["SNTYPE"].ToString());
mst.Add("SNVAL", dr["SNVAL"].ToString());
mst.Add("STATION", dr["STATION"].ToString());
mst.Add("KPNO", dr["KPNO"].ToString());
mst.Add("RECDATE", Convert.ToDateTime(dr["RECDATE"].ToString()));
dp.AddData(tx, "SFCR.T_WIP_KEYPART_UNDO", mst);
}
mst = new Dictionary <string, object>();
mst.Add("ESN", ESN);
dp.DeleteData(tx, "SFCR.T_WIP_KEYPART_ONLINE", mst);
tx.Commit();
return("OK");
}
catch (Exception ex)
{
tx.Rollback();
return(ex.Message);
}
finally
{
conn.Close();
conn.Dispose();
}
}
public string InsertAteScript(string AteScript)
{
try
{
int count = 0;
IDictionary <string, object> mstAteScript = MapListConverter.JsonToDictionary(AteScript);
IAdminProvider dp = (IAdminProvider)DpFactory.Create(typeof(IAdminProvider), DpFactory.ADMIN);
IDictionary <string, object> mst = new Dictionary <string, object>();
mst = new Dictionary <string, object>();
mst.Add("WOID", mstAteScript["WOID"]);
DataTable dtate = dp.GetData("SFCB.B_ATE_SCRIPT", "COUNT(1)", mst, out count).Tables[0];
if (dtate.Rows[0][0].ToString() == "0")
{
dp.AddData("SFCB.B_ATE_SCRIPT", mstAteScript);
}
else
{
dp.UpdateData("SFCB.B_ATE_SCRIPT", new string[] { "WOID" }, mstAteScript);
}
return("OK");
}
catch (Exception ex)
{
return(ex.Message);
}
}
/// <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);
}
/// <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);
}
public string Rework_SN(IDictionary <string, object> mst, List <string> LsKeyParts)
{
DbConnection conn = ProviderHelper.GetConnection(ProConfiguration.GetConfig().DatabaseType, ProConfiguration.GetConfig().DatabaseConnect);
DbTransaction tx = ProviderHelper.BeginTransaction(conn);
string Colnum = "ESN,WOID,PARTNUMBER,PRODUCTNAME,VERSIONCODE,TYPE,LOCSTATION,STATIONNAME,WIPSTATION,NEXTSTATION,USERID,RECDATE," +
"ERRFLAG,SCRAPFLAG,SN,MAC,IMEI,CARTONNUMBER,TRAYNO,PALLETNUMBER,MCARTONNUMBER,MPALLETNUMBER,LINE,SECTIONNAME,ROUTGROUPID," +
"STORENUMBER,WEIGHTQTY,QA_NO,QA_RESULT,TRACK_NO,ATE_STATION_NO,IN_LINE_TIME,BOMNUMBER,REWORKNO";
int count = 0;
try
{
IAdminProvider dp = (IAdminProvider)DpFactory.Create(typeof(IAdminProvider), DpFactory.ADMIN);
Dictionary <string, object> dic = new Dictionary <string, object>();
dic.Add("ESN", mst["ESN"]);
DataTable dt_wip_tracking = dp.GetData("SFCR.T_WIP_TRACKING_ONLINE", Colnum, dic, out count).Tables[0];
if (count > 0)
{
dp.AddListData(tx, "SFCR.T_WIP_UNDO", DataTableToDictionary(dt_wip_tracking));
}
if (LsKeyParts.Count > 0)
{
string colnumKeyPart = "esn,woId,sntype,snval,station,kpno,recdate".ToUpper();
DataTable dt_KeyParts = dp.GetData("SFCR.T_WIP_KEYPART_ONLINE", colnumKeyPart, dic, out count).Tables[0];
DataTable dt_Backup_KeyParts = new DataTable();
foreach (string str in colnumKeyPart.Split(','))
{
dt_Backup_KeyParts.Columns.Add(str, typeof(string));
}
if (dt_KeyParts.Rows.Count > 0)
{
foreach (DataRow dr in dt_KeyParts.Rows)
{
if (LsKeyParts.Contains(dr["SNTYPE"].ToString()))
{
dt_Backup_KeyParts.Rows.Add(dr["ESN"].ToString(), dr["WOID"].ToString(), dr["SNTYPE"].ToString(), dr["SNVAL"].ToString(), dr["STATION"].ToString(), dr["KPNO"].ToString(), dr["RECDATE"].ToString());
}
}
}
if (dt_Backup_KeyParts.Rows.Count > 0)
{
dp.AddListData(tx, "SFCR.T_WIP_KEYPART_UNDO", DataTableToDictionary(dt_Backup_KeyParts));
dp.DeleteListData(tx, "SFCR.T_WIP_KEYPART_ONLINE", DataTableToDictionary(dt_Backup_KeyParts));
}
}
dp.UpdateData(tx, "SFCR.T_WIP_TRACKING_ONLINE", new string[] { "ESN" }, mst);
tx.Commit();
return("OK");
}
catch (Exception ex)
{
tx.Rollback();
return(ex.Message);
}
finally
{
conn.Close();
conn.Dispose();
}
}
public string Clear_User_Info(string UserId)
{
DbConnection conn = ProviderHelper.GetConnection(ProConfiguration.GetConfig().DatabaseType, ProConfiguration.GetConfig().DatabaseConnect);
DbTransaction tx = ProviderHelper.BeginTransaction(conn);
try
{
IAdminProvider dp = (IAdminProvider)DpFactory.Create(typeof(IAdminProvider), DpFactory.ADMIN);
IDictionary <string, object> mst = new Dictionary <string, object>();
mst.Add("USERID", UserId);
mst.Add("PWD", "");
mst.Add("USERSTATUS", "0");
dp.UpdateData(tx, "SFCB.B_USER_INFO", new string[] { "USERID" }, mst);
mst = new Dictionary <string, object>();
mst.Add("USERID", UserId);
dp.DeleteData(tx, "sfcb.b_user_poplist".ToUpper(), mst);
tx.Commit();
return("OK");
}
catch (Exception ex)
{
tx.Rollback();
return(ex.Message);
}
finally
{
conn.Close();
conn.Dispose();
}
}
/// <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 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);
}
}
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);
}
/// <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 string GetSqlSequence()
{
string C_SEQ = string.Empty;
string PRGNAME = "SEQ_NEWSEQVALUE";
//MySqlCommand cmd = new MySqlCommand();
//cmd.CommandText = "select current_value from sfcb.sequence where name=@PRGNAME";
//cmd.Parameters.Add("PRGNAME", MySqlDbType.VarChar).Value = PRGNAME;
//DataTable dtSEQ = BLL.BllMsSqllib.Instance.ExecuteDataSet(cmd).Tables[0];
string fieldlist = "current_value,increment";
int count = 0;
IAdminProvider dp = (IAdminProvider)DpFactory.Create(typeof(IAdminProvider), DpFactory.ADMIN);
Dictionary <string, object> mst = new Dictionary <string, object>();
mst.Add("name", PRGNAME);
DataTable dtSEQ = dp.GetData("sfcb.sequence", fieldlist, mst, out count).Tables[0];
C_SEQ = "S" + dtSEQ.Rows[0]["current_value"].ToString().PadLeft(6, '0');
//cmd = new MySqlCommand();
//cmd.CommandText = "update sfcb.sequence set current_value=current_value+increment where name=@PRGNAME";
//cmd.Parameters.Add("PRGNAME", MySqlDbType.VarChar).Value = PRGNAME;
//BLL.BllMsSqllib.Instance.ExecteNonQuery(cmd);
mst = new Dictionary <string, object>();
mst.Add("current_value", Convert.ToInt32(dtSEQ.Rows[0]["current_value"].ToString()) + Convert.ToInt32(dtSEQ.Rows[0]["increment"].ToString()));
mst.Add("NAME", PRGNAME);
dp.UpdateData("sfcb.sequence", new string[] { "NAME" }, mst);
return(C_SEQ);
}
public string Sel_QCNO()
{
string C_SEQ = string.Empty;
if (ProConfiguration.GetConfig().DatabaseType == SysModel.DataLinkType.Oracle)
{
int count = 0;
IAdminProvider dp = (IAdminProvider)DpFactory.Create(typeof(IAdminProvider), DpFactory.ADMIN);
C_SEQ = DateTime.Now.ToString("yyyyMMdd") + dp.GetData("DUAL", "SEQ_FQC.NEXTVAL", null, out count).Tables[0].Rows[0][0].ToString();
}
if (ProConfiguration.GetConfig().DatabaseType == SysModel.DataLinkType.MySql)
{
string PRGNAME = "SEQ_FQC";
string table = "sfcb.sequence";
string fieldlist = "current_value,increment";
int count = 0;
IAdminProvider dp = (IAdminProvider)DpFactory.Create(typeof(IAdminProvider), DpFactory.ADMIN);
IDictionary <string, object> mst = new Dictionary <string, object>();
mst.Add("name", PRGNAME);
DataTable dtSEQ = dp.GetData(table, fieldlist, mst, out count).Tables[0];
C_SEQ = dtSEQ.Rows[0][0].ToString().PadLeft(6, '0');
mst = new Dictionary <string, object>();
mst.Add("current_value", Convert.ToInt32(dtSEQ.Rows[0]["current_value"].ToString()) + Convert.ToInt32(dtSEQ.Rows[0]["increment"].ToString()));
mst.Add("name", PRGNAME);
dp.UpdateData("sfcb.sequence", new string[] { "name" }, mst);
C_SEQ = DateTime.Now.ToString("yyyyMMdd") + C_SEQ;
}
return(C_SEQ);
}
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);
}
///// <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);
}
/// <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 InsertWoInfo(string dicwoinfo)
{
IDictionary <string, object> dic = MapListConverter.JsonToDictionary(dicwoinfo);
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", dic["WOID"]);
DataTable dt = dp.GetData(table, fieldlist, mst, out count).Tables[0];
try
{
if (dt.Rows[0][0].ToString() == "0")
{
mst.Add("RECDATE", System.DateTime.Now);
dp.AddData(table, dic);
}
else
{
mst.Add("RECDATE", System.DateTime.Now);
dp.UpdateData(table, new string[] { "WOID" }, dic);
}
return("OK");
}
catch (Exception ex)
{
return(ex.Message);
}
}
public void UpdateSupplyMaterialStatus(string dicskm)
{
IAdminProvider dp = (IAdminProvider)DpFactory.Create(typeof(IAdminProvider), DpFactory.ADMIN);
IDictionary <string, object> mst = MapListConverter.JsonToDictionary(dicskm);
mst.Add("supplytime".ToUpper(), System.DateTime.Now);
dp.UpdateData("sfcr.t_smt_kp_monnitor", new string[] { "ROWID" }, mst);
}
public void UpdatePackParameters(string dicstring)
{
IAdminProvider dp = (IAdminProvider)DpFactory.Create(typeof(IAdminProvider), DpFactory.ADMIN);
IDictionary <string, object> mst = MapListConverter.JsonToDictionary(dicstring);
mst.Add("RECDATE", System.DateTime.Now);
dp.UpdateData(table, new string[] { "PARTNUMBER" }, mst);
}
public void UpdateMaintaindate(string fixtureid, string fixturemaintaindate)
{
IAdminProvider dp = (IAdminProvider)DpFactory.Create(typeof(IAdminProvider), DpFactory.ADMIN);
IDictionary <string, object> mst = new Dictionary <string, object>();
mst.Add("fixturemaintaindate", fixturemaintaindate);
mst.Add("fixtureId", fixtureid);
dp.UpdateData("SFCR.T_FIXTURE_INFO", new string[] { "fixtureId" }, mst);
}
public void UpdateSmtkPMonnitorCdata(string rowid, string cdata)
{
IAdminProvider dp = (IAdminProvider)DpFactory.Create(typeof(IAdminProvider), DpFactory.ADMIN);
Dictionary <string, object> mst = new Dictionary <string, object>();
mst.Add("ROWID", rowid);
mst.Add("CDATA", cdata);
dp.UpdateData("sfcr.t_smt_kp_monnitor", new string[] { "ROWID" }, mst);
}
public void UPDATE_WIPSTATION(string STOCK_NO, string WIP_STATION)
{
IAdminProvider dp = (IAdminProvider)DpFactory.Create(typeof(IAdminProvider), DpFactory.ADMIN);
IDictionary <string, object> mst = new Dictionary <string, object>();
mst.Add("STORENUMBER", STOCK_NO);
mst.Add("WIPSTATION", string.IsNullOrEmpty(WIP_STATION) ? "1003" : WIP_STATION);
dp.UpdateData("sfcr.t_wip_tracking_online", new string[] { "STORENUMBER" }, mst);
}
public void EditSmtKpMonitorFlag(string kpmonitorId, int cdata)
{
IAdminProvider dp = (IAdminProvider)DpFactory.Create(typeof(IAdminProvider), DpFactory.ADMIN);
IDictionary <string, object> mst = new Dictionary <string, object>();
mst.Add("CDATA", cdata);
mst.Add("ROWID", kpmonitorId);
dp.UpdateData("SFCR.T_SMT_KP_MONNITOR", new string[] { "ROWID" }, mst);
}
/// <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);
//}
// }
}
//更改TrSn状态
public void UpdateTrSnStatus(string Status, string userid, string TrSn)
{
IAdminProvider dp = (IAdminProvider)DpFactory.Create(typeof(IAdminProvider), DpFactory.ADMIN);
IDictionary <string, object> mst = new Dictionary <string, object>();
mst.Add("SSTATUS", Status);
mst.Add("USERID", userid);
mst.Add("RECDATE", System.DateTime.Now);
mst.Add("TRSN", TrSn);
dp.UpdateData("SFCR.T_PART_STOREHOUSE_HAD", new string[] { "TRSN" }, mst);
}
public void UpdatePartBlocked(string dicstring)
{
IAdminProvider dp = (IAdminProvider)DpFactory.Create(typeof(IAdminProvider), DpFactory.ADMIN);
IDictionary <string, object> mst = MapListConverter.JsonToDictionary(dicstring);
if (ProConfiguration.GetConfig().DatabaseType == SysModel.DataLinkType.MySql)
{
mst.Add("in_station_time".ToUpper(), System.DateTime.Now);
}
dp.UpdateData("SFCR.T_PART_BLOCKED", new string[] { "PART_NO" }, mst);
}
public void UPDATE_STOCK_NO(string STOCK_NO, string WOID, string WIPSTATION, string ESN)
{
IAdminProvider dp = (IAdminProvider)DpFactory.Create(typeof(IAdminProvider), DpFactory.ADMIN);
IDictionary <string, object> mst = new Dictionary <string, object>();
mst.Add("STORENUMBER", STOCK_NO);
mst.Add("WOID", WOID);
mst.Add("WIPSTATION", WIPSTATION);
mst.Add("ESN", ESN);
dp.UpdateData("sfcr.t_wip_tracking_online", new string[] { "WOID", "WIPSTATION", "ESN" }, mst);
}
public string UpdateData(string TableName, string DicString, List <string> TableKey)
{
try
{
IAdminProvider dp = (IAdminProvider)DpFactory.Create(typeof(IAdminProvider), DpFactory.ADMIN);
IDictionary <string, object> mst = MapListConverter.JsonToDictionary(DicString);
dp.UpdateData(TableName, TableKey.ToArray(), mst);
return("OK");
}
catch (Exception ex)
{
return(ex.Message);
}
}
/// <summary>
/// 用户自己修改信息
/// </summary>
/// <param name="userinfo"></param>
public void UpdateUserPassword(string dicuserinfo)
{
IDictionary <string, object> mst = MapListConverter.JsonToDictionary(dicuserinfo);
IAdminProvider dp = (IAdminProvider)DpFactory.Create(typeof(IAdminProvider), DpFactory.ADMIN);
dp.UpdateData("SFCB.B_USER_INFO", new string[] { "USERID" }, mst);
//MySqlCommand cmd = new MySqlCommand();
//cmd.CommandText = "update SFCB.B_USER_INFO set pwd=@pwd, userphone=@userphone, useremail=@useremail where userId=@userId";
//cmd.Parameters.Add("userId", MySqlDbType.VarChar, 20).Value = userinfo.userId;
//cmd.Parameters.Add("userphone", MySqlDbType.VarChar, 30).Value = userinfo.userphone;
//cmd.Parameters.Add("useremail", MySqlDbType.VarChar, 50).Value = userinfo.useremail;
//cmd.Parameters.Add("pwd", MySqlDbType.VarChar, 15).Value = userinfo.pwd;
//BLL.BllMsSqllib.Instance.ExecteNonQuery(cmd);
}
public void UpdateTargetPlan(string dicstring)
{
//MySqlCommand cmd = new MySqlCommand();
//cmd.CommandText = "update SFCR.T_TARGET_PLAN set TargetQty=@sQTY, StartTime=@STime, EndTime=@ETime, Side=@SDE where ROWID=@idx";
//cmd.Parameters.Add("sQTY", MySqlDbType.VarChar).Value = sPlan.TargetQty;
//cmd.Parameters.Add("STime", MySqlDbType.VarChar).Value = sPlan.StartTime;
//cmd.Parameters.Add("ETime", MySqlDbType.VarChar).Value = sPlan.EndTime;
//cmd.Parameters.Add("SDE", MySqlDbType.VarChar).Value = sPlan.Side;
//cmd.Parameters.Add("idx", MySqlDbType.VarChar).Value = sPlan.Idx;
//BLL.BllMsSqllib.Instance.ExecteNonQuery(cmd);
IAdminProvider dp = (IAdminProvider)DpFactory.Create(typeof(IAdminProvider), DpFactory.ADMIN);
IDictionary<string, object> mst = MapListConverter.JsonToDictionary(dicstring);
dp.UpdateData("SFCR.T_TARGET_PLAN", new string[] { "ROWID" }, mst);
}
public string Update_SmtKpMonitor(string Json, List <string> TablesKey)
{
try
{
IAdminProvider dp = (IAdminProvider)DpFactory.Create(typeof(IAdminProvider), DpFactory.ADMIN);
IDictionary <string, object> mst = MapListConverter.JsonToDictionary(Json);
dp.UpdateData("SFCR.T_SMT_KP_MONNITOR", TablesKey.ToArray(), mst);
return("OK");
}
catch (Exception ex)
{
return(ex.Message);
}
}
