/// <summary>
/// Shows the form detail.
/// </summary>
private void ShowFormDetail()
{
try
{
using (var frmDetail = GetFormDetail())
{
if (frmDetail == null)
{
return;
}
frmDetail.ActionMode = ActionMode;
frmDetail.HelpTopicId = HelpTopicId;
frmDetail.KeyValue = frmDetail.ActionMode == ActionModeEnum.AddNew ? null : PrimaryKeyValue;
frmDetail.PostKeyValue += FrmDetail_PostKey;
if (ActionMode == ActionModeEnum.AddNew)
{
ListBindingSource.AddNew();
ListBindingSource.MoveLast();
}
frmDetail.BindingSourceDetail = ListBindingSource;
if (frmDetail.ShowDialog() == DialogResult.OK)
{
}
}
}
catch (Exception ex)
{
XtraMessageBox.Show(ex.Message + "Lỗi ở đây", ResourceHelper.GetResourceValueByName("ResExceptionCaption"), MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void Filter_Box()
{
try
{
ListBindingSource.RemoveFilter();
SubFilter = "";
if (!string.IsNullOrEmpty(TxtNo.Text))
{
SubFilter = SubFilter + "Kno='" + TxtNo.Text + "'";
}
if (!string.IsNullOrEmpty(ComboBox1.Text))
{
if (setFlag == true)
{
if (!string.IsNullOrEmpty(SubFilter))
{
SubFilter = SubFilter + " And ";
SubFilter = SubFilter + " Sid =" + ComboBox1.SelectedValue;
}
else
{
SubFilter = SubFilter + " Sid =" + ComboBox1.SelectedValue;
}
}
}
if (!string.IsNullOrEmpty(ComboBox2.Text))
{
if (SetUnitFlag == true)
{
if (!string.IsNullOrEmpty(SubFilter))
{
SubFilter = SubFilter + " And ";
SubFilter = SubFilter + " KSid =" + ComboBox2.SelectedValue;
}
else
{
SubFilter = SubFilter + " KSid =" + ComboBox2.SelectedValue;
}
}
}
if (!string.IsNullOrEmpty(TxtSubject.Text))
{
if (!string.IsNullOrEmpty(SubFilter))
{
SubFilter = SubFilter + " And ";
SubFilter = SubFilter + "subject Like'%" + TxtSubject.Text + "%'";
}
else
{
SubFilter = SubFilter + "subject Like'%" + TxtSubject.Text + "%'";
}
}
if (!string.IsNullOrEmpty(TxtPAsli.Text))
{
if (!string.IsNullOrEmpty(SubFilter))
{
SubFilter = SubFilter + " And ";
SubFilter = SubFilter + "pasli ='" + TxtPAsli.Text + "'";
}
else
{
SubFilter = SubFilter + "pasli ='" + TxtPAsli.Text + "'";
}
}
if (!string.IsNullOrEmpty(TxtPFarei.Text))
{
if (!string.IsNullOrEmpty(SubFilter))
{
SubFilter = SubFilter + " And ";
SubFilter = SubFilter + "PFarei ='" + TxtPFarei.Text + "'";
}
else
{
SubFilter = SubFilter + "PFarei ='" + TxtPFarei.Text + "'";
}
}
if (!string.IsNullOrEmpty(TxtDate1.Text) & string.IsNullOrEmpty(TxtDate2.Text))
{
if (!string.IsNullOrEmpty(SubFilter))
{
SubFilter = SubFilter + " And ";
SubFilter = SubFilter + "kdate = '" + TxtDate1.Text + "'";
}
else
{
SubFilter = SubFilter + "kdate = '" + TxtDate1.Text + "'";
}
}
if (string.IsNullOrEmpty(TxtDate1.Text) & !string.IsNullOrEmpty(TxtDate2.Text))
{
if (!string.IsNullOrEmpty(SubFilter))
{
SubFilter = SubFilter + " And ";
SubFilter = SubFilter + "kdate = '" + TxtDate2.Text + "'";
}
else
{
SubFilter = SubFilter + "kdate = '" + TxtDate2.Text + "'";
}
}
if (!string.IsNullOrEmpty(TxtDate1.Text) & !string.IsNullOrEmpty(TxtDate2.Text))
{
if (!string.IsNullOrEmpty(SubFilter))
{
SubFilter = SubFilter + " And ";
SubFilter = SubFilter + "kdate >= '" + TxtDate1.Text + "'";
}
else
{
SubFilter = SubFilter + "kdate >= '" + TxtDate1.Text + "'";
}
if (!string.IsNullOrEmpty(SubFilter))
{
SubFilter = SubFilter + " And ";
SubFilter = SubFilter + "kdate <='" + TxtDate2.Text + "'";
}
else
{
SubFilter = SubFilter + "kdate <='" + TxtDate2.Text + "'";
}
}
if (!string.IsNullOrEmpty(TxtEnDate1.Text) & string.IsNullOrEmpty(TxtEnDate2.Text))
{
if (!string.IsNullOrEmpty(SubFilter))
{
SubFilter = SubFilter + " And ";
SubFilter = SubFilter + "EndDate = '" + TxtEnDate1.Text + "'";
}
else
{
SubFilter = SubFilter + "EndDate = '" + TxtEnDate1.Text + "'";
}
}
if (string.IsNullOrEmpty(TxtEnDate1.Text) & !string.IsNullOrEmpty(TxtEnDate2.Text))
{
if (!string.IsNullOrEmpty(SubFilter))
{
SubFilter = SubFilter + " And ";
SubFilter = SubFilter + "EndDate = '" + TxtEnDate2.Text + "'";
}
else
{
SubFilter = SubFilter + "EndDate = '" + TxtEnDate2.Text + "'";
}
}
if (!string.IsNullOrEmpty(TxtEnDate1.Text) & !string.IsNullOrEmpty(TxtEnDate2.Text))
{
if (!string.IsNullOrEmpty(SubFilter))
{
SubFilter = SubFilter + " And ";
SubFilter = SubFilter + "EndDate >= '" + TxtEnDate1.Text + "'";
}
else
{
SubFilter = SubFilter + "EndDate >= '" + TxtEnDate1.Text + "'";
}
if (!string.IsNullOrEmpty(SubFilter))
{
SubFilter = SubFilter + " And ";
SubFilter = SubFilter + "EndDate <='" + TxtEnDate2.Text + "'";
}
else
{
SubFilter = SubFilter + "EndDate <='" + TxtEnDate2.Text + "'";
}
}
}
catch (Exception ex)
{
Interaction.MsgBox(ex.ToString());
}
}
