Example #1
0
 /// <summary>
 /// 服务机构对账单--ck--带事务
 /// </summary>
 /// <param name="number">店铺或会员编号</param>
 /// <param name="money">交易金额</param>
 /// <param name="sftype">交易类型</param>
 /// <param name="kmtype">科目</param>
 /// <param name="direction">是进还是出</param>
 public static int AddStoreAccount(string number, double money, D_AccountSftype sftype, S_Sftype Ssftype, D_AccountKmtype kmtype, DirectionEnum direction, string str, SqlTransaction tran)
 {
     return(D_AccountDAL.AddStoreAccount(number, money, sftype, Ssftype, kmtype, direction, str, tran));
 }
Example #2
0
 /// <summary>
 /// 服务机构对账单--ck
 /// </summary>
 /// <param name="number">店铺或会员编号</param>
 /// <param name="money">交易金额</param>
 /// <param name="sftype">交易类型</param>
 /// <param name="kmtype">科目</param>
 /// <param name="direction">是进还是出</param>
 public static void AddStoreAccount(string number, double money, D_AccountSftype sftype, S_Sftype Ssftype, D_AccountKmtype kmtype, DirectionEnum direction, string str)
 {
     D_AccountDAL.AddStoreAccount(number, money, sftype, Ssftype, kmtype, direction, str);
 }
Example #3
0
        /// <summary>
        /// 服务机构对账单--ck--带事务
        /// </summary>
        /// <param name="number"></param>
        /// <param name="money"></param>
        /// <param name="sftype"></param>
        /// <param name="Dsftype"></param>
        /// <param name="kmtype"></param>
        /// <param name="direction"></param>
        /// <param name="str"></param>
        public static int AddStoreAccount(string number, double money, D_AccountSftype sftype, S_Sftype Ssftype, D_AccountKmtype kmtype, DirectionEnum direction, string str, SqlTransaction tran)
        {
            int ret = 0;

            if (number != "" && money != 0)
            {
                SqlParameter[] parm = new SqlParameter[] {
                    new SqlParameter("@number", SqlDbType.NVarChar, 50),
                    new SqlParameter("@happentime", SqlDbType.DateTime),
                    new SqlParameter("@happenmoney", SqlDbType.Money),
                    new SqlParameter("@Balancemoney", SqlDbType.Money),
                    new SqlParameter("@Direction", SqlDbType.TinyInt),
                    new SqlParameter("@sftype", SqlDbType.TinyInt),
                    new SqlParameter("@kmtype", SqlDbType.TinyInt),
                    new SqlParameter("@remark", SqlDbType.NVarChar, 500)
                };
                double Residual = GetBalancemoney(sftype, number, tran);
                //if (DirectionEnum.AccountReduced == direction)
                //{
                //    money = -money;
                //}
                parm[0].Value = number;
                parm[1].Value = DateTime.Now.ToUniversalTime();
                parm[2].Value = money;
                parm[3].Value = Residual;
                parm[4].Value = (int)direction;
                parm[5].Value = (int)Ssftype;
                parm[6].Value = (int)kmtype;
                parm[7].Value = str;
                ret           = DBHelper.ExecuteNonQuery(tran, "add_storeAccount", parm, CommandType.StoredProcedure);
            }
            return(ret);
        }