13,190
社区成员
发帖
与我相关
我的任务
分享
/// <summary>
/// update
/// </summary>
/// <param name="Model">修改实体</param>
/// <param name="where">条件</param>
/// <returns>成功为1失败为0</returns>
public static StringBuilder ReturnUpdateIsOK(T Model, string where)
{
try
{
StringBuilder sb = new StringBuilder();
if (ProtectIsShow(where, out sb))
{
sb.AppendLine("内含危险字符!");
return sb;
}
else
{
List<StringBuilder> sbuList = ValueFieldsAndParam(Model, "Update");
SqlParameter[] para = GetParas(Model);
StringBuilder strSql = new StringBuilder();
StringBuilder sbu = new StringBuilder();
strSql.Append("update " + sbuList[3] + " set ");
strSql.Append(sbuList[0]);
if (!string.IsNullOrEmpty(where))
{
strSql.Append(" where " + where);
}
else
{
strSql.Append(sbuList[4]);
}
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), para);
if (rows > 0)
{
sbu.Append("1");
}
else
{
sbu.Append("0");
}
return sbu;
}
}
catch (Exception ex)
{
return Common.ReturnException(ex);
}
}