/// <summary>
/// 数据绑定
/// </summary>
private void BindData()
{
if (IntParam > 0)
{
CurrencyExchConfig config = FacadeManage.aideTreasureFacade.GetCurrencyExch(IntParam);
if (config != null)
{
CtrlHelper.SetText(txtProductName, config.ConfigName);
CtrlHelper.SetText(txtCurrency, config.Diamond.ToString());
CtrlHelper.SetText(txtGold, config.ExchGold.ToString());
CtrlHelper.SetText(txtSortID, config.SortID.ToString());
CtrlHelper.SetText(txtImageType, config.ImageType.ToString());
}
}
}
/// <summary>
/// 新增兑换金币配置
/// </summary>
/// <param name="config">兑换金币配置</param>
/// <returns></returns>
public int InsertCurrencyExch(CurrencyExchConfig config)
{
string sqlQuery =
@"INSERT INTO CurrencyExchConfig(ConfigName,Diamond,ExchGold,ImageType,SortID) VALUES(@ConfigName,@Diamond,@ExchGold,@ImageType,@SortID)";
var prams = new List <DbParameter>
{
Database.MakeInParam("ConfigName", config.ConfigName),
Database.MakeInParam("Diamond", config.Diamond),
Database.MakeInParam("ExchGold", config.ExchGold),
Database.MakeInParam("ImageType", config.ImageType),
Database.MakeInParam("SortID", config.SortID)
};
return(Database.ExecuteNonQuery(CommandType.Text, sqlQuery, prams.ToArray()));
}
/// <summary>
/// 修改兑换金币配置
/// </summary>
/// <param name="config">兑换金币配置</param>
/// <returns></returns>
public int UpdateCurrencyExch(CurrencyExchConfig config)
{
string sqlQuery =
@"UPDATE CurrencyExchConfig SET ConfigName=@ConfigName,Diamond=@Diamond,ExchGold=@ExchGold,ImageType=@ImageType,SortID=@SortID WHERE ConfigID=@ConfigID";
var prams = new List <DbParameter>
{
Database.MakeInParam("ConfigName", config.ConfigName),
Database.MakeInParam("Diamond", config.Diamond),
Database.MakeInParam("ExchGold", config.ExchGold),
Database.MakeInParam("ImageType", config.ImageType),
Database.MakeInParam("SortID", config.SortID),
Database.MakeInParam("ConfigID", config.ConfigID)
};
return(Database.ExecuteNonQuery(CommandType.Text, sqlQuery, prams.ToArray()));
}
/// <summary>
/// 数据保存
/// </summary>
protected void btnSave_Click(object sender, EventArgs e)
{
CurrencyExchConfig config = new CurrencyExchConfig();
if (IntParam > 0)
{
if (!AuthUserOperationPermission(Permission.Edit))
{
return;
}
config = FacadeManage.aideTreasureFacade.GetCurrencyExch(IntParam);
}
else
{
if (!AuthUserOperationPermission(Permission.Add))
{
return;
}
}
config.ConfigName = CtrlHelper.GetText(txtProductName);
config.Diamond = CtrlHelper.GetInt(txtCurrency, 0);
config.ExchGold = Convert.ToInt64(txtGold.Text);
config.ImageType = Convert.ToByte(txtImageType.Text);
config.SortID = CtrlHelper.GetInt(txtSortID, 0);
//验证是否存在相同钻石配置
if (IntParam <= 0 && FacadeManage.aideTreasureFacade.IsExistCurrencyExch(config.Diamond))
{
ShowError("抱歉，相同额度的钻石已存在");
return;
}
int result = IntParam > 0 ? FacadeManage.aideTreasureFacade.UpdateCurrencyExch(config) : FacadeManage.aideTreasureFacade.InsertCurrencyExch(config);
if (result > 0)
{
ShowInfo("配置信息操作成功", "GoldExchConfigList.aspx", 1200);
}
else
{
ShowError("配置信息操作失败");
}
}
/// <summary>
/// 修改兑换金币配置
/// </summary>
/// <param name="config">兑换金币配置</param>
/// <returns></returns>
public int UpdateCurrencyExch(CurrencyExchConfig config)
{
return(aideTreasureData.UpdateCurrencyExch(config));
}
/// <summary>
/// 新增兑换金币配置
/// </summary>
/// <param name="config">兑换金币配置</param>
/// <returns></returns>
public int InsertCurrencyExch(CurrencyExchConfig config)
{
return(aideTreasureData.InsertCurrencyExch(config));
}
