WPF 单表新增多条数据
作者:邱名涛
撰写时间:2019 年 8 月15日
private void Window_Loaded(object sender, RoutedEventArgs e)
{
txt_DanHao.Text = DateTime.Now.ToString("CG" + "yyyyMMddHHmms");//用时间生成单号
myDatePicker.Text = DateTime.Today.ToLongDateString();//时间控件指定当天日期
}
//点击保存按钮,保存数据到数据库
private void btn_BanoCun(object sender, RoutedEventArgs e)
{
//获取页面文本值
string ProNumbers = txt_DanHao.Text.Trim();
DateTime ProTime =Convert.ToDateTime( myDatePicker.ToString());
int ShangID = Convert.ToInt32(txt_ShangID.Text.Trim());
if (ShangID > 0)
{
//循环表格CommodityID,获取表格的值
for (int i = 0; i < Data_CommodityID.Items.Count; i++)
{
int iCommodityID = Convert.ToInt32(((DataRowView)Data_CommodityID.Items[i]).Row["CommodityID"]);
decimal iAverage = Convert.ToDecimal(((DataRowView)Data_CommodityID.Items[i]).Row["Average"]);
string iAmount = ((DataRowView)Data_CommodityID.Items[i]).Row["Amount"].ToString();
string iRemark = ((DataRowView)Data_CommodityID.Items[i]).Row["Remark"].ToString();
if (ShangID > 0 && iCommodityID > 0 && ProNumbers != "")
{
int count = myClient.Insert_Purchase(iCommodityID, ShangID, ProNumbers, ProTime, iAverage, iAmount, iRemark);
if (count > 0)
{
MessageBoxResult dr = MessageBox.Show("采购入库成功!", "系统提示", MessageBoxButton.OKCancel,
MessageBoxImage.Asterisk); //弹出确定对话框
if (dr == MessageBoxResult.OK) //如果点了确定按钮
{
}
}
}
}
}
else {
MessageBox.Show("请选择入库供应商!", "系统提示", MessageBoxButton.OKCancel, MessageBoxImage.Asterisk);
}
}