/// <summary>
/// 保存代理返利配置（新增，修改）
/// </summary>
/// <param name="cfg"></param>
/// <returns></returns>
public int SaveAgentReturnConfig(ReturnAwardConfig cfg)
{
var prams = new List <DbParameter>
{
Database.MakeInParam(ReturnAwardConfig._AwardLevel, cfg.AwardLevel),
Database.MakeInParam(ReturnAwardConfig._AwardScale, cfg.AwardScale),
Database.MakeInParam(ReturnAwardConfig._AwardType, cfg.AwardType),
Database.MakeInParam(ReturnAwardConfig._Nullity, cfg.Nullity),
Database.MakeInParam(ReturnAwardConfig._UpdateTime, cfg.UpdateTime)
};
string sql;
if (cfg.ConfigID > 0)
{
prams.Add(Database.MakeInParam(ReturnAwardConfig._ConfigID, cfg.ConfigID));
sql = $" UPDATE {ReturnAwardConfig.Tablename} " +
$" SET {ReturnAwardConfig._AwardLevel} = @{ReturnAwardConfig._AwardLevel}," +
$" {ReturnAwardConfig._AwardScale} = @{ReturnAwardConfig._AwardScale}," +
$" {ReturnAwardConfig._AwardType} = @{ReturnAwardConfig._AwardType}," +
$" {ReturnAwardConfig._Nullity} = @{ReturnAwardConfig._Nullity}," +
$" {ReturnAwardConfig._UpdateTime} = @{ReturnAwardConfig._UpdateTime} " +
$"WHERE {ReturnAwardConfig._ConfigID} = @{ReturnAwardConfig._ConfigID}";
}
else
{
sql = $" IF NOT EXISTS (SELECT 1 FROM {ReturnAwardConfig.Tablename}(NOLOCK) WHERE {ReturnAwardConfig._AwardLevel}={cfg.AwardLevel} AND {ReturnAwardConfig._AwardType}={cfg.AwardType})" +
"BEGIN " +
$" INSERT {ReturnAwardConfig.Tablename} ({ReturnAwardConfig._AwardLevel},{ReturnAwardConfig._AwardScale},{ReturnAwardConfig._AwardType} ,{ReturnAwardConfig._Nullity},{ReturnAwardConfig._UpdateTime})" +
$" VALUES (@{ReturnAwardConfig._AwardLevel},@{ReturnAwardConfig._AwardScale},@{ReturnAwardConfig._AwardType},@{ReturnAwardConfig._Nullity},@{ReturnAwardConfig._UpdateTime}) " +
"END ";
}
return(Database.ExecuteNonQuery(CommandType.Text, sql, prams.ToArray()));
}
/// <summary>
/// 数据绑定
/// </summary>
private void BindData()
{
if (IntParam <= 0)
{
return;
}
ReturnAwardConfig config = FacadeManage.aideAgentFacade.GetAgentReturnConfig(IntParam);
if (config == null)
{
return;
}
CtrlHelper.SetText(txtPresentScale, (config.AwardScale * 1000).ToString("F2"));
CtrlHelper.SetText(txtAwardLevel, config.AwardLevel.ToString());
ddlAwardType.SelectedValue = config.AwardType.ToString();
rblNullity.SelectedValue = config.Nullity.ToString();
ddlAwardType.Enabled = false;
}
/// <summary>
/// 数据保存
/// </summary>
protected void btnSave_Click(object sender, EventArgs e)
{
ReturnAwardConfig cfg = new ReturnAwardConfig();
if (IntParam > 0)
{
if (!AuthUserOperationPermission(Permission.Edit))
{
return;
}
cfg = FacadeManage.aideAgentFacade.GetAgentReturnConfig(IntParam);
}
else
{
if (!AuthUserOperationPermission(Permission.Add))
{
return;
}
}
cfg.AwardLevel = Convert.ToInt32(ddlLevel.SelectedValue);
cfg.AwardScale = Convert.ToDecimal(txtPresentScale.Text) / 1000;
cfg.AwardType = Convert.ToByte(ddlAwardType.SelectedValue);
cfg.Nullity = Convert.ToBoolean(rblNullity.SelectedValue);
cfg.UpdateTime = DateTime.Now;
if (cfg.AwardLevel == 0)
{
ShowError("必须选择返利类型");
return;
}
int result = FacadeManage.aideAgentFacade.SaveAgentReturnConfig(cfg);
if (result > 0)
{
ShowInfo("操作成功", "AgentReturnConfigList.aspx", 1200);
}
else
{
ShowError("返利已存在或操作失败");
}
}
/// <summary>
/// 保存代理返利配置（新增，修改）
/// </summary>
/// <param name="cfg"></param>
/// <returns></returns>
public int SaveAgentReturnConfig(ReturnAwardConfig cfg)
{
return(agentData.SaveAgentReturnConfig(cfg));
}
