Пример #1
0
    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
        {
        }
    }
Пример #2
0
    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("生产总工单、半成品、重工工单的排产及实际完成订单数量汇总");
            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 {

        }
    }
Пример #4
0
    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 {

        }
    }