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