Ejemplo n.º 1
0
        private void button2_Click(object sender, EventArgs e)
        {
            CashMemo cm = new CashMemo();

            cm.CustomerName  = textBoxCname.Text;
            cm.CustomerPhone = Convert.ToInt32(textBoxcPhone.Text);
            cm.Date          = DateTime.Today.ToShortDateString();
            cm.newentry();
            cm.CashMemoNO = cm.returnid();
            for (int i = 0; i <= Rowcount - 1; i++)
            {
                SoldProductcs sp = new SoldProductcs();
                sp.BranchID  = LoginForm.BRCHID;
                sp.ProductId = Convert.ToInt32(dataGridView1.Rows[i].Cells[0].Value);
                Branch_Product bp1 = new Branch_Product();
                bp1.Productid = sp.ProductId;
                bp1.BranchId  = sp.BranchID;
                bp1.ptype2();
                sp.Pname = bp1.ProductName;
                sp.ProductSalesUnitPrice = bp1.SalesPrice;
                sp.Ptype          = bp1.ProductType;
                sp.ProdducExpDate = bp1.ProductExpdate;
                sp.MfgDate        = bp1.ProductMfgdate;
                sp.Quantity       = Convert.ToInt32(dataGridView1.Rows[i].Cells[3].Value);
                bp1.Quantity     -= sp.Quantity;
                bp1.proupdate2(bp1.Quantity);
                sp.TotalPrice = Convert.ToInt32(dataGridView1.Rows[i].Cells[4].Value);
                sp.CashMemoNo = cm.CashMemoNO;
                sp.SoldDate   = DateTime.Today.ToShortDateString();
                sp.newentry();
            }
        }
Ejemplo n.º 2
0
        public void LoadAll()
        {
            string sql = "SELECT * FROM CashMemo";

            this.dt    = DataAccess.GetDataTable(sql);
            this.count = dt.Rows.Count;
            this.arr   = new CashMemo[this.count];

            for (int i = 0; i < this.count; i++)
            {
                CashMemo p = new CashMemo();
                p.CashMemoNO    = (int)dt.Rows[i]["Cashmemo_NO"];
                p.CustomerPhone = (int)dt.Rows[i]["Customer_phone"];
                p.CustomerName  = dt.Rows[i]["Customer_name"].ToString();
                p.Date          = dt.Rows[i]["Date"].ToString();
                this.arr[i]     = p;
            }
        }