public static int AddAccount(string Coinname, string number, double money, D_AccountSftype sftype, D_AccountKmtype kmtype, DirectionEnum direction, string str, SqlTransaction tran) { int r = 0; if (number != "" && money != 0) { string sql = "INSERT INTO [Account" + Coinname + "]([number],[happentime],[happenmoney],[Balancemoney],[Direction],[sftype],[kmtype],[remark])VALUES(@number,@happentime,@happenmoney,@Balancemoney,@Direction,@sftype,@kmtype,@remark)"; 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 = Convert.ToDouble( DBHelper.ExecuteScalar(tran, "select point" + Coinname + "in-point" + Coinname + "out as rr from memberinfo where number='" + number + "'", CommandType.Text)); 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)sftype; parm[6].Value = (int)kmtype; parm[7].Value = str; r = DBHelper.ExecuteNonQuery(tran, sql, parm, CommandType.Text); } return(r); }
public static double GetBalancemoneyWithdraw(D_AccountSftype sftype, string number) { string sql = ""; double money = 0; switch (sftype) { case D_AccountSftype.MemberType: sql = "select isnull(Jackpot,0)-isnull(Out,0) as Residual from MemberInfo where Number=@Number"; break; case D_AccountSftype.MemberCoshType: sql = "select isnull(TotalRemittances,0)-isnull(TotalDefray,0) as Residual from memberinfo where number=@number"; break; case D_AccountSftype.MemberTypeFx: sql = "select isnull(fuxiaoin,0)-isnull(fuxiaoout,0) as Residual from MemberInfo where Number=@Number"; break; case D_AccountSftype.MemberTypeFxth: sql = "select isnull(fuxiaothin,0)-isnull(fuxiaothout,0) as Residual from memberinfo where number=@number"; break; case D_AccountSftype.MemberTypeBd: sql = "select isnull(pointBIn,0)-isnull(pointBOut,0) as Residual from memberinfo where number=@number"; break; case D_AccountSftype.StoreType: sql = "select isnull(TotalAccountMoney,0)-isnull(TotalOrderGoodMoney,0) as Residual from StoreInfo where StoreID=@Number"; break; case D_AccountSftype.StoreDingHuokuan: sql = "select isnull(TotalAccountMoney,0)-isnull(TotalOrderGoodMoney,0) as Residual from Storeinfo where storeid=@number"; break; case D_AccountSftype.StoreZhouZhuankuan: sql = "select isnull(TurnOverMoney,0)-isnull(TurnOverGoodsMoney,0) as Residual from storeinfo where storeid=@number"; break; } if (sql != "") { SqlParameter[] parm = new SqlParameter[] { new SqlParameter("@Number", SqlDbType.NVarChar, 50) }; parm[0].Value = number; object obj = DBHelper.ExecuteScalar(sql, parm, CommandType.Text); if (obj != null) { money = Convert.ToDouble(obj); } } return(money); }
/// <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> /// 服务机构对账单--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 void AddStoreAccount(string number, double money, D_AccountSftype sftype, S_Sftype Ssftype, 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.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; DBHelper.ExecuteNonQuery("add_storeAccount", parm, CommandType.StoredProcedure); } }
public static void AddAccount(string number, double money, D_AccountSftype sftype, D_AccountKmtype kmtype, DirectionEnum direction, string str, SqlTransaction tran) { if (number != "" && money != 0) { string sql = "INSERT INTO [storeaccount]([number],[happentime],[happenmoney],[Balancemoney],[Direction],[sftype],[kmtype],[remark])VALUES(@number,@happentime,@happenmoney,@Balancemoney,@Direction,@sftype,@kmtype,@remark)"; 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; parm[2].Value = money; parm[3].Value = Residual + money; parm[4].Value = (int)direction; parm[5].Value = (int)sftype; parm[6].Value = (int)kmtype; parm[7].Value = str; DBHelper.ExecuteNonQuery(tran, sql, parm, CommandType.Text); } }
public static string GetD_AccountSftypeStr(D_AccountSftype sftype) { string str = ""; switch (sftype) { case D_AccountSftype.Branch: str = BLL.Translation.Translate("006546", "分公司"); break; case D_AccountSftype.Company: str = BLL.Translation.Translate("001824", "总公司"); break; case D_AccountSftype.MemberType: str = BLL.Translation.Translate("000599", "会员"); break; case D_AccountSftype.StoreType: str = BLL.Translation.Translate("000388", "店铺"); break; } return(str); }
/// <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); }
/// <summary> /// 对账单不带事务——ds2012——tianfeng /// </summary> /// <param name="number">店铺或会员编号</param> /// <param name="money">交易金额</param> /// <param name="sftype">交易类型</param> /// <param name="kmtype">科目</param> /// <param name="direction">是进还是出</param> public static void AddAccount(string number, double money, D_AccountSftype sftype, D_AccountKmtype kmtype, DirectionEnum direction, string remark) { D_AccountDAL.AddAccount(number, money, sftype, kmtype, direction, remark); }
/// <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> /// 对账单带事务——ds2012——tianfeng /// </summary> /// <param name="number">店铺或会员编号</param> /// <param name="money">交易金额</param> /// <param name="sftype">交易类型</param> /// <param name="kmtype">科目</param> /// <param name="direction">是进还是出</param> public static void AddAccount(string number, double money, D_AccountSftype sftype, D_AccountKmtype kmtype, DirectionEnum direction, string remark, SqlTransaction tran, bool state) { D_AccountDAL.AddAccount(number, money, sftype, kmtype, direction, remark, tran, state); }
/// <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)); }