public bool Update(SystemFeedback model, List <string> fileds, string sqlWhere)
{
StringBuilder strSql = new StringBuilder();
strSql.AppendFormat("update {0} set ", model.GetType().Name);
List <string> filedsList = new List <string>();
List <SqlParameter> sqlParameter = new List <SqlParameter>();
SqlParameter Param = new SqlParameter("@Id", SqlDbType.Int, 4);
if (string.IsNullOrEmpty(sqlWhere))
{
Param.Value = model.Id;
sqlParameter.Add(Param);
}
foreach (string filed in fileds)
{
filedsList.Add(string.Format("{0}=@{0}", filed));
Param = new SqlParameter(string.Format("@{0}", filed), model.GetType().GetProperty(filed).GetValue(model, null));
sqlParameter.Add(Param);
}
strSql.AppendFormat("{0}", string.Join(",", filedsList.ToArray()));
if (string.IsNullOrEmpty(sqlWhere))
{
strSql.Append(" where Id=@Id ");
}
else
{
strSql.AppendFormat(" where 1=1 and {0} ", sqlWhere);
}
SqlParameter[] parameters = sqlParameter.ToArray();
return(sqlhelper.ExecNon(strSql.ToString(), parameters) > 0 ? true : false);
}
public async Task <IActionResult> Edit(int id, [Bind("Id,UserFullName,UserEmail,Message,SystemFeedbackCategoryId")] SystemFeedback systemFeedback)
{
if (id != systemFeedback.Id)
{
return(NotFound());
}
if (ModelState.IsValid)
{
try
{
_context.Update(systemFeedback);
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!SystemFeedbackExists(systemFeedback.Id))
{
return(NotFound());
}
else
{
throw;
}
}
return(RedirectToAction(nameof(Index)));
}
ViewData["SystemFeedbackCategoryId"] = new SelectList(_context.SystemFeedbackCategories, "Id", "Id", systemFeedback.SystemFeedbackCategoryId);
return(View(systemFeedback));
}
public async Task <IActionResult> Create([Bind("Id,UserFullName,UserEmail,Message,SystemFeedbackCategoryId")] SystemFeedback systemFeedback)
{
if (ModelState.IsValid)
{
_context.Add(systemFeedback);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
ViewData["SystemFeedbackCategoryId"] = new SelectList(_context.SystemFeedbackCategories, "Id", "Id", systemFeedback.SystemFeedbackCategoryId);
return(View(systemFeedback));
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public SystemFeedback GetModel(string where)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select Id, UserId, UserName, FeedbackContet, FeedbackTime ");
strSql.Append(" from SystemFeedback ");
strSql.Append(" where ");
strSql.Append(where);
var dt = sqlhelper.GetTable(strSql.ToString());
SystemFeedback model = null;
if (dt.Rows.Count > 0)
{
model = Mapper.DynamicMap <IDataReader, List <SystemFeedback> >(dt.CreateDataReader()).FirstOrDefault();
}
return(model);
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(SystemFeedback model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into SystemFeedback(");
strSql.Append("UserId,UserName,FeedbackContet,FeedbackTime");
strSql.Append(") values (");
strSql.Append("@UserId,@UserName,@FeedbackContet,@FeedbackTime");
strSql.Append(") ");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@UserId", SqlDbType.Int, 4),
new SqlParameter("@UserName", SqlDbType.VarChar, 50),
new SqlParameter("@FeedbackContet", SqlDbType.VarChar, 1000),
new SqlParameter("@FeedbackTime", SqlDbType.DateTime)
};
parameters[0].Value = model.UserId;
parameters[1].Value = model.UserName;
parameters[2].Value = model.FeedbackContet;
parameters[3].Value = model.FeedbackTime;
return(sqlhelper.ExecNon(strSql.ToString(), parameters));
}
