/// <summary>
/// 获取代理佣金结算
/// </summary>
/// <param name="flowId">结算流水号</param>
/// <returns>代理佣金结算对象</returns>
public virtual TTAgentSettlement Get(long flowId)
{
TTAgentSettlement ttAgentSettlement = null;
try
{
string strSQL = "select * from TTAgentSettlement where flowId=@flowId";
Param param = new Param();
param.Clear();
param.Add("@flowId", flowId);
db.Open();
ComDataReader dr = db.ExecuteReader(CommandType.Text, strSQL, param);
if (dr.Read())
{
ttAgentSettlement = ReadData(dr);
}
dr.Close();
}
catch (Exception e)
{
throw e;
}
finally
{
db.Close();
}
return(ttAgentSettlement);
}
public void ProcessRequest(HttpContext context)
{
try
{
LoginUser loginUser = new LoginUser(context, "AgentCommissionPay");
if (!loginUser.Pass)//权限验证
{
return;
}
//加载DataGrid
if (context.Request["action"] == "gridLoad")
{
AgentSettlementBLL bll = new AgentSettlementBLL(context, loginUser);
int page = int.Parse(context.Request["page"]);
int rows = int.Parse(context.Request["rows"]);
string agentId = context.Request["agentId"];
string agentName = context.Request["agentName"];
string payStatus = context.Request["payStatus"];
string startDate = context.Request["startDate"];
string endDate = context.Request["endDate"];
bll.LoadGrid(page, rows, agentId, agentName, payStatus, startDate, endDate);
return;
}
//加载信息
if (context.Request["action"] == "load")
{
AgentSettlementBLL bll = new AgentSettlementBLL(context, loginUser);
long flowId = long.Parse(context.Request["flowId"]);//结算流水号
bll.Load(flowId);
return;
}
//支付
if (context.Request["action"] == "pay")
{
AgentSettlementBLL bll = new AgentSettlementBLL(context, loginUser);
TTAgentSettlement ttAgentSettlement = new TTAgentSettlement();
ttAgentSettlement.flowId = long.Parse(context.Request["flowId"]);
ttAgentSettlement.payStatus = "1";
ttAgentSettlement.modeId = context.Request["modeId"]; //支付方式
ttAgentSettlement.payTime = context.Request["payTime"]; //支付时间
ttAgentSettlement.cashierId = loginUser.UserId; //支付人编号
ttAgentSettlement.cashierName = loginUser.UserName; //支付人名称
bll.Edit(ttAgentSettlement);
return;
}
//支付方式
if (context.Request["action"] == "handleModeListLoad")
{
Combobox com = new Combobox(context, loginUser);
com.HandleModeCombobox();
}
}
catch (Exception e)
{
Message.error(context, e.Message);
}
}
/// <summary>
/// 加载指定代理佣金结算
/// <param name="flowId">结算流水号</param>
/// </summary>
public void Load(long flowId)
{
try
{
TTAgentSettlement ttAgentSettlement = ttAgentSettlementDAO.Get(flowId);
WebJson.ToJson(context, ttAgentSettlement);
}
catch (Exception e)
{
Message.error(context, e.Message);
}
}
/// <summary>
/// 读取代理佣金结算信息
/// <param name="dr">记录指针</param>
/// </summary>
/// <returns>代理佣金结算对象</returns>
public TTAgentSettlement ReadAgentSettlementData(ComDataReader dr)
{
TTAgentSettlement ttAgentSettlement = new TTAgentSettlement();
ttAgentSettlement.agentId = dr["agentId"].ToString(); //代理商编号
ttAgentSettlement.agentName = dr["agentName"].ToString(); //代理商名称
ttAgentSettlement.startDate = dr["startDate"].ToString(); //结算起始日期
ttAgentSettlement.endDate = dr["endDate"].ToString(); //结算结束日期
ttAgentSettlement.saleFee = double.Parse(dr["saleFee"].ToString()); //销售总额
ttAgentSettlement.rebate = double.Parse(dr["rebate"].ToString()); //返点比例
ttAgentSettlement.commissionFee = double.Parse(dr["commissionFee"].ToString()); //佣金金额
return(ttAgentSettlement);
}
/// <summary>
/// 代理佣金支付
/// <param name="data">数据库连接</param>
/// <param name="ttAgentSettlement">代理佣金结算</param>
/// </summary>
public override void Edit(DataAccess data, TTAgentSettlement ttAgentSettlement)
{
string strSQL = "update TTAgentSettlement set payStatus=@payStatus,modeId=@modeId,payTime=sysdate,cashierId=@cashierId,cashierName=@cashierName where flowId=@flowId";
Param param = new Param();
param.Clear();
param.Add("@payStatus", ttAgentSettlement.payStatus); //支付状态
param.Add("@modeId", ttAgentSettlement.modeId); //支付方式
param.Add("@cashierId", ttAgentSettlement.cashierId); //支付人编号
param.Add("@cashierName", ttAgentSettlement.cashierName); //支付人名称
param.Add("@flowId", ttAgentSettlement.flowId); //结算流水号
data.ExecuteNonQuery(CommandType.Text, strSQL, param);
}
/// <summary>
/// 修改代理佣金结算
/// <param name="ttAgentSettlement">代理佣金结算</param>
/// </summary>
public void Edit(TTAgentSettlement ttAgentSettlement)
{
try
{
ttAgentSettlementDAO.Edit(ttAgentSettlement);
Message.success(context, "代理佣金支付成功");
loginSession.Log(ttAgentSettlement.agentName + "代理佣金支付成功");
}
catch (Exception e)
{
Message.error(context, "代理佣金支付失败");
loginSession.Log(e.Message);
}
}
/// <summary>
/// 增加代理佣金结算
/// </summary>
/// <param name="ttAgentSettlement">代理佣金结算</param>
public virtual void Add(TTAgentSettlement ttAgentSettlement)
{
try
{
db.Open();
Add(db, ttAgentSettlement);
}
catch (Exception e)
{
throw e;
}
finally
{
db.Close();
}
}
/// <summary>
/// 增加代理佣金结算
/// <param name="data">数据库连接</param>
/// <param name="ttAgentSettlement">代理佣金结算</param>
/// </summary>
public override void Add(DataAccess data, TTAgentSettlement ttAgentSettlement)
{
string strSQL = "insert into TTAgentSettlement (flowId,agentId,agentName,startDate,endDate,saleFee,rebate,commissionFee,settlementId,settlementName) values (SAgentSettlement_flowId.Nextval,@agentId,@agentName,@startDate,@endDate,@saleFee,@rebate,@commissionFee,@settlementId,@settlementName)";
Param param = new Param();
param.Clear();
param.Add("@agentId", ttAgentSettlement.agentId); //代理商编号
param.Add("@agentName", ttAgentSettlement.agentName); //代理商名称
param.Add("@startDate", ttAgentSettlement.startDate); //结算起始日期
param.Add("@endDate", ttAgentSettlement.endDate); //结算结束日期
param.Add("@saleFee", ttAgentSettlement.saleFee); //销售总额
param.Add("@rebate", ttAgentSettlement.rebate); //返点比例
param.Add("@commissionFee", ttAgentSettlement.commissionFee); //佣金金额
param.Add("@settlementId", ttAgentSettlement.settlementId); //结算人编号
param.Add("@settlementName", ttAgentSettlement.settlementName); //结算人名称
data.ExecuteNonQuery(CommandType.Text, strSQL, param);
}
public void AddList(List <TTAgentSettlement> agentSettlementList, string startDate, string endDate, string userId, string userName)
{
ComTransaction trans = null;
try
{
db.Open();
trans = db.BeginTransaction();
foreach (var agentSettlement in agentSettlementList)
{
TTAgentSettlement ttAgentSettlement = new TTAgentSettlement();
ttAgentSettlement.agentId = agentSettlement.agentId;
ttAgentSettlement.agentName = agentSettlement.agentName;
ttAgentSettlement.startDate = agentSettlement.startDate;
ttAgentSettlement.endDate = agentSettlement.endDate;
ttAgentSettlement.saleFee = agentSettlement.saleFee;
ttAgentSettlement.rebate = agentSettlement.rebate;
ttAgentSettlement.commissionFee = agentSettlement.commissionFee;
ttAgentSettlement.settlementId = userId;
ttAgentSettlement.settlementName = userName;
this.Add(db, ttAgentSettlement);
}
//根据时间更改订单的状态
string strSQL = @"update TTLotteryOrder set settleStatus='1',settleTime=sysdate" +
" where bettime>='" + startDate + " 00:00:00' " +
" and bettime<='" + endDate + " 23:59:59' " +
" and orderstatus='" + (int)OrderStatus.Ticket + "' " +
" and settleStatus='0'";
Param param = new Param();
db.ExecuteNonQuery(CommandType.Text, strSQL, param);
trans.Commit();
}
catch (Exception e)
{
trans.Rollback();
throw e;
}
finally
{
db.Close();
}
}
/// <summary>
/// 修改代理佣金结算
/// </summary>
/// <param name="data">数据库连接</param>
/// <param name="ttAgentSettlement">代理佣金结算</param>
public virtual void Edit(DataAccess data, TTAgentSettlement ttAgentSettlement)
{
string strSQL = "update TTAgentSettlement set agentId=@agentId,agentName=@agentName,startDate=@startDate,endDate=@endDate,saleFee=@saleFee,rebate=@rebate,commissionFee=@commissionFee,payStatus=@payStatus,modeId=@modeId,settlementTime=To_date(@settlementTime,'yyyy-mm-dd hh24:mi:ss'),settlementId=@settlementId,settlementName=@settlementName,payTime=To_date(@payTime,'yyyy-mm-dd hh24:mi:ss'),cashierId=@cashierId,cashierName=@cashierName where flowId=@flowId";
Param param = new Param();
param.Clear();
param.Add("@agentId", ttAgentSettlement.agentId); //代理商编号
param.Add("@agentName", ttAgentSettlement.agentName); //代理商名称
param.Add("@startDate", ttAgentSettlement.startDate); //结算起始日期
param.Add("@endDate", ttAgentSettlement.endDate); //结算结束日期
param.Add("@saleFee", ttAgentSettlement.saleFee); //销售总额
param.Add("@rebate", ttAgentSettlement.rebate); //返点比例
param.Add("@commissionFee", ttAgentSettlement.commissionFee); //佣金金额
param.Add("@payStatus", ttAgentSettlement.payStatus); //支付状态
param.Add("@modeId", ttAgentSettlement.modeId); //支付方式
param.Add("@settlementTime", ttAgentSettlement.settlementTime); //结算时间
param.Add("@settlementId", ttAgentSettlement.settlementId); //结算人编号
param.Add("@settlementName", ttAgentSettlement.settlementName); //结算人名称
param.Add("@payTime", ttAgentSettlement.payTime); //支付时间
param.Add("@cashierId", ttAgentSettlement.cashierId); //支付人编号
param.Add("@cashierName", ttAgentSettlement.cashierName); //支付人名称
param.Add("@flowId", ttAgentSettlement.flowId); //结算流水号
data.ExecuteNonQuery(CommandType.Text, strSQL, param);
}
/// <summary>
/// 读取代理佣金结算信息
/// </summary>
/// <param name="dr">记录指针</param>
/// <returns>代理佣金结算对象</returns>
protected virtual TTAgentSettlement ReadData(ComDataReader dr)
{
TTAgentSettlement ttAgentSettlement = new TTAgentSettlement();
ttAgentSettlement.flowId = long.Parse(dr["flowId"].ToString()); //结算流水号
ttAgentSettlement.agentId = dr["agentId"].ToString(); //代理商编号
ttAgentSettlement.agentName = dr["agentName"].ToString(); //代理商名称
ttAgentSettlement.startDate = dr["startDate"].ToString(); //结算起始日期
ttAgentSettlement.endDate = dr["endDate"].ToString(); //结算结束日期
ttAgentSettlement.saleFee = double.Parse(dr["saleFee"].ToString()); //销售总额
ttAgentSettlement.rebate = double.Parse(dr["rebate"].ToString()); //返点比例
ttAgentSettlement.commissionFee = double.Parse(dr["commissionFee"].ToString()); //佣金金额
ttAgentSettlement.payStatus = dr["payStatus"].ToString(); //支付状态
ttAgentSettlement.modeId = dr["modeId"].ToString(); //支付方式
if (dr["settlementTime"] == null)
{
ttAgentSettlement.settlementTime = "";//结算时间
}
else
{
ttAgentSettlement.settlementTime = string.Format("{0:yyyy-MM-dd HH:mm:ss}", dr["settlementTime"]); //结算时间
}
ttAgentSettlement.settlementId = dr["settlementId"].ToString(); //结算人编号
ttAgentSettlement.settlementName = dr["settlementName"].ToString(); //结算人名称
if (dr["payTime"] == null)
{
ttAgentSettlement.payTime = "";//支付时间
}
else
{
ttAgentSettlement.payTime = string.Format("{0:yyyy-MM-dd HH:mm:ss}", dr["payTime"]); //支付时间
}
ttAgentSettlement.cashierId = dr["cashierId"].ToString(); //支付人编号
ttAgentSettlement.cashierName = dr["cashierName"].ToString(); //支付人名称
return(ttAgentSettlement);
}
