public bool Update(SystemSmsTemplate 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 JsonResult AddEditSmsTemplte(SystemSmsTemplate tempate)
{
JsonResult result = null;
try
{
BaseResultDto <string> resultDto = new BaseResultDto <string>();
if (tempate.Id > 0)
{
//编辑
resultDto = HttpHelper.CreatHelper().DoPostObject <BaseResultDto <string> >(string.Format("{0}Sms/Update", this.WebApiUrl), tempate);
}
else
{
//添加
resultDto = HttpHelper.CreatHelper().DoPostObject <BaseResultDto <string> >(string.Format("{0}Sms/Add", this.WebApiUrl), tempate);
}
result = Json(new { status = resultDto.ErrorCode, message = resultDto.ErrorMsg }, JsonRequestBehavior.AllowGet);
}
catch (Exception ex)
{
result = Json(new { status = -1, message = ex.Message }, JsonRequestBehavior.AllowGet);
}
return(result);
}
public BaseResultDto <string> Update(SystemSmsTemplate model)
{
BaseResultDto <string> resultDto = new BaseResultDto <string>();
try
{
resultDto.ErrorCode = helper.Update <SystemSmsTemplate>(model) ? 1 : 0;
resultDto.ErrorMsg = "修改成功";
}
catch (Exception ex)
{
resultDto.ErrorCode = -1;
resultDto.ErrorMsg = ex.Message;
}
return(resultDto);
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public SystemSmsTemplate GetModel(string where)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 Id, TemplateName, TemplateContent ");
strSql.Append(" from SystemSmsTemplate ");
strSql.Append(" where ");
strSql.Append(where);
var dt = sqlhelper.GetTable(strSql.ToString());
SystemSmsTemplate model = null;
if (dt.Rows.Count > 0)
{
model = Mapper.DynamicMap <IDataReader, List <SystemSmsTemplate> >(dt.CreateDataReader()).FirstOrDefault();
}
return(model);
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(SystemSmsTemplate model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into SystemSmsTemplate(");
strSql.Append("TemplateName,TemplateContent ");
strSql.Append(") values (");
strSql.Append("@TemplateName,@TemplateContent ");
strSql.Append(") ");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@TemplateName", SqlDbType.VarChar, 100),
new SqlParameter("@TemplateContent", SqlDbType.VarChar, 500)
};
parameters[0].Value = model.TemplateName;
parameters[1].Value = model.TemplateContent;
return(sqlhelper.ExecNon(strSql.ToString(), parameters));
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(SystemSmsTemplate model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update SystemSmsTemplate set ");
strSql.Append(" TemplateName = @TemplateName , ");
strSql.Append(" TemplateContent = @TemplateContent ");
strSql.Append(" where Id=@Id ");
SqlParameter[] parameters =
{
new SqlParameter("@Id", SqlDbType.Int, 4),
new SqlParameter("@TemplateName", SqlDbType.VarChar, 100),
new SqlParameter("@TemplateContent", SqlDbType.VarChar, 500)
};
parameters[0].Value = model.Id;
parameters[1].Value = model.TemplateName;
parameters[2].Value = model.TemplateContent;
return(sqlhelper.ExecNon(strSql.ToString(), parameters) > 0 ? true : false);
}
