/// <summary>
/// 添加
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public int Add(dp_servicecomplain model)
{
string sql = @"INSERT INTO dp_servicecomplain
([areaid]
,[classinfoid]
,[contents]
,[addtime])
VALUES
(
@areaid
,@classinfoid
,@contents
,@addtime);SELECT CAST(SCOPE_IDENTITY() as int)";
using (IDbConnection conn = new SqlConnection(DapperHelper.GetConStr()))
{
int identity = conn.Query <int>(sql, model).FirstOrDefault();
return(identity);
}
}
public String SaveOpinion(dp_servicecomplain model)
{
user = HttpContext.Session["user_pc"] as E_User;
int servicecomplainid = dServiceComplain.Add(new dp_servicecomplain()
{
classinfoid = user.classinfoid,
areaid = user.areaid,
contents = model.contents,
addtime = DateTime.Now
});
if (model.opinionlist != null)
{
foreach (var item in model.opinionlist)
{
dServiceComplain.AddServiceComplainOpinion(new dp_servicecomplainopinion()
{
opinionid = item.opinionid,
servicecomplainid = servicecomplainid
});
}
}
return(JsonConvert.SerializeObject(new { result = "True" }));
}
