/// <summary>
/// 修改等级
/// 作者：郭孟稳
/// 时间：2016.07.13
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public bool UpdateLevel(MallUserLevelModel model)
{
string strsql = @"update Mall_UserLevel set UL_LevelName=@UL_LevelName,UL_Type=@UL_Type,UL_CustomerID=@UL_CustomerID,UL_Description=@UL_Description,UL_DefaultLevel=@UL_DefaultLevel,UL_Integral=@UL_Integral,UL_MemberNum=@UL_MemberNum,UL_DirectTeamNum=@UL_DirectTeamNum,UL_IndirectTeamNum=@UL_IndirectTeamNum,UL_Money=@UL_Money,UL_OpenLevel_One=@UL_OpenLevel_One,UL_BelongOne_Content=@UL_BelongOne_Content,UL_OpenLevel_Two=@UL_OpenLevel_Two,UL_BelongTwo_Content=@UL_BelongTwo_Content,UL_GuidetLevel=@UL_GuidetLevel,UL_Gold=@UL_Gold where UL_ID=@UL_ID";
SqlParameter[] parm =
{
new SqlParameter("@UL_ID", model.UL_ID),
new SqlParameter("@UL_LevelName", model.UL_LevelName),
new SqlParameter("@UL_Type", model.UL_Type),
new SqlParameter("@UL_CustomerID", model.UL_CustomerID),
new SqlParameter("@UL_Description", model.UL_Description),
new SqlParameter("@UL_DefaultLevel", model.UL_DefaultLevel),
new SqlParameter("@UL_Integral", model.UL_Integral),
new SqlParameter("@UL_MemberNum", model.UL_MemberNum),
new SqlParameter("@UL_DirectTeamNum", model.UL_DirectTeamNum),
new SqlParameter("@UL_IndirectTeamNum", model.UL_IndirectTeamNum),
new SqlParameter("@UL_Money", model.UL_Money),
new SqlParameter("@UL_OpenLevel_One", model.UL_OpenLevel_One),
new SqlParameter("@UL_BelongOne_Content", model.UL_BelongOne_Content),
new SqlParameter("@UL_OpenLevel_Two", model.UL_OpenLevel_Two),
new SqlParameter("@UL_BelongTwo_Content", model.UL_BelongTwo_Content),
new SqlParameter("@UL_GuidetLevel", model.UL_GuidetLevel),
new SqlParameter("@UL_Gold", model.UL_Gold),
};
return(DbHelperSQLP.ExecuteNonQuery(WebConfig.getConnectionString(), CommandType.Text, strsql, parm) == 1);
}
/// <summary>
/// 添加等级
/// 作者：郭孟稳
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public int InsertLevel(MallUserLevelModel model)
{
string strsql = @"insert into Mall_UserLevel (UL_Level,UL_LevelName,UL_Type,UL_CustomerID,UL_Description,UL_DefaultLevel,UL_Integral
,UL_MemberNum,UL_DirectTeamNum,UL_IndirectTeamNum,UL_Money,UL_OpenLevel_One,UL_BelongOne_Content,UL_OpenLevel_Two,UL_BelongTwo_Content,UL_GuidetLevel,UL_Gold)
values (@UL_Level,@UL_LevelName,@UL_Type,@UL_CustomerID,@UL_Description,@UL_DefaultLevel,@UL_Integral
,@UL_MemberNum,@UL_DirectTeamNum,@UL_IndirectTeamNum,@UL_Money,@UL_OpenLevel_One,@UL_BelongOne_Content,@UL_OpenLevel_Two,@UL_BelongTwo_Content,@UL_GuidetLevel,@UL_Gold)
select @@IDENTITY";
SqlParameter[] parm =
{
new SqlParameter("@UL_Level", model.UL_Level),
new SqlParameter("@UL_LevelName", model.UL_LevelName),
new SqlParameter("@UL_Type", model.UL_Type),
new SqlParameter("@UL_CustomerID", model.UL_CustomerID),
new SqlParameter("@UL_Description", model.UL_Description),
new SqlParameter("@UL_DefaultLevel", model.UL_DefaultLevel),
new SqlParameter("@UL_Integral", model.UL_Integral),
new SqlParameter("@UL_MemberNum", model.UL_MemberNum),
new SqlParameter("@UL_DirectTeamNum", model.UL_DirectTeamNum),
new SqlParameter("@UL_IndirectTeamNum", model.UL_IndirectTeamNum),
new SqlParameter("@UL_Money", model.UL_Money),
new SqlParameter("@UL_OpenLevel_One", model.UL_OpenLevel_One),
new SqlParameter("@UL_BelongOne_Content", model.UL_BelongOne_Content),
new SqlParameter("@UL_OpenLevel_Two", model.UL_OpenLevel_Two),
new SqlParameter("@UL_BelongTwo_Content", model.UL_BelongTwo_Content),
new SqlParameter("@UL_GuidetLevel", model.UL_GuidetLevel),
new SqlParameter("@UL_Gold", model.UL_Gold)
};
return(Convert.ToInt32(DbHelperSQLP.ExecuteScalar(WebConfig.getConnectionString(), CommandType.Text, strsql, parm)));
}
/// <summary>
/// 获取等级信息
/// </summary>
/// <param name="level">级别</param>
/// <param name="storeId">商户ID</param>
/// <returns></returns>
public MallUserLevelModel GetLevelModel(int levelId, int storeId)
{
string strsql = @"select UL.* from Mall_UserLevel UL
where UL.UL_ID=@UL_ID and UL_CustomerID=@UL_CustomerID";
SqlParameter[] parm =
{
new SqlParameter("@UL_ID", levelId),
new SqlParameter("@UL_CustomerID", storeId)
};
MallUserLevelModel model = null;
using (IDataReader dr = DbHelperSQLP.ExecuteReader(WebConfig.getConnectionString(), CommandType.Text, strsql, parm))
{
model = DbHelperSQLP.GetEntity <MallUserLevelModel>(dr);
}
return(model);
}
/// <summary>
/// 编辑等级
/// </summary>
/// <param name="levelId"></param>
/// <param name="levelType"></param>
/// <param name="levelname"></param>
/// <param name="upgradeCount"></param>
/// <returns></returns>
public static bool EditLevel(int levelId, int levelType, string levelname, int upgradeCount)
{
using (var dal = FactoryDispatcher.UserFactory())
{
MallUserLevelModel model = new MallUserLevelModel()
{
IntegralPreID = 0,
PricePreID = 0,
UL_BelongOne_Content = "",
UL_BelongTwo_Content = "",
UL_CustomerID = ConstConfig.storeId,
UL_DefaultLevel = 0,
UL_Description = "",
UL_DirectTeamNum = 0,
UL_Gold = 0,
UL_GuidetLevel = -1,
UL_ID = levelId,
UL_IndirectTeamNum = 0,
UL_Integral = 0,
UL_Level = 1,
UL_LevelName = levelname,
UL_MemberNum = upgradeCount,
UL_Money = 0,
UL_OpenLevel_One = false,
UL_OpenLevel_Two = false,
UL_Type = levelType,
};
if (levelId > 0)
{
model.UL_Level = dal.GetLevelCount(ConstConfig.storeId, levelType) + 1;
return(dal.UpdateLevel(model));
}
else
{
model.UL_Level = dal.GetMaxLevel(ConstConfig.storeId, levelType) + 1;
return(dal.InsertLevel(model) > 0);
}
}
}
