protected void Page_Load(object sender, EventArgs e) { if (IsPostBack) { month = HttpUtil.GetReqStrValue("month"); werk = HttpUtil.GetReqStrValue("werk"); SAPCHARTPARAM param = new SAPCHARTPARAM(); param.I_WERKS = werk; param.I_GJAHR = month.Substring(0, 4); param.I_MONAT = month.Substring(5, 2); monthStr = param.I_MONAT; days = DateTime.DaysInMonth(Convert.ToInt32(param.I_GJAHR), Convert.ToInt32(param.I_MONAT)); //库存金额情况变动表 //ZTTPP_STOCK_MONEY val1 = new ZTTPP_STOCK_MONEY(); //val1.ZDATE = ""; //val1.ZKCJE = ""; //val1.ZKW = ""; //val1List = RFCUtil.GetTable<ZTTPP_STOCK_MONEY>(param, "ZP_REPL_STOCK_MONEY_OUT", "IT_STOCK_MONEY", val1); // AttributeItem[] item1List = val1.af_GetAvailableAttributeItem(); for (int i = 1; i <= days; i++) { labels += "\"" + param.I_MONAT + "/" + (i < 10 ? "0" + i : "" + i) + "\","; } labels = labels.Substring(0, labels.Length - 1); IRfcTable IrfTable = RFCUtil.GetTable(param, "ZP_REPL_STOCK_MONEY_OUT", "IT_STOCK_MONEY"); for (int i = 0; i < IrfTable.Count; i++) { IrfTable.CurrentIndex = i; string zdate = IrfTable.GetString("ZDATE"); string zkw = IrfTable.GetString("ZKW"); string zkcje = IrfTable.GetString("ZKCJE"); stockMap.Add("" + zdate + zkw, zkcje); //zkwMap.Add(zkw, zkw); if (!zkwMap.ContainsKey(zkw)) { zkwMap.Add(zkw, zkw); } } foreach (var zkw in zkwMap) { lineNames.Add(zkw.Key); string data = ""; for (int i = 1; i <= days; i++) { data += stockMap.ContainsKey(month + "-" + (i < 10 ? "0" + i : "" + i) + zkw.Key) ? stockMap[month + "-" + (i < 10 ? "0" + i : "" + i) + zkw.Key] + "," : "0" + ","; } datas.Add(data); } //itemLists.Add(item1List); } else { } }
protected void Page_Load(object sender, EventArgs e) { if (IsPostBack) { tabnames.Add("销售创建、计划、完成订单汇总"); tabnames.Add("销售创建、计划、完成订单金额汇总"); month = HttpUtil.GetReqStrValue("month"); werk = HttpUtil.GetReqStrValue("werk"); vkorg = HttpUtil.GetReqStrValue("vkorg"); SAPCHARTPARAM param = new SAPCHARTPARAM(); param.I_WERKS = werk; param.I_GJAHR = month.Substring(0, 4); param.I_MONAT = month.Substring(5, 2); param.I_VKORG = vkorg; //销售创建、计划、完成订单汇总 ZTTPP_SALES_SUM val1 = new ZTTPP_SALES_SUM(); val1.ZDATE = ""; val1.ZJHXS = ""; val1.ZSJJH = ""; val1.ZXSDD = ""; // val1List = RFCUtil.GetTable<ZTTPP_SALES_SUM>(param, "ZP_REPL_STOCK_MONEY_OUT", "IT_STOCK_MONEY", val1); AttributeItem[] item1List = val1.af_GetAvailableAttributeItem(); //销售创建、计划、完成订单金额汇总 ZTTPP_SALES_SUM_MN val2 = new ZTTPP_SALES_SUM_MN(); val2.ZDATE = ""; val2.ZJHJE = ""; val2.ZSJJE = ""; val2.ZXSJE = ""; //val2List = RFCUtil.GetTable<ZTTPP_SALES_SUM_MN>(param, "ZP_REPL_STOCK_MONEY_OUT", "IT_STOCK_MONEY", val2); AttributeItem[] item2List = val2.af_GetAvailableAttributeItem(); List <ITableImplement> vals = new List <ITableImplement>(); vals.Add(val1); vals.Add(val2); Dictionary <string, List <ITableImplement> > map = RFCUtil.GetTable2(param, "ZP_REPL_SALES_ORDER_OUT", new string[] { "IT_SALES_SUM", "IT_SALES_SUM_MN" }, vals); valLists.Add(map["IT_SALES_SUM"]); valLists.Add(map["IT_SALES_SUM_MN"]); itemLists.Add(item1List); itemLists.Add(item2List); } else { } }
protected void Page_Load(object sender, EventArgs e) { if (IsPostBack) { tabnames.Add("销售创建、计划、完成订单汇总"); tabnames.Add("销售创建、计划、完成订单金额汇总"); month = HttpUtil.GetReqStrValue("month"); werk = HttpUtil.GetReqStrValue("werk"); vkorg = HttpUtil.GetReqStrValue("vkorg"); SAPCHARTPARAM param = new SAPCHARTPARAM(); param.I_WERKS = werk; param.I_GJAHR = month.Substring(0, 4); param.I_MONAT = month.Substring(5, 2); param.I_VKORG = vkorg; //销售创建、计划、完成订单汇总 ZTTPP_SALES_SUM val1 = new ZTTPP_SALES_SUM(); val1.ZDATE = ""; val1.ZJHXS = ""; val1.ZSJJH = ""; val1.ZXSDD = ""; // val1List = RFCUtil.GetTable<ZTTPP_SALES_SUM>(param, "ZP_REPL_STOCK_MONEY_OUT", "IT_STOCK_MONEY", val1); AttributeItem[] item1List = val1.af_GetAvailableAttributeItem(); //销售创建、计划、完成订单金额汇总 ZTTPP_SALES_SUM_MN val2 = new ZTTPP_SALES_SUM_MN(); val2.ZDATE = ""; val2.ZJHJE = ""; val2.ZSJJE = ""; val2.ZXSJE = ""; //val2List = RFCUtil.GetTable<ZTTPP_SALES_SUM_MN>(param, "ZP_REPL_STOCK_MONEY_OUT", "IT_STOCK_MONEY", val2); AttributeItem[] item2List = val2.af_GetAvailableAttributeItem(); List<ITableImplement> vals = new List<ITableImplement>(); vals.Add(val1); vals.Add(val2); Dictionary<string, List<ITableImplement>> map = RFCUtil.GetTable2(param, "ZP_REPL_SALES_ORDER_OUT", new string[] { "IT_SALES_SUM", "IT_SALES_SUM_MN" }, vals); valLists.Add(map["IT_SALES_SUM"]); valLists.Add(map["IT_SALES_SUM_MN"]); itemLists.Add(item1List); itemLists.Add(item2List); } else { } }
protected void Page_Load(object sender, EventArgs e) { if (IsPostBack) { month = HttpUtil.GetReqStrValue("month"); werk = HttpUtil.GetReqStrValue("werk"); SAPCHARTPARAM param = new SAPCHARTPARAM(); param.I_WERKS = werk; param.I_GJAHR = month.Substring(0, 4); param.I_MONAT = month.Substring(5, 2); monthStr = param.I_MONAT; days = DateTime.DaysInMonth(Convert.ToInt32(param.I_GJAHR), Convert.ToInt32(param.I_MONAT)); //库存金额情况变动表 //ZTTPP_STOCK_MONEY val1 = new ZTTPP_STOCK_MONEY(); //val1.ZDATE = ""; //val1.ZKCJE = ""; //val1.ZKW = ""; //val1List = RFCUtil.GetTable<ZTTPP_STOCK_MONEY>(param, "ZP_REPL_STOCK_MONEY_OUT", "IT_STOCK_MONEY", val1); // AttributeItem[] item1List = val1.af_GetAvailableAttributeItem(); IRfcTable IrfTable = RFCUtil.GetTable(param, "ZP_REPL_STOCK_MONEY_OUT", "IT_STOCK_MONEY"); for (int i = 0; i < IrfTable.Count; i++) { IrfTable.CurrentIndex = i; string zdate = IrfTable.GetString("ZDATE"); string zkw = IrfTable.GetString("ZKW"); string zkcje = IrfTable.GetString("ZKCJE"); stockMap.Add("" + zdate + zkw, zkcje); //zkwMap.Add(zkw, zkw); if (!zkwMap.ContainsKey(zkw)) { zkwMap.Add(zkw, zkw); } } //itemLists.Add(item1List); } else { } }
protected void Page_Load(object sender, EventArgs e) { if (IsPostBack) { month = HttpUtil.GetReqStrValue("month"); werk = HttpUtil.GetReqStrValue("werk"); SAPCHARTPARAM param = new SAPCHARTPARAM(); param.I_WERKS = werk; param.I_GJAHR = month.Substring(0, 4); param.I_MONAT = month.Substring(5, 2); monthStr = param.I_MONAT; days=DateTime.DaysInMonth(Convert.ToInt32(param.I_GJAHR), Convert.ToInt32(param.I_MONAT)); //库存金额情况变动表 //ZTTPP_STOCK_MONEY val1 = new ZTTPP_STOCK_MONEY(); //val1.ZDATE = ""; //val1.ZKCJE = ""; //val1.ZKW = ""; //val1List = RFCUtil.GetTable<ZTTPP_STOCK_MONEY>(param, "ZP_REPL_STOCK_MONEY_OUT", "IT_STOCK_MONEY", val1); // AttributeItem[] item1List = val1.af_GetAvailableAttributeItem(); IRfcTable IrfTable = RFCUtil.GetTable(param, "ZP_REPL_STOCK_MONEY_OUT", "IT_STOCK_MONEY"); for (int i = 0; i < IrfTable.Count; i++) { IrfTable.CurrentIndex = i; string zdate=IrfTable.GetString("ZDATE"); string zkw = IrfTable.GetString("ZKW"); string zkcje = IrfTable.GetString("ZKCJE"); stockMap.Add("" + zdate + zkw, zkcje); //zkwMap.Add(zkw, zkw); if (!zkwMap.ContainsKey(zkw)) { zkwMap.Add(zkw, zkw); } } //itemLists.Add(item1List); } else { } }
protected void Page_Load(object sender, EventArgs e) { if (IsPostBack) { tabnames.Add("采购创建、入库、冲销订单汇总"); tabnames.Add("采购创建、入库、冲销订单金额汇总"); tabnames.Add("未按期完成入库采购订单"); tabnames.Add("未按期完成入库采购订单-创建者"); month = HttpUtil.GetReqStrValue("month"); werk = HttpUtil.GetReqStrValue("werk"); SAPCHARTPARAM param = new SAPCHARTPARAM(); param.I_WERKS = werk; param.I_GJAHR = month.Substring(0, 4); param.I_MONAT = month.Substring(5, 2); days = DateTime.DaysInMonth(Convert.ToInt32(param.I_GJAHR), Convert.ToInt32(param.I_MONAT)); monthStr = param.I_MONAT; for (int i = 1; i <= days; i++) { labels += "\"" + param.I_MONAT + "/" + (i < 10 ? "0" + i : "" + i) + "\","; } labels = labels.Substring(0, labels.Length - 1); //采购创建、入库、冲销订单汇总 ZTTPP_POMOVE_SUM val1 = new ZTTPP_POMOVE_SUM(); val1.ZDATE = ""; val1.Z101DD = ""; val1.Z102DD = ""; val1.Z103DD = ""; val1.Z104DD = ""; val1.Z105DD = ""; val1.Z106DD = ""; val1.ZCJDD = ""; //val1List = RFCUtil.GetTable<ZTTPP_POMOVE_SUM>(param, "ZP_REPL_PURCHASE_ORDER_OUT", "IT_POMOVE_SUM", val1); AttributeItem[] item1List = val1.af_GetAvailableAttributeItem(); List<string> val1Names = new List<string>(); val1Names.Add(ZTTPP_POMOVE_SUM.Attribute.Z101DD.ZhName); val1Names.Add(ZTTPP_POMOVE_SUM.Attribute.Z102DD.ZhName); val1Names.Add(ZTTPP_POMOVE_SUM.Attribute.Z103DD.ZhName); val1Names.Add(ZTTPP_POMOVE_SUM.Attribute.Z104DD.ZhName); val1Names.Add(ZTTPP_POMOVE_SUM.Attribute.Z105DD.ZhName); val1Names.Add(ZTTPP_POMOVE_SUM.Attribute.Z106DD.ZhName); val1Names.Add(ZTTPP_POMOVE_SUM.Attribute.ZCJDD.ZhName); lineNames.Add(val1Names); //采购创建、入库、冲销订单金额汇总 ZTTPP_POMOVE_SUM_MN val2 = new ZTTPP_POMOVE_SUM_MN(); val2.ZDATE = ""; val2.Z101JE = ""; val2.Z102JE = ""; val2.Z103JE = ""; val2.Z104JE = ""; val2.Z105JE = ""; val2.Z106JE = ""; val2.ZCJJE = ""; // val2List = RFCUtil.GetTable<ZTTPP_POMOVE_SUM_MN>(param, "ZP_REPL_PURCHASE_ORDER_OUT", "IT_POMOVE_SUM_MN", val2); AttributeItem[] item2List = val2.af_GetAvailableAttributeItem(); List<string> val2Names = new List<string>(); val2Names.Add(ZTTPP_POMOVE_SUM_MN.Attribute.Z101JE.ZhName); val2Names.Add(ZTTPP_POMOVE_SUM_MN.Attribute.Z102JE.ZhName); val2Names.Add(ZTTPP_POMOVE_SUM_MN.Attribute.Z103JE.ZhName); val2Names.Add(ZTTPP_POMOVE_SUM_MN.Attribute.Z104JE.ZhName); val2Names.Add(ZTTPP_POMOVE_SUM_MN.Attribute.Z105JE.ZhName); val2Names.Add(ZTTPP_POMOVE_SUM_MN.Attribute.Z106JE.ZhName); val2Names.Add(ZTTPP_POMOVE_SUM_MN.Attribute.ZCJJE.ZhName); lineNames.Add(val2Names); //未按期完成入库采购订单 ZTTPP_POMOVE_LAG val3 = new ZTTPP_POMOVE_LAG(); val3.ZDATE = ""; val3.ZSCDD = ""; // val3List = RFCUtil.GetTable<ZTTPP_POMOVE_LAG>(param, "ZTTPP_POMOVE_LAG", "IT_POMOVE_LAG", val3); AttributeItem[] item3List = val3.af_GetAvailableAttributeItem(); List<string> val3Names = new List<string>(); val3Names.Add(ZTTPP_POMOVE_LAG.Attribute.ZSCDD.ZhName); lineNames.Add(val3Names); //未按期完成入库采购订单-创建者 ZTTPP_POMOVE_LAGER val4 = new ZTTPP_POMOVE_LAGER(); val4.ZDATE = ""; val4.ZDDRY = ""; val4.ZSCDD = ""; // val4List = RFCUtil.GetTable<ZTTPP_POMOVE_LAGER>(param, "ZTTPP_POMOVE_LAGER", "IT_POMOVE_LAGER", val4); AttributeItem[] item4List = val4.af_GetAvailableAttributeItem(); List<ITableImplement> vals = new List<ITableImplement>(); vals.Add(val1); vals.Add(val2); vals.Add(val3); vals.Add(val4); Dictionary<string, List<ITableImplement>> map = RFCUtil.GetTable2(param, "ZP_REPL_PURCHASE_ORDER_OUT", new string[] { "IT_POMOVE_SUM", "IT_POMOVE_SUM_MN", "IT_POMOVE_LAG" }, vals); valLists.Add(map["IT_POMOVE_SUM"]); valLists.Add(map["IT_POMOVE_SUM_MN"]); valLists.Add(map["IT_POMOVE_LAG"]); //valLists.Add(map["IT_POMOVE_LAGER"]); itemLists.Add(item1List); itemLists.Add(item2List); itemLists.Add(item3List); itemLists.Add(item4List); foreach (List<ITableImplement> valList in valLists) { List<string> datas = new List<string>(); foreach (AttributeItem item in itemLists[valLists.IndexOf(valList)]) { if (item.FieldName.Equals("ZDATE")) { continue; } string data = ""; foreach (ITableImplement val in valList) { try { data += "" + Convert.ToInt32(val[item]) + ","; } catch (Exception ee) { //Response.Write(val[item]); data += "" + val[item] + ","; } } data = data.Substring(0, data.Length - 1); datas.Add(data); } dataLists.Add(datas); } List<string> val4Names = new List<string>(); lineNames.Add(val4Names); IRfcTable IrfTable = RFCUtil.GetTable(param, "ZP_REPL_PURCHASE_ORDER_OUT", "IT_POMOVE_LAGER"); for (int i = 0; i < IrfTable.Count; i++) { IrfTable.CurrentIndex = i; string zdate = IrfTable.GetString("ZDATE"); string zscdd = IrfTable.GetString("ZSCDD"); string zddry = IrfTable.GetString("ZDDRY"); purchaseMap.Add("" + zdate + zddry, Convert.ToInt32(zscdd)+""); //zkwMap.Add(zkw, zkw); if (!zddryMap.ContainsKey(zddry)) { zddryMap.Add(zddry, zddry); } } foreach (var zddry in zddryMap) { val4Names.Add(zddry.Key); string data = ""; for (int i = 1; i <= days; i++) { data += purchaseMap.ContainsKey(month + "-" + (i < 10 ? "0" + i : "" + i) + zddry.Key) ? purchaseMap[month + "-" + (i < 10 ? "0" + i : "" + i) + zddry.Key] + "," : "0" + ","; } datas2.Add(data); } } else { } }
protected void Page_Load(object sender, EventArgs e) { if (IsPostBack) { tabnames.Add("生产总工单、成品的计划排产及实际完成订单汇总"); tabnames.Add("生产总工单、半成品、重工工单的排产及实际完成订单汇总"); tabnames.Add("生产总工单、成品的计划排产及实际完成订单数量汇总"); tabnames.Add("生产总工单、生产总工单、成品的计划排产及实际完成订单数量汇总"); tabnames.Add("常规产品计划与实际排产订单数量汇总"); tabnames.Add("未按期完成入库生产订单汇总"); month = HttpUtil.GetReqStrValue("month"); werk = HttpUtil.GetReqStrValue("werk"); SAPCHARTPARAM param = new SAPCHARTPARAM(); param.I_WERKS = werk; param.I_GJAHR = month.Substring(0, 4); param.I_MONAT = month.Substring(5, 2); int days = DateTime.DaysInMonth(Convert.ToInt32(param.I_GJAHR), Convert.ToInt32(param.I_MONAT)); for (int i = 1; i <= days; i++) { labels += "\"" + param.I_MONAT + "/" + (i < 10 ? "0" + i : "" + i) + "\","; } labels = labels.Substring(0, labels.Length - 1); //生产总工单、成品汇总 ZTTPP_FP_SUM val1 = new ZTTPP_FP_SUM(); val1.ZDATE = ""; val1.ZFSSUM = ""; val1.ZFSUM = ""; val1.ZSFSUM = ""; val1.ZSSUM = ""; // val1List = RFCUtil.GetTable<ZTTPP_FP_SUM>(param, "ZP_REPL_WQ_ORDER_OUT", "IT_ORDER_RET", val1); AttributeItem[] item1List = val1.af_GetAvailableAttributeItem(); List <string> val1Names = new List <string>(); val1Names.Add(ZTTPP_FP_SUM.Attribute.ZFSSUM.ZhName); val1Names.Add(ZTTPP_FP_SUM.Attribute.ZFSUM.ZhName); val1Names.Add(ZTTPP_FP_SUM.Attribute.ZSFSUM.ZhName); val1Names.Add(ZTTPP_FP_SUM.Attribute.ZSSUM.ZhName); lineNames.Add(val1Names); //生产总工单、半成品、重工工单的排产及实际完成订单汇总 ZTTPP_SM_SUM val2 = new ZTTPP_SM_SUM(); val2.ZDATE = ""; val2.ZFRSUM = ""; val2.ZFSMSUM = ""; val2.ZFSUM = ""; val2.ZSRSUM = ""; val2.ZSSMSUM = ""; val2.ZSSUM = ""; // val2List = RFCUtil.GetTable<ZTTPP_SM_SUM>(param, "ZP_REPL_WQ_ORDER_OUT", "IT_ORDER_SM", val2); AttributeItem[] item2List = val2.af_GetAvailableAttributeItem(); List <string> val2Names = new List <string>(); val2Names.Add(ZTTPP_SM_SUM.Attribute.ZFRSUM.ZhName); val2Names.Add(ZTTPP_SM_SUM.Attribute.ZFSMSUM.ZhName); val2Names.Add(ZTTPP_SM_SUM.Attribute.ZFSUM.ZhName); val2Names.Add(ZTTPP_SM_SUM.Attribute.ZSRSUM.ZhName); val2Names.Add(ZTTPP_SM_SUM.Attribute.ZSSMSUM.ZhName); val2Names.Add(ZTTPP_SM_SUM.Attribute.ZSSUM.ZhName); lineNames.Add(val2Names); //生产总工单、成品的计划排产及实际完成订单数量汇总 ZTTPP_FP_SUM_NUM val3 = new ZTTPP_FP_SUM_NUM(); val3.ZDATE = ""; val3.ZDDSL = ""; val3.ZKSCPSL = ""; val3.ZSJCPSL = ""; val3.ZSJSL = ""; // val3List = RFCUtil.GetTable<ZTTPP_FP_SUM_NUM>(param, "ZP_REPL_WQ_ORDER_OUT", "IT_ORDER_RET_NUM", val3); AttributeItem[] item3List = val3.af_GetAvailableAttributeItem(); List <string> val3Names = new List <string>(); val3Names.Add(ZTTPP_FP_SUM_NUM.Attribute.ZDDSL.ZhName); val3Names.Add(ZTTPP_FP_SUM_NUM.Attribute.ZKSCPSL.ZhName); val3Names.Add(ZTTPP_FP_SUM_NUM.Attribute.ZSJCPSL.ZhName); val3Names.Add(ZTTPP_FP_SUM_NUM.Attribute.ZSJSL.ZhName); lineNames.Add(val3Names); //生产总工单、半成品、重工工单的排产及实际完成订单数量汇总 ZTTPP_SM_SUM_NUM val4 = new ZTTPP_SM_SUM_NUM(); val4.ZDATE = ""; val4.ZKSBCPSL = ""; val4.ZKSCGSL = ""; val4.ZKSSL = ""; val4.ZSJBCPSL = ""; val4.ZSJCGSL = ""; val4.ZSJSL = ""; // val4List = RFCUtil.GetTable<ZTTPP_SM_SUM_NUM>(param, "ZP_REPL_WQ_ORDER_OUT", "IT_ORDER_SM_NUM", val4); AttributeItem[] item4List = val4.af_GetAvailableAttributeItem(); List <string> val4Names = new List <string>(); val4Names.Add(ZTTPP_SM_SUM_NUM.Attribute.ZKSBCPSL.ZhName); val4Names.Add(ZTTPP_SM_SUM_NUM.Attribute.ZKSCGSL.ZhName); val4Names.Add(ZTTPP_SM_SUM_NUM.Attribute.ZKSSL.ZhName); val4Names.Add(ZTTPP_SM_SUM_NUM.Attribute.ZSJBCPSL.ZhName); val4Names.Add(ZTTPP_SM_SUM_NUM.Attribute.ZSJCGSL.ZhName); val4Names.Add(ZTTPP_SM_SUM_NUM.Attribute.ZSJSL.ZhName); lineNames.Add(val4Names); //常规产品计划与实际排产订单数量汇总 ZTTPP_RULE_SUM val5 = new ZTTPP_RULE_SUM(); val5.ZDATE = ""; val5.ZCGSJSL = ""; val5.ZCGSL = ""; // val5List = RFCUtil.GetTable<ZTTPP_RULE_SUM>(param, "ZP_REPL_WQ_ORDER_OUT", "IT_ORDER_RULE", val5); AttributeItem[] item5List = val5.af_GetAvailableAttributeItem(); List <string> val5Names = new List <string>(); val5Names.Add(ZTTPP_RULE_SUM.Attribute.ZCGSJSL.ZhName); val5Names.Add(ZTTPP_RULE_SUM.Attribute.ZCGSL.ZhName); lineNames.Add(val5Names); //未按期完成入库生产订单汇总 ZTTPP_UNDONE_SUM val6 = new ZTTPP_UNDONE_SUM(); val6.ZDATE = ""; val6.ZWWCGS = ""; // val6List = RFCUtil.GetTable<ZTTPP_UNDONE_SUM>(param, "ZP_REPL_WQ_ORDER_OUT", "IT_ORDER_UNDONE", val6); AttributeItem[] item6List = val6.af_GetAvailableAttributeItem(); List <string> val6Names = new List <string>(); val6Names.Add(ZTTPP_UNDONE_SUM.Attribute.ZWWCGS.ZhName); lineNames.Add(val6Names); List <ITableImplement> vals = new List <ITableImplement>(); vals.Add(val1); vals.Add(val2); vals.Add(val3); vals.Add(val4); vals.Add(val5); vals.Add(val6); Dictionary <string, List <ITableImplement> > map = RFCUtil.GetTable2(param, "ZP_REPL_WQ_ORDER_OUT", new string[] { "IT_ORDER_RET", "IT_ORDER_SM", "IT_ORDER_RET_NUM", "IT_ORDER_SM_NUM", "IT_ORDER_RULE", "IT_ORDER_UNDONE" }, vals); valLists.Add(map["IT_ORDER_RET"]); valLists.Add(map["IT_ORDER_SM"]); valLists.Add(map["IT_ORDER_RET_NUM"]); valLists.Add(map["IT_ORDER_SM_NUM"]); valLists.Add(map["IT_ORDER_RULE"]); valLists.Add(map["IT_ORDER_UNDONE"]); itemLists.Add(item1List); itemLists.Add(item2List); itemLists.Add(item3List); itemLists.Add(item4List); itemLists.Add(item5List); itemLists.Add(item6List); //foreach(AttributeItem item1 in item1List){ // if (item1.FieldName.Equals("ZDATE")) { continue; } // string data = ""; // foreach(ITableImplement val1 in val1List){ // } //} foreach (List <ITableImplement> valList in valLists) { List <string> datas = new List <string>(); foreach (AttributeItem item in itemLists[valLists.IndexOf(valList)]) { if (item.FieldName.Equals("ZDATE")) { continue; } string data = ""; foreach (ITableImplement val in valList) { try { data += "" + Convert.ToInt32(val[item]) + ","; } catch (Exception ee) { //Response.Write(val[item]); data += "" + val[item] + ","; } } data = data.Substring(0, data.Length - 1); datas.Add(data); } dataLists.Add(datas); } } else { } }
protected void Page_Load(object sender, EventArgs e) { if (IsPostBack) { tabnames.Add("销售创建、计划、完成订单汇总"); tabnames.Add("销售创建、计划、完成订单金额汇总"); month = HttpUtil.GetReqStrValue("month"); werk = HttpUtil.GetReqStrValue("werk"); vkorg = HttpUtil.GetReqStrValue("vkorg"); SAPCHARTPARAM param = new SAPCHARTPARAM(); param.I_WERKS = werk; param.I_GJAHR = month.Substring(0, 4); param.I_MONAT = month.Substring(5, 2); param.I_VKORG = vkorg; int days = DateTime.DaysInMonth(Convert.ToInt32(param.I_GJAHR), Convert.ToInt32(param.I_MONAT)); for (int i = 1; i <= days; i++) { labels += "\"" + param.I_MONAT + "/" + (i < 10 ? "0" + i : "" + i) + "\","; } labels = labels.Substring(0, labels.Length - 1); //销售创建、计划、完成订单汇总 ZTTPP_SALES_SUM val1 = new ZTTPP_SALES_SUM(); val1.ZDATE = ""; val1.ZJHXS = ""; val1.ZSJJH = ""; val1.ZXSDD = ""; // val1List = RFCUtil.GetTable<ZTTPP_SALES_SUM>(param, "ZP_REPL_STOCK_MONEY_OUT", "IT_STOCK_MONEY", val1); AttributeItem[] item1List = val1.af_GetAvailableAttributeItem(); List<string> val1Names = new List<string>(); val1Names.Add(ZTTPP_SALES_SUM.Attribute.ZJHXS.ZhName); val1Names.Add(ZTTPP_SALES_SUM.Attribute.ZSJJH.ZhName); val1Names.Add(ZTTPP_SALES_SUM.Attribute.ZXSDD.ZhName); lineNames.Add(val1Names); //销售创建、计划、完成订单金额汇总 ZTTPP_SALES_SUM_MN val2 = new ZTTPP_SALES_SUM_MN(); val2.ZDATE = ""; val2.ZJHJE = ""; val2.ZSJJE = ""; val2.ZXSJE = ""; //val2List = RFCUtil.GetTable<ZTTPP_SALES_SUM_MN>(param, "ZP_REPL_STOCK_MONEY_OUT", "IT_STOCK_MONEY", val2); AttributeItem[] item2List = val2.af_GetAvailableAttributeItem(); List<string> val2Names = new List<string>(); val2Names.Add(ZTTPP_SALES_SUM_MN.Attribute.ZJHJE.ZhName); val2Names.Add(ZTTPP_SALES_SUM_MN.Attribute.ZSJJE.ZhName); val2Names.Add(ZTTPP_SALES_SUM_MN.Attribute.ZXSJE.ZhName); lineNames.Add(val2Names); List<ITableImplement> vals = new List<ITableImplement>(); vals.Add(val1); vals.Add(val2); Dictionary<string, List<ITableImplement>> map = RFCUtil.GetTable2(param, "ZP_REPL_SALES_ORDER_OUT", new string[] { "IT_SALES_SUM", "IT_SALES_SUM_MN" }, vals); valLists.Add(map["IT_SALES_SUM"]); valLists.Add(map["IT_SALES_SUM_MN"]); itemLists.Add(item1List); itemLists.Add(item2List); foreach (List<ITableImplement> valList in valLists) { List<string> datas = new List<string>(); foreach (AttributeItem item in itemLists[valLists.IndexOf(valList)]) { if (item.FieldName.Equals("ZDATE")) { continue; } string data = ""; foreach (ITableImplement val in valList) { try { data += "" + Convert.ToInt32(val[item]) + ","; } catch (Exception ee) { //Response.Write(val[item]); data += "" + val[item] + ","; } } data = data.Substring(0, data.Length - 1); datas.Add(data); } dataLists.Add(datas); } } else { } }
protected void Page_Load(object sender, EventArgs e) { if (IsPostBack) { tabnames.Add("生产总工单、成品的计划排产及实际完成订单汇总"); tabnames.Add("生产总工单、半成品、重工工单的排产及实际完成订单汇总"); tabnames.Add("生产总工单、成品的计划排产及实际完成订单数量汇总"); tabnames.Add("生产总工单、半成品、重工工单的排产及实际完成订单数量汇总"); tabnames.Add("常规产品计划与实际排产订单数量汇总"); tabnames.Add("未按期完成入库生产订单汇总"); panelnames.Add("生产总工单、成品的计划排产及实际完成订单汇总"); panelnames.Add("生产总工单、半成品、重工工单的排产及实际完成订单汇总"); panelnames.Add("生产总工单、成品的计划排产及实际完成订单数量汇总"); panelnames.Add("生产总工单、半成品、重工工单的排产及实际完成订单数量汇总"); panelnames.Add("常规产品计划与实际排产订单数量汇总"); panelnames.Add("未按期完成入库生产订单汇总"); month = HttpUtil.GetReqStrValue("month"); werk = HttpUtil.GetReqStrValue("werk"); SAPCHARTPARAM param = new SAPCHARTPARAM(); param.I_WERKS = werk; param.I_GJAHR = month.Substring(0, 4); param.I_MONAT = month.Substring(5, 2); int days = DateTime.DaysInMonth(Convert.ToInt32(param.I_GJAHR), Convert.ToInt32(param.I_MONAT)); for (int i = 1; i <= days; i++) { labels += "\"" + param.I_MONAT + "/" + (i < 10 ? "0" + i : "" + i) + "\","; } labels = labels.Substring(0, labels.Length - 1); //生产总工单、成品汇总 ZTTPP_FP_SUM val1 = new ZTTPP_FP_SUM(); val1.ZDATE = ""; val1.ZFSSUM = ""; val1.ZFSUM = ""; val1.ZSFSUM = ""; val1.ZSSUM = ""; // val1List = RFCUtil.GetTable<ZTTPP_FP_SUM>(param, "ZP_REPL_WQ_ORDER_OUT", "IT_ORDER_RET", val1); AttributeItem[] item1List = val1.af_GetAvailableAttributeItem(); List<string> val1Names = new List<string>(); val1Names.Add(ZTTPP_FP_SUM.Attribute.ZSSUM.ZhName); val1Names.Add(ZTTPP_FP_SUM.Attribute.ZFSUM.ZhName); val1Names.Add(ZTTPP_FP_SUM.Attribute.ZSFSUM.ZhName); val1Names.Add(ZTTPP_FP_SUM.Attribute.ZFSSUM.ZhName); lineNames.Add(val1Names); //生产总工单、半成品、重工工单的排产及实际完成订单汇总 ZTTPP_SM_SUM val2 = new ZTTPP_SM_SUM(); val2.ZDATE = ""; val2.ZFRSUM = ""; val2.ZFSMSUM = ""; val2.ZFSUM = ""; val2.ZSRSUM = ""; val2.ZSSMSUM = ""; val2.ZSSUM = ""; // val2List = RFCUtil.GetTable<ZTTPP_SM_SUM>(param, "ZP_REPL_WQ_ORDER_OUT", "IT_ORDER_SM", val2); AttributeItem[] item2List = val2.af_GetAvailableAttributeItem(); List<string> val2Names = new List<string>(); val2Names.Add(ZTTPP_SM_SUM.Attribute.ZSSUM.ZhName); val2Names.Add(ZTTPP_SM_SUM.Attribute.ZFSUM.ZhName); val2Names.Add(ZTTPP_SM_SUM.Attribute.ZSSMSUM.ZhName); val2Names.Add(ZTTPP_SM_SUM.Attribute.ZFSMSUM.ZhName); val2Names.Add(ZTTPP_SM_SUM.Attribute.ZSRSUM.ZhName); val2Names.Add(ZTTPP_SM_SUM.Attribute.ZFRSUM.ZhName); lineNames.Add(val2Names); //生产总工单、成品的计划排产及实际完成订单数量汇总 ZTTPP_FP_SUM_NUM val3 = new ZTTPP_FP_SUM_NUM(); val3.ZDATE = ""; val3.ZDDSL = ""; val3.ZKSCPSL = ""; val3.ZSJCPSL = ""; val3.ZSJSL = ""; // val3List = RFCUtil.GetTable<ZTTPP_FP_SUM_NUM>(param, "ZP_REPL_WQ_ORDER_OUT", "IT_ORDER_RET_NUM", val3); AttributeItem[] item3List = val3.af_GetAvailableAttributeItem(); List<string> val3Names = new List<string>(); val3Names.Add(ZTTPP_FP_SUM_NUM.Attribute.ZDDSL.ZhName); val3Names.Add(ZTTPP_FP_SUM_NUM.Attribute.ZSJSL.ZhName); val3Names.Add(ZTTPP_FP_SUM_NUM.Attribute.ZKSCPSL.ZhName); val3Names.Add(ZTTPP_FP_SUM_NUM.Attribute.ZSJCPSL.ZhName); lineNames.Add(val3Names); //生产总工单、半成品、重工工单的排产及实际完成订单数量汇总 ZTTPP_SM_SUM_NUM val4 = new ZTTPP_SM_SUM_NUM(); val4.ZDATE = ""; val4.ZKSBCPSL = ""; val4.ZKSCGSL = ""; val4.ZKSSL = ""; val4.ZSJBCPSL = ""; val4.ZSJCGSL = ""; val4.ZSJSL = ""; // val4List = RFCUtil.GetTable<ZTTPP_SM_SUM_NUM>(param, "ZP_REPL_WQ_ORDER_OUT", "IT_ORDER_SM_NUM", val4); AttributeItem[] item4List = val4.af_GetAvailableAttributeItem(); List<string> val4Names = new List<string>(); val4Names.Add(ZTTPP_SM_SUM_NUM.Attribute.ZKSSL.ZhName); val4Names.Add(ZTTPP_SM_SUM_NUM.Attribute.ZSJSL.ZhName); val4Names.Add(ZTTPP_SM_SUM_NUM.Attribute.ZKSBCPSL.ZhName); val4Names.Add(ZTTPP_SM_SUM_NUM.Attribute.ZSJBCPSL.ZhName); val4Names.Add(ZTTPP_SM_SUM_NUM.Attribute.ZKSCGSL.ZhName); val4Names.Add(ZTTPP_SM_SUM_NUM.Attribute.ZSJCGSL.ZhName); lineNames.Add(val4Names); //常规产品计划与实际排产订单数量汇总 ZTTPP_RULE_SUM val5 = new ZTTPP_RULE_SUM(); val5.ZDATE = ""; val5.ZCGSJSL = ""; val5.ZCGSL = ""; // val5List = RFCUtil.GetTable<ZTTPP_RULE_SUM>(param, "ZP_REPL_WQ_ORDER_OUT", "IT_ORDER_RULE", val5); AttributeItem[] item5List = val5.af_GetAvailableAttributeItem(); List<string> val5Names = new List<string>(); val5Names.Add(ZTTPP_RULE_SUM.Attribute.ZCGSL.ZhName); val5Names.Add(ZTTPP_RULE_SUM.Attribute.ZCGSJSL.ZhName); lineNames.Add(val5Names); //未按期完成入库生产订单汇总 ZTTPP_UNDONE_SUM val6 = new ZTTPP_UNDONE_SUM(); val6.ZDATE = ""; val6.ZWWCGS = ""; // val6List = RFCUtil.GetTable<ZTTPP_UNDONE_SUM>(param, "ZP_REPL_WQ_ORDER_OUT", "IT_ORDER_UNDONE", val6); AttributeItem[] item6List = val6.af_GetAvailableAttributeItem(); List<string> val6Names = new List<string>(); val6Names.Add(ZTTPP_UNDONE_SUM.Attribute.ZWWCGS.ZhName); lineNames.Add(val6Names); List<ITableImplement> vals = new List<ITableImplement>(); vals.Add(val1); vals.Add(val2); vals.Add(val3); vals.Add(val4); vals.Add(val5); vals.Add(val6); Dictionary<string, List<ITableImplement>> map = RFCUtil.GetTable2(param, "ZP_REPL_WQ_ORDER_OUT", new string[] { "IT_ORDER_RET", "IT_ORDER_SM", "IT_ORDER_RET_NUM", "IT_ORDER_SM_NUM", "IT_ORDER_RULE", "IT_ORDER_UNDONE" }, vals); valLists.Add( map["IT_ORDER_RET"]); valLists.Add(map["IT_ORDER_SM"]); valLists.Add(map["IT_ORDER_RET_NUM"]); valLists.Add( map["IT_ORDER_SM_NUM"]); valLists.Add( map["IT_ORDER_RULE"]); valLists.Add( map["IT_ORDER_UNDONE"]); itemLists.Add(item1List); itemLists.Add(item2List); itemLists.Add(item3List); itemLists.Add(item4List); itemLists.Add(item5List); itemLists.Add(item6List); foreach (List<ITableImplement> valList in valLists) { int index = valLists.IndexOf(valList); List<string> datas = new List<string>(); maxList.Add(0); foreach (AttributeItem item in itemLists[index]) { if (item.FieldName.Equals("ZDATE")) { continue; } string data = ""; foreach (ITableImplement val in valList) { try { if (Convert.ToDecimal(val[item]) > maxList[index]) { maxList[index] = Convert.ToDecimal(val[item]); } data += "" + Convert.ToDecimal(val[item]) + ","; } catch (Exception ee) { //Response.Write(val[item]); data += "" + val[item] + ","; } } data = data.Substring(0, data.Length - 1); datas.Add(data); } dataLists.Add(datas); } foreach (decimal max in maxList) { stepList.Add(getStepWidth(max)); } } else { } }
protected void Page_Load(object sender, EventArgs e) { if (IsPostBack) { tabnames.Add("采购创建、入库、冲销订单汇总"); tabnames.Add("采购创建、入库、冲销订单金额汇总"); tabnames.Add("未按期完成入库采购订单"); tabnames.Add("未按期完成入库采购订单-创建者"); month = HttpUtil.GetReqStrValue("month"); werk = HttpUtil.GetReqStrValue("werk"); SAPCHARTPARAM param = new SAPCHARTPARAM(); param.I_WERKS = werk; param.I_GJAHR = month.Substring(0, 4); param.I_MONAT = month.Substring(5, 2); monthStr = param.I_MONAT; days = DateTime.DaysInMonth(Convert.ToInt32(param.I_GJAHR), Convert.ToInt32(param.I_MONAT)); //采购创建、入库、冲销订单汇总 ZTTPP_POMOVE_SUM val1 = new ZTTPP_POMOVE_SUM(); val1.ZDATE = ""; val1.Z101DD = ""; val1.Z102DD = ""; val1.Z103DD = ""; val1.Z104DD = ""; val1.Z105DD = ""; val1.Z106DD = ""; val1.ZCJDD = ""; //val1List = RFCUtil.GetTable<ZTTPP_POMOVE_SUM>(param, "ZP_REPL_PURCHASE_ORDER_OUT", "IT_POMOVE_SUM", val1); AttributeItem[] item1List = val1.af_GetAvailableAttributeItem(); //采购创建、入库、冲销订单金额汇总 ZTTPP_POMOVE_SUM_MN val2 = new ZTTPP_POMOVE_SUM_MN(); val2.ZDATE = ""; val2.Z101JE = ""; val2.Z102JE = ""; val2.Z103JE = ""; val2.Z104JE = ""; val2.Z105JE = ""; val2.Z106JE = ""; val2.ZCJJE = ""; // val2List = RFCUtil.GetTable<ZTTPP_POMOVE_SUM_MN>(param, "ZP_REPL_PURCHASE_ORDER_OUT", "IT_POMOVE_SUM_MN", val2); AttributeItem[] item2List = val2.af_GetAvailableAttributeItem(); //未按期完成入库采购订单 ZTTPP_POMOVE_LAG val3 = new ZTTPP_POMOVE_LAG(); val3.ZDATE = ""; val3.ZSCDD = ""; // val3List = RFCUtil.GetTable<ZTTPP_POMOVE_LAG>(param, "ZTTPP_POMOVE_LAG", "IT_POMOVE_LAG", val3); AttributeItem[] item3List = val3.af_GetAvailableAttributeItem(); //未按期完成入库采购订单-创建者 ZTTPP_POMOVE_LAGER val4 = new ZTTPP_POMOVE_LAGER(); val4.ZDATE = ""; val4.ZDDRY = ""; val4.ZSCDD = ""; // val4List = RFCUtil.GetTable<ZTTPP_POMOVE_LAGER>(param, "ZTTPP_POMOVE_LAGER", "IT_POMOVE_LAGER", val4); AttributeItem[] item4List = val4.af_GetAvailableAttributeItem(); List <ITableImplement> vals = new List <ITableImplement>(); vals.Add(val1); vals.Add(val2); vals.Add(val3); vals.Add(val4); Dictionary <string, List <ITableImplement> > map = RFCUtil.GetTable2(param, "ZP_REPL_PURCHASE_ORDER_OUT", new string[] { "IT_POMOVE_SUM", "IT_POMOVE_SUM_MN", "IT_POMOVE_LAG", "IT_POMOVE_LAGER" }, vals); valLists.Add(map["IT_POMOVE_SUM"]); valLists.Add(map["IT_POMOVE_SUM_MN"]); valLists.Add(map["IT_POMOVE_LAG"]); // valLists.Add(map["IT_POMOVE_LAGER"]); itemLists.Add(item1List); itemLists.Add(item2List); itemLists.Add(item3List); // itemLists.Add(item4List); IRfcTable IrfTable = RFCUtil.GetTable(param, "ZP_REPL_PURCHASE_ORDER_OUT", "IT_POMOVE_LAGER"); for (int i = 0; i < IrfTable.Count; i++) { IrfTable.CurrentIndex = i; string zdate = IrfTable.GetString("ZDATE"); string zscdd = IrfTable.GetString("ZSCDD"); string zddry = IrfTable.GetString("ZDDRY"); purchaseMap.Add("" + zdate + zddry, Convert.ToInt32(zscdd) + ""); //zkwMap.Add(zkw, zkw); if (!zddryMap.ContainsKey(zddry)) { zddryMap.Add(zddry, zddry); } } } else { } }
protected void Page_Load(object sender, EventArgs e) { if (IsPostBack) { tabnames.Add("生产总工单、成品的计划排产及实际完成订单汇总"); tabnames.Add("生产总工单、半成品、重工工单的排产及实际完成订单汇总"); tabnames.Add("生产总工单、成品的计划排产及实际完成订单数量汇总"); tabnames.Add("生产总工单、生产总工单、成品的计划排产及实际完成订单数量汇总"); tabnames.Add("常规产品计划与实际排产订单数量汇总"); tabnames.Add("未按期完成入库生产订单汇总"); panelnames.Add("生产总工单、成品的计划排产及实际完成订单汇总"); panelnames.Add("生产总工单、半成品、重工工单的排产及实际完成订单汇总"); panelnames.Add("生产总工单、成品的计划排产及实际完成订单数量汇总"); panelnames.Add("生产总工单、生产总工单、成品的计划排产及实际完成订单数量汇总"); panelnames.Add("常规产品计划与实际排产订单数量汇总"); panelnames.Add("未按期完成入库生产订单汇总"); month = HttpUtil.GetReqStrValue("month"); werk = HttpUtil.GetReqStrValue("werk"); SAPCHARTPARAM param = new SAPCHARTPARAM(); param.I_WERKS = werk; param.I_GJAHR = month.Substring(0, 4); param.I_MONAT = month.Substring(5, 2); //生产总工单、成品汇总 ZTTPP_FP_SUM val1 = new ZTTPP_FP_SUM(); val1.ZDATE = ""; val1.ZFSSUM = ""; val1.ZFSUM = ""; val1.ZSFSUM = ""; val1.ZSSUM = ""; // val1List = RFCUtil.GetTable<ZTTPP_FP_SUM>(param, "ZP_REPL_WQ_ORDER_OUT", "IT_ORDER_RET", val1); AttributeItem[] item1List = val1.af_GetAvailableAttributeItem(); //生产总工单、半成品、重工工单的排产及实际完成订单汇总 ZTTPP_SM_SUM val2 = new ZTTPP_SM_SUM(); val2.ZDATE = ""; val2.ZFRSUM = ""; val2.ZFSMSUM = ""; val2.ZFSUM = ""; val2.ZSRSUM = ""; val2.ZSSMSUM = ""; val2.ZSSUM = ""; // val2List = RFCUtil.GetTable<ZTTPP_SM_SUM>(param, "ZP_REPL_WQ_ORDER_OUT", "IT_ORDER_SM", val2); AttributeItem[] item2List = val2.af_GetAvailableAttributeItem(); //生产总工单、成品的计划排产及实际完成订单数量汇总 ZTTPP_FP_SUM_NUM val3 = new ZTTPP_FP_SUM_NUM(); val3.ZDATE = ""; val3.ZDDSL = ""; val3.ZKSCPSL = ""; val3.ZSJCPSL = ""; val3.ZSJSL = ""; // val3List = RFCUtil.GetTable<ZTTPP_FP_SUM_NUM>(param, "ZP_REPL_WQ_ORDER_OUT", "IT_ORDER_RET_NUM", val3); AttributeItem[] item3List = val3.af_GetAvailableAttributeItem(); //生产总工单、半成品、重工工单的排产及实际完成订单数量汇总 ZTTPP_SM_SUM_NUM val4 = new ZTTPP_SM_SUM_NUM(); val4.ZDATE = ""; val4.ZKSBCPSL = ""; val4.ZKSCGSL = ""; val4.ZKSSL = ""; val4.ZSJBCPSL = ""; val4.ZSJCGSL = ""; val4.ZSJSL = ""; // val4List = RFCUtil.GetTable<ZTTPP_SM_SUM_NUM>(param, "ZP_REPL_WQ_ORDER_OUT", "IT_ORDER_SM_NUM", val4); AttributeItem[] item4List = val4.af_GetAvailableAttributeItem(); //常规产品计划与实际排产订单数量汇总 ZTTPP_RULE_SUM val5 = new ZTTPP_RULE_SUM(); val5.ZDATE = ""; val5.ZCGSJSL = ""; val5.ZCGSL = ""; // val5List = RFCUtil.GetTable<ZTTPP_RULE_SUM>(param, "ZP_REPL_WQ_ORDER_OUT", "IT_ORDER_RULE", val5); AttributeItem[] item5List = val5.af_GetAvailableAttributeItem(); //未按期完成入库生产订单汇总 ZTTPP_UNDONE_SUM val6 = new ZTTPP_UNDONE_SUM(); val6.ZDATE = ""; val6.ZWWCGS = ""; // val6List = RFCUtil.GetTable<ZTTPP_UNDONE_SUM>(param, "ZP_REPL_WQ_ORDER_OUT", "IT_ORDER_UNDONE", val6); AttributeItem[] item6List = val6.af_GetAvailableAttributeItem(); List <ITableImplement> vals = new List <ITableImplement>(); vals.Add(val1); vals.Add(val2); vals.Add(val3); vals.Add(val4); vals.Add(val5); vals.Add(val6); Dictionary <string, List <ITableImplement> > map = RFCUtil.GetTable2(param, "ZP_REPL_WQ_ORDER_OUT", new string[] { "IT_ORDER_RET", "IT_ORDER_SM", "IT_ORDER_RET_NUM", "IT_ORDER_SM_NUM", "IT_ORDER_RULE", "IT_ORDER_UNDONE" }, vals); valLists.Add(map["IT_ORDER_RET"]); valLists.Add(map["IT_ORDER_SM"]); valLists.Add(map["IT_ORDER_RET_NUM"]); valLists.Add(map["IT_ORDER_SM_NUM"]); valLists.Add(map["IT_ORDER_RULE"]); valLists.Add(map["IT_ORDER_UNDONE"]); itemLists.Add(item1List); itemLists.Add(item2List); itemLists.Add(item3List); itemLists.Add(item4List); itemLists.Add(item5List); itemLists.Add(item6List); } else { } }
protected void Page_Load(object sender, EventArgs e) { if (IsPostBack) { tabnames.Add("销售创建、计划、完成订单汇总"); tabnames.Add("销售创建、计划、完成订单金额汇总"); month = HttpUtil.GetReqStrValue("month"); werk = HttpUtil.GetReqStrValue("werk"); vkorg = HttpUtil.GetReqStrValue("vkorg"); SAPCHARTPARAM param = new SAPCHARTPARAM(); param.I_WERKS = werk; param.I_GJAHR = month.Substring(0, 4); param.I_MONAT = month.Substring(5, 2); param.I_VKORG = vkorg; int days = DateTime.DaysInMonth(Convert.ToInt32(param.I_GJAHR), Convert.ToInt32(param.I_MONAT)); for (int i = 1; i <= days; i++) { labels += "\"" + param.I_MONAT + "/" + (i < 10 ? "0" + i : "" + i) + "\","; } labels = labels.Substring(0, labels.Length - 1); //销售创建、计划、完成订单汇总 ZTTPP_SALES_SUM val1 = new ZTTPP_SALES_SUM(); val1.ZDATE = ""; val1.ZJHXS = ""; val1.ZSJJH = ""; val1.ZXSDD = ""; // val1List = RFCUtil.GetTable<ZTTPP_SALES_SUM>(param, "ZP_REPL_STOCK_MONEY_OUT", "IT_STOCK_MONEY", val1); AttributeItem[] item1List = val1.af_GetAvailableAttributeItem(); List <string> val1Names = new List <string>(); val1Names.Add(ZTTPP_SALES_SUM.Attribute.ZJHXS.ZhName); val1Names.Add(ZTTPP_SALES_SUM.Attribute.ZSJJH.ZhName); val1Names.Add(ZTTPP_SALES_SUM.Attribute.ZXSDD.ZhName); lineNames.Add(val1Names); //销售创建、计划、完成订单金额汇总 ZTTPP_SALES_SUM_MN val2 = new ZTTPP_SALES_SUM_MN(); val2.ZDATE = ""; val2.ZJHJE = ""; val2.ZSJJE = ""; val2.ZXSJE = ""; //val2List = RFCUtil.GetTable<ZTTPP_SALES_SUM_MN>(param, "ZP_REPL_STOCK_MONEY_OUT", "IT_STOCK_MONEY", val2); AttributeItem[] item2List = val2.af_GetAvailableAttributeItem(); List <string> val2Names = new List <string>(); val2Names.Add(ZTTPP_SALES_SUM_MN.Attribute.ZJHJE.ZhName); val2Names.Add(ZTTPP_SALES_SUM_MN.Attribute.ZSJJE.ZhName); val2Names.Add(ZTTPP_SALES_SUM_MN.Attribute.ZXSJE.ZhName); lineNames.Add(val2Names); List <ITableImplement> vals = new List <ITableImplement>(); vals.Add(val1); vals.Add(val2); Dictionary <string, List <ITableImplement> > map = RFCUtil.GetTable2(param, "ZP_REPL_SALES_ORDER_OUT", new string[] { "IT_SALES_SUM", "IT_SALES_SUM_MN" }, vals); valLists.Add(map["IT_SALES_SUM"]); valLists.Add(map["IT_SALES_SUM_MN"]); itemLists.Add(item1List); itemLists.Add(item2List); foreach (List <ITableImplement> valList in valLists) { List <string> datas = new List <string>(); foreach (AttributeItem item in itemLists[valLists.IndexOf(valList)]) { if (item.FieldName.Equals("ZDATE")) { continue; } string data = ""; foreach (ITableImplement val in valList) { try { data += "" + Convert.ToInt32(val[item]) + ","; } catch (Exception ee) { //Response.Write(val[item]); data += "" + val[item] + ","; } } data = data.Substring(0, data.Length - 1); datas.Add(data); } dataLists.Add(datas); } } else { } }
protected void Page_Load(object sender, EventArgs e) { if (IsPostBack) { startmonth = HttpUtil.GetReqStrValue("startmonth"); endmonth = HttpUtil.GetReqStrValue("endmonth"); SAPCHARTPARAM param = new SAPCHARTPARAM(); param.I_PERIOD_S = startmonth.Replace("-", ""); param.I_PERIOD_E = endmonth.Replace("-", ""); //生产订单物料耗用差异率 ALVTEMP val1 = new ALVTEMP(); val1.WERKS = ""; val1.GJAHR = ""; val1.MONAT = ""; val1.ERNAM = ""; val1.ZZHIB = ""; val1.ZKDBS = ""; //val1List = RFCUtil.GetTable<ALVTEMP>(param, "ZP_REPL_QUARTER_ASSESS_OUT", "IT_MLD", val1); itemList = val1.af_GetAvailableAttributeItem(); ////盘盈盘亏/盘点初的库存总金额 //val2List = RFCUtil.GetTable<ALVTEMP>(param, "ZP_REPL_QUARTER_ASSESS_OUT", "IT_OPCIITA", val1); ////采购订单及时率 //val3List = RFCUtil.GetTable<ALVTEMP>(param, "ZP_REPL_QUARTER_ASSESS_OUT", "IT_POTR", val1); ////采购订单及时率(按操作人员) //val4List = RFCUtil.GetTable<ALVTEMP>(param, "ZP_REPL_QUARTER_ASSESS_OUT", "IT_POTR_PERP", val1); ////采购订单完成率 //val5List = RFCUtil.GetTable<ALVTEMP>(param, "ZP_REPL_QUARTER_ASSESS_OUT", "IT_POCR", val1); ////采购订单完成率(按操作人员) //val6List = RFCUtil.GetTable<ALVTEMP>(param, "ZP_REPL_QUARTER_ASSESS_OUT", "IT_POCR_PERP", val1); ////生产订单入库及时率 //val7List = RFCUtil.GetTable<ALVTEMP>(param, "ZP_REPL_QUARTER_ASSESS_OUT", "IT_POINR", val1); List <ITableImplement> vals = new List <ITableImplement>(); vals.Add(val1); vals.Add(val1); vals.Add(val1); vals.Add(val1); vals.Add(val1); vals.Add(val1); vals.Add(val1); Dictionary <string, List <ITableImplement> > map = RFCUtil.GetTable2(param, "ZP_REPL_QUARTER_ASSESS_OUT", new string[] { "IT_MLD", "IT_OPCIITA", "IT_POTR", "IT_POTR_PERP", "IT_POCR", "IT_POCR_PERP", "IT_POINR" }, vals); val1List = map["IT_MLD"]; val2List = map["IT_OPCIITA"]; val3List = map["IT_POTR"]; val4List = map["IT_POTR_PERP"]; val5List = map["IT_POCR"]; val6List = map["IT_POCR_PERP"]; val7List = map["IT_POINR"]; } else { } }
protected void Page_Load(object sender, EventArgs e) { if (IsPostBack) { month = HttpUtil.GetReqStrValue("month"); werk = HttpUtil.GetReqStrValue("werk"); SAPCHARTPARAM param = new SAPCHARTPARAM(); param.I_WERKS = werk; param.I_GJAHR = month.Substring(0, 4); param.I_MONAT = month.Substring(5, 2); monthStr = param.I_MONAT; days = DateTime.DaysInMonth(Convert.ToInt32(param.I_GJAHR), Convert.ToInt32(param.I_MONAT)); //库存金额情况变动表 //ZTTPP_STOCK_MONEY val1 = new ZTTPP_STOCK_MONEY(); //val1.ZDATE = ""; //val1.ZKCJE = ""; //val1.ZKW = ""; //val1List = RFCUtil.GetTable<ZTTPP_STOCK_MONEY>(param, "ZP_REPL_STOCK_MONEY_OUT", "IT_STOCK_MONEY", val1); // AttributeItem[] item1List = val1.af_GetAvailableAttributeItem(); for (int i = 1; i <= days; i++) { labels += "\"" + param.I_MONAT + "/" + (i < 10 ? "0" + i : "" + i) + "\","; } labels = labels.Substring(0, labels.Length - 1); maxList.Add(0); IRfcTable IrfTable = RFCUtil.GetTable(param, "ZP_REPL_STOCK_MONEY_OUT", "IT_STOCK_MONEY"); for (int i = 0; i < IrfTable.Count; i++) { IrfTable.CurrentIndex = i; string zdate=IrfTable.GetString("ZDATE"); string zkw = IrfTable.GetString("ZKW"); string zkcje = IrfTable.GetString("ZKCJE"); if (Convert.ToDecimal(zkcje) > maxList[0]) { maxList[0] = Convert.ToDecimal(zkcje); } stockMap.Add("" + zdate + zkw, zkcje); //zkwMap.Add(zkw, zkw); if (!zkwMap.ContainsKey(zkw)) { zkwMap.Add(zkw, zkw); } } foreach (var zkw in zkwMap) { lineNames.Add(zkw.Key); string data = ""; for (int i = 1; i <= days; i++) { data += stockMap.ContainsKey(month + "-" + (i < 10 ? "0" + i : "" + i) + zkw.Key) ? stockMap[month + "-" + (i < 10 ? "0" + i : "" + i) + zkw.Key] + "," : "0" + ","; } datas.Add(data); } //itemLists.Add(item1List); foreach (decimal max in maxList) { stepList.Add(getStepWidth(max)); } } else { } }
protected void Page_Load(object sender, EventArgs e) { if (IsPostBack) { tabnames.Add("采购创建、入库、冲销订单汇总"); tabnames.Add("采购创建、入库、冲销订单金额汇总"); tabnames.Add("未按期完成入库采购订单"); tabnames.Add("未按期完成入库采购订单-创建者"); month = HttpUtil.GetReqStrValue("month"); werk = HttpUtil.GetReqStrValue("werk"); SAPCHARTPARAM param = new SAPCHARTPARAM(); param.I_WERKS = werk; param.I_GJAHR = month.Substring(0, 4); param.I_MONAT = month.Substring(5, 2); monthStr = param.I_MONAT; days = DateTime.DaysInMonth(Convert.ToInt32(param.I_GJAHR), Convert.ToInt32(param.I_MONAT)); //采购创建、入库、冲销订单汇总 ZTTPP_POMOVE_SUM val1 = new ZTTPP_POMOVE_SUM(); val1.ZDATE = ""; val1.Z101DD = ""; val1.Z102DD = ""; val1.Z103DD = ""; val1.Z104DD = ""; val1.Z105DD = ""; val1.Z106DD = ""; val1.ZCJDD = ""; //val1List = RFCUtil.GetTable<ZTTPP_POMOVE_SUM>(param, "ZP_REPL_PURCHASE_ORDER_OUT", "IT_POMOVE_SUM", val1); AttributeItem[] item1List = val1.af_GetAvailableAttributeItem(); //采购创建、入库、冲销订单金额汇总 ZTTPP_POMOVE_SUM_MN val2 = new ZTTPP_POMOVE_SUM_MN(); val2.ZDATE = ""; val2.Z101JE = ""; val2.Z102JE = ""; val2.Z103JE = ""; val2.Z104JE = ""; val2.Z105JE = ""; val2.Z106JE = ""; val2.ZCJJE = ""; // val2List = RFCUtil.GetTable<ZTTPP_POMOVE_SUM_MN>(param, "ZP_REPL_PURCHASE_ORDER_OUT", "IT_POMOVE_SUM_MN", val2); AttributeItem[] item2List = val2.af_GetAvailableAttributeItem(); //未按期完成入库采购订单 ZTTPP_POMOVE_LAG val3 = new ZTTPP_POMOVE_LAG(); val3.ZDATE = ""; val3.ZSCDD = ""; // val3List = RFCUtil.GetTable<ZTTPP_POMOVE_LAG>(param, "ZTTPP_POMOVE_LAG", "IT_POMOVE_LAG", val3); AttributeItem[] item3List = val3.af_GetAvailableAttributeItem(); //未按期完成入库采购订单-创建者 ZTTPP_POMOVE_LAGER val4 = new ZTTPP_POMOVE_LAGER(); val4.ZDATE = ""; val4.ZDDRY = ""; val4.ZSCDD = ""; // val4List = RFCUtil.GetTable<ZTTPP_POMOVE_LAGER>(param, "ZTTPP_POMOVE_LAGER", "IT_POMOVE_LAGER", val4); AttributeItem[] item4List = val4.af_GetAvailableAttributeItem(); List<ITableImplement> vals = new List<ITableImplement>(); vals.Add(val1); vals.Add(val2); vals.Add(val3); vals.Add(val4); Dictionary<string, List<ITableImplement>> map = RFCUtil.GetTable2(param, "ZP_REPL_PURCHASE_ORDER_OUT", new string[] { "IT_POMOVE_SUM", "IT_POMOVE_SUM_MN", "IT_POMOVE_LAG", "IT_POMOVE_LAGER" }, vals); valLists.Add(map["IT_POMOVE_SUM"]); valLists.Add(map["IT_POMOVE_SUM_MN"]); valLists.Add(map["IT_POMOVE_LAG"]); // valLists.Add(map["IT_POMOVE_LAGER"]); itemLists.Add(item1List); itemLists.Add(item2List); itemLists.Add(item3List); // itemLists.Add(item4List); IRfcTable IrfTable = RFCUtil.GetTable(param, "ZP_REPL_PURCHASE_ORDER_OUT", "IT_POMOVE_LAGER"); for (int i = 0; i < IrfTable.Count; i++) { IrfTable.CurrentIndex = i; string zdate = IrfTable.GetString("ZDATE"); string zscdd = IrfTable.GetString("ZSCDD"); string zddry = IrfTable.GetString("ZDDRY"); purchaseMap.Add("" + zdate + zddry, Convert.ToInt32(zscdd)+""); //zkwMap.Add(zkw, zkw); if (!zddryMap.ContainsKey(zddry)) { zddryMap.Add(zddry, zddry); } } } else { } }
protected void Page_Load(object sender, EventArgs e) { if (IsPostBack) { startmonth = HttpUtil.GetReqStrValue("startmonth"); endmonth = HttpUtil.GetReqStrValue("endmonth"); SAPCHARTPARAM param = new SAPCHARTPARAM(); param.I_PERIOD_S = startmonth.Replace("-",""); param.I_PERIOD_E = endmonth.Replace("-", ""); //生产订单物料耗用差异率 ALVTEMP val1 = new ALVTEMP(); val1.WERKS = ""; val1.GJAHR = ""; val1.MONAT = ""; val1.ERNAM = ""; val1.ZZHIB = ""; val1.ZKDBS = ""; //val1List = RFCUtil.GetTable<ALVTEMP>(param, "ZP_REPL_QUARTER_ASSESS_OUT", "IT_MLD", val1); itemList = val1.af_GetAvailableAttributeItem(); ////盘盈盘亏/盘点初的库存总金额 //val2List = RFCUtil.GetTable<ALVTEMP>(param, "ZP_REPL_QUARTER_ASSESS_OUT", "IT_OPCIITA", val1); ////采购订单及时率 //val3List = RFCUtil.GetTable<ALVTEMP>(param, "ZP_REPL_QUARTER_ASSESS_OUT", "IT_POTR", val1); ////采购订单及时率(按操作人员) //val4List = RFCUtil.GetTable<ALVTEMP>(param, "ZP_REPL_QUARTER_ASSESS_OUT", "IT_POTR_PERP", val1); ////采购订单完成率 //val5List = RFCUtil.GetTable<ALVTEMP>(param, "ZP_REPL_QUARTER_ASSESS_OUT", "IT_POCR", val1); ////采购订单完成率(按操作人员) //val6List = RFCUtil.GetTable<ALVTEMP>(param, "ZP_REPL_QUARTER_ASSESS_OUT", "IT_POCR_PERP", val1); ////生产订单入库及时率 //val7List = RFCUtil.GetTable<ALVTEMP>(param, "ZP_REPL_QUARTER_ASSESS_OUT", "IT_POINR", val1); List<ITableImplement> vals = new List<ITableImplement>(); vals.Add(val1); vals.Add(val1); vals.Add(val1); vals.Add(val1); vals.Add(val1); vals.Add(val1); vals.Add(val1); Dictionary<string, List<ITableImplement>> map = RFCUtil.GetTable2(param, "ZP_REPL_QUARTER_ASSESS_OUT", new string[] { "IT_MLD", "IT_OPCIITA", "IT_POTR", "IT_POTR_PERP", "IT_POCR", "IT_POCR_PERP", "IT_POINR" }, vals); val1List = map["IT_MLD"]; val2List=map["IT_OPCIITA"]; val3List=map["IT_POTR"]; val4List=map["IT_POTR_PERP"]; val5List=map["IT_POCR"]; val6List=map["IT_POCR_PERP"]; val7List=map["IT_POINR"]; } else { } }
protected void Page_Load(object sender, EventArgs e) { if (IsPostBack) { tabnames.Add("生产总工单、成品的计划排产及实际完成订单汇总"); tabnames.Add("生产总工单、半成品、重工工单的排产及实际完成订单汇总"); tabnames.Add("生产总工单、成品的计划排产及实际完成订单数量汇总"); tabnames.Add("生产总工单、生产总工单、成品的计划排产及实际完成订单数量汇总"); tabnames.Add("常规产品计划与实际排产订单数量汇总"); tabnames.Add("未按期完成入库生产订单汇总"); panelnames.Add("生产总工单、成品的计划排产及实际完成订单汇总"); panelnames.Add("生产总工单、半成品、重工工单的排产及实际完成订单汇总"); panelnames.Add("生产总工单、成品的计划排产及实际完成订单数量汇总"); panelnames.Add("生产总工单、生产总工单、成品的计划排产及实际完成订单数量汇总"); panelnames.Add("常规产品计划与实际排产订单数量汇总"); panelnames.Add("未按期完成入库生产订单汇总"); month = HttpUtil.GetReqStrValue("month"); werk = HttpUtil.GetReqStrValue("werk"); SAPCHARTPARAM param = new SAPCHARTPARAM(); param.I_WERKS = werk; param.I_GJAHR = month.Substring(0,4); param.I_MONAT = month.Substring(5,2); //生产总工单、成品汇总 ZTTPP_FP_SUM val1 = new ZTTPP_FP_SUM(); val1.ZDATE = ""; val1.ZFSSUM = ""; val1.ZFSUM = ""; val1.ZSFSUM = ""; val1.ZSSUM = ""; // val1List = RFCUtil.GetTable<ZTTPP_FP_SUM>(param, "ZP_REPL_WQ_ORDER_OUT", "IT_ORDER_RET", val1); AttributeItem[] item1List = val1.af_GetAvailableAttributeItem(); //生产总工单、半成品、重工工单的排产及实际完成订单汇总 ZTTPP_SM_SUM val2 = new ZTTPP_SM_SUM(); val2.ZDATE = ""; val2.ZFRSUM = ""; val2.ZFSMSUM = ""; val2.ZFSUM = ""; val2.ZSRSUM = ""; val2.ZSSMSUM = ""; val2.ZSSUM = ""; // val2List = RFCUtil.GetTable<ZTTPP_SM_SUM>(param, "ZP_REPL_WQ_ORDER_OUT", "IT_ORDER_SM", val2); AttributeItem[] item2List = val2.af_GetAvailableAttributeItem(); //生产总工单、成品的计划排产及实际完成订单数量汇总 ZTTPP_FP_SUM_NUM val3 = new ZTTPP_FP_SUM_NUM(); val3.ZDATE = ""; val3.ZDDSL = ""; val3.ZKSCPSL = ""; val3.ZSJCPSL = ""; val3.ZSJSL = ""; // val3List = RFCUtil.GetTable<ZTTPP_FP_SUM_NUM>(param, "ZP_REPL_WQ_ORDER_OUT", "IT_ORDER_RET_NUM", val3); AttributeItem[] item3List = val3.af_GetAvailableAttributeItem(); //生产总工单、半成品、重工工单的排产及实际完成订单数量汇总 ZTTPP_SM_SUM_NUM val4 = new ZTTPP_SM_SUM_NUM(); val4.ZDATE = ""; val4.ZKSBCPSL = ""; val4.ZKSCGSL = ""; val4.ZKSSL = ""; val4.ZSJBCPSL = ""; val4.ZSJCGSL = ""; val4.ZSJSL = ""; // val4List = RFCUtil.GetTable<ZTTPP_SM_SUM_NUM>(param, "ZP_REPL_WQ_ORDER_OUT", "IT_ORDER_SM_NUM", val4); AttributeItem[] item4List = val4.af_GetAvailableAttributeItem(); //常规产品计划与实际排产订单数量汇总 ZTTPP_RULE_SUM val5 = new ZTTPP_RULE_SUM(); val5.ZDATE = ""; val5.ZCGSJSL = ""; val5.ZCGSL = ""; // val5List = RFCUtil.GetTable<ZTTPP_RULE_SUM>(param, "ZP_REPL_WQ_ORDER_OUT", "IT_ORDER_RULE", val5); AttributeItem[] item5List = val5.af_GetAvailableAttributeItem(); //未按期完成入库生产订单汇总 ZTTPP_UNDONE_SUM val6 = new ZTTPP_UNDONE_SUM(); val6.ZDATE = ""; val6.ZWWCGS = ""; // val6List = RFCUtil.GetTable<ZTTPP_UNDONE_SUM>(param, "ZP_REPL_WQ_ORDER_OUT", "IT_ORDER_UNDONE", val6); AttributeItem[] item6List = val6.af_GetAvailableAttributeItem(); List<ITableImplement> vals = new List<ITableImplement>(); vals.Add(val1); vals.Add(val2); vals.Add(val3); vals.Add(val4); vals.Add(val5); vals.Add(val6); Dictionary<string, List<ITableImplement>> map = RFCUtil.GetTable2(param, "ZP_REPL_WQ_ORDER_OUT", new string[] { "IT_ORDER_RET", "IT_ORDER_SM", "IT_ORDER_RET_NUM", "IT_ORDER_SM_NUM", "IT_ORDER_RULE", "IT_ORDER_UNDONE" }, vals); valLists.Add( map["IT_ORDER_RET"]); valLists.Add(map["IT_ORDER_SM"]); valLists.Add(map["IT_ORDER_RET_NUM"]); valLists.Add( map["IT_ORDER_SM_NUM"]); valLists.Add( map["IT_ORDER_RULE"]); valLists.Add( map["IT_ORDER_UNDONE"]); itemLists.Add(item1List); itemLists.Add(item2List); itemLists.Add(item3List); itemLists.Add(item4List); itemLists.Add(item5List); itemLists.Add(item6List); } else { } }
protected void Page_Load(object sender, EventArgs e) { if (IsPostBack) { tabnames.Add("采购创建、入库、冲销订单汇总"); tabnames.Add("采购创建、入库、冲销订单金额汇总"); tabnames.Add("未按期完成入库采购订单"); tabnames.Add("未按期完成入库采购订单-创建者"); month = HttpUtil.GetReqStrValue("month"); werk = HttpUtil.GetReqStrValue("werk"); SAPCHARTPARAM param = new SAPCHARTPARAM(); param.I_WERKS = werk; param.I_GJAHR = month.Substring(0, 4); param.I_MONAT = month.Substring(5, 2); days = DateTime.DaysInMonth(Convert.ToInt32(param.I_GJAHR), Convert.ToInt32(param.I_MONAT)); monthStr = param.I_MONAT; for (int i = 1; i <= days; i++) { labels += "\"" + param.I_MONAT + "/" + (i < 10 ? "0" + i : "" + i) + "\","; } labels = labels.Substring(0, labels.Length - 1); //采购创建、入库、冲销订单汇总 ZTTPP_POMOVE_SUM val1 = new ZTTPP_POMOVE_SUM(); val1.ZDATE = ""; val1.Z101DD = ""; val1.Z102DD = ""; val1.Z103DD = ""; val1.Z104DD = ""; val1.Z105DD = ""; val1.Z106DD = ""; val1.ZCJDD = ""; //val1List = RFCUtil.GetTable<ZTTPP_POMOVE_SUM>(param, "ZP_REPL_PURCHASE_ORDER_OUT", "IT_POMOVE_SUM", val1); AttributeItem[] item1List = val1.af_GetAvailableAttributeItem(); List <string> val1Names = new List <string>(); val1Names.Add(ZTTPP_POMOVE_SUM.Attribute.Z101DD.ZhName); val1Names.Add(ZTTPP_POMOVE_SUM.Attribute.Z102DD.ZhName); val1Names.Add(ZTTPP_POMOVE_SUM.Attribute.Z103DD.ZhName); val1Names.Add(ZTTPP_POMOVE_SUM.Attribute.Z104DD.ZhName); val1Names.Add(ZTTPP_POMOVE_SUM.Attribute.Z105DD.ZhName); val1Names.Add(ZTTPP_POMOVE_SUM.Attribute.Z106DD.ZhName); val1Names.Add(ZTTPP_POMOVE_SUM.Attribute.ZCJDD.ZhName); lineNames.Add(val1Names); //采购创建、入库、冲销订单金额汇总 ZTTPP_POMOVE_SUM_MN val2 = new ZTTPP_POMOVE_SUM_MN(); val2.ZDATE = ""; val2.Z101JE = ""; val2.Z102JE = ""; val2.Z103JE = ""; val2.Z104JE = ""; val2.Z105JE = ""; val2.Z106JE = ""; val2.ZCJJE = ""; // val2List = RFCUtil.GetTable<ZTTPP_POMOVE_SUM_MN>(param, "ZP_REPL_PURCHASE_ORDER_OUT", "IT_POMOVE_SUM_MN", val2); AttributeItem[] item2List = val2.af_GetAvailableAttributeItem(); List <string> val2Names = new List <string>(); val2Names.Add(ZTTPP_POMOVE_SUM_MN.Attribute.Z101JE.ZhName); val2Names.Add(ZTTPP_POMOVE_SUM_MN.Attribute.Z102JE.ZhName); val2Names.Add(ZTTPP_POMOVE_SUM_MN.Attribute.Z103JE.ZhName); val2Names.Add(ZTTPP_POMOVE_SUM_MN.Attribute.Z104JE.ZhName); val2Names.Add(ZTTPP_POMOVE_SUM_MN.Attribute.Z105JE.ZhName); val2Names.Add(ZTTPP_POMOVE_SUM_MN.Attribute.Z106JE.ZhName); val2Names.Add(ZTTPP_POMOVE_SUM_MN.Attribute.ZCJJE.ZhName); lineNames.Add(val2Names); //未按期完成入库采购订单 ZTTPP_POMOVE_LAG val3 = new ZTTPP_POMOVE_LAG(); val3.ZDATE = ""; val3.ZSCDD = ""; // val3List = RFCUtil.GetTable<ZTTPP_POMOVE_LAG>(param, "ZTTPP_POMOVE_LAG", "IT_POMOVE_LAG", val3); AttributeItem[] item3List = val3.af_GetAvailableAttributeItem(); List <string> val3Names = new List <string>(); val3Names.Add(ZTTPP_POMOVE_LAG.Attribute.ZSCDD.ZhName); lineNames.Add(val3Names); //未按期完成入库采购订单-创建者 ZTTPP_POMOVE_LAGER val4 = new ZTTPP_POMOVE_LAGER(); val4.ZDATE = ""; val4.ZDDRY = ""; val4.ZSCDD = ""; // val4List = RFCUtil.GetTable<ZTTPP_POMOVE_LAGER>(param, "ZTTPP_POMOVE_LAGER", "IT_POMOVE_LAGER", val4); AttributeItem[] item4List = val4.af_GetAvailableAttributeItem(); List <ITableImplement> vals = new List <ITableImplement>(); vals.Add(val1); vals.Add(val2); vals.Add(val3); vals.Add(val4); Dictionary <string, List <ITableImplement> > map = RFCUtil.GetTable2(param, "ZP_REPL_PURCHASE_ORDER_OUT", new string[] { "IT_POMOVE_SUM", "IT_POMOVE_SUM_MN", "IT_POMOVE_LAG" }, vals); valLists.Add(map["IT_POMOVE_SUM"]); valLists.Add(map["IT_POMOVE_SUM_MN"]); valLists.Add(map["IT_POMOVE_LAG"]); //valLists.Add(map["IT_POMOVE_LAGER"]); itemLists.Add(item1List); itemLists.Add(item2List); itemLists.Add(item3List); itemLists.Add(item4List); foreach (List <ITableImplement> valList in valLists) { List <string> datas = new List <string>(); foreach (AttributeItem item in itemLists[valLists.IndexOf(valList)]) { if (item.FieldName.Equals("ZDATE")) { continue; } string data = ""; foreach (ITableImplement val in valList) { try { data += "" + Convert.ToInt32(val[item]) + ","; } catch (Exception ee) { //Response.Write(val[item]); data += "" + val[item] + ","; } } data = data.Substring(0, data.Length - 1); datas.Add(data); } dataLists.Add(datas); } List <string> val4Names = new List <string>(); lineNames.Add(val4Names); IRfcTable IrfTable = RFCUtil.GetTable(param, "ZP_REPL_PURCHASE_ORDER_OUT", "IT_POMOVE_LAGER"); for (int i = 0; i < IrfTable.Count; i++) { IrfTable.CurrentIndex = i; string zdate = IrfTable.GetString("ZDATE"); string zscdd = IrfTable.GetString("ZSCDD"); string zddry = IrfTable.GetString("ZDDRY"); purchaseMap.Add("" + zdate + zddry, Convert.ToInt32(zscdd) + ""); //zkwMap.Add(zkw, zkw); if (!zddryMap.ContainsKey(zddry)) { zddryMap.Add(zddry, zddry); } } foreach (var zddry in zddryMap) { val4Names.Add(zddry.Key); string data = ""; for (int i = 1; i <= days; i++) { data += purchaseMap.ContainsKey(month + "-" + (i < 10 ? "0" + i : "" + i) + zddry.Key) ? purchaseMap[month + "-" + (i < 10 ? "0" + i : "" + i) + zddry.Key] + "," : "0" + ","; } datas2.Add(data); } } else { } }