void dgvEditCt_CellValidated(object sender, DataGridViewCellEventArgs e)
{ //Cai dat cac ham tinh toan
dgvVoucher dgvEditCt = (dgvVoucher)sender;
if (this.ActiveControl != dgvEditCt)
{
return;
}
drCurrent = ((DataRowView)bdsEditCt.Current).Row;
DataGridViewCell dgvCell = ((dgvVoucher)sender).CurrentCell;
string strColumnName = dgvCell.OwningColumn.Name.ToUpper();
if (Common.Inlist(strColumnName, "SO_LUONG9"))
{
Update_Gia_Vt(drCurrent);
}
if (Common.Inlist(strColumnName, "SO_LUONG9,GIA_NT9,TIEN_NT9,TIEN"))
{
Voucher.Calc_So_Luong(drCurrent);
Voucher.Update_TTien(this);
}
else if (Common.Inlist(strColumnName, "TIEN"))
{
Voucher.Calc_Tien(drCurrent);
Voucher.Update_TTien(this);
}
bdsEditCt.EndEdit(); //Cap nhat lai DataSource
}
void dgvEditCt_KeyDown(object sender, KeyEventArgs e)
{
if (e.KeyCode == Keys.Space)
{
if (dgvEditCt1.CurrentCell.OwningColumn.DataPropertyName == "DVT")
{
drCurrent = ((DataRowView)bdsEditCt.Current).Row;
string strMa_Vt = (string)drCurrent["Ma_Vt"];
string strDvt_Old = (string)drCurrent["Dvt"];
string strDvt_Chuan = string.Empty;
DataRow drDmVt = DataTool.SQLGetDataRowByID("LIVATTU", "Ma_Vt", strMa_Vt);
strDvt_Chuan = (string)drDmVt["Dvt"];
string inputMask = (string)drDmVt["Dvt"];
for (int i = 1; i <= 3; i++)
{
inputMask += (string)drDmVt["Dvt" + i] == string.Empty ? string.Empty : "," + (string)drDmVt["Dvt" + i];
}
if (inputMask != string.Empty)
{
inputMask += "," + inputMask;
}
if (inputMask == null || inputMask == string.Empty)
{
return;
}
string[] strArrInputMask = inputMask.Split(',');
for (int i = 0; i <= strArrInputMask.Length - 1; i++)
{
if (strArrInputMask[i] == strDvt_Old)
{
drCurrent["Dvt"] = strArrInputMask[i + 1];
break;
}
}
if ((string)drCurrent["Dvt"] == strDvt_Chuan)
{
drCurrent["He_So9"] = 1;
}
else
{
for (int i = 1; i <= 3; i++)
{
if ((string)drDmVt["Dvt" + i] == (string)drCurrent["Dvt"])
{
drCurrent["He_So9"] = drDmVt["He_So" + i];
}
}
}
Voucher.Calc_So_Luong(drCurrent);
}
}
}
private bool CellKeyEnter()
{ //Ham thuc hien phim Enter: true: thuc hien thanh cong, false: khong thuc hien duoc
if (dgvEditCt1.CurrentCell == null)
{
return(false);
}
DataGridViewCell dgvCell = dgvEditCt1.CurrentCell;
string strCurrentColumn = dgvCell.OwningColumn.Name.ToUpper();
#region Enter tai TEN_VT
if (Common.Inlist(strCurrentColumn, "TEN_VT"))
{
drCurrent = ((DataRowView)bdsEditCt.Current).Row;
if (drCurrent["Ma_Vt"] == DBNull.Value || (string)drCurrent["Ma_Vt"] == string.Empty)
{
bool bIsCurrentLastRow = dgvEditCt1.bIsCurrentLastRow;
bdsEditCt.RemoveCurrent();
dtEditCt.AcceptChanges();
if (bIsCurrentLastRow)
{
this.SelectNextControl(dgvEditCt1, true, true, true, true);
}
return(true);
}
return(false);
}
#endregion
#region Enter tai TIEN_NT9
if (Common.Inlist(strCurrentColumn, "TIEN_NT9"))
{
if (txtMa_Tte.Text.Trim() == Element.sysMa_Tte)
{
// Cap nhat tien TIEN_NT9 truoc khi xuong dong
double dbTien_Nt9 = 0;
if (double.TryParse(dgvEditCt1.CurrentCell.FormattedValue.ToString().Trim(), out dbTien_Nt9))
{
dgvEditCt1.CancelEdit();
drCurrent = ((DataRowView)bdsEditCt.Current).Row;
drCurrent["TIEN_NT9"] = dbTien_Nt9;
Voucher.Calc_So_Luong(drCurrent);
Voucher.Update_TTien(this);
}
if (dgvEditCt1.bIsCurrentLastRow)
{
if (!Voucher.AddRow(this))
{
this.SelectNextControl(dgvEditCt1, true, true, true, true);
}
else
{
dgvEditCt1.FocusNextFirstCell();
return(true);
}
}
else
{
dgvEditCt1.FocusNextFirstCell();
}
}
return(false);
}
#endregion
#region Enter TIEN
if (Common.Inlist(strCurrentColumn, "TIEN"))
{
if (dgvEditCt1.bIsCurrentLastRow)
{
// Cap nhat Tien truoc khi xuống dòng
double dbTien = 0;
if (double.TryParse(dgvEditCt1.CurrentCell.FormattedValue.ToString().Trim(), out dbTien))
{
dgvEditCt1.CancelEdit();
drCurrent = ((DataRowView)bdsEditCt.Current).Row;
drCurrent["TIEN"] = dbTien;
Voucher.Calc_So_Luong(drCurrent);
Voucher.Update_TTien(this);
}
if (!Voucher.AddRow(this))
{
return(false);
}
else
{
dgvEditCt1.FocusNextFirstCell();
}
return(true);
}
return(false);
}
#endregion
return(false);
}
private bool dgvLookupMa_Vt(ref DataGridViewCell dgvCell)
{
string strValue = string.Empty;
if (this.ActiveControl.GetType().Name == "DataGridViewTextBoxEditingControl")
{
strValue = this.ActiveControl.Text;
}
else
{
strValue = dgvCell.FormattedValue.ToString().Trim();
}
bool bRequire = false;
//frmVatTu frmLookup = new frmVatTu();
DataRow drLookup = Lookup.ShowLookup("Ma_Vt", strValue, bRequire, "", "");
if (bRequire && drLookup == null)
{
return(false);
}
if (drLookup == null)
{
dgvCell.Value = string.Empty;
dgvCell.Tag = string.Empty;
}
else
{
drCurrent = ((DataRowView)bdsEditCt.Current).Row;
string strMa_Vt_Old = drCurrent["Ma_Vt"] == DBNull.Value ? string.Empty : (string)drCurrent["Ma_Vt"];
string strMa_Vt = (string)drLookup["Ma_Vt"];
dgvEditCt1.CancelEdit();
dgvCell.Value = drLookup["Ma_Vt"].ToString();
dgvCell.Tag = drLookup["Ten_Vt"].ToString();
//La vat tu dich vu
if ((string)drLookup["Loai_Vt"] == "0")
{
if ((string)drCurrent["Ten_Vt"] == string.Empty)
{
drCurrent["Ten_Vt"] = drLookup["Ten_Vt"];
}
drCurrent["Dvt"] = drLookup["Dvt"];
}
else
{
drCurrent["Ten_Vt"] = drLookup["Ten_Vt"];
if (strMa_Vt != strMa_Vt_Old)
{
drCurrent["Dvt"] = drLookup["Dvt"];
drCurrent["He_So9"] = 1;
Voucher.Calc_So_Luong(drCurrent);
}
else
{
if (drCurrent["Dvt"] == DBNull.Value || (string)drCurrent["Dvt"] == string.Empty)
{
drCurrent["Dvt"] = drLookup["Dvt"];
}
}
}
}
return(true);
}