public override bool SendMessage(string jsonData)
{
JavaScriptSerializer js = new JavaScriptSerializer();
MyConsultation consultation = js.Deserialize <MyConsultation>(jsonData);
List <SqlParameter> list = new List <SqlParameter>();
Report_ID = consultation.Report_ID;
SenderID = consultation.SenderID;
ReceiverID = consultation.ReceiverID;
Content = consultation.Content;
Images = consultation.Images;
SqlParameter[] ps =
{
new SqlParameter("@Report_ID", Report_ID),
new SqlParameter("@SenderID", SenderID),
new SqlParameter("@ReceiverID", ReceiverID),
new SqlParameter("@Content", Content),
new SqlParameter("@images", Images),
};
list.AddRange(ps);
string sql = "insert into Consultation (Report_ID,SenderID,ReceiverID,Content,images) values(@Report_ID,@SenderID,@ReceiverID,@Content,@images)";
return(SqlHelper.ExecuteNonQuery(sql, list.ToArray()) > 0 ? true : false);
}
public override string GetOneMessage(decimal sender_id, decimal receiver_id)
{
List <MyConsultation> list = new List <MyConsultation>();
string datetime = DateTime.Now.ToLocalTime().ToString();
string sql = "select * from Consultation where SenderID=@SenderID and ReceiverID=@ReceiverID and IsReaded = 0; update Consultation set IsReaded = 1, ReadTime = @ReadTime where SenderID = @SenderID and ReceiverID = @ReceiverID";
using (SqlDataReader sdr = SqlHelper.ExecuteReader(sql, new SqlParameter("@SenderID", sender_id), new SqlParameter("@ReceiverID", receiver_id), new SqlParameter("@ReadTime", datetime)))
{
if (sdr.HasRows)
{
while (sdr.Read())
{
MyConsultation cs = new MyConsultation();
cs.Content = sdr["Content"].ToString();
cs.Images = sdr["images"].ToString();
if (cs.Content == "")
{
cs.Images = sdr["images"].ToString();
list.Add(cs);
}
else if (cs.Images == "")
{
cs.Content = sdr["Content"].ToString();
list.Add(cs);
}
else
{
list.Add(cs);
}
}
}
}
JavaScriptSerializer js = new JavaScriptSerializer();
return(js.Serialize(list));
}
public override string GetMessage(decimal sender_id, decimal receiver_id)
{
List <MyConsultation> list = new List <MyConsultation>();
string datetime = DateTime.Now.ToLocalTime().ToString();
//string sql1 = "select * from (select top 3 * from Consultation where SenderID=@SenderID and ReceiverID=@ReceiverID and IsReaded = 1 order by ID desc) as t order by ID";
string sql2 = "select * from Consultation where SenderID=@SenderID and ReceiverID=@ReceiverID and IsReaded = 0; update Consultation set IsReaded = 1, ReadTime = @ReadTime where SenderID = @SenderID and ReceiverID = @ReceiverID";
//using (SqlDataReader sdr = SqlHelper.ExecuteReader(sql1, new SqlParameter("@SenderID", sender_id), new SqlParameter("@ReceiverID", receiver_id)))
//{
// if (sdr.HasRows)
// {
// while (sdr.Read())
// {
// MyConsultation cs = new MyConsultation();
// cs.Content = sdr["Content"].ToString();
// cs.Images = sdr["images"].ToString();
// if (cs.Content == "")
// {
// cs.Images = sdr["images"].ToString();
// list.Add(cs);
// }
// else if (cs.Images == "")
// {
// cs.Content = sdr["Content"].ToString();
// list.Add(cs);
// }
// else
// list.Add(cs);
// }
// }
//}
using (SqlDataReader sdr = SqlHelper.ExecuteReader(sql2, new SqlParameter("@SenderID", sender_id), new SqlParameter("@ReceiverID", receiver_id), new SqlParameter("@ReadTime", datetime)))
{
if (sdr.HasRows)
{
while (sdr.Read())
{
MyConsultation cs = new MyConsultation();
cs.Content = sdr["Content"].ToString();
cs.Images = sdr["images"].ToString();
if (cs.Content == "")
{
cs.Images = sdr["images"].ToString();
list.Add(cs);
}
else if (cs.Images == "")
{
cs.Content = sdr["Content"].ToString();
list.Add(cs);
}
else
{
list.Add(cs);
}
}
}
}
string jsonData = JsonConvert.SerializeObject(list);
return(jsonData);
}