private void SaveData()
{
clsDM_Kho cls = new clsDM_Kho();
for (int i = fg.Rows.Fixed; i < fg.Rows.Count; i++)
{
if (fg.GetDataDisplay(i, "IsEdit").ToLower() == "")
{
continue;
}
cls.Ten_Kho = fg.GetDataDisplay(i, "Ten_Kho");
cls.SuDung = fg.GetBoolValue(i, "SuDung");
//delete
if (fg.GetDataDisplay(i, "IsEdit") == "0")
{
cls.ID_Kho = int.Parse(fg.GetDataDisplay(i, "ID_Kho"));
cls.TonTai = false;
cls.Update();
}
else if (fg.GetDataDisplay(i, "IsEdit") == "1")
{
cls.TonTai = true;
if (fg.GetDataDisplay(i, "ID_Kho") == "")
{
cls.Insert();
}
else
{
cls.ID_Kho = int.Parse(fg.GetDataDisplay(i, "ID_Kho"));
cls.Update();
}
}
}
BaseMessages.ShowInformationMessage("Cập nhật thành công!");
}
private void Loadfg()
{
fg.Tag = 0;
fg.BeginUpdate();
clsDM_Kho cls = new clsDM_Kho();
DataTable dt = cls.SelectAll();
dt.DefaultView.RowFilter = "TonTai = 1";
int iSTT = 1;
int i = fg.Rows.Fixed;
fg.Rows.Count = fg.Rows.Fixed;
foreach (DataRow dr in dt.DefaultView.ToTable().Rows)
{
fg.Rows.Add();
fg[i, "STT"] = iSTT;
iSTT++;
fg[i, "ID_Kho"] = dr["ID_Kho"];
fg[i, "Ten_Kho"] = dr["Ten_Kho"];
fg[i, "SuDung"] = dr["SuDung"];
fg[i, "TonTai"] = dr["TonTai"];
i++;
}
fg.Row = -1;
fg.AutoSizeRows();
fg.EndUpdate();
fg.Tag = 1;
}
private void LoadKho()
{
clsDM_Kho cls = new clsDM_Kho();
DataTable dt = cls.SelectAll();
dt.DefaultView.RowFilter = "TonTai = 1";
dt.DefaultView.Sort = "ID_Kho ASC";
cboKho.Properties.DataSource = dt;
cboKho.Properties.DisplayMember = "Ten_Kho";
cboKho.Properties.ValueMember = "ID_Kho";
}
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 LoadKho()
{
var cmb = cboKhoXuat;
cmb.Tag = 0;
clsDM_Kho cls = new clsDM_Kho();
DataTable dt = cls.SelectAll();
dt.DefaultView.RowFilter = "TonTai = 1";
dt.DefaultView.Sort = "ID_Kho ASC";
dt = dt.DefaultView.ToTable();
cmb.Properties.DataSource = dt;
cmb.Properties.DisplayMember = "Ten_Kho";
cmb.Properties.ValueMember = "ID_Kho";
cmb.EditValue = 0;
cmb.Tag = 1;
}
private void Load_cmbKho()
{
var cmb = cmbKho;
cmb.Tag = 0;
clsDM_Kho cls = new clsDM_Kho();
DataTable dt = cls.SelectAll();
if (dt.Rows.Count > 0)
{
dt.Rows.Add(0, "Tất cả", 1, 1);
}
dt.DefaultView.RowFilter = "TonTai = 1";
dt.DefaultView.Sort = "ID_Kho ASC";
cmb.Properties.DataSource = dt;
cmb.Properties.DisplayMember = "Ten_Kho";
cmb.Properties.ValueMember = "ID_Kho";
cmb.EditValue = 0;
cmb.Tag = 1;
}
private void btnXuatKho_Click(object sender, EventArgs e)
{
if (int.Parse(cmbKho.EditValue.ToString()) == 0)
{
BaseMessages.ShowWarningMessage("Chọn kho để xuất kho");
return;
}
m_bFlag = false;
LockEdit(false);
LockEditXuatKho(false);
//Loadfg
fg.BeginUpdate();
for (int i = fg.Rows.Fixed; i < fg.Rows.Count; i++)
{
fg.Rows[i]["Chon"] = false;
}
clsDM_Kho clsKho = new clsDM_Kho();
DataTable dtKho = clsKho.SelectAll();
dtKho.DefaultView.RowFilter = "ID_Kho <> " + cmbKho.EditValue.ToString() + " AND TonTai = 1";
dtKho = dtKho.DefaultView.ToTable();
ListDictionary datamap = new ListDictionary();
for (int i = 0; i <= dtKho.Rows.Count - 1; i++)
{
datamap.Add(dtKho.Rows[i][0], dtKho.Rows[i][1]);
}
fg.Cols["ID_KhoXuat"].DataMap = datamap;
fg.Row = -1;
fg.AutoSizeRows();
fg.EndUpdate();
}
