/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(Sys_TaskDaily model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update Sys_TaskDaily set ");
strSql.Append(" insetName = @insetName , ");
strSql.Append(" dt_remark = @dt_remark , ");
strSql.Append(" dt_logUid = @dt_logUid , ");
strSql.Append(" dt_Source = @dt_Source , ");
strSql.Append(" accountid = @accountid , ");
strSql.Append(" t_mk = @t_mk , ");
strSql.Append(" vm_id = @vm_id , ");
strSql.Append(" dt_Time = @dt_Time , ");
strSql.Append(" dt_Level = @dt_Level , ");
strSql.Append(" dt_Status = @dt_Status , ");
strSql.Append(" dt_Name = @dt_Name , ");
strSql.Append(" inertTime = @inertTime ");
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(Sys_TaskDaily model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into Sys_TaskDaily(");
strSql.Append("insetName,dt_remark,dt_logUid,dt_Source,accountid,t_mk,vm_id,dt_Time,dt_Level,dt_Status,dt_Name,inertTime");
strSql.Append(") values (");
strSql.Append("@insetName,@dt_remark,@dt_logUid,@dt_Source,@accountid,@t_mk,@vm_id,@dt_Time,@dt_Level,@dt_Status,@dt_Name,@inertTime");
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(Sys_TaskDaily model)
{
Sys_TaskDailyBaseDAL dal = new Sys_TaskDailyBaseDAL();
return(dal.Update(model));
}
/// <summary>
/// 新增加一条数据
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public static int Add(Sys_TaskDaily model)
{
Sys_TaskDailyBaseDAL dal = new Sys_TaskDailyBaseDAL();
return(dal.Add(model));
}
