/// <summary> /// 带事务报单款对账单——ds2012——CK /// </summary> /// <param name="number"></param> /// <param name="money"></param> /// <param name="sftype"></param> /// <param name="kmtype"></param> /// <param name="direction"></param> /// <param name="str"></param> public static int AddAccountTran(string number, double money, D_AccountSftype sftype, D_Sftype Dsftype, D_AccountKmtype kmtype, DirectionEnum direction, string remark, SqlTransaction tran) { return(D_AccountDAL.AddAccountTran(number, money, sftype, Dsftype, kmtype, direction, remark, tran)); }
/// <summary> /// 现金对账单--重载--带事务 /// </summary> /// <param name="number">店铺或会员编号</param> /// <param name="money">交易金额</param> /// <param name="sftype">交易类型</param> /// <param name="kmtype">科目</param> /// <param name="direction">是进还是出</param> public static int AddAccountWithdraw1(string number, double money, D_AccountSftype sftype, D_Sftype Dsftype, 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 = GetBalancemoneyWithdraw(sftype, number, tran); //if (DirectionEnum.AccountReduced == direction) //{ // money = -money; //} parm[0].Value = number; parm[1].Value = DateTime.Now; parm[2].Value = money; parm[3].Value = Residual; parm[4].Value = (int)direction; parm[5].Value = (int)Dsftype; parm[6].Value = (int)kmtype; parm[7].Value = str; ret = DBHelper.ExecuteNonQuery(tran, "AddD_AccountWithdraw", parm, CommandType.StoredProcedure); } return(ret); }
/// <summary> /// 对账单不带事务——ds2012——tianfeng重载-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 AddAccount1(string number, double money, D_AccountSftype sftype, D_Sftype Dsftype, D_AccountKmtype kmtype, DirectionEnum direction, string remark) { D_AccountDAL.AddAccount1(number, money, sftype, Dsftype, kmtype, direction, remark); }
/// <summary> /// 无事务报单款对账单——ds2012——tianfeng /// </summary> /// <param name="number"></param> /// <param name="money"></param> /// <param name="sftype"></param> /// <param name="kmtype"></param> /// <param name="direction"></param> /// <param name="str"></param> public static void AddAccount1(string number, double money, D_AccountSftype sftype, D_Sftype Dsftype, D_AccountKmtype kmtype, DirectionEnum direction, string str) { 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); if (DirectionEnum.AccountReduced == direction) { money = -money; } parm[0].Value = number; parm[1].Value = DateTime.Now; parm[2].Value = money; parm[3].Value = Residual; parm[4].Value = (int)direction; parm[5].Value = (int)Dsftype; parm[6].Value = (int)kmtype; parm[7].Value = str; DBHelper.ExecuteNonQuery("AddD_Account", parm, CommandType.StoredProcedure); } }