/// <summary>
/// ���û��Ķ�Ѷ��¼��ʾ��datagrid��
/// </summary>
protected void BindGrid(string Username,string DispType)
{
SMS sm = new SMS();
SqlDataReader dr = null;
if(DispType=="1") //�ҵ����Ľ���
{
try
{
dr = sm.GetMyReceive(Username);
dgMsgList.DataSource = UDS.Components.Tools.ConvertDataReaderToDataTable(dr).DefaultView;
dgMsgList.DataBind();
}
catch
{
Server.Transfer("../Error.aspx");
}
}
if(DispType=="2") //��������
{
try
{
dr = sm.GetMySent(Username);
dgMsgList.DataSource = UDS.Components.Tools.ConvertDataReaderToDataTable(dr).DefaultView;
dgMsgList.DataBind();
}
catch
{
Server.Transfer("../Error.aspx");
}
}
switch (DispType)
{
case "1":
dgMsgList.Columns[2].Visible = false; //�������ռ���
break;
case "2":
dgMsgList.Columns[1].Visible = false; //�������ռ���
this.btnRead .Visible = false; //�������İ�ť
this.btnDelete .Visible = false; //����ɾ����ť
break;
default:
break;
}
sm = null;
dr = null;
}
private void Page_Load(object sender, System.EventArgs e)
{
string Username = (Request.QueryString["Username"]!=null)?Request.QueryString["Username"].ToString():Request.Cookies["Username"].Value.ToString();
string DispType = (Request.QueryString["DispType"]!=null)?Request.QueryString["DispType"].ToString():"1";
string result = Request.Params["result"];
if(!Page.IsPostBack)
{
if (string.IsNullOrEmpty(result))
{
BindGrid(Username, DispType);
Session["MsgDispType"] = DispType;
this.btnDelete.Attributes["onclick"] = "javascript:return confirm('��ȷ��Ҫɾ����?');";
}
else
{
SMS sm = new SMS();
SqlDataReader dreader = null;
try
{
dreader = sm.GetMyReceive(Username);
DataTable dt = dreader.ToDataTable(true);
List<UDSSMS> retList = new List<UDSSMS>();
foreach (DataRow dr in dt.Rows)
{
if (dr.IsNull("isread") || !bool.Parse(dr["isread"].ToString()))
{
UDSSMS sms = new UDSSMS()
{
Id = dr["ID"].ToString(),
Content = dr["content"].ToString(),
IsRead = dr.IsNull("isread") ? false : bool.Parse(dr["isread"].ToString()),
ReceiverRealName = dr["ReceiverRealName"].ToString(),
Sender = dr["sender"].ToString(),
SenderRealName = dr["senderrealname"].ToString(),
SendTime = DateTime.Parse(dr["sendtime"].ToString()).ToString(),
Type = dr["type"].ToString()
};
retList.Add(sms);
}
}
var jsonSer = new Newtonsoft.Json.JsonSerializer();
StringWriter sw = new StringWriter();
using (JsonWriter jw = new JsonTextWriter(sw))
{
jw.Formatting = Formatting.Indented;
jsonSer.Serialize(jw, retList);
}
string content = sw.ToString();
Response.Clear();
Response.ContentType = "application/json";
sw.Close();
Response.Write(content);
//HttpContext.Current.ApplicationInstance.CompleteRequest();
}
catch (Exception eX)
{
if (null != dreader)
{
if (!dreader.IsClosed)
{
dreader.Close();
}
}
Response.StatusCode = 400;
Response.ContentType = "text/html";
Response.Write(eX.Message);
//HttpContext.Current.ApplicationInstance.CompleteRequest();
}
finally
{
Response.End();
}
}
}
}
