public override string InsertLocalFromMaster()
{
/*MSYS.Web.EquipService.EquipServiceInterfaceService service = new MSYS.Web.EquipService.EquipServiceInterfaceService();
* StringBuilder buffer = new StringBuilder();
* buffer.Append("<?xml version=\"1.0\" encoding=\"utf-8\" ?>");
* buffer.Append("<request>");
* buffer.Append("</request>");
* tEqEqpCls[] cls = service.getEquipClsList(buffer.ToString());
* if (cls.Length > 0)
* {
* MSYS.DAL.DbOperator opt = new DAL.DbOperator();
* List<string> commandlist = new List<string>();
* string[] seg = { "ID_KEY", "NODE_NAME", "NODE_VALUE", "PARENT_ID", "PATH", "TYPE" };
* foreach (tEqEqpCls item in cls)
* {
* string[] value = { item.idKey, item.nodeName, item.nodeValue, item.parentId, item.path, item.type };
* string temp = opt.getMergeStr(seg, value, 1, "HT_EQ_EQP_CLS");
* commandlist.Add(temp);
* if (opt.UpDateOra(temp) != "Success")
* System.Diagnostics.Debug.Write(temp);
* }
* return opt.TransactionCommand(commandlist);
* }
* else
* return "未获取更新";*/
MSYS.Web.PlanService.WsPlanForGSInterfaceService service = new MSYS.Web.PlanService.WsPlanForGSInterfaceService();
MSYS.DAL.DbOperator opt = new DAL.DbOperator();
prodAssignPlan[] pb = service.getProdAssignForGS("", "");
prodAssignVO[] pvo = service.getProdAssignListForGS("", "");
string[] seg = { "id", "PLAN_NAME", "B_FLOW_STATUS", "ISSUED_STATUS", "PLAN_TIME", "IS_VALID", "REMARK" };
string[] seg2 = { "month_plan_id", "prod_code ", "plan_year", "prod_month", "plan_type", "plan_outpu", "plan_sort", "exe_status" };
foreach (prodAssignPlan p in pb)
{
if (p.planNo.Substring(0, 2) != "GS")
{
continue;
}
string[] value = { p.id, p.planName, p.bFlowStatus, p.issuedStatus, p.planTime, "1", p.remark, };
// string[] value2 = { p.id };
opt.getMergeStr(seg, value, 1, "HT_PROD_MONTH_PLAN");
// opt.getMergeStr(seg2, value2, 1, "HT_PROD_MONTH_PLAN_DETAIL");
// dt.Rows.Add(paras);
}
foreach (prodAssignVO p in pvo)
{
if (p.planNo.Substring(0, 2) != "GS")
{
continue;
}
string[] value = { p.planNo, p.prodCode, p.jobYear, p.jobMonth, p.planType, p.jobOutput, p.jobSort, p.status };
opt.getMergeStr(seg2, value, 1, "HT_PROD_MONTH_PLAN_DETAIL");
}
return("12");
}
public override string InsertLocalFromMaster()
{
MSYS.Web.EquipService.EquipServiceInterfaceService service = new MSYS.Web.EquipService.EquipServiceInterfaceService();
StringBuilder buffer = new StringBuilder();
buffer.Append("<?xml version=\"1.0\" encoding=\"utf-8\" ?>");
buffer.Append("<request>");
buffer.Append("</request>");
tEqEqpCls[] cls = service.getEquipClsList(buffer.ToString());
if (cls.Length > 0)
{
MSYS.DAL.DbOperator opt = new DAL.DbOperator();
List <string> commandlist = new List <string>();
string[] seg = { "ID_KEY", "NODE_NAME", "NODE_VALUE", "PARENT_ID", "PATH", "TYPE" };
foreach (tEqEqpCls item in cls)
{
string[] value = { item.idKey, item.nodeName, item.nodeValue, item.parentId, item.path, item.type };
string temp = opt.getMergeStr(seg, value, 1, "HT_EQ_EQP_CLS");
commandlist.Add(temp);
if (opt.UpDateOra(temp) != "Success")
{
System.Diagnostics.Debug.Write(temp);
}
}
return(opt.TransactionCommand(commandlist));
}
else
{
return("未获取更新");
}
}
public override string InsertLocalFromMaster()
{
MSYS.Web.EquipService.EquipServiceInterfaceService service = new MSYS.Web.EquipService.EquipServiceInterfaceService();
StringBuilder buffer = new StringBuilder();
tEqEqpTbl[] tbs = service.getEquipList(new tEqEqpTbl());
if (tbs.Length > 0)
{
MSYS.DAL.DbOperator opt = new DAL.DbOperator();
List <string> commandlist = new List <string>();
string[] seg = { "IDKEY", "CLS_CODE", "CREATE_TIME", "CREATOR", "DUTY_NAME", "EQ_MODEL", "EQ_NAME", "EQP_FROM", "EQP_IP", "EQP_MAC", "EQP_SN", "EQP_SYS", "EQ_STATUS", "EQ_TYPE", "FLAG", "IS_DEL", "IS_MADEINCHINA", "IS_SPEC_EQP", "MANUFACTURER", "MGT_DEPT_CODE", "NC_CODE", "NET_WORTH", "ORI_OWNER_NAME", "ORI_WORTH", "OWNER_NAME", "POWER_UNIT", "RATED_POWER", "REAL_POWER", "REMARK", "SERIAL_NUMBER", "SGS_CODE", "SUPPLIER", "USED_DATE", "USE_DEPT_CODE", "ZG_DATE", "FINANCE_EQ_NAME" };
foreach (tEqEqpTbl item in tbs)
{
string[] value = { item.idkey, item.clsCode, item.createTime, item.creator, item.dutyName, item.eqModel, item.eqName, item.eqpFrom, item.eqpIp, item.eqpMac, item.eqpSn, item.eqpSys, item.eqStatus, item.eqType, item.flag.ToString(), item.isDel, item.isMadeinchina, item.isSpecEqp, item.manufacturer, item.mgtDeptCode, item.ncCode, item.netWorth, item.oriOwnerName, item.oriWorth, item.ownerName, item.powerUnit, item.ratedPower, item.realPower, item.remark, item.serialNumber, item.sgsCode, item.supplier, item.usedDate, item.useDeptCode, item.zgDate, item.financeEqName, };
string temp = opt.getMergeStr(seg, value, 1, "HT_EQ_EQP_TBL");
commandlist.Add(temp);
if (opt.UpDateOra(temp) != "Success")
{
System.Diagnostics.Debug.Write(temp);
}
}
return(opt.TransactionCommand(commandlist));
}
else
{
return("未获取更新");
}
}
public override string InsertLocalFromMaster()
{
MSYS.Web.PlanService.WsPlanForGSInterfaceService service = new MSYS.Web.PlanService.WsPlanForGSInterfaceService();
MSYS.DAL.DbOperator opt = new DAL.DbOperator();
quarterPlanVO[] pb = service.getQuarterPlanList("", "");
prodAssignVO[] pvo = service.getProdAssignListForGS("", "");
string[] seg = { "id", "PLAN_NAME", "B_FLOW_STATUS", "ISSUED_STATUS", "PLAN_YEAR", "QUATER", "IS_VALID", "REMARK" };
string[] seg2 = { "QUARTER_PLAN_ID", "prod_code ", "plan_OUTPUT_1", "PLAN_OUTPUT_2", "PLAN_OUTPUT_3", "TOTAL_OUTPUT", "IS_DEL" };
foreach (quarterPlanVO p in pb)
{
string[] value = { p.quarterPlan.id, p.quarterPlan.planName, p.quarterPlan.flowStatus, p.quarterPlan.issuedStatus, p.quarterPlan.planYear, p.quarterPlan.quarter, "1", p.quarterPlan.remark, };
// string[] value2 = { p.id };
opt.getMergeStr(seg, value, 1, "HT_PROD_SEASON_PLAN");
foreach (tAmQuarterPlanDetail pd in p.subList)
{
string[] value2 = { p.quarterPlan.id, pd.prodCode, pd.planOutput1.ToString(), pd.planOutput2.ToString(), pd.planOutput3.ToString(), pd.totalOutput.ToString(), pd.isDel };
opt.getMergeStr(seg2, value2, 1, "HT_PROD_SEASON_PLAN_DETAIL");
}
// opt.getMergeStr(seg2, value2, 1, "HT_PROD_MONTH_PLAN_DETAIL");
// dt.Rows.Add(paras);
}
return("12");
}
private static void service_Completed(object sender, getEquipClsListCompletedEventArgs e)
{
tEqEqpCls[] cls = e.Result;
if (cls.Length > 0)
{
MSYS.DAL.DbOperator opt = new DAL.DbOperator();
// List<string> commandlist = new List<string>();
string[] seg = { "ID_KEY", "NODE_NAME", "NODE_VALUE", "PARENT_ID", "PATH", "TYPE" };
foreach (tEqEqpCls item in cls)
{
string[] value = { item.idKey, item.nodeName, item.nodeValue, item.parentId, item.path, item.type };
string temp = opt.getMergeStr(seg, value, 1, "HT_EQ_EQP_CLS");
// commandlist.Add(temp);
if (opt.UpDateOra(temp) != "Success")
{
System.Diagnostics.Debug.Write(temp);
}
}
// return opt.TransactionCommand(commandlist);
}
}
private static void service_Completed(object sender, getEquipListCompletedEventArgs e)
{
tEqEqpTbl[] tbs = e.Result;
if (tbs.Length > 0)
{
MSYS.DAL.DbOperator opt = new DAL.DbOperator();
// List<string> commandlist = new List<string>();
string[] seg = { "IDKEY", "CLS_CODE", "CREATE_TIME", "CREATOR", "DUTY_NAME", "EQ_MODEL", "EQ_NAME", "EQP_FROM", "EQP_IP", "EQP_MAC", "EQP_SN", "EQP_SYS", "EQ_STATUS", "EQ_TYPE", "FLAG", "IS_DEL", "IS_MADEINCHINA", "IS_SPEC_EQP", "MANUFACTURER", "MGT_DEPT_CODE", "NC_CODE", "NET_WORTH", "ORI_OWNER_NAME", "ORI_WORTH", "OWNER_NAME", "POWER_UNIT", "RATED_POWER", "REAL_POWER", "REMARK", "SERIAL_NUMBER", "SGS_CODE", "SUPPLIER", "USED_DATE", "USE_DEPT_CODE", "ZG_DATE", "FINANCE_EQ_NAME" };
foreach (tEqEqpTbl item in tbs)
{
string[] value = { item.idkey, item.clsCode, item.createTime, item.creator, item.dutyName, item.eqModel, item.eqName, item.eqpFrom, item.eqpIp, item.eqpMac, item.eqpSn, item.eqpSys, item.eqStatus, item.eqType, item.flag.ToString(), item.isDel, item.isMadeinchina, item.isSpecEqp, item.manufacturer, item.mgtDeptCode, item.ncCode, item.netWorth, item.oriOwnerName, item.oriWorth, item.ownerName, item.powerUnit, item.ratedPower, item.realPower, item.remark, item.serialNumber, item.sgsCode, item.supplier, item.usedDate, item.useDeptCode, item.zgDate, item.financeEqName, };
string temp = opt.getMergeStr(seg, value, 1, "HT_EQ_EQP_TBL");
// commandlist.Add(temp);
if (opt.UpDateOra(temp) != "Success")
{
System.Diagnostics.Debug.Write(temp);
}
}
// return opt.TransactionCommand(commandlist);
}
}