-
Notifications
You must be signed in to change notification settings - Fork 0
/
SearchFile.aspx.cs
157 lines (141 loc) · 6.05 KB
/
SearchFile.aspx.cs
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
using System;
using System.Collections.Generic;
using System.Data;
using System.Globalization;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using Kalboard360.ClassCode;
public partial class SearchFile : UICaltureBase
{
protected void Page_Load(object sender, EventArgs e)
{
if(!Page.IsPostBack)
{
Database db = new Database();
db.LoadDDL("FileTarget", "title", ref ddlField, "المجال");
db.LoadDDL("country", "name", ref ddlCountry, "الدولة", "lang=2");
db.LoadDDL("FileType", "Title", ref ddlType, "النوع");
string title = Request.QueryString["name"];
string date = Request.QueryString["date"];
string target = Request.QueryString["category"];
string country = Request.QueryString["country"];
string type = Request.QueryString["type"];
string no = Request.QueryString["no"];
txtTitle.Text = title;
ddlField.SelectedValue = target;
ddlCountry.SelectedValue = country;
ddlType.SelectedValue = type;
txtFileDate.Text = date;
if (no != null)
{
// string[] noArray = no.Split('/');
if (no.Length > 0)
{
txtNo1.Text = no;
}
}
LoadData(txtTitle.Text,no,ddlField.SelectedValue,txtFileDate.Text,ddlCountry.SelectedValue,ddlType.SelectedValue);
}
}
private void LoadData(string title="",string no="",string target="",string date="",string country="",string type="")
{
Dates dates =new Dates();
Database db = new Database();
//Users u = Session["User"] as Users;
// db.AddParameter("@id", u.Id);
string sql;
if (Session["User"] == null)
{
sql = "select files.*,FileTarget.title as TargetName,FileType.Title as TypeName from (files left join FileTarget on files.Target=FileTarget.id) inner join FileType on Files.Type=FileType.Id where files.[Security] in (1)";
}
else
{
sql = "select files.*,FileTarget.title as TargetName,FileType.Title as TypeName from (files left join FileTarget on files.Target=FileTarget.id) inner join FileType on Files.Type=FileType.Id where files.[Security] in (1,2)";
}
if (!string.IsNullOrWhiteSpace(title))
{
sql += " and (files.title like '%' + @title + '%' or files.[No] like '%' + @title + '%' or files.[From] like '%' + @title + '%' or files.[To] like '%' + @title + '%' or files.[Desc] like '%' + @title + '%' or files.[FileKey] like '%' + @title + '%')";
db.AddParameter("@title", title);
}
if (!string.IsNullOrWhiteSpace(no))
{
sql += " and files.no like '%' + @no + '%'";
db.AddParameter("@no", no);
}
if (!string.IsNullOrWhiteSpace(target) && !target.Equals("-1"))
{
sql += " and files.[target] = @Field";
db.AddParameter("@Field", target);
}
DateTime tmp;
if (DateTime.TryParseExact(dates.HijriToGreg(txtFileDate.Text, "d/M/yyyy"), "d/M/yyyy", CultureInfo.InvariantCulture, DateTimeStyles.None, out tmp))
{
sql += " and (day(files.fileDate)=@day and month(files.fileDate)=@month and year(files.fileDate)=@year)";
db.AddParameter("@day", tmp.Day);
db.AddParameter("@month", tmp.Month);
db.AddParameter("@year", tmp.Year);
}
if (!string.IsNullOrWhiteSpace(country) && !country.Equals("-1"))
{
sql += " and files.[country] = @country";
db.AddParameter("@country", country);
}
if (!string.IsNullOrWhiteSpace(type) && !type.Equals("-1"))
{
sql += " and files.[type] = @type";
db.AddParameter("@type", type);
}
if (ddlSort.SelectedValue != "-1")
{
if (ddlSort.SelectedValue == "1") {
sql += " order by files.fileDate desc";
}
else if (ddlSort.SelectedValue == "2")
{
sql += " order by files.fileDate asc";
}
else if (ddlSort.SelectedValue == "3")
{
sql += " order by files.Title";
}
}
DataTable dt = db.ExecuteDataTable(sql);
Repeater1.DataSource = dt;
Repeater1.DataBind();
}
protected void Repeater1_OnPagePropertiesChanged(object sender, EventArgs e)
{
LoadData(txtTitle.Text, txtNo1.Text, ddlField.SelectedValue, txtFileDate.Text,ddlCountry.SelectedValue);
}
protected void btnSearch_OnClick(object sender, EventArgs e)
{
LoadData(txtTitle.Text, txtNo1.Text, ddlField.SelectedValue, txtFileDate.Text,ddlCountry.SelectedValue);
}
protected void ddlSort_SelectedIndexChanged(object sender, EventArgs e)
{
LoadData(txtTitle.Text, txtNo1.Text, ddlField.SelectedValue, txtFileDate.Text, ddlCountry.SelectedValue);
}
protected void ddlCountry_SelectedIndexChanged(object sender, EventArgs e)
{
LoadData(txtTitle.Text, txtNo1.Text, ddlField.SelectedValue, txtFileDate.Text, ddlCountry.SelectedValue);
}
protected void ddlField_SelectedIndexChanged(object sender, EventArgs e)
{
LoadData(txtTitle.Text, txtNo1.Text, ddlField.SelectedValue, txtFileDate.Text, ddlCountry.SelectedValue);
}
protected void txtTitle_TextChanged(object sender, EventArgs e)
{
LoadData(txtTitle.Text, txtNo1.Text, ddlField.SelectedValue, txtFileDate.Text, ddlCountry.SelectedValue);
}
protected void txtFileDate_TextChanged(object sender, EventArgs e)
{
// Response.Redirect("d");
LoadData(txtTitle.Text, txtNo1.Text, ddlField.SelectedValue, txtFileDate.Text, ddlCountry.SelectedValue);
}
protected void txtNo1_TextChanged(object sender, EventArgs e)
{
LoadData(txtTitle.Text, txtNo1.Text, ddlField.SelectedValue, txtFileDate.Text, ddlCountry.SelectedValue);
}
}