public static DataTable edit_praise(praise model)
{
string result = "";
SqlParameter[] param =
{
new SqlParameter("@id", model.id),
new SqlParameter("@praise_table_id", model.praise_table_id == null?0:model.praise_table_id),
new SqlParameter("@praise_userid", model.praise_userid == null?"":model.praise_userid),
new SqlParameter("@praise_username", model.praise_username == null?"":model.praise_username),
new SqlParameter("@praise_type", model.praise_type == null?"":model.praise_type)
};
return(SQLHelp.ExecuteDataTable("edit_praise", CommandType.StoredProcedure, param));
}
/// <summary>
/// 新增评论
/// </summary>
/// <param name="context"></param>
public void edit_praise(HttpContext context)
{
HttpRequest request = context.Request;
HttpResponse response = context.Response;
string id = context.Request["id"];
string guid = request["guid"];
try
{
praise praise = new praise();
praise.id = Convert.ToInt32(id);
praise.praise_table_id = int.Parse(request["praise_table_id"].ToString());
praise.praise_isdelete = "0";
praise.praise_type = request["praise_type"];
List <praise> list2 = list_All.Where(item => item.praise_table_id == Convert.ToInt64(praise.praise_table_id))
.Where(item => item.praise_userid == guid)
.Where(item => item.praise_type == praise.praise_type)
.ToList <praise>();
//若存在则删除
if (list2.Count > 0)
{
list_All.Remove(list2[0]);
List <praise> list_Remove = list_All.Where(item => item.praise_table_id == Convert.ToInt64(praise.praise_table_id)).Where(item => item.praise_type == praise.praise_type).ToList <praise>();
//成功提示
jsonModel = new JsonModel()
{
errNum = 0,
errMsg = "success",
retData = list_Remove
};
//开启线程操作数据库
new Thread(() =>
{
Constant.praise_S.Delete(Convert.ToInt32(list2[0].id));
})
{
IsBackground = true
}.Start();
}
//若不存在则添加
else
{
praise.praise_userid = request["praise_userid"];
praise.praise_username = request["praise_username"];
praise.praise_createdate = DateTime.Now;
praise.praise_updatedate = DateTime.Now;
//添加
list_All.Add(praise);
List <praise> list_add = list_All.Where(item => item.praise_table_id == Convert.ToInt64(praise.praise_table_id)).Where(item => item.praise_type == praise.praise_type).ToList <praise>();
//成功提示
jsonModel = new JsonModel()
{
errNum = 0,
errMsg = "success",
retData = list_add
};
//开启线程操作数据库
new Thread(() =>
{
DataTable report = Constant.bbc.edit_praise(praise);
List <Dictionary <string, object> > s_list = new List <Dictionary <string, object> >();
s_list = Constant.common.DataTableToList(report);
})
{
IsBackground = true
}.Start();
}
}
catch (Exception ex)
{
LogHelper.Error(ex);
jsonModel = Constant.ErrorGetData(ex);
}
finally
{
response.Write("{\"result\":" + Constant.jss.Serialize(jsonModel) + "}");
}
}
/// <summary>
/// 点赞
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public DataTable edit_praise(praise model)
{
return(DALBaseCommon.edit_praise(model));
}
