private void butOk_Click(object sender, EventArgs e)
{
IAdapter Iad = (IAdapter)iapplication.GetService(typeof(IAdapter));
int amount = 0;
for (int i = 0; i < listView1.Items.Count; i++)
{
Fields2Xml f2x = new Fields2Xml("CK_ORDERPRODUCT"); //定义要修改的表名
//f2x.addField("F_IP", SqlDbType.VarChar, dr["F_IP"].ToString(), true, false);//指定主键值,没指定主键将添加
f2x.addField("F_PurchasNo", SqlDbType.VarChar, myOrderNumber.FieldValue.ToString(), false, false); //定义要修改的字段和值
f2x.addField("F_PRODUCTID", SqlDbType.Int, listView1.Items[i].SubItems[0].Text.ToString(), false, false); //定义要修改的字段和值
f2x.addField("F_COUNT", SqlDbType.Int, listView1.Items[i].SubItems[3].Text.ToString(), false, false); //定义要修改的字段和值
f2x.addField("F_UnitPrice", SqlDbType.Int, listView1.Items[i].SubItems[5].Text.ToString(), false, false); //定义要修改的字段和值
f2x.addField("F_Unit", SqlDbType.VarChar, listView1.Items[i].SubItems[4].Text.ToString(), false, false); //定义要修改的字段和值
f2x.addField("F_PRODUCT", SqlDbType.VarChar, listView1.Items[i].SubItems[2].Text.ToString(), false, false); //定义要修改的字段和值
f2x.addField("F_CODE", SqlDbType.VarChar, listView1.Items[i].SubItems[1].Text.ToString(), false, false); //定义要修改的字段和值
String retxml = (string)Iad.RunCmdnoCheck("AFunction1", new object[] { f2x.getDataXml(FormType.Insert) }); //指定执行类型,执行
f2x.ReturnXmlAnalsy(retxml); //返回的执行结果;
MessageBox.Show(retxml);
amount = amount + Int32.Parse(listView1.Items[i].SubItems[6].Text.ToString());
}
MessageBox.Show(amount.ToString());
this.myEditTextBox2.FieldValue = amount;
this.Commit();
this.listView1.Clear();
}
private void button1_Click(object sender, EventArgs e)
{
//if (ds != null && ds.Rows.Count > 0)
//{
// for (int i = 0; ds.Rows.Count > i; i++)
// {
// //ListViewItem item = new ListViewItem(ds.Rows[0]["F_ID"].ToString());
// //item.SubItems.Add(ds.Rows[i]["F_CODE"].ToString());
// //item.SubItems.Add(ds.Rows[i]["F_NAME"].ToString());
// //item.SubItems.Add(this.textBox1.Text);
// //item.SubItems.Add(ds.Rows[i]["F_MESURE"].ToString());
// //item.SubItems.Add(ds.Rows[i]["F_IN_SPRICE"].ToString());
// //item.SubItems.Add(textBox2.Text);
// //listView1.Items.Add(item);
// }
//}
string key = "";
IAdapter Iad = (IAdapter)iapplication.GetService(typeof(IAdapter));
Fields2Xml f2x = new Fields2Xml("CK_BUYORDERDETAIL"); //定义要修改的表名
f2x.addField("F_ID", SqlDbType.Int, "0", true, true); //指定主键值,没指定主键将添加
f2x.addField("F_PurchasNo", SqlDbType.VarChar, OrderNum); //定义要修改的字段和值
f2x.addField("F_PRODUCTID", SqlDbType.Int, editrow["F_ID"].ToString()); //定义要修改的字段和值
f2x.addField("F_COUNT", SqlDbType.Int, this.textBox1.Text); //定义要修改的字段和值
f2x.addField("F_UnitPrice", SqlDbType.Int, editrow["F_IN_SPRICE"].ToString()); //定义要修改的字段和值
f2x.addField("F_Unit", SqlDbType.VarChar, editrow["F_MESURE"].ToString()); //定义要修改的字段和值
f2x.addField("F_PRODUCT", SqlDbType.VarChar, editrow["F_NAME"].ToString()); //定义要修改的字段和值
f2x.addField("F_CODE", SqlDbType.VarChar, editrow["F_CODE"].ToString()); //定义要修改的字段和值
String retxml = (string)Iad.RunCmdnoCheck("AFunction1", new object[] { f2x.getDataXml(FormType.Insert) }); //指定执行类型,执行
MessageBox.Show(retxml);
if (f2x.ReturnXmlAnalsy(retxml, ref key))
{
ListViewItem item = new ListViewItem(editrow["F_ID"].ToString());
item.SubItems.Add(editrow["F_CODE"].ToString());
item.SubItems.Add(editrow["F_NAME"].ToString());
item.SubItems.Add(this.textBox1.Text);
item.SubItems.Add(editrow["F_MESURE"].ToString());
item.SubItems.Add(editrow["F_IN_SPRICE"].ToString());
item.SubItems.Add(textBox2.Text);
item.Tag = key;
listView1.Items.Add(item);
amount = amount + float.Parse(textBox2.Text);
amountTextBox.FieldValue = amount;
amountTextBox.ShowFieldValue = amount;
}
}
private void listView1_MouseDoubleClick(object sender, MouseEventArgs e)
{
if (listView1.SelectedItems.Count == 0)
{
return;
}
if (MessageBox.Show("是否删除该明细", "提示", MessageBoxButtons.OKCancel, MessageBoxIcon.Information) == DialogResult.Cancel)
{
return;
}
ListViewItem lvi = listView1.SelectedItems[0];
IAdapter Iad = (IAdapter)iapplication.GetService(typeof(IAdapter));
Fields2Xml f2x = new Fields2Xml("CK_BUYORDERDETAIL"); //定义要修改的表名
f2x.addField("F_ID", SqlDbType.Int, lvi.Tag.ToString(), true, true, true); //指定主键值,没指定主键将添加
String retxml = (string)Iad.RunCmdnoCheck("AFunction1", new object[] { f2x.getDataXml(FormType.Delete) }); //指定执行类型,执行
if (f2x.ReturnXmlAnalsy(retxml))
{
listView1.Items.Remove(lvi);
}
}
