/// <summary>
/// 数据保存
/// </summary>
protected void btnSave_Click(object sender, EventArgs e)
{
RankingConfig config = new RankingConfig();
config.TypeID = Convert.ToByte(ddlType.SelectedValue);
config.RankType = Convert.ToInt32(ddlRank.SelectedValue);
if (IntParam > 0)
{
if (!AuthUserOperationPermission(Permission.Edit))
{
return;
}
config = FacadeManage.aideNativeWebFacade.GetRankingConfigById(IntParam);
}
else
{
if (!AuthUserOperationPermission(Permission.Add))
{
return;
}
if (FacadeManage.aideNativeWebFacade.ExistRankingConfig(config.TypeID, config.RankType))
{
ShowError("相同配置信息已存在");
return;
}
}
config.AwardTicket = CtrlHelper.GetInt(txtAwardTicket, 0);
config.Diamond = CtrlHelper.GetInt(txtDiamond, 0);
config.Gold = Convert.ToInt64(CtrlHelper.GetText(txtGold));
int result = 0;
if (IntParam > 0)
{
result = FacadeManage.aideNativeWebFacade.UpdateRankingConfig(config);
}
else
{
result = FacadeManage.aideNativeWebFacade.InsertRankingConfig(config);
}
if (result > 0)
{
ShowInfo("操作成功", "RankingConfigList.aspx", 1200);
}
else
{
ShowError("操作失败");
}
}
/// <summary>
/// 数据绑定
/// </summary>
private void BindData()
{
if (IntParam > 0)
{
RankingConfig config = FacadeManage.aideNativeWebFacade.GetRankingConfigById(IntParam);
if (config != null)
{
CtrlHelper.SetText(txtDiamond, config.Diamond.ToString());
CtrlHelper.SetText(txtRankID, config.RankID.ToString());
CtrlHelper.SetText(txtValidityTime, config.ValidityTime.ToString());
ddlType.SelectedValue = config.TypeID.ToString();
}
}
}
/// <summary>
/// 新增排行榜配置
/// </summary>
/// <param name="config">配置信息</param>
/// <returns></returns>
public int InsertRankingConfig(RankingConfig config)
{
string sql = @"INSERT INTO RankingConfig(TypeID,RankID,Diamond,ValidityTime,UpdateTime)
VALUES(@TypeID,@RankID,@Diamond,@ValidityTime,@UpdateTime)";
var prams = new List <DbParameter>
{
Database.MakeInParam("TypeID", config.TypeID),
Database.MakeInParam("RankID", config.RankID),
Database.MakeInParam("Diamond", config.Diamond),
Database.MakeInParam("ValidityTime", config.ValidityTime),
Database.MakeInParam("UpdateTime", config.UpdateTime)
};
return(Database.ExecuteNonQuery(CommandType.Text, sql, prams.ToArray()));
}
/// <summary>
/// 数据绑定
/// </summary>
private void BindData()
{
if (IntParam > 0)
{
RankingConfig config = FacadeManage.aideNativeWebFacade.GetRankingConfigById(IntParam);
if (config != null)
{
CtrlHelper.SetText(txtAwardTicket, config.AwardTicket.ToString());
CtrlHelper.SetText(txtDiamond, config.Diamond.ToString());
CtrlHelper.SetText(txtGold, config.Gold.ToString());
ddlType.SelectedValue = config.TypeID.ToString();
ddlRank.SelectedValue = config.RankType.ToString();
}
}
}
/// <summary>
/// 新增排行榜配置
/// </summary>
/// <param name="config">配置信息</param>
/// <returns></returns>
public int InsertRankingConfig(RankingConfig config)
{
string sql = @"INSERT INTO RankingConfig(TypeID,RankType,Gold,Diamond,AwardTicket,CollectDate)
VALUES(@TypeID,@RankType,@Gold,@Diamond,@AwardTicket,@CollectDate)";
var prams = new List <DbParameter>
{
Database.MakeInParam("TypeID", config.TypeID),
Database.MakeInParam("RankType", config.RankType),
Database.MakeInParam("Gold", config.Gold),
Database.MakeInParam("Diamond", config.Diamond),
Database.MakeInParam("AwardTicket", config.AwardTicket),
Database.MakeInParam("CollectDate", config.CollectDate)
};
return(Database.ExecuteNonQuery(CommandType.Text, sql, prams.ToArray()));
}
/// <summary>
/// 修改排行榜配置
/// </summary>
/// <param name="config">配置信息</param>
/// <returns></returns>
public int UpdateRankingConfig(RankingConfig config)
{
string sql = @"UPDATE RankingConfig SET TypeID=@TypeID,RankID=@RankID,Diamond=@Diamond,
ValidityTime=@ValidityTime,UpdateTime=@UpdateTime WHERE ConfigID=@ConfigID";
var prams = new List <DbParameter>
{
Database.MakeInParam("TypeID", config.TypeID),
Database.MakeInParam("RankID", config.RankID),
Database.MakeInParam("Diamond", config.Diamond),
Database.MakeInParam("ValidityTime", config.ValidityTime),
Database.MakeInParam("UpdateTime", config.UpdateTime),
Database.MakeInParam("ConfigID", config.ConfigID)
};
return(Database.ExecuteNonQuery(CommandType.Text, sql, prams.ToArray()));
}
/// <summary>
/// 修改排行榜配置
/// </summary>
/// <param name="config">配置信息</param>
/// <returns></returns>
public int UpdateRankingConfig(RankingConfig config)
{
string sql = @"UPDATE RankingConfig SET TypeID=@TypeID,RankType=@RankType,Gold=@Gold,
Diamond=@Diamond,AwardTicket=@AwardTicket,CollectDate=@CollectDate WHERE ConfigID=@ConfigID";
var prams = new List <DbParameter>
{
Database.MakeInParam("TypeID", config.TypeID),
Database.MakeInParam("RankType", config.RankType),
Database.MakeInParam("Gold", config.Gold),
Database.MakeInParam("Diamond", config.Diamond),
Database.MakeInParam("AwardTicket", config.AwardTicket),
Database.MakeInParam("CollectDate", config.CollectDate),
Database.MakeInParam("ConfigID", config.ConfigID)
};
return(Database.ExecuteNonQuery(CommandType.Text, sql, prams.ToArray()));
}
/// <summary>
/// 数据保存
/// </summary>
protected void btnSave_Click(object sender, EventArgs e)
{
RankingConfig config = new RankingConfig();
if (IntParam > 0)
{
AuthUserOperationPermission(Permission.Edit);
config = FacadeManage.aideNativeWebFacade.GetRankingConfigById(IntParam);
}
else
{
AuthUserOperationPermission(Permission.Add);
if (FacadeManage.aideNativeWebFacade.ExistRankingConfig(config.TypeID, config.RankID))
{
ShowError("相同配置信息已存在");
return;
}
}
config.Diamond = CtrlHelper.GetInt(txtDiamond, 0);
config.RankID = CtrlHelper.GetInt(txtRankID, 0);
config.ValidityTime = CtrlHelper.GetInt(txtValidityTime, 0);
config.TypeID = Convert.ToByte(ddlType.SelectedValue);
config.UpdateTime = DateTime.Now;
int result = IntParam > 0 ? FacadeManage.aideNativeWebFacade.UpdateRankingConfig(config) : FacadeManage.aideNativeWebFacade.InsertRankingConfig(config);
if (result > 0)
{
ShowInfo("操作成功", "RankingConfigList.aspx", 1200);
}
else
{
ShowError("操作失败");
}
}
/// <summary>
/// 修改排行榜配置
/// </summary>
/// <param name="config">配置信息</param>
/// <returns></returns>
public int UpdateRankingConfig(RankingConfig config)
{
return(_aideNativeWebData.UpdateRankingConfig(config));
}
/// <summary>
/// 新增排行榜配置
/// </summary>
/// <param name="config">配置信息</param>
/// <returns></returns>
public int InsertRankingConfig(RankingConfig config)
{
return(_aideNativeWebData.InsertRankingConfig(config));
}
