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(); quarterPlanVO[] pb = service.getQuarterPlanList(System.DateTime.Now.Year.ToString(), GetQuarterNum(System.DateTime.Now)); if (pb == null) { return; } // prodAssignVO[] pvo = service.getProdAssignListForGS("", ""); string[] seg = { "id", "PLAN_NAME", "FLOW_STATUS", "ISSUED_STATUS", "PLAN_YEAR", "QUARTER", "IS_DEL", "REMARK", "CREATE_ID" }; 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 plname = p.quarterPlan.planName == "" ? System.DateTime.Now.Year.ToString() + "-" + GetQuarterNum(new DateTime()) + "季度生产计划" :p.quarterPlan.planName; string plname = System.DateTime.Now.Year.ToString() + "-" + Convert.ToInt32(GetQuarterNum(System.DateTime.Now)).ToString() + "季度生产计划"; System.Diagnostics.Debug.WriteLine(plname); System.Diagnostics.Debug.WriteLine(p.quarterPlan.id); string sqllog = "select id from ht_svr_user where loginname = '" + p.quarterPlan.createId + "'"; string cid = opt.CreateDataSetOra(sqllog).Tables[0].Rows[0][0].ToString(); string[] value = { p.quarterPlan.pzCode, plname, "2", p.quarterPlan.issuedStatus, p.quarterPlan.planYear, Convert.ToInt32(GetQuarterNum(System.DateTime.Now)).ToString(), "0", p.quarterPlan.remark, cid }; // string[] value2 = { p.id }; opt.MergeInto(seg, value, 2, "HT_PROD_SEASON_PLAN"); foreach (tAmQuarterPlanDetail pd in p.subList) { System.Diagnostics.Debug.WriteLine(pd.prodCode); System.Diagnostics.Debug.WriteLine(System.DateTime.Now.Year.ToString()); System.Diagnostics.Debug.WriteLine(GetQuarterNum(System.DateTime.Now)); string sql = "select prod_code from ht_pub_prod_design where xy_prod_code = " + pd.prodCode; DataSet ds = opt.CreateDataSetOra(sql); if (ds == null || ds.Tables[0].Rows.Count == 0) { continue; } string xy_prod_code = ds.Tables[0].Rows[0][0].ToString(); if (xy_prod_code.Substring(0, 3) != "703") { continue; } // string[] value2 = { p.quarterPlan.id, pd.prodCode, pd.planOutput1.ToString(), pd.planOutput2.ToString(), pd.planOutput3.ToString(), pd.totalOutput.ToString(), pd.isDel }; string[] value2 = { p.quarterPlan.pzCode, xy_prod_code, pd.planOutput1.ToString(), pd.planOutput2.ToString(), pd.planOutput3.ToString(), pd.totalOutput.ToString(), pd.isDel }; opt.MergeInto(seg2, value2, 2, "HT_PROD_SEASON_PLAN_DETAIL"); } // opt.getMergeStr(seg2, value2, 1, "HT_PROD_MONTH_PLAN_DETAIL"); // dt.Rows.Add(paras); } bindGrid1(); ScriptManager.RegisterStartupScript(UpdatePanel1, this.Page.GetType(), "", "alert('同步完成');", true); }
//同步季度生产计划 protected void btnSync_Click(Object sender, EventArgs e) { MSYS.Web.PlanService.WsPlanForGSInterfaceService service = new MSYS.Web.PlanService.WsPlanForGSInterfaceService(); MSYS.DAL.DbOperator opt = new MSYS.DAL.DbOperator(); string[] seg1 = new string[] { "ID", "PLAN_NAME", "FLOW_STATUS", "ISSUED_STATUS", "CREATE_ID", "CREATE_TIME", "MODIFY_ID", "MODIFYER", "MODIFY_TIME", "DEPT_ID", "PLAN_YEAR", "QUARTER", "UNIT", "REMARK", "IS_DEL", "TOTAL_OUTPUT", "PZ_CODE", "ADJUST_STATUS" }; string[] seg2 = new string[] { "ID", "QUARTER_PLAN_ID", "PROD_CODE", "PLAN_OUTPUT_1", "PLAN_OUT_PUT_2", "PLAN_OUTPUT_3", "TOTAL_OUTPUT", "IS_DEL", "OUTPUT_1_ADJUST", "OUTPUT_2_ADJUST", "OUTPUT_3_ADJUST", "IS_VALID" }; string table1 = " HT_PROD_SEASON_PLAN"; string table2 = "HT_PROD_SEASON_PLAN_DETAIL"; quarterPlanVO[] qp = service.getQuarterPlanList(txtYear.Text, listSeason.SelectedValue.ToString()); foreach (quarterPlanVO q in qp) { string[] data = new string[] { q.quarterPlan.id, q.quarterPlan.planName, q.quarterPlan.flowStatus, q.quarterPlan.issuedStatus, q.quarterPlan.createId, q.quarterPlan.createTime.ToString(), null, null, null, q.quarterPlan.deptId, q.quarterPlan.planYear, q.quarterPlan.quarter, q.quarterPlan.unitId }; string result = opt.InsertData(seg1, data, table1); foreach (tAmQuarterPlanDetail ap in q.subList) { string[] data_detail = new string[] { ap.id.ToString(), ap.quarterPlanId, ap.prodCode, ap.planOutput1.ToString(), ap.planOutput2.ToString(), ap.planOutput3.ToString(), ap.totalOutput.ToString(), ap.isDel, ap.output1Adjust, ap.output2Adjust, ap.output3Adjust, "true" }; } } }
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"); }