public DataSet OrderBackFromSAP(string ReceiptNO, string year)
{
NcoFunction ncoClient = new NcoFunction();
try
{
ncoClient.Connect();
ncoClient.FunctionName = FunctionName;//Rfc function name
Dictionary <string, object> importParameters = new Dictionary <string, object>();
importParameters.Add("RECEIPTNO", ReceiptNO);
importParameters.Add("YEAR", year);
ncoClient.ImportParameters = importParameters;
DataSet ds = ncoClient.Execute();
ds = RFCUtil.ReplaceDataSet(ds);
ncoClient.DISConncet();
LogData(ds);
return(ds);
}
catch (Exception e)
{
ncoClient.DISConncet();
throw e;
}
}
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)
{
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("生产总工单、生产总工单、成品的计划排产及实际完成订单数量汇总");
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("采购创建、入库、冲销订单金额汇总");
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
{
}
}
public string getShipOrderList(string vendor, string plant_code, string order_code, string starttime, string endtime)
{
V_PURSUEDELIVER conf = new V_PURSUEDELIVER();
conf.Status = "REL";
if (!string.IsNullOrEmpty(vendor))
{
conf.Vendor = vendor;
}
if (!string.IsNullOrEmpty(plant_code))
{
conf.Plant_code = plant_code;
}
if (!string.IsNullOrEmpty(starttime))
{
}
if (!string.IsNullOrEmpty(endtime))
{
conf.af_WhereSQL += " AND creation_date < '" + endtime + " 23:59:59'";
}
V_PURSUEDELIVER val = new V_PURSUEDELIVER();
val.Order_code = 0;
val.Line_num = "";
val.Quantity = 0;
val.Unit = "";
val.Creation_date = DateTime.Now;
val.Material_id = "";
val.Po_num = "";
val.Po_line_num = "";
val.Status = "";
val.Plan_line_num = 0;
List <V_PURSUEDELIVER> lineList3 = BLLTable <V_PURSUEDELIVER> .Factory("conn_gys").Select(val, conf);
RFCPARAM paramObj = new RFCPARAM();
paramObj.I_WERKS = plant_code;
paramObj.DATE_FROM = starttime;
paramObj.DATE_TO = endtime;
paramObj.I_LIFNR = vendor;
paramObj.DATE_FROM = DateTime.Now.AddYears(-1).ToString("yyyyMMdd");
paramObj.DATE_TO = DateTime.Now.AddYears(1).ToString("yyyyMMdd");
IT_LINES valObj = new IT_LINES();
valObj.EBELN = "";
valObj.EBELP = "";
valObj.LOEKZ = "";
valObj.MATNR = "";
valObj.TXZ01 = "";
valObj.MENGE = 1;
valObj.MEINS = "";
valObj.EINDT = "";
valObj.LTEXT = "";
valObj.WERKS = "";
valObj.ETENR = "";
valObj.OBMNG = 1;
List <IT_LINES> lines = RFCUtil.GetTable <IT_LINES>(paramObj, "ZVP_NOT_DLV_PO", "IT_LINES", valObj);
Dictionary <string, IT_LINES> lineMap = new Dictionary <string, IT_LINES>();
foreach (IT_LINES detail in lines)
{
string key = detail.EBELN + Convert.ToInt32(detail.EBELP) + Convert.ToInt32(detail.ETENR);
// lines.Add(detail);
if (lineMap.ContainsKey(key))
{
lineMap[key] = detail;
// deliverMap[key] = ship;
}
else
{
lineMap.Add(key, detail);
// deliverMap.Add(key, ship);
}
}
List <V_PURSUEDELIVER> lineList = new List <V_PURSUEDELIVER>();
Dictionary <string, decimal> numMap = new Dictionary <string, decimal>();
for (int i = lineList3.Count - 1; i >= 0; i--)
{
// foreach(V_PURSUEDELIVER line in lineList3){
V_PURSUEDELIVER line = lineList3[i];
string key = line.Po_num + "" + line.Po_line_num + "" + line.Plan_line_num;
decimal usedNum = 0;
if (numMap.ContainsKey(key))
{
//usedNum表示上一个 key相同的发货单送的数量。
usedNum = numMap[key];
if (usedNum == -1)
{
//肯定为在途
lineList.Add(line);
continue;
}
}
else
{
numMap.Add(key, 0);
}
if (!lineMap.ContainsKey(key))
{
//lineList.Remove(line);
//如果不在未清中，那么肯定不在途
continue;
}
else
{
IT_LINES line_1 = lineMap[key];
Vp_initial_polines conf2 = new Vp_initial_polines();
conf2.Po_number = line.Po_num;
conf2.Po_line = line.Po_line_num;
conf2.Po_line_num = line.Plan_line_num + "";
Vp_initial_polines valObj2 = new Vp_initial_polines();
valObj2.Quantity = 0;
Vp_initial_polines poline = BLLTable <Vp_initial_polines> .Factory("conn_gys").GetRowData(valObj2, conf2);
decimal sum = 0;
decimal num = 0;
if (poline != null)
{
sum = poline.Quantity;
}
if (sum > 0)
{
num = sum - line_1.OBMNG - usedNum;
}
else
{
num = line_1.MENGE - line_1.OBMNG - usedNum;
}
if (num >= line.Quantity)
{
numMap[key] += line.Quantity;
// lineList.Remove(line);
}
else
{
//如果=-1 则代表 第一条 key 都没有交货，以后遇到 -1 就continue
numMap[key] = -1;
lineList.Add(line);
}
}
}
//这里需要过滤一下
if (!string.IsNullOrEmpty(order_code))
{
List <V_PURSUEDELIVER> lineList4 = new List <V_PURSUEDELIVER>();
//如果有传入订单号，则过滤
for (int i = 0; i < lineList.Count; i++)
{
if (order_code.Equals(lineList[i].Order_code + ""))
{
lineList4.Add(lineList[i]);
}
}
lineList = lineList4;
}
lineList.Reverse();
string xml = "<Orders>";
foreach (V_PURSUEDELIVER p in lineList)
{
string tempxml = "<Order>";
tempxml += "<Order_code>" + p.Order_code + "</Order_code>";
tempxml += "<Line_num>" + p.Line_num + "</Line_num>";
tempxml += "<Quantity>" + p.Quantity + "</Quantity>";
tempxml += "<Unit>" + p.Unit + "</Unit>";
tempxml += "<Creation_date>" + p.Creation_date + "</Creation_date>";
tempxml += "<Material_id>" + p.Material_id + "</Material_id>";
tempxml += "<Po_num>" + p.Po_num + "</Po_num>";
tempxml += "<Po_line_num>" + p.Po_line_num + "</Po_line_num>";
tempxml += "<Status>" + p.Status + "</Status>";
tempxml += "</Order>";
xml += tempxml;
}
xml += "</Orders>";
//string json=JsonUtil.getJsonStr<V_PURSUEDELIVER>(list);
return(xml);
}
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
{
}
}
