/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(CRM_Aut_Record model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update CRM_Aut_Record set ");
strSql.Append(" r_accid = @r_accid , ");
strSql.Append(" r_max = @r_max , ");
strSql.Append(" r_min = @r_min , ");
strSql.Append(" t_tex = @t_tex , ");
strSql.Append(" r_time = @r_time , ");
strSql.Append(" r_status = @r_status , ");
strSql.Append(" r_remark = @r_remark , ");
strSql.Append(" r_result = @r_result ");
strSql.Append(" where id=@id ");
int row = DapperHelper.Execute(strSql.ToString(), model);
if (row > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 新增加一条数据
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public int Add(CRM_Aut_Record model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into CRM_Aut_Record(");
strSql.Append("r_accid,r_max,r_min,t_tex,r_time,r_status,r_remark,r_result");
strSql.Append(") values (");
strSql.Append("@r_accid,@r_max,@r_min,@t_tex,@r_time,@r_status,@r_remark,@r_result");
strSql.Append(") ");
strSql.Append(";select @@IDENTITY");
object obj = DapperHelper.ExecuteScalar(strSql.ToString(), model);
if (obj != null)
{
return(Convert.ToInt32(obj));
}
else
{
return(0);
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public static bool Update(CRM_Aut_Record model)
{
CRM_Aut_RecordBaseDAL dal = new CRM_Aut_RecordBaseDAL();
return(dal.Update(model));
}
/// <summary>
/// 新增加一条数据
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public static int Add(CRM_Aut_Record model)
{
CRM_Aut_RecordBaseDAL dal = new CRM_Aut_RecordBaseDAL();
return(dal.Add(model));
}
