/// <summary> /// 编辑用户PID /// </summary> /// <param name="model"></param> /// <returns></returns> public bool EditUserPID(UserPidModel model) { if (model.id <= 0) { return(dal.addUserPID(model) > 0); } else { return(dal.UpdateUserPID(model)); } }
/// <summary> /// 添加用户PID /// </summary> /// <param name="model"></param> /// <returns></returns> public int addUserPID(UserPidModel model) { string strSql = "insert into userpid_list(userid,title,pid) values(@userid,@title,@pid);select @@IDENTITY"; var param = new[] { new SqlParameter("@userid", model.userid), new SqlParameter("@title", model.title), new SqlParameter("@pid", model.pid) }; return(Convert.ToInt32(DbHelperSQL.ExecuteScalar(GlobalConfig.getConnectionString(), CommandType.Text, strSql, param))); }
/// <summary> /// 修改用户PID /// </summary> /// <param name="model"></param> /// <returns></returns> public bool UpdateUserPID(UserPidModel model) { string strSql = "update userpid_list set title=@title,pid=@pid where userid=@userid and id=@id"; var param = new[] { new SqlParameter("@userid", model.userid), new SqlParameter("@id", model.id), new SqlParameter("@title", model.title), new SqlParameter("@pid", model.pid) }; return(DbHelperSQL.ExecuteNonQuery(GlobalConfig.getConnectionString(), CommandType.Text, strSql, param) > 0); }
/// <summary> /// 添加用户PID /// </summary> /// <param name="model"></param> /// <returns></returns> public int AddUserPID(UserPidModel model) { return(dal.addUserPID(model)); }
/// <summary> /// 修改用户PID /// </summary> /// <param name="model"></param> /// <returns></returns> public bool UpdateUserPID(UserPidModel model) { return(dal.UpdateUserPID(model)); }