/// <summary>
/// 留言管理列表
/// </summary>
/// <returns></returns>
public HttpResponseBase GetVoteMessageList()
{
List<VoteMessageQuery> store = new List<VoteMessageQuery>();
string json = string.Empty;
int tranInt = 0;
try
{
VoteMessageQuery query = new VoteMessageQuery();
query.Start = Convert.ToInt32(Request.Params["start"] ?? "0");
query.Limit = Convert.ToInt32(Request.Params["limit"] ?? "25");
_voteMsg = new VoteMessageMgr(mySqlConnectionString);
int totalCount = 0;
if (!string.IsNullOrEmpty(Request.Params["message"]))
{
query.message_content = Request.Params["message"];
//if (int.TryParse(Request.Params["message"], out tranInt))
//{
// query.message_id = int.Parse(Request.Params["message"].ToString());
//}
//else
//{
// query.message_content = Request.Params["message"];
//}
}
if (!string.IsNullOrEmpty(Request.Params["article"]))
{
query.article_id = int.Parse(Request.Params["article"].ToString());
//if (int.TryParse(Request.Params["article"], out tranInt))
//{
// query.article_id = int.Parse(Request.Params["article"].ToString());
//}
//else
//{
// query.article_title = Request.Params["article"];
//}
}
query.message_status = -1;
if (!string.IsNullOrEmpty(Request.Params["status"]))
{
query.message_status = int.Parse(Request.Params["status"].ToString());
}
store = _voteMsg.GetVoteMessageList(query, out totalCount);
IsoDateTimeConverter timeConverter = new IsoDateTimeConverter();
//这里使用自定义日期格式，如果不使用的话，默认是ISO8601格式
timeConverter.DateTimeFormat = "yyyy-MM-dd HH:mm:ss";
json = "{success:true,totalCount:" + totalCount + ",data:" + JsonConvert.SerializeObject(store, Formatting.Indented, timeConverter) + "}";//返回json數據
}
catch (Exception ex)
{
Log4NetCustom.LogMessage logMessage = new Log4NetCustom.LogMessage();
logMessage.Content = string.Format("TargetSite:{0},Source:{1},Message:{2}", ex.TargetSite.Name, ex.Source, ex.Message);
logMessage.MethodName = System.Reflection.MethodBase.GetCurrentMethod().Name;
log.Error(logMessage);
json = "{success:false,totalCount:0,data:[]}";
}
this.Response.Clear();
this.Response.Write(json);
this.Response.End();
return this.Response;
}
/// <summary>
/// 刪除留言列表
/// </summary>
/// <returns></returns>
public HttpResponseBase DeleteVoteMessage()
{
VoteMessageQuery query = new VoteMessageQuery();
string json = string.Empty;
try
{
string Row_id = "";
if (!string.IsNullOrEmpty(Request.Params["rowId"]))
{
Row_id = Request.Params["rowId"];
query.message_id_in = Row_id.TrimEnd(',');
}
_voteMsg = new VoteMessageMgr(mySqlConnectionString);
int result = _voteMsg.DelVoteMessage(query);
if (result > 0)
{
json = "{success:true,msg:\"" + result + "\"}";
}
else
{
json = "{success:false,msg:\"" + result + "\"}";
}
}
catch (Exception ex)
{
Log4NetCustom.LogMessage logMessage = new Log4NetCustom.LogMessage();
logMessage.Content = string.Format("TargetSite:{0},Source:{1},Message:{2}", ex.TargetSite.Name, ex.Source, ex.Message);
logMessage.MethodName = System.Reflection.MethodBase.GetCurrentMethod().Name;
log.Error(logMessage);
json = "{success:false,msg:'0'}";
}
this.Response.Clear();
this.Response.Write(json);
this.Response.End();
return this.Response;
}
public JsonResult UpdateVoteMessageStatus()
{
try
{
VoteMessageQuery query = new VoteMessageQuery();
if (!string.IsNullOrEmpty(Request.Params["message_id"].ToString()))
{
query.message_id = Convert.ToInt32(Request.Params["message_id"].ToString());
}
query.message_status = Convert.ToInt32(Request.Params["message_status"] ?? "0");
_voteMsg = new VoteMessageMgr(mySqlConnectionString);
query.update_user = (Session["caller"] as Caller).user_id;
System.Net.IPAddress[] addlist = System.Net.Dns.GetHostByName(System.Net.Dns.GetHostName()).AddressList;
query.ip = addlist[0].ToString();
query.update_time = DateTime.Now;
if (_voteMsg.UpVoteMessageStatus(query) > 0)
{
return Json(new { success = "true" });
}
else
{
return Json(new { success = "false" });
}
}
catch (Exception ex)
{
Log4NetCustom.LogMessage logMessage = new Log4NetCustom.LogMessage();
logMessage.Content = string.Format("TargetSite:{0},Source:{1},Message:{2}", ex.TargetSite.Name, ex.Source, ex.Message);
logMessage.MethodName = System.Reflection.MethodBase.GetCurrentMethod().Name;
log.Error(logMessage);
return Json(new { success = "false" });
}
}
/// <summary>
/// 保存留言管理
/// </summary>
/// <returns></returns>
public HttpResponseBase SaveVoteMessage()
{
string json = string.Empty;
try
{
VoteMessageQuery query = new VoteMessageQuery();
if (!string.IsNullOrEmpty(Request.Params["message_id"]))
{
query.message_id = Convert.ToInt32(Request.Params["message_id"]);
}
if (!string.IsNullOrEmpty(Request.Params["article_id"]))
{
query.article_id = Convert.ToInt32(Request.Params["article_id"]);
}
if (!string.IsNullOrEmpty(Request.Params["message_content"]))
{
query.message_content = Request.Params["message_content"];
}
System.Net.IPAddress[] addlist = System.Net.Dns.GetHostByName(System.Net.Dns.GetHostName()).AddressList;
query.ip = addlist[0].ToString();
query.create_user = (Session["caller"] as Caller).user_id;
query.update_user = (Session["caller"] as Caller).user_id;
query.create_time = DateTime.Now;
query.update_time = query.create_time;
_voteMsg = new VoteMessageMgr(mySqlConnectionString);
int result = 0;
if (query.message_id != 0)//編輯
{
result = _voteMsg.UpdateVoteMessage(query);
}
else //新增
{
result = _voteMsg.AddVoteMessage(query);
}
if (result > 0)
{
json = "{\"success\":\"true\",\"msg\":\"保存成功!\"}";
}
else
{
json = "{\"success\":\"false\",\"msg\":\"保存失敗!\"}";
}
}
catch (Exception ex)
{
Log4NetCustom.LogMessage logMessage = new Log4NetCustom.LogMessage();
logMessage.Content = string.Format("TargetSite:{0},Source:{1},Message:{2}", ex.TargetSite.Name, ex.Source, ex.Message);
logMessage.MethodName = System.Reflection.MethodBase.GetCurrentMethod().Name;
log.Error(logMessage);
json = "{\"success\":\"false\",\"msg\":\"參數出錯!\"}";
}
this.Response.Clear();
this.Response.Write(json);
this.Response.End();
return this.Response;
}
