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