string Luu_Chi_Tiet(Data_QLKDataContext database) { var result = "OK"; var dt = dsNhapKho.CHUNG_TU_CHI_TIET; var id = ""; var row = 0; for (var i = 0; i < dt.Rows.Count; i++) { if (dt.Rows[i].RowState != DataRowState.Deleted) { row++; if (dt.Rows[i]["Ma_Hang_Hoa"] == DBNull.Value) { MessageBox.Show("Vui lòng chọn mặt hàng.", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Warning); result = "Chưa chọn mặt hàng"; gbList.FocusedRowHandle = row; gbList.SetColumnError(colMa_Hang_Hoa, "Chưa chọn mặt hàng"); return result; } if (dt.Rows[i]["Ma_Kho_Hang"] == DBNull.Value) { MessageBox.Show("Chưa chọn kho hàng.", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Warning); result = "Chưa chọn kho hàng"; gbList.FocusedRowHandle = row; gbList.SetColumnError(colMa_Kho_Hang, "Chưa chọn kho hàng"); return result; } id = dt.Rows[i]["Ma_Chi_Tiet"].ToString(); } var dr = dt.Rows[i]; switch (dr.RowState) { case DataRowState.Added: var chung_tu_chi_tiet = new CHUNG_TU_CHI_TIET { Ma_Chi_Tiet = Guid.NewGuid(), Ma_Chung_Tu = txtMaChungTu.Text, Ma_Hang_Hoa = dt.Rows[i]["Ma_Hang_Hoa"].ToString(), Loai_Chung_Tu = 1, //1 nhap kho 2 xuat kho Tinh_Trang = true, //true nhap kho false xuat kho Ma_Kho_Hang = dt.Rows[i]["Ma_Kho_Hang"].ToString(), So_Luong = Convert.ToDecimal(dt.Rows[i]["So_Luong"]), Don_Gia = Convert.ToDecimal(dt.Rows[i]["Don_Gia"]), Thanh_Tien = Convert.ToDecimal(dt.Rows[i]["Thanh_Tien"]), Ghi_Chu = dt.Rows[i]["Ghi_Chu"].ToString(), So_Thu_Tu = 0 }; database.CHUNG_TU_CHI_TIETs.InsertOnSubmit(chung_tu_chi_tiet); break; case DataRowState.Modified: var chi_tiet_sua = (from ctct in database.CHUNG_TU_CHI_TIETs where ctct.Ma_Chi_Tiet == new Guid(id) select ctct).FirstOrDefault(); chi_tiet_sua.Ma_Chi_Tiet = new Guid(id); chi_tiet_sua.Ma_Chung_Tu = txtMaChungTu.Text; chi_tiet_sua.Ma_Hang_Hoa = dt.Rows[i]["Ma_Hang_Hoa"].ToString(); chi_tiet_sua.Loai_Chung_Tu = 1; //1 nhap kho 2 xuat kho chi_tiet_sua.Tinh_Trang = true; //true nhap kho false xuat kho chi_tiet_sua.Ma_Kho_Hang = dt.Rows[i]["Ma_Kho_Hang"].ToString(); chi_tiet_sua.So_Luong = Convert.ToDecimal(dt.Rows[i]["So_Luong"]); chi_tiet_sua.Don_Gia = Convert.ToDecimal(dt.Rows[i]["Don_Gia"]); chi_tiet_sua.Thanh_Tien = Convert.ToDecimal(dt.Rows[i]["Thanh_Tien"]); chi_tiet_sua.Ghi_Chu = dt.Rows[i]["Ghi_Chu"].ToString(); chi_tiet_sua.So_Thu_Tu = 0; break; case DataRowState.Deleted: var chi_tiet_xoa = (from ctct in database.CHUNG_TU_CHI_TIETs where ctct.Ma_Chi_Tiet == new Guid(id) select ctct).FirstOrDefault(); database.CHUNG_TU_CHI_TIETs.DeleteOnSubmit(chi_tiet_xoa); break; } database.SubmitChanges(); } return result; }
partial void UpdateCHUNG_TU_CHI_TIET(CHUNG_TU_CHI_TIET instance);
partial void DeleteCHUNG_TU_CHI_TIET(CHUNG_TU_CHI_TIET instance);
partial void InsertCHUNG_TU_CHI_TIET(CHUNG_TU_CHI_TIET instance);