public int SaveImgPay(OfficalImgPay officalImgPay)
{
var prams = new List <DbParameter>
{
Database.MakeInParam("ConfigName", officalImgPay.ConfigName),
Database.MakeInParam("payType", officalImgPay.PayType),
Database.MakeInParam("PayUrl", officalImgPay.PayUrl),
Database.MakeInParam("MaxAmount", officalImgPay.MaxAmount),
Database.MakeInParam("MinAmount", officalImgPay.MinAmount),
Database.MakeInParam("SortId", officalImgPay.SortId),
Database.MakeInParam("Nullity", officalImgPay.Nullity),
Database.MakeInParam("Description", officalImgPay.Description)
};
string sqlQuery;
if (officalImgPay.id == 0)
{
sqlQuery = @"INSERT INTO [dbo].[OfficalImgPay]( [ConfigName], [payType], [PayUrl], [MaxAmount], [MinAmount], [SortId], [Nullity],[Description])
VALUES (@ConfigName,@payType,@PayUrl,@MaxAmount,@MinAmount,@SortId,@Nullity,@Description)";
}
else
{
prams.Add(Database.MakeInParam("id", officalImgPay.id));
sqlQuery = @"UPDATE [dbo].[OfficalImgPay] SET ConfigName=@ConfigName,payType=@payType,PayUrl=@PayUrl,MaxAmount=@MaxAmount,MinAmount=@MinAmount,SortId=@SortId,Nullity=@Nullity,Description=@Description WHERE id=@id";
}
return(Database.ExecuteNonQuery(CommandType.Text, sqlQuery, prams.ToArray()));
}
private void BindData()
{
if (IntParam > 0)
{
OfficalImgPay chanel = FacadeManage.aideTreasureFacade.GetImgPayById(IntParam);
TxtName.Text = chanel.ConfigName;
ddlProductType.SelectedValue = chanel.PayType.ToString();
PayUrl.Text = chanel.PayUrl;
TexMax.Text = FacadeManage.ConversionMoneyToShow(chanel.MaxAmount).ToString();
TexMin.Text = FacadeManage.ConversionMoneyToShow(chanel.MinAmount).ToString();
TextBoxPre.Text = chanel.PresentScore.ToString();
TexDescription.Text = chanel.Description;
TexSort.Text = chanel.SortId.ToString();
ckbLock.Checked = chanel.Nullity == 1;
}
}
protected void btnSave_Click(object sender, EventArgs e)
{
OfficalImgPay chanel = new OfficalImgPay();
if (IntParam > 0)
{
if (!AuthUserOperationPermission(Permission.Edit))
{
return;
}
chanel = FacadeManage.aideTreasureFacade.GetImgPayById(IntParam);
}
else
{
if (!AuthUserOperationPermission(Permission.Add))
{
return;
}
}
chanel.ConfigName = TxtName.Text;
chanel.PayType = Convert.ToByte(ddlProductType.SelectedValue);
chanel.PayUrl = PayUrl.Text;
chanel.MinAmount = FacadeManage.ConversionMoneyToReal(Convert.ToInt32(TexMin.Text));
chanel.MaxAmount = FacadeManage.ConversionMoneyToReal(Convert.ToInt32(TexMax.Text));
chanel.Description = TexDescription.Text;
chanel.PresentScore = Convert.ToInt32(TextBoxPre.Text);
chanel.SortId = Convert.ToInt32(TexSort.Text);
chanel.Nullity = (byte)(ckbLock.Checked ? 1 : 0);
int result = FacadeManage.aideTreasureFacade.SaveImgPay(chanel);
if (result > 0)
{
ShowInfo("配置信息操作成功", "OfficalImgPayList.aspx", 1200);
}
else
{
ShowError("配置信息操作失败");
}
}
public int SaveImgPay(OfficalImgPay officalImgPay)
{
return(aideTreasureData.SaveImgPay(officalImgPay));
}
