private void btn_add_Click(object sender, EventArgs e)
{
if (!Checker.Check_Number(txt_optnum.Text.Trim(), false))
{
MessageBox.Show("数量输入不正确");
return;
}
if (cbx_tp.SelectedIndex == -1)
{
MessageBox.Show("未选择操作类型");
return;
}
GoodsMenu menu = new GoodsMenu();
txt_menuid.Text = UpdateMulGoodsHelper.get_menu_id(user, dt_opttime.Value, ++menu_list_count);
menu.MenuId = txt_menuid.Text.Trim();
menu.Date = dt_opttime.Value;
menu.OptPeopleId = user.Userid;
menu.TxtMsg = txt_msg.Text.Trim();
menu.Number = txt_optnum.Text.Trim();
menu.Goods = GoodsMSHelper.Select_goods_by_goodsId(txt_goodsid.Text.Trim());
if (menu.Goods == null)
{
MessageBox.Show("记录中不存在该货物");
return;
}
list.Add(new KeyValuePair <GoodsMenu, int>(menu, cbx_tp.SelectedIndex));
lis_menu.Items.Add(UpdateMulGoodsHelper.add_list_message(menu, cbx_tp.SelectedIndex));
this.btn_fresh_Click(sender, e);
}
public static bool init_entry_report(DateTime begin, DateTime end)
{
DBhelper help = new DBhelper();
help.updateDate("delete from report");
string sql1 = string.Format("select * from entry where entrytime between '{0}' and '{1}'",
begin.ToShortDateString(), end.AddDays(1).ToShortDateString());
DataTable dt = help.SqlSelect(sql1, "entry");
if (dt == null)
{
return(false);
}
ArrayList arr = new ArrayList();
for (int i = 0; i < dt.Rows.Count; i++)
{
GoodsMenu menu = new GoodsMenu();
menu.MenuId = dt.Rows[i]["entryid"].ToString();
menu.Date = (DateTime)dt.Rows[i]["entrytime"];
menu.OptPeopleId = dt.Rows[i]["peopleid"].ToString();
menu.TxtMsg = dt.Rows[i]["text1"].ToString();
menu.Goods = GoodsMSHelper.Select_goods_by_goodsId(dt.Rows[i]["goodsid"].ToString());
menu.Number = dt.Rows[i]["entrynumber"].ToString();
string sql = GoodsMSHelper.report_goods(menu);
arr.Add(sql);
}
return(help.MultiTrans(arr));
}
//出库
public static string come_goods(GoodsMenu menu)
{
string sql = String.Format("insert into come (comeid, cometime, peopleid, text2, goodsid, comenumber) "
+ "values('{0}', '{1}', '{2}', '{3}', '{4}', {5})",
menu.MenuId, menu.Date, menu.OptPeopleId, menu.TxtMsg, menu.Goods.Goods_id, menu.Number);
return(sql);
}
public static string add_list_message(GoodsMenu menu, int type)
{
String msg = menu.Goods.Goods_id + " " + menu.Goods.Goods_name + " ";
msg += type == 0 ? "[入库] " : "[出库] ";
msg += menu.Number;
msg += " ";
msg += menu.Goods.Goods_unit;
return(msg);
}
private void btn_post_Click(object sender, EventArgs e)
{
if (MessageBox.Show("确认提交?", "确认提交?", MessageBoxButtons.YesNo) == System.Windows.Forms.DialogResult.No)
{
return;
}
ArrayList arr = new ArrayList();
foreach (KeyValuePair <GoodsMenu, int> x in list)
{
GoodsMenu menu = x.Key;
int type = x.Value;
string cmd1 = "", cmd2 = "";
if (type == 0) // in
{
cmd1 = GoodsMSHelper.entry_goods(menu);
cmd2 = GoodsMSHelper.Update_goods_number(menu.Goods, menu.Number, 0);
}
else if (type == 1) // out
{
cmd1 = GoodsMSHelper.come_goods(menu);
cmd2 = GoodsMSHelper.Update_goods_number(menu.Goods, menu.Number, 1);
}
arr.Add(cmd1);
arr.Add(cmd2);
}
if (arr.Count == 0)
{
MessageBox.Show("订单为空");
return;
}
if (GoodsMSHelper.multy_post_menu(arr))
{
MessageBox.Show("操作提交成功");
lis_menu.Items.Clear();
list.Clear();
}
else
{
MessageBox.Show("操作提交失败");
}
}
