/// <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)); }