void XemHoaDon()
{
string strMa_Ct = txtMa_Ct.Text.Trim();
string strKey = "(0 = 0) "; // = TRUE
if (!(txtMa_Ct.Text.Trim() == string.Empty))
{
strKey += " AND (Ma_Ct = '" + txtMa_Ct.Text.Trim() + "')";
}
if (!dteNgay_Ct1.IsNull)
{
strKey += " AND (Ngay_Ct >= '" + dteNgay_Ct1.Text.Trim() + "')";
}
if (!dteNgay_Ct2.IsNull)
{
strKey += " AND (Ngay_Ct <= '" + dteNgay_Ct2.Text.Trim() + "')";
}
if (!(txtSo_Ct1.Text.Trim() == string.Empty))
{
strKey += " AND (So_Ct >= '" + txtSo_Ct1.Text.Trim() + "')";
}
if (!(txtSo_Ct2.Text.Trim() == string.Empty))
{
strKey += " AND (So_Ct <= '" + txtSo_Ct2.Text.Trim() + "')";
}
if (!(txtMa_Dt.Text.Trim() == string.Empty))
{
strKey += " AND (Ma_Dt = '" + txtMa_Dt.Text.Trim() + "')";
}
//Chua xu ly theo Ma_KhN
if (!(txtMa_Kho.Text.Trim() == string.Empty))
{
strKey += " AND (Ma_Kho = '" + txtMa_Kho.Text.Trim() + "')";
}
if (!(txtMa_Vt.Text.Trim() == string.Empty))
{
strKey += " AND (Ma_Vt = '" + txtMa_Vt.Text.Trim() + "')";
}
if (!(txtMa_Nh_Vt.Text.Trim() == string.Empty))
{
strKey += " AND (Ma_Vt IN (SELECT Ma_Vt FROM LIVATTU WHERE Ma_Nh_Vt = '" + txtMa_Nh_Vt.Text.Trim() + "'))";
}
frmChonHD_View frm = new frmChonHD_View();
frm.Load(frmEditCtHD, strMa_Ct, strKey);
}
void btAddHD_Click(object sender, EventArgs e)
{
frmChonHD_View frm = new frmChonHD_View();
frm.dtViewCur = this.dtEditCt;
frm.LoadCheckPXK(enuEdit.New, txtMa_Px.Text, txtMa_CBNV_GH.Text, txtMa_Ct.Text);
if (frm.is_Accept)
{
DataTable dt = frm.dtVoucherSelect;
foreach (DataRow dr in dt.Rows)
{
DataRow drNew = this.dtEditCt.NewRow();
Common.CopyDataRow(dr, drNew);
this.dtEditCt.Rows.Add(drNew);
}
//FillData();
}
}
