private void btn_hoantat_Click(object sender, EventArgs e)
{
DONDATHANG dh = new DONDATHANG();
dh.IDNCC = int.Parse(cbbncc.SelectedValue.ToString());
dh.NGAYDAT = DateTime.Today;
dh.IDNGUOIDAT = FormMain.currentuser;
dh.TONGCONG = int.Parse(txt_tongtien.Text.ToString());
dh.TRANGTHAI = false;
DONDATHANGBUS bus = new DONDATHANGBUS();
List <CT_DONDATHANG> ctddh = new List <CT_DONDATHANG>();
foreach (DataGridViewRow row in dgvphieudat.Rows)
{
CT_DONDATHANG ct = new CT_DONDATHANG();
ct.IDSANPHAM = int.Parse(row.Tag.ToString());
ct.SL = int.Parse(row.Cells[1].Value.ToString());
ct.DONGIA = int.Parse(row.Cells[2].Value.ToString());
ct.TONG = int.Parse(row.Cells[3].Value.ToString());
ct.SL_NHAP = 0;
ctddh.Add(ct);
}
if (bus.Insert(dh, ctddh))
{
MessageBox.Show("đã lưu đơn hàng");
}
else
{
MessageBox.Show(DONDATHANGDAO.error_message);
}
}
private void btn_Them_Click(object sender, EventArgs e)
{
if (txt_mactddh.Text == "" || txt_soluong.Text == "" || txt_madonhang.Text == "")
{
MessageBox.Show("Không được để trống");
return;
}
//kiểm tra trùng
CT_DONDATHANG bb = new CT_DONDATHANG();
var kt = from s in ql.CT_DONDATHANGs where s.MA_CTDDH == txt_mactddh.Text select s;
if (kt.Count() > 0)
{
MessageBox.Show("Trùng khóa chính");
return;
}
bb.MA_CTDDH = txt_mactddh.Text;
bb.SOLUONGDAT = Convert.ToInt32(txt_soluong.Text);
bb.MADH = txt_madonhang.Text;
bb.MASP = cbo_tensp.SelectedValue.ToString();
ql.CT_DONDATHANGs.InsertOnSubmit(bb);
ql.SubmitChanges();
insert();
MessageBox.Show("Thành công");
}
private void btn_hoantat_Click(object sender, EventArgs e)
{
int index = donnhapgv.CurrentCell.RowIndex;
int madh = int.Parse(donnhapgv[0, index].Value.ToString());
int index_ct = nhapkhogv.CurrentCell.RowIndex;
List <CT_DONDATHANG> ctddh = new List <CT_DONDATHANG>();
foreach (DataGridViewRow row in nhapkhogv.Rows)
{
CT_DONDATHANG ct = new CT_DONDATHANG();
ct.IDDONDAT = madh;
ct.IDSANPHAM = int.Parse(nhapkhogv[5, index_ct].Value.ToString());
ct.SL_NHAP = int.Parse(nhapkhogv[1, index_ct].Value.ToString());
ctddh.Add(ct);
}
DONDATHANGBUS bus = new DONDATHANGBUS();
if (bus.Update(madh, ctddh))
{
MessageBox.Show("Cập nhật thành công!");
btn_laydulieu.PerformClick();
}
}
