/// <summary>
/// 数据绑定
/// </summary>
private void BindData()
{
if (IntParam > 0)
{
ddlProductType.Enabled = false;
AppPayConfig config = FacadeManage.aideTreasureFacade.GetAppPayConfig(IntParam);
if (config != null)
{
CtrlHelper.SetText(txtAppleID, config.AppleID);
CtrlHelper.SetText(txtCurrency, config.Score.ToString());
CtrlHelper.SetText(txtPrice, config.PayPrice.ToString(CultureInfo.InvariantCulture));
CtrlHelper.SetText(txtProductName, config.PayName);
CtrlHelper.SetText(txtPresentScore, config.PresentScore.ToString());
CtrlHelper.SetText(txtFristPresent, config.FristPresent.ToString());
CtrlHelper.SetText(txtSortID, config.SortID.ToString());
ddlProductType.SelectedValue = config.PayType.ToString();
ddlScoreType.SelectedValue = config.ScoreType.ToString();
rbImage.SelectedValue = config.ImageType.ToString();
DropFirstType.SelectedValue = config.PayIdentity.ToString();
apple.Visible = config.PayType > 0;
}
}
else
{
apple.Visible = false;
}
}
/// <summary>
/// 修改充值产品
/// </summary>
/// <param name="config">充值产品</param>
/// <returns></returns>
public int UpdateAppPayConfig(AppPayConfig config)
{
StringBuilder sqlQuery = new StringBuilder();
sqlQuery.Append("UPDATE AppPayConfig SET ")
.Append("AppleID=@AppleID, ")
.Append("PayName=@PayName, ")
.Append("PayType=@PayType, ")
.Append("PayPrice=@PayPrice, ")
.Append("PayIdentity=@PayIdentity, ")
.Append("ImageType=@ImageType, ")
.Append("Diamond=@Diamond, ")
.Append("PresentDiamond=@PresentDiamond, ")
.Append("SortID=@SortID ")
.Append("WHERE ConfigID=@ConfigID");
var prams = new List <DbParameter>
{
Database.MakeInParam("AppleID", config.AppleID),
Database.MakeInParam("PayName", config.PayName),
Database.MakeInParam("PayType", config.PayType),
Database.MakeInParam("PayPrice", config.PayPrice),
Database.MakeInParam("PayIdentity", config.PayIdentity),
Database.MakeInParam("ImageType", config.ImageType),
Database.MakeInParam("Diamond", config.Diamond),
Database.MakeInParam("PresentDiamond", config.PresentDiamond),
Database.MakeInParam("SortID", config.SortID),
Database.MakeInParam("ConfigID", config.ConfigID)
};
return(Database.ExecuteNonQuery(CommandType.Text, sqlQuery.ToString(), prams.ToArray()));
}
/// <summary>
/// 新增、修改充值产品
/// </summary>
/// <param name="config">充值产品</param>
/// <returns></returns>
public int SaveAppPayConfig(AppPayConfig config)
{
var prams = new List <DbParameter>
{
Database.MakeInParam("AppleID", config.AppleID),
Database.MakeInParam("PayName", config.PayName),
Database.MakeInParam("PayType", config.PayType),
Database.MakeInParam("PayPrice", config.PayPrice),
Database.MakeInParam("PayIdentity", config.PayIdentity),
Database.MakeInParam("ImageType", config.ImageType),
Database.MakeInParam("SortID", config.SortID),
Database.MakeInParam("ScoreType", config.ScoreType),
Database.MakeInParam("Score", config.Score),
Database.MakeInParam("PresentScore", config.PresentScore),
Database.MakeInParam("FristPresent", config.FristPresent),
Database.MakeInParam("ConfigTime", config.ConfigTime)
};
string sqlQuery;
if (config.ConfigID == 0)
{
sqlQuery = @"INSERT INTO AppPayConfig(AppleID,PayName,PayType,PayPrice,PayIdentity,ImageType,SortID,Score,FristPresent,PresentScore,ScoreType,ConfigTime)
VALUES(@AppleID,@PayName,@PayType,@PayPrice,@PayIdentity,@ImageType,@SortID,@Diamond,@PresentDiamond,@ConfigTime)";
}
else
{
prams.Add(Database.MakeInParam("ConfigID", config.ConfigID));
StringBuilder sql = new StringBuilder();
sql.Append("UPDATE AppPayConfig SET ")
.Append("AppleID=@AppleID, ")
.Append("PayName=@PayName, ")
.Append("PayType=@PayType, ")
.Append("PayPrice=@PayPrice, ")
.Append("PayIdentity=@PayIdentity, ")
.Append("ImageType=@ImageType, ")
.Append("Score=@Score, ")
.Append("ScoreType=@ScoreType, ")
.Append("PresentScore=@PresentScore, ")
.Append("FristPresent=@FristPresent, ")
.Append("SortID=@SortID ")
.Append("WHERE ConfigID=@ConfigID");
sqlQuery = sql.ToString();
}
return(Database.ExecuteNonQuery(CommandType.Text, sqlQuery, prams.ToArray()));
}
/// <summary>
/// 新增充值产品
/// </summary>
/// <param name="config">充值产品</param>
/// <returns></returns>
public int InsertAppPayConfig(AppPayConfig config)
{
string sqlQuery =
@"INSERT INTO AppPayConfig(AppleID,PayName,PayType,PayPrice,PayIdentity,ImageType,SortID,Diamond,PresentDiamond,ConfigTime)
VALUES(@AppleID,@PayName,@PayType,@PayPrice,@PayIdentity,@ImageType,@SortID,@Diamond,@PresentDiamond,@ConfigTime)";
var prams = new List <DbParameter>
{
Database.MakeInParam("AppleID", config.AppleID),
Database.MakeInParam("PayName", config.PayName),
Database.MakeInParam("PayType", config.PayType),
Database.MakeInParam("PayPrice", config.PayPrice),
Database.MakeInParam("PayIdentity", config.PayIdentity),
Database.MakeInParam("ImageType", config.ImageType),
Database.MakeInParam("SortID", config.SortID),
Database.MakeInParam("Diamond", config.Diamond),
Database.MakeInParam("PresentDiamond", config.PresentDiamond),
Database.MakeInParam("ConfigTime", config.ConfigTime)
};
return(Database.ExecuteNonQuery(CommandType.Text, sqlQuery, prams.ToArray()));
}
/// <summary>
/// 修改充值产品
/// </summary>
/// <param name="config">充值产品</param>
/// <returns></returns>
public int UpdateAppPayConfig(AppPayConfig config)
{
return(aideTreasureData.UpdateAppPayConfig(config));
}
/// <summary>
/// 新增充值产品
/// </summary>
/// <param name="config">充值产品</param>
/// <returns></returns>
public int InsertAppPayConfig(AppPayConfig config)
{
return(aideTreasureData.InsertAppPayConfig(config));
}
/// <summary>
/// 新增、修改充值产品
/// </summary>
/// <param name="config">充值产品</param>
/// <returns></returns>
public int SaveAppPayConfig(AppPayConfig config)
{
return(aideTreasureData.SaveAppPayConfig(config));
}
/// <summary>
/// 数据保存
/// </summary>
protected void btnSave_Click(object sender, EventArgs e)
{
AppPayConfig config = new AppPayConfig();
if (IntParam > 0)
{
if (!AuthUserOperationPermission(Permission.Edit))
{
return;
}
config = FacadeManage.aideTreasureFacade.GetAppPayConfig(IntParam);
}
else
{
if (!AuthUserOperationPermission(Permission.Add))
{
return;
}
}
config.AppleID = CtrlHelper.GetText(txtAppleID);
config.Score = CtrlHelper.GetInt(txtCurrency, 0);
config.ScoreType = Convert.ToByte(ddlScoreType.SelectedValue);
config.PayName = CtrlHelper.GetText(txtProductName);
config.PayPrice = Convert.ToDecimal(txtPrice.Text);
config.PayType = Convert.ToByte(ddlProductType.SelectedValue);
config.PresentScore = CtrlHelper.GetInt(txtPresentScore, 0);
config.FristPresent = CtrlHelper.GetInt(txtFristPresent, 0);
config.SortID = CtrlHelper.GetInt(txtSortID, 0);
config.ImageType = Convert.ToByte(rbImage.SelectedValue);
config.PayIdentity = Convert.ToByte(DropFirstType.SelectedValue);
string where;
//验证苹果产品标识
if (config.PayType == 1)
{
if (string.IsNullOrEmpty(config.AppleID))
{
ShowError("操作失败，苹果产品标识不能为空");
return;
}
where = IntParam > 0 ? $"WHERE ConfigID!={IntParam} AND PayType = 1 AND AppleID = '{config.AppleID}'" : $"WHERE PayType = 1 AND AppleID = '{config.AppleID}'";
if (FacadeManage.aideTreasureFacade.IsExistAppPayConfig(where))
{
ShowError("操作失败，苹果产品标识已存在");
return;
}
}
//验证首充是否重复
// if(config.PayIdentity == 2 && IntParam == 0)
// {
// where = $"WHERE PayType = {config.PayType} AND PayIdentity = 2";
// if(FacadeManage.aideTreasureFacade.IsExistAppPayConfig(where))
// {
// ShowError("操作失败，首充产品仅限配置一个");
// return;
// }
// }
if (IntParam > 0)
{
config.ConfigID = IntParam;
}
int result = FacadeManage.aideTreasureFacade.SaveAppPayConfig(config);
if (result > 0)
{
ShowInfo("配置信息操作成功", "AppPayConfigList.aspx", 1200);
}
else
{
ShowError("配置信息操作失败");
}
}
