private void cbMaVatTu_SelectedIndexChanged(object sender, EventArgs e)
{
DataTable table = new clsDMVatTu().getThongTinTuMaVT(cbMaVatTu.GetItemText(this.cbMaVatTu.SelectedItem));// cbMaVatTu.Text);
if (table.Rows.Count == 0)
return;
cbTenVatTu.Text = table.Rows[0]["ten_vat_tu"].ToString();
}
public void Init()
{
cbMaVatTu.AutoCompleteMode = AutoCompleteMode.SuggestAppend;
cbMaVatTu.AutoCompleteSource = AutoCompleteSource.CustomSource;
clsDMVatTu vt = new clsDMVatTu();
clsGiaoDienChung.initCombobox(cbMaVatTu, new clsDMVatTu(), "Ma_vat_tu", "ID_Vat_tu", "Ma_vat_tu");
clsGiaoDienChung.initCombobox(cbTenVatTu, new clsDMVatTu(), "Ten_vat_tu", "ID_Vat_tu", "Ten_vat_tu");
clsGiaoDienChung.initCombobox(cbChatLuong, new clsDMChatLuong(), "Loai_chat_luong", "ID_chat_luong", "Loai_chat_luong");
cbMaVatTu.SelectedIndex = -1;
}
private void cbTenVatTu_SelectedIndexChanged(object sender, EventArgs e)
{
clsDMVatTu vattu = new clsDMVatTu();
string Ma_Vat_Tu = vattu.getMaVatTu(cbTenVatTu.GetItemText(this.cbTenVatTu.SelectedItem));
cbMaVatTu.Text = Ma_Vat_Tu;
DataTable table = vattu.getData_By_MaVatTu(Ma_Vat_Tu);
if (table.Rows.Count == 0)
return;
cbMaVatTu.Text = table.Rows[0]["ma_vat_tu"].ToString();
}
private void btnGridSave_Click(object sender, EventArgs e)
{
try
{
Int32 selectedRowCount = gridMaster.CurrentCell.RowIndex;
if (dataTable1.Rows.Count == 0 || selectedRowCount >= dataTable1.Rows.Count)
return;
if (PanelButton.getClickStatus() == enumButton2.SuaLuoi)
{
gridMaster.Rows[selectedRowCount].Cells["ma_vat_tu"].Value = cbMaVatTu.Text;
gridMaster.Rows[selectedRowCount].Cells["ten_vat_tu"].Value = cbTenVatTu.Text;
gridMaster.Rows[selectedRowCount].Cells["ten_don_vi_tinh"].Value = txtDVT.Text;
gridMaster.Rows[selectedRowCount].Cells["chat_luong"].Value = cbChatLuong.Text;
gridMaster.Rows[selectedRowCount].Cells["ID_chat_luong"].Value = cbChatLuong.SelectedValue;
// gridMaster.Rows[selectedRowCount].Cells["so_luong_yeu_cau"].Value = txtSLYC.Text;
gridMaster.Rows[selectedRowCount].Cells["so_luong_thuc_lanh"].Value = txtSLTX.Text;
gridMaster.Rows[selectedRowCount].Cells["don_gia"].Value = txtDonGia.Text;
clsDMVatTu vt = new clsDMVatTu();
DataTable temp = vt.GetAll(cbMaVatTu.Text);
gridMaster.Rows[selectedRowCount].Cells["ID_don_vi_tinh"].Value = temp.Rows[0]["ID_Don_vi_tinh"];
if (txtDonGia.Text == "")
txtDonGia.Text = "0";
gridMaster.Rows[selectedRowCount].Cells["thanh_tien"].Value =double.Parse( txtDonGia.Text)*int.Parse(txtSLTX.Text);
PanelButton.setClickStatus( sttaf);
}
if (PanelButton.getClickStatus() == enumButton2.XoaLuoi)
{
dataTable1.Rows.RemoveAt(selectedRowCount);
PanelButton.setClickStatus(sttaf);
}
setInputComponentStatus(true);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private void btnGridAdd_Click(object sender, EventArgs e)
{
try
{
if(cbKhoNhan.Text =="")
{
MessageBox.Show("vui lòng chọn kho trước khi cho mượn vật tư");
return;
}
sttaf = PanelButton.getClickStatus();
if (cbMaVatTu.Text == "" || cbTenVatTu.Text == "" || cbChatLuong.Text == "")
{
MessageBox.Show("Mã vật tư và tên vật tư không được rỗng, Chất lượng bắt buộc nhập !");
return;
}
if (isLoaiPhieu == "KNMN" || isLoaiPhieu == "KCTN")
{
clsTonKho checkton = new clsTonKho();
decimal temp = checkton.checkSLTonChoMuon((int)cbKhoNhan.SelectedValue, cbMaVatTu.Text, (int)cbChatLuong.SelectedValue, int.Parse(txtSLTX.Text));
if (temp < int.Parse(txtSLTX.Text))
{
MessageBox.Show("Số lượng vật tư mượn phải nhỏ hơn số lượng trong kho,Không thể cho mượn đối với vật tư này!Số lượng còn lại trong kho: "+ temp );
return;
}
}
DataRow[] result = dataTable1.Select("Ma_vat_tu =" + cbMaVatTu.Text +" and ID_chat_luong =" +cbChatLuong.SelectedValue );
if (result.Length == 0)
{
try
{
DataRow dr = dataTable1.NewRow();
dr["Ma_vat_tu"] = cbMaVatTu.Text;
dr["ten_vat_tu"] = cbTenVatTu.Text;
dr["Ten_don_vi_tinh"] = txtDVT.Text;
dr["chat_luong"] = cbChatLuong.Text;
dr["ID_chat_luong"] = cbChatLuong.SelectedValue;
// dr["so_luong_yeu_cau"] = txtSLYC.Text;
dr["so_luong_thuc_lanh"] = txtSLTX.Text;
dr["don_gia"] = txtDonGia.Text;
clsDMVatTu vt = new clsDMVatTu();
DataTable temp = vt.GetAll(cbMaVatTu.Text);
dr["ID_don_vi_tinh"] = temp.Rows[0]["ID_Don_vi_tinh"];
if (txtDonGia.Text == "")
txtDonGia.Text = "0";
dr["thanh_tien"] = double.Parse(txtDonGia.Text) * double.Parse(txtSLTX.Text) == 0;
dataTable1.Rows.Add(dr);
ResetGridInputForm();
PanelButton.setClickStatus(sttaf);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
else
MessageBox.Show("Đã tồn tại mã vật tư này rồi !");
// gridMaster.SelectedRows.
}
catch (Exception ex)
{
MessageBox.Show(Utilities.clsThamSoUtilities.COException(ex));
}
}
private void initVatTuData()
{
Int32 selectedRowCount = gridMaster.CurrentCell.RowIndex;
string Ma_Vat_Tu = cbMaVatTu.GetItemText(cbMaVatTu.SelectedItem);
clsDMVatTu vattu = new clsDMVatTu();
string Ten_Vat_Tu = vattu.getTenVatTu(Ma_Vat_Tu);
cbTenVatTu.Text = Ten_Vat_Tu;
DataTable tb = vattu.getData_By_MaVatTu(Ma_Vat_Tu);
txtDVT.Text = tb.Rows[0]["Ten_don_vi_tinh"].ToString();
txtDonGia.Text = gridMaster.Rows[selectedRowCount].Cells["Don_gia"].Value.ToString();// tb.Rows[0]["Don_gia"].ToString();
cbChatLuong.Text = gridMaster.Rows[selectedRowCount].Cells["chat_luong"].Value.ToString();
}
private void cbMaVatTu_SelectionChangeCommitted(object sender, EventArgs e)
{
try
{
ComboBox c = (ComboBox)sender;
//DataRowView dtv = c.Items[c.SelectedIndex] as DataRowView ;
string Ma_Vat_Tu = c.GetItemText(c.SelectedItem);
clsDMVatTu vattu = new clsDMVatTu();
string Ten_Vat_Tu = vattu.getTenVatTu(Ma_Vat_Tu);
cbTenVatTu.Text = Ten_Vat_Tu;
DataTable tb = vattu.getData_By_MaVatTu(Ma_Vat_Tu);
txtDVT.Text = tb.Rows[0]["Ten_don_vi_tinh"].ToString();
txtDonGia.Text = tb.Rows[0]["Don_gia"].ToString();
}
catch (Exception ex) { }
}
private void gridMaster_EditingControlShowing_1(object sender, DataGridViewEditingControlShowingEventArgs e)
{
try
{
int row = gridMaster.CurrentCell.RowIndex;
int column = gridMaster.CurrentCell.ColumnIndex;
string headerText = gridMaster.Columns[column].Name;
if (headerText.Equals("Ma_vat_tu"))
{
TextBox tb = e.Control as TextBox;
clsDMVatTu vattu = new clsDMVatTu();
if (tb != null)
{
tb.AutoCompleteMode = AutoCompleteMode.SuggestAppend;
tb.AutoCompleteCustomSource = vattu.getListToCombobox("ma_vat_tu");// AutoCompleteLoad;
tb.AutoCompleteSource = AutoCompleteSource.CustomSource;
}
}
if (headerText.Equals("Chat_luong"))
{
TextBox tb = e.Control as TextBox;
clsDMChatLuong cl = new clsDMChatLuong();
if (tb != null)
{
tb.AutoCompleteMode = AutoCompleteMode.SuggestAppend;
tb.AutoCompleteCustomSource = cl.getListToCombobox("loai_chat_luong");// AutoCompleteLoad;
tb.AutoCompleteSource = AutoCompleteSource.CustomSource;
}
}
if (headerText.Equals("Ten_vat_tu"))
{
TextBox tb = e.Control as TextBox;
clsDMVatTu cl = new clsDMVatTu();
if (tb != null)
{
tb.AutoCompleteMode = AutoCompleteMode.SuggestAppend;
tb.AutoCompleteCustomSource = cl.getListToCombobox("Ten_vat_tu");// AutoCompleteLoad;
tb.AutoCompleteSource = AutoCompleteSource.CustomSource;
}
}
}
catch (Exception ex) { MessageBox.Show(ex.Message); }
}
private void btnGridAdd_Click(object sender, EventArgs e)
{
try
{
sttaf = PanelButton.getClickStatus();
if ((double.Parse(txtSLYC.Text)) < 0 || (double.Parse(txtSLTX.Text)) < 0)
{
MessageBox.Show("Số lượng vật tư không được phép giá trị âm !");
return;
}
if (cbMaVatTu.Text == "" || cbTenVatTu.Text == "" || cbChatLuong.Text == "")
{
MessageBox.Show("Mã vật tư và tên vật tư không được rỗng, Chất lượng bắt buộc nhập !");
return;
}
DataRow[] result = dataTable1.Select("Ma_vat_tu =" + cbMaVatTu.Text + " and ID_chat_luong =" + cbChatLuong.SelectedValue);
if (result.Length == 0)
{
try
{
DataRow dr = dataTable1.NewRow();
dr["Ma_vat_tu"] = cbMaVatTu.Text;
dr["ten_vat_tu"] = cbTenVatTu.Text;
dr["Ten_don_vi_tinh"] = txtDVT.Text;
dr["chat_luong"] = cbChatLuong.Text;
dr["ID_chat_luong"] = cbChatLuong.SelectedValue;
dr["so_luong_yeu_cau"] = txtSLYC.Text;
dr["so_luong_thuc_lanh"] = txtSLTX.Text;
dr["don_gia"] = txtDonGia.Text;
clsDMVatTu vt = new clsDMVatTu();
DataTable temp = vt.GetAll(cbMaVatTu.Text);
dr["ID_don_vi_tinh"] = temp.Rows[0]["ID_Don_vi_tinh"];
if (txtDonGia.Text == "")
txtDonGia.Text = "0";
dr["thanh_tien"] = double.Parse(txtDonGia.Text) * double.Parse(txtSLTX.Text) == 0;
dataTable1.Rows.Add(dr);
ResetGridInputForm();
PanelButton.setClickStatus(sttaf);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
else
MessageBox.Show("Đã tồn tại mã vật tư này rồi !");
// gridMaster.SelectedRows.
}
catch (Exception ex)
{
MessageBox.Show(Utilities.clsThamSoUtilities.COException(ex));
}
}
private void init_cbTenVatTu_ALL()
{
cbTenVatTu.AutoCompleteMode = AutoCompleteMode.SuggestAppend;
cbTenVatTu.AutoCompleteSource = AutoCompleteSource.CustomSource;
clsDMVatTu vt = new clsDMVatTu();
AutoCompleteStringCollection combData1 = vt.getListTenVatTu();
cbTenVatTu.AutoCompleteCustomSource = combData1;
cbTenVatTu.DataSource = vt.getAll_Ma_Ten_VatTu();
cbTenVatTu.ValueMember = "ID_Vat_tu";
cbTenVatTu.DisplayMember = "Ten_vat_tu";
cbTenVatTu.SelectedIndex = -1;
}
/// <summary>
/// txtSL:
/// [ ] Nếu ko mượn vt từ kho khác, luôn lấy SL từ kho xuất
/// </summary>
private void setInfoVatTu(string ID_Vat_tu)
{
clsDMVatTu vt = new clsDMVatTu();
txtDVT.Text = vt.getDVT_from_IDVT(ID_Vat_tu);
//txtSL.Text = "-";
////txtSL
//string ID_Kho = "";
//if (chkboxEnableMuonVT.Checked)
//{
// ID_Kho = cbMuonVTTaiKho.SelectedValue.ToString();
//}
//else
//{
// ID_Kho = cbKhoXuat.SelectedValue.ToString();
//}
//if (Int32.Parse(ID_Kho) >= 0)
//{
// string Ma_vat_tu = vt.getMaVT_from_IDVT(ID_Vat_tu);
// //clsTonKho TonKho = new clsTonKho();
// //txtSL.Text = TonKho.getSL_from_MaVatTu(Ma_vat_tu, ID_Kho);
//}
}
/// <summary>
/// hàm này tiến hành cập nhật lại CSDL rất lớn liên quang 5000 dòng
///
/// </summary>
public void ChuyenDoi()
{
DatabaseHelper help = new DatabaseHelper();
help.ConnectDatabase();
// insert
using (var dbcxtransaction = help.ent.Database.BeginTransaction())
{
try
{
for (int i = 0; i < tb.Rows.Count - 1; i++)
{
string Ma_phieu_nhap = tb.Rows[i]["column1"].ToString();
DateTime Ngay_lap = DateTime.Parse(tb.Rows[i]["column2"].ToString());
string Kho_nhan = tb.Rows[i]["column3"].ToString();
string Ly_do = tb.Rows[i]["column4"].ToString();
string Ma_vat_tu = tb.Rows[i]["column5"].ToString();
string Ten_vat_tu = tb.Rows[i]["column6"].ToString();
string Chat_luong = tb.Rows[i]["column7"].ToString();
string DVT = tb.Rows[i]["column8"].ToString();
string So_luong_thuc_lanh = tb.Rows[i]["column9"].ToString();
string Don_gia = tb.Rows[i]["column10"].ToString();
string Thanh_tien = tb.Rows[i]["column11"].ToString();
clsPhieuNhapKho pnk = new clsPhieuNhapKho();
if (pnk.CheckTonTaiSoDK(Ma_phieu_nhap, help) == false)
{
pnk.Ma_phieu_nhap = Ma_phieu_nhap;
pnk.isGoiDau = rdoPhieuGoiDau.Checked;
pnk.isCanTru = false;
pnk.Ngay_lap = Ngay_lap;
pnk.Kho_nhan = Kho_nhan;
pnk.Ly_do = Ly_do;
clsLoaiPhieuNhap LPN = new clsLoaiPhieuNhap();
LPN.Ma_LPN = Loai_PN;
pnk.ID_Loai_Phieu_Nhap = LPN.GetFirst(help);
pnk.ID_khoNhan = idkho;
if ( pnk.Insert(help) == 0)
{
dbcxtransaction.Rollback();
MessageBox.Show("insert thất bại tại dòng !" + i);
return;
}
}
clsChi_Tiet_Phieu_Nhap_Vat_Tu ctpn = new clsChi_Tiet_Phieu_Nhap_Vat_Tu();
ctpn.Ma_vat_tu = Ma_vat_tu;
ctpn.Ma_phieu_nhap = Ma_phieu_nhap;
ctpn.ID_Chat_luong = Chat_luong.Contains("mới") ? 1 : 2;
//kiểm tra xem vật tư đã có trong csdl chưa nếu chưa thêm vào
clsDM_DonViTinh DMDVT = new clsDM_DonViTinh();
if (ctpn.CheckTonTaiSoDK(help) == false)
{
DMDVT.Ten_don_vi_tinh = DVT;
if (DMDVT.hasDuplicateRow(help) == false)
{
//nếu chưa có thì insert dòng mới
DMDVT.Insert(help);
}
//tiến hành insert 5000 dòng dữ liệu từ phiếu nhập
}
ctpn.ID_Don_vi_tinh = DMDVT.getMATuTen(DVT, help);
//kiểm tra mã vật tư đã tồn tại chưa trong CSDL
clsDMVatTu vt = new clsDMVatTu();
vt.Ma_vat_tu = Ma_vat_tu;
vt.Ten_vat_tu = Ten_vat_tu;
vt.ID_Don_vi_tinh = ctpn.ID_Don_vi_tinh;
if (vt.KiemTraTrungMa(help) == false)
{
vt.Insert(help);
}
ctpn.So_luong_thuc_lanh = decimal.Parse(So_luong_thuc_lanh);
ctpn.Insert(help);
backgroundWorker1.ReportProgress(i);
}
dbcxtransaction.Commit();
backgroundWorker1.ReportProgress(0);
MessageBox.Show("Thêm thành công!");
}
catch (Exception ex)
{
dbcxtransaction.Rollback(); // Get stack trace for the exception with source file information
MessageBox.Show(Utilities.clsThamSoUtilities.COException(ex));
return;
}
}
}
/// <summary>
/// Initializes --> combobox kho nhap.
/// </summary>
private void initTenVatTu()
{
clsDMVatTu DMVatTu = new clsDMVatTu();
cbTenVatTu.DisplayMember = "Ten_vat_tu";
cbTenVatTu.ValueMember = "id";
cbTenVatTu.DataSource = DMVatTu.GetAll_for_cb();
cbTenVatTu.SelectedIndex = -1;
}
private void cbMaVatTu_KeyDown(object sender, KeyEventArgs e)
{
try
{
DataTable table = new clsDMVatTu().getThongTinTuMaVT(cbMaVatTu.GetItemText(this.cbMaVatTu.SelectedItem));// cbMaVatTu.Text);
if (table.Rows.Count == 0)
return;
cbTenVatTu.Text = table.Rows[0]["ten_vat_tu"].ToString();
int iddvt = int.Parse(table.Rows[0]["ID_don_vi_tinh"].ToString());
clsDM_DonViTinh dvt = new clsDM_DonViTinh();
string tenDVT = dvt.getTenDVTTuMa(iddvt);
txtDVT.Text = tenDVT;
}
catch (Exception ex) { MessageBox.Show(Utilities.clsThamSoUtilities.COException(ex)); }
}
private void cbTenVatTu_SelectionChangeCommitted(object sender, EventArgs e)
{
try
{
ComboBox c = (ComboBox)sender;
string Ten_Vat_Tu = c.GetItemText(c.SelectedItem);
clsDMVatTu vattu = new clsDMVatTu();
string Ma_Vat_Tu = vattu.getMaVatTu(Ten_Vat_Tu);
cbMaVatTu.Text = Ma_Vat_Tu;
DataTable tb = vattu.getData_By_MaVatTu(Ma_Vat_Tu);
txtDVT.Text = tb.Rows[0]["Ten_don_vi_tinh"].ToString();
txtDonGia.Text = tb.Rows[0]["Don_gia"].ToString();
txtSoLuongTon.Text = new clsTonKho().checkKho_VatTu((int)cbKhoNhan.SelectedValue, cbMaVatTu.Text, (int)cbChatLuong.SelectedValue).ToString();
}
catch (Exception ex) { }
}
private void gridMaster_CellEndEdit(object sender, DataGridViewCellEventArgs e)
{
try
{
int column = gridMaster.CurrentCell.ColumnIndex;
string forcus = gridMaster.Columns[column].Name;
int row = gridMaster.CurrentCell.RowIndex;
if (forcus.ToLower().Equals("ma_vat_tu"))
{
clsDMVatTu vattu = new clsDMVatTu();
string mavattu = gridMaster.Rows[row].Cells["Ma_vat_tu"].Value.ToString();
DataTable temp = vattu.getData_By_MaVatTu(mavattu);
if (temp == null)
return;
gridMaster.Rows[row].Cells["Ten_vat_tu"].Value = temp.Rows[0]["ten_vat_tu"];
gridMaster.Rows[row].Cells["Ten_don_vi_tinh"].Value = temp.Rows[0]["Ten_don_vi_tinh"];
gridMaster.Rows[row].Cells["Don_gia"].Value = temp.Rows[0]["Don_gia"];
gridMaster.Rows[row].Cells["id_don_vi_tinh"].Value = temp.Rows[0]["id_don_vi_tinh"];
}
if (forcus.ToLower().Equals("ten_vat_tu"))
{
clsDMVatTu vattu = new clsDMVatTu();
string tenvattu = gridMaster.Rows[row].Cells["Ten_vat_tu"].Value.ToString();
DataTable temp = vattu.getTenVatTuData(tenvattu);
if (temp == null)
return;
gridMaster.Rows[row].Cells["Ma_vat_tu"].Value = temp.Rows[0]["Ma_vat_tu"];
gridMaster.Rows[row].Cells["Ten_don_vi_tinh"].Value = temp.Rows[0]["Ten_don_vi_tinh"];
gridMaster.Rows[row].Cells["Don_gia"].Value = temp.Rows[0]["Don_gia"];
gridMaster.Rows[row].Cells["id_don_vi_tinh"].Value = temp.Rows[0]["id_don_vi_tinh"];
}
// gridMaster.Rows[row].Cells["Chat_luong"].Selected = true;
//gridMaster.CurrentCell = gridMaster.Rows[row].Cells["Chat_luong"];
//gridMaster.BeginEdit(true);
//gridMaster.CurrentCell.Selected = true;
clsDMChatLuong cl = new clsDMChatLuong();
string ten_chat_luong = gridMaster.Rows[row].Cells["chat_luong"].Value == null ? "" : gridMaster.Rows[row].Cells["chat_luong"].Value.ToString();
if (ten_chat_luong != "")
{
gridMaster.Rows[row].Cells["id_chat_luong"].Value = cl.getIDChatLuong(ten_chat_luong);
}
}
catch (Exception ex) { }
}
private void cbMaVatTu_SelectedIndexChanged(object sender, EventArgs e)
{
try
{
DataTable table = new clsDMVatTu().getThongTinTuMaVT(cbMaVatTu.GetItemText(this.cbMaVatTu.SelectedItem));// cbMaVatTu.Text);
if (table.Rows.Count == 0)
return;
cbTenVatTu.Text = table.Rows[0]["ten_vat_tu"].ToString();
}
catch (Exception ex) { MessageBox.Show(Utilities.clsThamSoUtilities.COException(ex)); }
}
private void cbTenVatTu_SelectionChangeCommitted(object sender, EventArgs e)
{
clsDMVatTu vattu = new clsDMVatTu();
string Ma_Vat_Tu = vattu.getMaVatTu(cbTenVatTu.GetItemText(this.cbTenVatTu.SelectedItem));
cbMaVatTu.Text = Ma_Vat_Tu;
DataTable table = vattu.getData_By_MaVatTu(Ma_Vat_Tu);
if (table.Rows.Count == 0)
return;
cbMaVatTu.Text = table.Rows[0]["ma_vat_tu"].ToString();
int iddvt = int.Parse(table.Rows[0]["ID_don_vi_tinh"].ToString());
clsDM_DonViTinh dvt = new clsDM_DonViTinh();
string tenDVT = dvt.getTenDVTTuMa(iddvt);
txtDVT.Text = tenDVT;
}
