public void ThanhToanNhap() { NhapNguyenLieuDTO nhapnl = new NhapNguyenLieuDTO(); nhapnl.MaNcc = MaNhaCc; nhapnl.TenDn = TenDn ?? "admin"; nhapnl.NgayNhap = dtpngaynhap.Value.ToString(); nhapnl.TongTien = txttongtien.Text; bool t = nhapnl_bus.NhapNl_Insert(nhapnl); for (int i = 0; i < datanlnhap.Rows.Count - 1; i++) { CtNhapNguyenLieuDTO ctnhapnl = new CtNhapNguyenLieuDTO(); ctnhapnl.MaNl = datanlnhap.Rows[i].Cells[0].Value.ToString(); ctnhapnl.SoLuong = datanlnhap.Rows[i].Cells[4].Value.ToString(); ctnhapnl.DonViTinh = datanlnhap.Rows[i].Cells[2].Value.ToString(); ctnhapnl.HSd = datanlnhap.Rows[i].Cells[3].Value.ToString(); ctnhapnl.DonGia = datanlnhap.Rows[i].Cells[5].Value.ToString(); ctnhapnl_bus.CtNhapNl_Insert(ctnhapnl); //CtNguyenLieuDTO ctnl = new CtNguyenLieuDTO(); //ctnl.MaNl = datanlnhap.Rows[i].Cells[0].Value.ToString(); //ctnl.DVt = datanlnhap.Rows[i].Cells[2].Value.ToString(); //ctnl.HSd = datanlnhap.Rows[i].Cells[3].Value.ToString(); //ctnl.TonKho = datanlnhap.Rows[i].Cells[4].Value.ToString(); //ctnhapnl_bus.CtNhapNl_InsertNl(ctnl); } CtNhapNl_InsertNl(); HoaDonNhap hdn = new HoaDonNhap(TenDn, Quyen); HoaDonNhapp hdnp = new HoaDonNhapp(); hdn.crvhoadonnhap.ReportSource = hdnp; this.Hide(); hdn.ShowDialog(); }
public bool CtNhapNl_Insert(CtNhapNguyenLieuDTO ctnhapnl) { try { openConnect(); SqlCommand cmd = new SqlCommand("CTNHAPNL_INSERT", con); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add(new SqlParameter("MANGUYENLIEU", ctnhapnl.MaNl)); cmd.Parameters.Add(new SqlParameter("@SOLUONG", Convert.ToDouble(ctnhapnl.SoLuong))); ///////////////////////////////// DateTime hsd = DateTime.ParseExact(ctnhapnl.HSd, "dd/MM/yyyy", CultureInfo.InvariantCulture); ///////////////////////////////// cmd.Parameters.Add(new SqlParameter("@HANSUDUNG", Convert.ToDateTime(hsd))); cmd.Parameters.Add(new SqlParameter("@DVT", ctnhapnl.DonViTinh)); cmd.Parameters.Add(new SqlParameter("@DONGIA", Convert.ToInt32(ctnhapnl.DonGia))); cmd.ExecuteNonQuery(); closeConnect(); return(true); } catch { return(false); } }
public bool CtNhapNl_Insert(CtNhapNguyenLieuDTO ctnhapnl) { return(ctnhapnl_dal.CtNhapNl_Insert(ctnhapnl)); }