/// <summary>
/// 删除成绩类别
/// </summary>
/// <param name="scoreType"></param>
/// <returns></returns>
public static bool ScoreType_Del(ScoreType scoreType)
{
try
{
using (var conn = DbHelper.CCService())
{
var p = new DynamicParameters();
p.Add("@ScoreTypeID", scoreType.ScoreTypeID);
p.Add("@UserID", 0);
conn.Execute("ScoreType_Del", p, commandType: CommandType.StoredProcedure);
return true;
}
}
catch (Exception e)
{
return false;
}
}
/// <summary>
/// 新增成绩类别
/// </summary>
/// <param name="scoreType"></param>
/// <returns></returns>
public static ScoreType ScoreType_Add(ScoreType scoreType)
{
try
{
using (var conn = DbHelper.CCService())
{
var p = new DynamicParameters();
p.Add("@ScoreTypeID", dbType: DbType.Int32, direction: ParameterDirection.Output);
p.Add("@OCID", scoreType.OCID);
p.Add("@Name", scoreType.Name);
p.Add("@ParentID", scoreType.ParentID);
p.Add("@UserID", scoreType.ParentID);
conn.Execute("ScoreType_Add", p, commandType: CommandType.StoredProcedure);
scoreType.ScoreTypeID = p.Get<int>("ScoreTypeID");
return scoreType;
}
}
catch (Exception e)
{
return null;
}
}
/// <summary>
/// 更新成绩类别启用状态
/// </summary>
/// <param name="scoreType"></param>
/// <returns></returns>
public bool ScoreType_Status_Upd(ScoreType scoreType)
{
return ScoreTypeDAL.ScoreType_Status_Upd(scoreType);
}
/// <summary>
/// 更新成绩类别名称
/// </summary>
/// <param name="scoreType"></param>
/// <returns></returns>
public bool ScoreType_Name_Upd(ScoreType scoreType)
{
return ScoreTypeDAL.ScoreType_Name_Upd(scoreType);
}
/// <summary>
/// 删除成绩类别
/// </summary>
/// <param name="scoreType"></param>
/// <returns></returns>
public bool ScoreType_Del(ScoreType scoreType)
{
return ScoreTypeDAL.ScoreType_Del(scoreType);
}
/// <summary>
/// 新增成绩类别
/// </summary>
/// <param name="scoreType"></param>
/// <returns></returns>
public ScoreType ScoreType_Add(ScoreType scoreType)
{
return ScoreTypeDAL.ScoreType_Add(scoreType);
}
