protected void Page_Load(object sender, EventArgs e)
{
VerifyPage("", false);
if (!IsPostBack) {
#region
string callback = Request.QueryString["jsoncallback"];
var term = HttpUtility.UrlDecode(Request.QueryString["term"]);
if (!string.IsNullOrEmpty(term)) {
MySQlHelper h = new MySQlHelper();
string sql = "SELECT UserName,UID,CONVERT(IsEnterprise,SIGNED) as IsEnterprise FROM dr_user WHERE UserName IS NOT NULL AND UserName!='' and username like '%" + term + "%' and IsEnterprise='" + CurrentEmp.OrgId + "'";
DataTable dt = h.ExecuteQuery(sql, CommandType.Text);
string data = "";
if (dt.Rows.Count > 0) {
string names = "";
for (int i = 0; i < dt.Rows.Count; i++) {
string s = "{\"label\":\"" + dt.Rows[i]["UserName"] + "\",\"value\":\"" + dt.Rows[i]["UID"] + "\",\"entId\":\"" + dt.Rows[i]["IsEnterprise"].ToString() + "\"},";
names += s;
}
names = names.Substring(0, names.Length - 1);
data = "[" + names + "]";
}
//data = "[\"title\", \"Recent Uploads tagged cat\",\"link\", \"http://www.sina.com.cn\",\"ch\",\"chtest\"]";
string result = string.Format("{0}({1})", callback, data);
Response.Expires = -1;
Response.Clear();
Response.ContentEncoding = Encoding.UTF8;
Response.ContentType = "application/json";
Response.Write(data);
Response.Flush();
Response.End();
}
#endregion
}
}
private StringBuilder GetMsg()
{
var sb = new StringBuilder();
#region
MySQlHelper mySQlHelper = new MySQlHelper();
var sql = "SELECT * FROM dr_user_notice WHERE (UserName='******' AND FromUser='******') OR (UserName='******' AND FromUser='******') ORDER BY InfoId ";
var dt = mySQlHelper.ExecuteDataset(sql).Tables[0];
if (dt.Rows.Count > 0) {
//sb.Append("<ul class=\"clearfix\">");
for (int i = dt.Rows.Count - 1; i >= 0; i--) {
if (CurrentEmp.EmplName == dt.Rows[i]["FromUser"].ToString()) {
Literal1.Text = GetName(dt.Rows[i]["UserName"]);
sb.Append("<div class=\"message-right clearfix\">");
sb.Append("<span class=\"name\">" + CurrentEmp.EmplName + "</span>");
sb.Append("<p class=\"message\"><i></i>" + dt.Rows[i]["Message"] + "</p>");
sb.Append("<span class=\"time\">" +
Convert.ToDateTime(dt.Rows[i]["CreateTime"])
.ToString("yyyy-MM-dd HH:mm:ss") + "</span>");
sb.Append("</div>");
//sb.Append("<li class=\"out\">");
//sb.Append("<div class=\"message\">");
//sb.Append("<span class=\"arrow\"></span>");
//sb.Append("<a class=\"name\" href=\"javascript:void(0);\">" + CurrentEmp.EmplName + "</a>");
//sb.Append("<span class=\"datetime\"> " +
// Convert.ToDateTime(dt.Rows[i]["CreateTime"])
// .ToString("yyyy-MM-dd HH:mm:ss") + "</span>");
//sb.Append("<span class=\"body\">" + dt.Rows[i]["Message"]);
//sb.Append("</span>");
//sb.Append("</div>");
//sb.Append("</li>");
}
else
{
Literal1.Text = GetName(dt.Rows[i]["FromUser"]);
sb.Append("<div class=\"message-left clearfix\">");
sb.Append("<span class=\"name\">" + GetName(dt.Rows[i]["FromUser"]) + "</span>");
sb.Append("<p class=\"message\"><i></i>" + dt.Rows[i]["Message"] + "</p>");
sb.Append("<span class=\"time\">" +
Convert.ToDateTime(dt.Rows[i]["CreateTime"])
.ToString("yyyy-MM-dd HH:mm:ss") + "</span>");
sb.Append("</div>");
//sb.Append("<li class=\"in\">");
//sb.Append("<div class=\"message\">");
//sb.Append("<span class=\"arrow\"></span>");
//sb.Append("<a class=\"name\" href=\"javascript:void(0);\">" + GetName(dt.Rows[i]["FromUser"]) +
// "</a>");
//sb.Append("<span class=\"datetime\"> " +
// Convert.ToDateTime(dt.Rows[i]["CreateTime"])
// .ToString("yyyy-MM-dd HH:mm:ss") + "</span>");
//sb.Append("<span class=\"body\">" + dt.Rows[i]["Message"]);
//sb.Append("</span>");
//sb.Append("</div>");
//sb.Append("</li>");
}
}
//sb.Append("</ul>");
}
#endregion
return sb;
}