/// <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" })); }