protected void bSave_Click(object sender, ImageClickEventArgs e)
{
lock (Database.lockObjectDB)
{
ArrayList al = new ArrayList();
string s = "";
if (DatePickerStart.DatePickerText != "")
{
try
{
Convert.ToDateTime(DatePickerStart.DatePickerText);
}
catch
{
lbInform.Text = "Неправильно введена дата документа с";
DatePickerStart.Focus();
return;
}
}
if (DatePickerEnd.DatePickerText != "")
{
try
{
Convert.ToDateTime(DatePickerEnd.DatePickerText);
}
catch
{
lbInform.Text = "Неправильно введена дата документа по";
DatePickerEnd.Focus();
return;
}
}
if (DatePickerStart.DatePickerText != "")
{
al.Add(String.Format("(date_doc>=[{0:" + ConfigurationSettings.AppSettings["DateFormat"] + "}])", DatePickerStart.SelectedDate));
}
if (DatePickerEnd.DatePickerText != "")
{
al.Add(String.Format("(date_doc<=[{0:" + ConfigurationSettings.AppSettings["DateFormat"] + "}])", DatePickerEnd.SelectedDate));
}
string id_type = dListType.SelectedItem.Value;
if (id_type != "-1")
{
al.Add(String.Format("(type={0})", id_type));
}
id_type = dListBranch.SelectedItem.Value;
if (id_type != "-1")
{
al.Add($"(id_branch={id_type})");
}
if (tbProd.Text != "")
{
al.Add(String.Format("(id in (select id_doc from V_Products_StorageDocs where prod_name like [%{0}%]))", tbProd.Text));
}
if (tbCard.Text != "")
{
if (tbCard.Text.Trim().Length >= 16)
{
al.Add(
$"(id in (select id_doc from V_Cards_StorageDocs where panhash like [{FuncClass.GetHashPan(tbCard.Text.Trim())}]))");
}
else
{
al.Add($"(id in (select id_doc from V_Cards_StorageDocs where pan like [%{tbCard.Text.Trim()}%]))");
}
}
if (tbCreate.Text != "")
{
al.Add(String.Format("(loweredusername like [%{0}%])", tbCreate.Text.Trim()));
}
if (chAll.Checked)
{
al.Add(String.Format("(priz_gen=1 or priz_gen=0)", tbCard.Text));
}
else
{
al.Add(String.Format("(priz_gen=0)", tbCard.Text));
}
if (al.Count > 0)
{
string[] all = Array.CreateInstance(typeof(string), al.Count) as string[];
al.CopyTo(all, 0);
s = "where " + String.Join(" and ", all);
}
Response.Write("<script language=javascript>window.returnValue='" + s + "'; window.close();</script>");
}
}