/// <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);
}
public static int AddAccount(string Coinname, string number, double money, D_AccountSftype sftype, D_AccountKmtype kmtype, DirectionEnum direction, string str)
{
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("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(sql, parm, CommandType.Text);
}
return(r);
}
/// <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);
}
}
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);
}
}
