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(); } }