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