public override string InsertLocalFromMaster()
{
StringBuilder buffer = new StringBuilder();
buffer.Append("<?xml version=\"1.0\" encoding=\"utf-8\" ?>");
buffer.Append("<request>");
buffer.Append("</request>");
MisMasterDataServiceInterfaceService service = new MisMasterDataServiceInterfaceService();
string Xmlstr = service.getUserInfo(buffer.ToString());
XmlDocument xx = new XmlDocument();
xx.LoadXml(Xmlstr); //加载xml
XmlNodeList xxList = xx.GetElementsByTagName(rootname); //取得节点名为DEPTINFO的XmlNode集合
MSYS.DAL.DbOperator opt = new MSYS.DAL.DbOperator();
List <string> commandlist = new List <string>();
string temp;
foreach (XmlNode xxNode in xxList)
{
XmlNodeList childList = xxNode.ChildNodes; //取得DEPTINFO下的子节点集合
int count = childList.Count + 1;
if (count == seg.Length)
{
string[] segvalue = new string[count];
segvalue[0] = childList[2].InnerText;
segvalue[1] = childList[0].InnerText;
segvalue[2] = childList[1].InnerText;
segvalue[3] = childList[3].InnerText;
string dpno = opt.GetSegValue("select F_CODE from Ht_Svr_Org_Group where F_KEY = '" + segvalue[3] + "'", "F_CODE");
if (dpno != "NoRecord")
{
segvalue[3] = dpno;
}
string psd = opt.GetSegValue("select Password from HT_SVR_USER where ID = '" + segvalue[0] + "'", "PassWord");
if (psd == "NoRecord" || psd == "")
{
segvalue[4] = "e10adc3949ba59abbe56e057f20f883e";
}
else
{
segvalue[4] = psd;
}
temp = opt.getMergeStr(seg, segvalue, 1, tablename);
commandlist.Add(temp);
if (opt.UpDateOra(temp) != "Success")
{
System.Diagnostics.Debug.Write(temp);
}
}
else
{
return("字段与值个数不匹配");
}
}
return(opt.TransactionCommand(commandlist));
}
protected override void InsertLocalFromMasterAsyn()
{
StringBuilder buffer = new StringBuilder();
buffer.Append("<?xml version=\"1.0\" encoding=\"utf-8\" ?>");
buffer.Append("<request>");
buffer.Append("</request>");
MisMasterDataServiceInterfaceService service = new MisMasterDataServiceInterfaceService();
service.getDeptInfoCompleted += new getDeptInfoCompletedEventHandler(service_Completed);
service.getDeptInfoAsync(buffer.ToString());
}
public override string InsertLocalFromMaster()
{
StringBuilder buffer = new StringBuilder();
buffer.Append("<?xml version=\"1.0\" encoding=\"utf-8\" ?>");
buffer.Append("<request>");
buffer.Append("</request>");
MisMasterDataServiceInterfaceService service = new MisMasterDataServiceInterfaceService();
string Xmlstr = service.getDeptInfo(buffer.ToString());
XmlDocument xx = new XmlDocument();
xx.LoadXml(Xmlstr); //加载xml
XmlNodeList xxList = xx.GetElementsByTagName(rootname); //取得节点名为DEPTINFO的XmlNode集合
MSYS.DAL.DbOperator opt = new MSYS.DAL.DbOperator();
List <string> commandlist = new List <string>();
foreach (XmlNode xxNode in xxList)
{
XmlNodeList childList = xxNode.ChildNodes; //取得DEPTINFO下的子节点集合
int count = childList.Count + 1;
if (count == seg.Length)
{
string[] segvalue = new string[count];
for (int i = 0; i < count - 1; i++)
{
segvalue[i] = childList[i].InnerText;
}
segvalue[2] = "";
if (segvalue[1] == "江苏鑫源烟草薄片有限公司")
{
segvalue[count - 1] = "00700000";
}
else
{
segvalue[3] = opt.GetSegValue("select F_code from ht_svr_org_group where f_key = '" + segvalue[3] + "'", "F_CODE");
segvalue[4] = opt.GetSegValue("select F_code from ht_svr_org_group where f_key = '" + segvalue[0] + "'", "F_CODE");
if (segvalue[4] == "NoRecord")
{
string code;
if (segvalue[3] == "00700000")
{
code = "007" + opt.GetSegValue("select nvl(Max(substr(F_CODE,4,3))+1,1) as code from Ht_Svr_Org_Group where F_parentid = '00700000'", "CODE").PadLeft(3, '0') + "00";
}
else
{
code = segvalue[3].Substring(0, 6) + opt.GetSegValue("select nvl( Max(substr(F_CODE,7,2))+1,1) as code from Ht_Svr_Org_Group where F_parentid = '" + segvalue[3] + "'", "CODE").PadLeft(2, '0');
}
segvalue[4] = code;
}
}
string temp = opt.getMergeStr(seg, segvalue, 1, tablename);
commandlist.Add(temp);
if (opt.UpDateOra(temp) != "Success")
{
System.Diagnostics.Debug.Write(temp);
}
}
}
return(opt.TransactionCommand(commandlist));
}