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