/// <summary>
/// 审核补扣款
/// </summary>
/// <param name="info">扣补款对象</param>
public static bool UpdateInfoTran(DeductModel info)
{
using (SqlConnection conn = new SqlConnection(DBHelper.connString))
{
conn.Open();
SqlTransaction tran = conn.BeginTransaction();
try
{
if (DeductDAL.UpdateDeduct(info, tran) <= 0)
{
tran.Rollback();
return(false);
}
if (!ReleaseDAL.UpdateDeductOut(tran, info.Number, info.IsDeduct, info.DeductMoney))
{
tran.Rollback();
return(false);
}
DirectionEnum de = DirectionEnum.AccountsIncreased;
if (info.IsDeduct == 0)
{
de = DirectionEnum.AccountReduced;
}
string remark = "";
if (info.IsDeduct == 0)
{
remark = "008021~【" + info.Number + "】~000153~" + info.ExpectNum + "~008022";
D_AccountDAL.AddAccountWithdraw1(info.Number, info.DeductMoney, D_AccountSftype.MemberType, D_Sftype.BounsAccount, D_AccountKmtype.AddMoneycut, de, remark, tran);
}
else
{
remark = "008021~【" + info.Number + "】~000153~" + info.ExpectNum + "~008023";
D_AccountDAL.AddAccountWithdraw1(info.Number, info.DeductMoney, D_AccountSftype.MemberType, D_Sftype.BounsAccount, D_AccountKmtype.AddMoneyget, de, remark, tran);
}
tran.Commit();
return(true);
}
catch
{
tran.Rollback();
return(false);
}
finally
{
conn.Close();
conn.Dispose();
}
}
}
/// <summary>
/// 审核补扣款
/// </summary>
/// <param name="info">扣补款对象</param>
public static bool UpdateInfoTranBD(DeductModel info)
{
using (SqlConnection conn = new SqlConnection(DBHelper.connString))
{
conn.Open();
SqlTransaction tran = conn.BeginTransaction();
try
{
if (DeductDAL.UpdateDeduct(info, tran) <= 0)
{
tran.Rollback();
return(false);
}
if (!ReleaseDAL.UpdateDeductOutBD(tran, info.Number, info.IsDeduct, info.Actype, info.DeductMoney))
{
tran.Rollback();
return(false);
}
DirectionEnum de = DirectionEnum.AccountReduced;
D_AccountKmtype km = D_AccountKmtype.AddMoneycut;
string remark = "管理员协助扣款" + info.DeductMoney.ToString();
if (info.IsDeduct == 1)
{
de = DirectionEnum.AccountsIncreased;
km = D_AccountKmtype.AddMoneyget;
remark = "管理员协助补款" + info.DeductMoney.ToString();
}
D_AccountDAL.AddAccountWithdraw1(info.Number, info.DeductMoney, D_AccountSftype.MemberType, D_Sftype.BounsAccount, km, de, remark, tran);
tran.Commit();
return(true);
}
catch
{
tran.Rollback();
return(false);
}
finally
{
conn.Close();
conn.Dispose();
}
}
}
private bool GetAudit(DeductModel info)
{
bool bl = false;
using (SqlConnection conn = new SqlConnection(DBHelper.connString))
{
conn.Open();
SqlTransaction tran = conn.BeginTransaction();
try
{
if (DeductDAL.UpdateDeduct(info, tran) <= 0)
{
tran.Rollback();
return(false);
}
string p = "pointEin =pointEin +" + info.DeductMoney;
if (info.IsDeduct == 0)
{
p = "pointEout =pointEout +" + info.DeductMoney;
}
int r = DBHelper.ExecuteNonQuery(tran, "update memberinfo set " + p + " where number='" + info.Number + "'");
if (r == 0)
{
tran.Rollback(); return(false);
}
//对账单
string rem = "扣款";
D_AccountKmtype dakm = D_AccountKmtype.AddMoneycut;
DirectionEnum dem = DirectionEnum.AccountReduced;
if (info.IsDeduct == 0)
{
dakm = D_AccountKmtype.AddMoneycut;
}
else if (info.IsDeduct == 1)
{
dakm = D_AccountKmtype.AddMoneyget; dem = DirectionEnum.AccountsIncreased; rem = "补款";
}
int c = D_AccountDAL.AddAccount("E", info.Number, info.DeductMoney, D_AccountSftype.MemberType, dakm, dem, "管理员添加" + rem + " " + info.DeductMoney, tran);
if (c == 0)
{
tran.Rollback();
return(false);
}
tran.Commit();
return(true);
}
catch
{
tran.Rollback();
return(false);
}
finally
{
conn.Close();
conn.Dispose();
}
}
return(bl);
}
/// <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>
/// 获取订单是否请求发货
/// </summary>
/// <param name="direction">是进还是出</param>
public static int GetDeliveryflag(string OrderId, SqlTransaction tran)
{
return(D_AccountDAL.GetDeliveryflag(OrderId, 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>
/// 获取所有会员的报单账户余额总计和现金账户余额总计
/// </summary>
/// <returns></returns>
public static DataTable GetAllMemberAccountMoney()
{
return(D_AccountDAL.GetAllMemberAccountMoney());
}
/// <summary>
/// 获取期末余额总计
/// </summary>
/// <param name="type">类型</param>
/// <returns></returns>
public static double GetTotalBalancemoney(int type)
{
return(D_AccountDAL.GetTotalBalancemoeny(type));
}
/// <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));
}
