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