示例#1
0
 //构造函数
 public GoodsForm(BathDBDataContext dc, StorageList goods, StorageForm form)
 {
     db = dc;
     m_form = form;
     if (goods != null)
     {
         newGoods = false;
         m_goods = goods;
     }
     InitializeComponent();
     catId.Items.AddRange(db.GoodsCat.Select(x => x.name).ToArray());
     provider.Items.AddRange(db.Provider.Select(x => x.name).ToArray());
     stock.Items.AddRange(db.Stock.Select(x => x.name).ToArray());
     ComboUnit.Items.AddRange(db.Unit.Select(x => x.name).ToArray());
 }
示例#2
0
 partial void DeleteStorageList(StorageList instance);
示例#3
0
 partial void UpdateStorageList(StorageList instance);
示例#4
0
 partial void InsertStorageList(StorageList instance);
示例#5
0
        //确定
        private void btnOk_Click(object sender, EventArgs e)
        {
            if (catId.Text == "")
            {
                BathClass.printErrorMsg("需要选择商品类别");
                return;
            }

            m_goods.name = name.Text.Trim();
            try
            {
                m_goods.minAmount = Convert.ToInt32(minAmount.Text.Trim());
            }
            catch
            {
                m_goods.minAmount = null;
            }
            m_goods.note = note.Text.Trim();
            m_goods.goodsCatId = db.GoodsCat.FirstOrDefault(x => x.name == catId.Text).id;

            if (newGoods)
            {
                if (db.StorageList.FirstOrDefault(x => x.name == m_goods.name) != null)
                {
                    BathClass.printErrorMsg("已经存在此名称的商品!");
                    name.SelectAll();
                    return;
                }
                db.StorageList.InsertOnSubmit(m_goods);
            }

            if (amount.Text.Trim() != "")
            {
                if (amount.Text.Trim() == "")
                {
                    BathClass.printErrorMsg("需要输入数量!");
                    return;
                }

                if (stock.Text == "")
                {
                    BathClass.printErrorMsg("需要选择仓库!");
                    return;
                }

                StockIn inStock = new StockIn();
                inStock.name = name.Text;
                if (cost.Text != "")
                    inStock.cost = Convert.ToDouble(cost.Text);
                inStock.amount = Convert.ToDouble(amount.Text);
                inStock.stockId = db.Stock.FirstOrDefault(x => x.name == stock.Text).id;
                inStock.note = stockNote.Text;
                inStock.date = DateTime.Now;
                inStock.transactor = LogIn.m_User.id;
                inStock.checker = LogIn.m_User.id;

                string unit_text = ComboUnit.Text.Trim();
                if (unit_text != "")
                {
                    inStock.unit = unit_text;
                    if (!db.Unit.Any(x=>x.name==unit_text))
                    {
                        var unit_instance = new Unit();
                        unit_instance.name = unit_text;
                        db.Unit.InsertOnSubmit(unit_instance);
                    }

                }

                if (money.Text.Trim() != "")
                    inStock.money = Convert.ToDouble(money.Text.Trim());
                db.StockIn.InsertOnSubmit(inStock);
            }
            db.SubmitChanges();
            if (newGoods)
            {
                name.Text = "";
                catId.SelectedIndex = -1;
                provider.SelectedIndex = -1;
                minAmount.Text = "";
                note.Text = "";
                cost.Text = "";
                amount.Text = "";
                stock.SelectedIndex = -1;
                stockNote.Text = "";
                money.Text = "";
                name.Focus();
                db.SubmitChanges();
                m_form.dgv_show();
                m_goods = new StorageList();
            }
            else
            {
                this.DialogResult = DialogResult.OK;
                this.Close();
            }
        }