//Cach 1
private void CapNhatSLVatTuKhoVer1(int ID_QuyetDinh, byte trangthai)
{
clsQD_NhapVatTu_ChiTiet clsChiTiet = new clsQD_NhapVatTu_ChiTiet();
clsKho_VatTu clsKVT = new clsKho_VatTu();
DataTable dt = clsChiTiet.SelectAllW_ID_QuyetDinh(ID_QuyetDinh);
foreach (DataRow dr in dt.Rows)
{
clsKVT.ID_Kho = Convert.ToInt32(dr["ID_Kho"]);
clsKVT.ID_VatTu = Convert.ToInt32(dr["ID_VatTu"]);
bool bInsert = clsKVT.SelectOne().Rows.Count == 0;
if (trangthai == 5)
{
if (bInsert)
{
clsKVT.SoLuong = Convert.ToInt32(dr["SoLuong"]);
clsKVT.Insert();
}
else
{
clsKVT.SoLuong = clsKVT.SoLuong + Convert.ToInt32(dr["SoLuong"]);
clsKVT.Update();
}
}
else if (trangthai == 3)
{
clsKVT.SoLuong = clsKVT.SoLuong - Convert.ToInt32(dr["SoLuong"]);
clsKVT.Update();
}
}
}
private void Loadfg()
{
fg.Tag = 0;
fg.BeginUpdate();
clsQD_NhapVatTu_ChiTiet cls = new clsQD_NhapVatTu_ChiTiet();
Byte loai = 0; //dang xem
if (!btnCapNhat.Visible)
{
loai = 1; //dang cap nhat
}
if (m_byTrangthai == 1 || m_byTrangthai == 5)
{
loai = 0;
}
int iSTT = 1;
fg.Rows.Count = fg.Rows.Fixed;
DataTable dt = cls.Select_DS_VatTu(m_iID_QuyetDinh, m_iID_NhaCungCap, loai);
foreach (DataRow dr in dt.DefaultView.ToTable().Rows)
{
Row fgRow = fg.Rows.Add();
fgRow["STT"] = iSTT;
iSTT++;
fgRow["ID_QuyetDinh"] = dr["ID_QuyetDinh"];
fgRow["Chon"] = dr["Chon"];
fgRow["ID_VatTu"] = dr["ID_VatTu"];
fgRow["Ten_VatTu"] = dr["Ten_VatTu"];
fgRow["ID_Kho"] = dr["ID_Kho"];
fgRow["SoLuong"] = dr["SoLuong"];
}
clsDM_Kho clsKho = new clsDM_Kho();
DataTable dtKho = clsKho.SelectAll();
dtKho.DefaultView.RowFilter = "TonTai = 1";
ListDictionary datamap = new ListDictionary();
for (int i = 0; i <= dtKho.DefaultView.ToTable().Rows.Count - 1; i++)
{
datamap.Add(dtKho.Rows[i][0], dtKho.Rows[i][1]);
}
fg.Cols["ID_Kho"].DataMap = datamap;
fg.Row = -1;
fg.AutoSizeRows();
fg.AutoSizeCols();
fg.EndUpdate();
fg.Tag = 1;
}
private void SaveDataChiTiet(int ID_QuyetDinh)
{
//Save data chi tiet
clsQD_NhapVatTu_ChiTiet clsChiTiet = new clsQD_NhapVatTu_ChiTiet();
clsChiTiet.ID_QuyetDinh = Convert.ToInt32(ID_QuyetDinh);
clsChiTiet.DeleteWID_QuyetDinhLogic();
for (int i = fgChiTiet.Rows.Fixed; i < fgChiTiet.Rows.Count; i++)
{
if (fgChiTiet.GetBoolValue(i, "Chon"))
{
clsChiTiet.ID_VatTu = fgChiTiet.GetIntValue(i, "ID_VatTu");
clsChiTiet.ID_Kho = fgChiTiet.GetIntValue(i, "ID_Kho");
clsChiTiet.SoLuong = fgChiTiet.GetIntValue(i, "SoLuong");
clsChiTiet.Insert();
}
}
}
//Cach 3
private void CapNhatSLVatTuKhoVer3(int ID_QuyetDinh, byte trangthai)
{
clsQD_NhapVatTu_ChiTiet clsChiTiet = new clsQD_NhapVatTu_ChiTiet();
clsKho_VatTu clsKVT = new clsKho_VatTu();
DataTable dt = clsChiTiet.SelectAllW_ID_QuyetDinh(ID_QuyetDinh);
foreach (DataRow dr in dt.Rows)
{
if (trangthai == 5)
{
clsKVT.Update_SoLuongVer3(Convert.ToInt32(dr["ID_Kho"]), Convert.ToInt32(dr["ID_VatTu"]), Convert.ToInt32(dr["SoLuong"]));
}
else if (trangthai == 3)
{
clsKVT.Update_SoLuongVer3(Convert.ToInt32(dr["ID_Kho"]), Convert.ToInt32(dr["ID_VatTu"]), (-1) * Convert.ToInt32(dr["SoLuong"]));
}
}
}
private void btnLuu_Click(object sender, EventArgs e)
{
if (!IsValid())
{
return;
}
clsQD_NhapVatTu_ChiTiet cls = new clsQD_NhapVatTu_ChiTiet();
cls.ID_QuyetDinh = m_iID_QuyetDinh;
cls.DeleteWID_QuyetDinhLogic();
for (int i = fg.Rows.Fixed; i < fg.Rows.Count; i++)
{
if (fg.GetBoolValue(i, "Chon"))
{
cls.ID_VatTu = fg.GetIntValue(i, "ID_VatTu");
cls.ID_Kho = fg.GetIntValue(i, "ID_Kho");
cls.SoLuong = fg.GetIntValue(i, "SoLuong");
cls.Insert();
}
}
BaseMessages.ShowInformationMessage("Cập nhật thành công!");
LockEdit(true);
Loadfg();
}
private void LoadfgChiTiet(int ID_QuyetDinh, int ID_NhaCungCap)
{
//if (fgQD.Row < fgQD.Rows.Fixed)
//{
// return;
//}
var fg = fgChiTiet;
fg.Tag = 0;
fg.BeginUpdate();
int iSTT = 1;
fg.Rows.Count = fg.Rows.Fixed;
if (ID_QuyetDinh != 0) //Xem/Sua
{
clsQD_NhapVatTu_ChiTiet cls = new clsQD_NhapVatTu_ChiTiet();
Byte byLoai = 0; //dang xem
if (!btnSua.Visible)
{
byLoai = 1; //dang cap nhat
}
DataTable dt = cls.Select_DS_VatTuVer2(ID_QuyetDinh, ID_NhaCungCap, byLoai);
foreach (DataRow dr in dt.Rows)
{
Row fgRow = fg.Rows.Add();
fgRow["STT"] = iSTT;
iSTT++;
fgRow["ID_QuyetDinh"] = dr["ID_QuyetDinh"];
fgRow["Chon"] = dr["Chon"];
fgRow["ID_VatTu"] = dr["ID_VatTu"];
fgRow["Ten_VatTu"] = dr["Ten_VatTu"];
fgRow["ID_Kho"] = dr["ID_Kho"];
fgRow["Ten_Kho"] = dr["Ten_Kho"];
fgRow["SoLuong"] = dr["SoLuong"];
}
}
else //ID_QuyetDinh = 0, Them moi' QD
{
clsDM_VatTu cls = new clsDM_VatTu();
DataTable dt = cls.SelectVatTuWithID_NhaCungCap(ID_NhaCungCap);
foreach (DataRow dr in dt.Rows)
{
Row fgRow = fg.Rows.Add();
fgRow["STT"] = iSTT;
iSTT++;
fgRow["Chon"] = false;
fgRow["ID_VatTu"] = dr["ID_VatTu"];
fgRow["Ten_VatTu"] = dr["Ten_VatTu"];
fgRow["ID_Kho"] = dr["ID_Kho"];
fgRow["Ten_Kho"] = dr["Ten_Kho"];
}
}
//
//Tao combobox chon. Kho
//
//clsDM_Kho clsKho = new clsDM_Kho();
//DataTable dtKho = clsKho.SelectAll();
//dtKho.DefaultView.RowFilter = "TonTai = 1";
//ListDictionary datamap = new ListDictionary();
//for (int i = 0; i <= dtKho.DefaultView.ToTable().Rows.Count - 1; i++)
//{
// datamap.Add(dtKho.Rows[i][0], dtKho.Rows[i][1]);
//}
//fg.Cols["ID_Kho"].DataMap = datamap;
//
//
fg.Row = -1;
fg.AutoSizeRows();
fg.EndUpdate();
fg.Tag = 1;
}