protected void btnUpdate_Click(object sender, EventArgs e) { MSYS.Web.PlanService.WsPlanForGSInterfaceService service = new MSYS.Web.PlanService.WsPlanForGSInterfaceService(); MSYS.DAL.DbOperator opt = new MSYS.DAL.DbOperator(); System.Diagnostics.Debug.WriteLine(System.DateTime.Now.Month.ToString()); string month = System.DateTime.Now.Month.ToString().Length < 2? "0" + System.DateTime.Now.Month.ToString():System.DateTime.Now.Month.ToString(); prodAssignPlan[] pb = service.getProdAssignForGS(System.DateTime.Now.Year.ToString(), month); prodAssignVO[] pvo = service.getProdAssignListForGS(System.DateTime.Now.Year.ToString(), month); string[] seg = { "id", "PLAN_NAME", "B_FLOW_STATUS", "ISSUED_STATUS", "PLAN_TIME", "IS_DEL", "REMARK", "CREATE_ID" }; string[] seg2 = { "month_plan_id", "plan_no", "prod_code ", "plan_year", "prod_month", "plan_type", "plan_output", "plan_sort", "exe_status", "is_del", "is_valid", "create_id", "path_code" }; if (pb == null || pvo == null) { System.Diagnostics.Debug.WriteLine("无数据"); return; } string monthid = ""; string cid = ""; foreach (prodAssignPlan p in pb) { if (p.planNo.ToString().Substring(0, 2) != "GS") { continue; } monthid = p.id; string sqllog = "select id from ht_svr_user where loginname = '" + pvo[0].planNo + "'"; if (pvo[0].createId != null) { cid = opt.CreateDataSetOra(sqllog).Tables[0].Rows[0][0].ToString(); } string[] value = { p.id, p.planName, "2", p.issuedStatus, p.planNo.Substring(2, 4) + "-" + p.planNo.Substring(6, 2), "0", p.remark, cid }; // string[] value2 = { p.id }; opt.MergeInto(seg, value, 2, "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.ToString().Substring(0, 2) != "GS") //continue; // string sql = "select xy_prod_code from ht_pub_prod_design where prod_code = " + p.prodCode; // DataSet ds = opt.CreateDataSetOra(sql); //string xy_prod_code = ds.Tables[0].Rows[0][0].ToString(); if (p.prodCode.Substring(0, 3) != "703") { continue; } string path_code = opt.GetSegValue("select path_code from ht_pub_prod_design where prod_code = '" + p.prodCode + "'", "path_code"); string[] value = { monthid, p.planNo, p.prodCode, p.jobYear, p.jobMonth, p.planType, p.jobOutput, p.jobSort, Convert.ToInt32(p.status).ToString(), "0", "1", cid, path_code }; opt.MergeInto(seg2, value, 2, "HT_PROD_MONTH_PLAN_DETAIL"); insertSectionPath(path_code, p.planNo); } bindGrid1(); ScriptManager.RegisterStartupScript(UpdatePanel1, this.Page.GetType(), "", "alert('同步完成');", true); return; }
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.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"); }