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