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));
}
