コード例 #1
0
 /// <summary>
 /// 加载指定代理账户明细
 /// <param name="flowId">编号</param>
 /// </summary>
 public void Load(long flowId)
 {
     try
     {
         TTAgentAccDetail ttAgentAccDetail = ttAgentAccDetailDAO.Get(flowId);
         WebJson.ToJson(context, ttAgentAccDetail);
     }
     catch (Exception e)
     {
         Message.error(context, e.Message);
     }
 }
コード例 #2
0
 /// <summary>
 /// 增加代理账户明细
 /// <param name="ttAgentAccDetail">代理账户明细</param>
 /// </summary>
 public void Add(TTAgentAccDetail ttAgentAccDetail)
 {
     try
     {
         ttAgentAccDetailDAO.Add(ttAgentAccDetail);
         Message.success(context, "代理账户明细增加成功");
         loginSession.Log("XXXXXX代理账户明细增加成功");
     }
     catch (Exception e)
     {
         Message.error(context, "代理账户明细增加失败");
         loginSession.Log(e.Message);
     }
 }
コード例 #3
0
        /// <summary>
        /// 增加代理商充值
        /// <param name="ttAgentRecharge">代理商充值</param>
        /// </summary>
        public void Add(TTAgentRecharge ttAgentRecharge, TTAgentPreRechg ttAgentPreRechg)
        {
            ComTransaction trans = null;

            try
            {
                db.Open();
                trans = db.BeginTransaction();

                TBAgentDAO tbAgentDAO = new TBAgentDAO();


                TBAgent tbAgent = new TBAgent();
                tbAgent = tbAgentDAO.Get(db, ttAgentRecharge.agentId);//获取代理商信息
                //修改代理商信息表的当前余额
                tbAgent.sumRecharge  = tbAgent.sumRecharge + ttAgentRecharge.fee;
                tbAgent.balanceValue = tbAgent.balanceValue + ttAgentRecharge.fee;
                new TBAgentDAO().EditBalance(db, tbAgent);


                ttAgentRecharge.agentName   = tbAgent.agentName;                          //代理商名称
                ttAgentRecharge.lastBalance = tbAgent.balanceValue - ttAgentRecharge.fee; //代理商上次余额
                ttAgentRecharge.balance     = tbAgent.balanceValue;                       //代理商当前余额
                Add(db, ttAgentRecharge);

                //添加代理商充值账户明细
                TTAgentAccDetail ttAgentAccDetail = new TTAgentAccDetail();
                ttAgentAccDetail.agentId     = ttAgentRecharge.agentId;
                ttAgentAccDetail.agentName   = ttAgentRecharge.agentName;
                ttAgentAccDetail.lastBalance = ttAgentRecharge.lastBalance;
                ttAgentAccDetail.fee         = ttAgentRecharge.fee;
                ttAgentAccDetail.balance     = ttAgentRecharge.balance;
                ttAgentAccDetail.createTime  = ttAgentRecharge.createTime;
                ttAgentAccDetail.remark      = ttAgentRecharge.description;
                new TTAgentAccDetailDAO().Add(db, ttAgentAccDetail);

                new TTAgentPreRechgDAO().Edit(db, ttAgentPreRechg);//修改状态
                trans.Commit();
            }
            catch (Exception e)
            {
                trans.Rollback();
                throw e;
            }
            finally
            {
                db.Close();
            }
        }
コード例 #4
0
        /// <summary>
        /// 增加代理账户明细
        /// <param name="data">数据库连接</param>
        /// <param name="ttAgentAccDetail">代理账户明细</param>
        /// </summary>
        public override void Add(DataAccess data, TTAgentAccDetail ttAgentAccDetail)
        {
            string strSQL = "insert into TTAgentAccDetail (flowId,agentId,agentName,lastBalance,fee,balance,remark) values (SAgentAccDetail_flowId.Nextval,@agentId,@agentName,@lastBalance,@fee,@balance,@remark)";
            Param  param  = new Param();

            param.Clear();
            //param.Add("@flowId", ttAgentAccDetail.flowId);//流水号
            param.Add("@agentId", ttAgentAccDetail.agentId);         //代理商编号
            param.Add("@agentName", ttAgentAccDetail.agentName);     //代理商名称
            param.Add("@lastBalance", ttAgentAccDetail.lastBalance); //上次余额
            param.Add("@fee", ttAgentAccDetail.fee);                 //发生金额
            param.Add("@balance", ttAgentAccDetail.balance);         //当前余额
            param.Add("@remark", ttAgentAccDetail.remark);           //信息摘要
            data.ExecuteNonQuery(CommandType.Text, strSQL, param);
        }
コード例 #5
0
 /// <summary>
 /// 修改代理账户明细
 /// </summary>
 /// <param name="ttAgentAccDetail">代理账户明细</param>
 public virtual void Edit(TTAgentAccDetail ttAgentAccDetail)
 {
     try
     {
         db.Open();
         Edit(db, ttAgentAccDetail);
     }
     catch (Exception e)
     {
         throw e;
     }
     finally
     {
         db.Close();
     }
 }
コード例 #6
0
        /// <summary>
        /// 修改代理账户明细
        /// </summary>
        /// <param name="data">数据库连接</param>
        /// <param name="ttAgentAccDetail">代理账户明细</param>
        public virtual void Edit(DataAccess data, TTAgentAccDetail ttAgentAccDetail)
        {
            string strSQL = "update TTAgentAccDetail set agentId=@agentId,agentName=@agentName,lastBalance=@lastBalance,fee=@fee,balance=@balance,createTime=To_date(@createTime,'yyyy-mm-dd hh24:mi:ss'),remark=@remark where flowId=@flowId";
            Param  param  = new Param();

            param.Clear();
            param.Add("@agentId", ttAgentAccDetail.agentId);         //代理商编号
            param.Add("@agentName", ttAgentAccDetail.agentName);     //代理商名称
            param.Add("@lastBalance", ttAgentAccDetail.lastBalance); //上次余额
            param.Add("@fee", ttAgentAccDetail.fee);                 //发生金额
            param.Add("@balance", ttAgentAccDetail.balance);         //当前余额
            param.Add("@createTime", ttAgentAccDetail.createTime);   //创建时间
            param.Add("@remark", ttAgentAccDetail.remark);           //信息摘要
            param.Add("@flowId", ttAgentAccDetail.flowId);           //流水号
            data.ExecuteNonQuery(CommandType.Text, strSQL, param);
        }
コード例 #7
0
        protected DataAccess db = new DataAccess(DataAccess.DBConn);//数据库连接

        #region 代码生成器自动生成


        /// <summary>
        /// 增加代理账户明细
        /// </summary>
        /// <param name="data">数据库连接</param>
        /// <param name="ttAgentAccDetail">代理账户明细</param>
        public virtual void Add(DataAccess data, TTAgentAccDetail ttAgentAccDetail)
        {
            string strSQL = "insert into TTAgentAccDetail (flowId,agentId,agentName,lastBalance,fee,balance,createTime,remark) values (@flowId,@agentId,@agentName,@lastBalance,@fee,@balance,To_date(@createTime,'yyyy-mm-dd hh24:mi:ss'),@remark)";
            Param  param  = new Param();

            param.Clear();
            param.Add("@flowId", ttAgentAccDetail.flowId);           //流水号
            param.Add("@agentId", ttAgentAccDetail.agentId);         //代理商编号
            param.Add("@agentName", ttAgentAccDetail.agentName);     //代理商名称
            param.Add("@lastBalance", ttAgentAccDetail.lastBalance); //上次余额
            param.Add("@fee", ttAgentAccDetail.fee);                 //发生金额
            param.Add("@balance", ttAgentAccDetail.balance);         //当前余额
            param.Add("@createTime", ttAgentAccDetail.createTime);   //创建时间
            param.Add("@remark", ttAgentAccDetail.remark);           //信息摘要
            data.ExecuteNonQuery(CommandType.Text, strSQL, param);
        }
コード例 #8
0
 /// <summary>
 /// 增加代理账户明细
 /// <param name="ttAgentAccDetail">代理账户明细</param>
 /// </summary>
 public void Add(TTAgentAccDetail ttAgentAccDetail)
 {
     try
     {
         db.Open();
         Add(db, ttAgentAccDetail);
     }
     catch (Exception e)
     {
         throw e;
     }
     finally
     {
         db.Close();
     }
 }
コード例 #9
0
        /// <summary>
        /// 读取代理账户明细信息
        /// </summary>
        /// <param name="dr">记录指针</param>
        /// <returns>代理账户明细对象</returns>
        protected virtual TTAgentAccDetail ReadData(ComDataReader dr)
        {
            TTAgentAccDetail ttAgentAccDetail = new TTAgentAccDetail();

            ttAgentAccDetail.flowId      = long.Parse(dr["flowId"].ToString());        //流水号
            ttAgentAccDetail.agentId     = dr["agentId"].ToString();                   //代理商编号
            ttAgentAccDetail.agentName   = dr["agentName"].ToString();                 //代理商名称
            ttAgentAccDetail.lastBalance = double.Parse(dr["lastBalance"].ToString()); //上次余额
            ttAgentAccDetail.fee         = double.Parse(dr["fee"].ToString());         //发生金额
            ttAgentAccDetail.balance     = double.Parse(dr["balance"].ToString());     //当前余额
            if (dr["createTime"] == null)
            {
                ttAgentAccDetail.createTime = "";//创建时间
            }
            else
            {
                ttAgentAccDetail.createTime = string.Format("{0:yyyy-MM-dd HH:mm:ss}", dr["createTime"]); //创建时间
            }
            ttAgentAccDetail.remark = dr["remark"].ToString();                                            //信息摘要
            return(ttAgentAccDetail);
        }
コード例 #10
0
 /// <summary>
 /// 增加代理商充值
 /// <param name="ttAgentRecharge">代理商充值</param>
 /// </summary>
 public void Add(DataAccess db, TTAgentTakeCash ttAgentTakeCash, TBAgent tbAgent)
 {
     //ComTransaction trans = null;
     try
     {
         //db.Open();
         //trans = db.BeginTransaction();
         ttAgentTakeCash.agentName   = tbAgent.agentName;                                 //代理商名称
         ttAgentTakeCash.lastBalance = tbAgent.balanceValue;                              //代理商上次余额
         ttAgentTakeCash.balance     = ttAgentTakeCash.lastBalance - ttAgentTakeCash.fee; //代理商当前余额
         Add(db, ttAgentTakeCash);
         //添加代理商提现账户明细
         TTAgentAccDetailDAO ttAgentAccDetailDAO = new TTAgentAccDetailDAO();
         TTAgentAccDetail    ttAgentAccDetail    = new TTAgentAccDetail();
         ttAgentAccDetail.agentId     = ttAgentTakeCash.agentId;
         ttAgentAccDetail.agentName   = ttAgentTakeCash.agentName;
         ttAgentAccDetail.lastBalance = ttAgentTakeCash.lastBalance;
         ttAgentAccDetail.fee         = 0 - ttAgentTakeCash.fee;
         ttAgentAccDetail.balance     = ttAgentTakeCash.balance;
         ttAgentAccDetail.createTime  = ttAgentTakeCash.createTime;
         ttAgentAccDetail.remark      = ttAgentTakeCash.description;
         new TTAgentAccDetailDAO().Add(db, ttAgentAccDetail);
         //修改代理商信息表的当前余额
         tbAgent.sumDraw      = tbAgent.sumDraw + ttAgentTakeCash.fee;
         tbAgent.balanceValue = ttAgentTakeCash.balance;
         new TBAgentDAO().EditBalance(db, tbAgent);
         //trans.Commit();
     }
     catch (Exception e)
     {
         //trans.Rollback();
         throw e;
     }
     //finally
     //{
     //    db.Close();
     //}
 }