1.请写代码产生下列之xml文件。
2.请写代码计算出各个matnr下所有 lot 数量之总和。
<?xml version="1.0" encoding="utf-8"?>
<message>
<message_id>REM_GI_RAW</message_id>
<type_id>I</type_id>
<system_byte>3a5f62f4-698a-44a6-a23a-ec64ea2ce56c</system_byte>
<bwart>333</bwart>
<mblnr>4000003087</mblnr>
<budat>20080515</budat>
<werks>T001</werks>
<lgort>3100</lgort>
<kostl>9T000001</kostl>
<movements>
<matnr cdy="3A000001-01" vendor="12345678" type="AA01">
<lot id="B01DDS001">
<erfmg>30</erfmg>
<erfme>PC</erfme>
</lot>
<lot id="B01DDS002">
<erfmg>10</erfmg>
<erfme>PC</erfme>
</lot>
</matnr>
<matnr cdy="3A009999-01" vendor="123dssse8" type="BB02">
<lot id="BFDSRGD001">
<erfmg>20</erfmg>
<erfme>KG</erfme>
</lot>
<lot id="B01DDSD02">
<erfmg>10</erfmg>
<erfme>KG</erfme>
</lot>
</matnr>
</movements>
</message>
2.请写代码计算出各个matnr下所有 lot 数量之总和。
<?xml version="1.0" encoding="utf-8"?>
<message>
<message_id>REM_GI_RAW</message_id>
<type_id>I</type_id>
<system_byte>3a5f62f4-698a-44a6-a23a-ec64ea2ce56c</system_byte>
<bwart>333</bwart>
<mblnr>4000003087</mblnr>
<budat>20080515</budat>
<werks>T001</werks>
<lgort>3100</lgort>
<kostl>9T000001</kostl>
<movements>
<matnr cdy="3A000001-01" vendor="12345678" type="AA01">
<lot id="B01DDS001">
<erfmg>30</erfmg>
<erfme>PC</erfme>
</lot>
<lot id="B01DDS002">
<erfmg>10</erfmg>
<erfme>PC</erfme>
</lot>
</matnr>
<matnr cdy="3A009999-01" vendor="123dssse8" type="BB02">
<lot id="BFDSRGD001">
<erfmg>20</erfmg>
<erfme>KG</erfme>
</lot>
<lot id="B01DDSD02">
<erfmg>10</erfmg>
<erfme>KG</erfme>
</lot>
</matnr>
</movements>
</message>
protected void btnSubmit_Click(object sender, System.EventArgs e)
{
DataSet ds = new DataSet("myDs");
if(!File.Exists(Server.MapPath("dbXML.xml")))
{
//以下创建数据库xml
DataTable dt = new DataTable("Question");
dt.Columns.Add("QuestionID",typeof(int));
dt.Columns.Add("Name",typeof(string));
dt.Columns.Add("Age",typeof(int));
dt.Columns.Add("Email",typeof(string));
dt.Columns.Add("Item",typeof(string));
ds.Tables.Add(dt);
//ds.WriteXml(Server.MapPath("dbQuestion.xml"));
}
else
ds.ReadXml(Server.MapPath("dbXML.xml"));
//以下生成一条记录
DataRow dr = ds.Tables[0].NewRow();
dr["QuestionID"] = ds.Tables[0].Rows.Count+1;
dr["Name"] =tbName.Text.Trim();
dr["Age"] = tbAge.Text;
dr["Email"] = tbEmail.Text;
//以下保存用户的调查项目
DataSet dsItem = new DataSet("Item");
DataTable dtItem = new DataTable("dtItem");
dsItem.Tables.Add(dtItem);
dtItem.Columns.Add("ID", typeof(int));
dtItem.Columns.Add("Title", typeof(string));
dtItem.Columns.Add("Answer", typeof(string));
for (int i = 1; i <= 6; i++)
{
DataRow drItem = dtItem.NewRow();
drItem["ID"] = i;
drItem["Title"] = ((Label)this.FindControl("lbQuestion" + i.ToString())).Text;
RadioButtonList rbl = (RadioButtonList)this.FindControl("rbQuestion" + i.ToString());
for (int j = 0; j < 4; j++)
{
if (rbl.Items[j].Selected)
drItem["Answer"] = rbl.Items[j].Text;
}
dtItem.Rows.Add(drItem);
} dr["Item"] = dsItem.GetXml();
ds.Tables[0].Rows.Add(dr);
//最后保存并转向
ds.WriteXml(Server.MapPath("dbXML.xml"));
Session["myDs"] = ds;
Response.Redirect("show.aspx");
}
}
我在公司的时候只能上CSDN好不 别拿你的头发长见识短到这来墨迹 无聊