/// <summary> /// 电子货币支付 /// </summary> public void IsElecPay(SqlTransaction tran, MemberOrderModel memberOrderModel) { //支付期数 memberOrderModel.PayExpect = CommonClass.CommonDataBLL.getMaxqishu(); //生成汇款单号 memberOrderModel.RemittancesId = Model.Other.MYDateTime.ToYYMMDDHHmmssString(); //支付状态改为1 memberOrderModel.DefrayState = 1; //电子货币支付时,记录已经支付的金额 addOrderDataDAL.Upd_ECTPay(tran, memberOrderModel.ElectronicaccountId, Convert.ToDouble(memberOrderModel.TotalMoney)); //电子货币支付,则在店汇款中插入记录,最后两个参数需要更改, addOrderDataDAL.AddDataTORemittances(tran, memberOrderModel); //更新店铺的汇款 addOrderDataDAL.Add_Remittances(tran, Convert.ToDouble(memberOrderModel.TotalMoney), memberOrderModel.StoreId); }
/// <summary> /// 填写退货退款单 ——ds2012——tianfeng /// </summary> /// <param name="DocID">订单号</param> /// <param name="StoreID">店编号</param> /// <returns></returns> public static Boolean UPtInventoryDoc(string DocID, string StoreID, int flag, double money, string reason, Boolean bol, string opbh, string opip, int qishu) { SqlParameter[] parameter = { new SqlParameter("@DocID", SqlDbType.VarChar, 20), new SqlParameter("@StoreID", SqlDbType.VarChar, 20), new SqlParameter("@Flag", SqlDbType.Int), new SqlParameter("@Charged", SqlDbType.Money, 20), new SqlParameter("@Reason", SqlDbType.VarChar, 250), new SqlParameter("@error", SqlDbType.VarChar, 20) }; parameter[0].Value = DocID; parameter[1].Value = StoreID; parameter[2].Value = flag; parameter[3].Value = money; parameter[4].Value = reason; parameter[5].Direction = ParameterDirection.Output; double totalFmoney = GetInventoryTotalMoney(DocID); using (SqlConnection conn = new SqlConnection(DBHelper.connString)) { conn.Open(); using (SqlTransaction tran = conn.BeginTransaction()) { try { //修改 double Fmoney = GetInventoryMoney(tran, DocID); string huidan = "HK" + Model.Other.MYDateTime.ToYYMMDDHHmmssString(); //判断汇单号是否存在:true存在,false不存在 bool isExist = RemittancesDAL.isMemberExistsHuiDan(huidan); while (isExist) { huidan = "HK" + Model.Other.MYDateTime.ToYYMMDDHHmmssString(); isExist = RemittancesDAL.isMemberExistsHuiDan(huidan); } if (bol) { AddOrderDataDAL.AddDataTORemittances(tran, huidan, StoreID, (Fmoney * (-1)), DocID, opip, opbh, qishu); DBHelper.ExecuteNonQuery(tran, "update storeinfo set totalaccountmoney=totalaccountmoney - @money where storeid=@storeid", new SqlParameter[2] { new SqlParameter("@money", Fmoney), new SqlParameter("@storeid", StoreID) }, CommandType.Text); D_AccountDAL.AddStoreAccount(StoreID, Fmoney, D_AccountSftype.StoreDingHuokuan, S_Sftype.dianhuo, D_AccountKmtype.ReturnCharge, DirectionEnum.AccountReduced, "返回上次店铺退货单款" + DocID, tran); DBHelper.ExecuteNonQuery(tran, "UPtInventoryDoc", parameter, CommandType.StoredProcedure); AddOrderDataDAL.AddDataTORemittances(tran, "", StoreID, totalFmoney, DocID, opip, opbh, qishu); DBHelper.ExecuteNonQuery(tran, "update storeinfo set totalaccountmoney=totalaccountmoney + @money where storeid=@storeid", new SqlParameter[2] { new SqlParameter("@money", totalFmoney), new SqlParameter("@storeid", StoreID) }, CommandType.Text); D_AccountDAL.AddStoreAccount(StoreID, totalFmoney, D_AccountSftype.StoreDingHuokuan, S_Sftype.dianhuo, D_AccountKmtype.ReturnRebate, DirectionEnum.AccountsIncreased, "店铺退货单退款" + DocID, tran); AddOrderDataDAL.AddDataTORemittances(tran, huidan, StoreID, (money * (-1)), DocID, opip, opbh, qishu); DBHelper.ExecuteNonQuery(tran, "update storeinfo set totalaccountmoney=totalaccountmoney - @money where storeid=@storeid", new SqlParameter[2] { new SqlParameter("@money", money), new SqlParameter("@storeid", StoreID) }, CommandType.Text); D_AccountDAL.AddStoreAccount(StoreID, money, D_AccountSftype.StoreDingHuokuan, S_Sftype.dianhuo, D_AccountKmtype.ReturnCharge, DirectionEnum.AccountReduced, "店铺退货单扣款" + DocID, tran); } else { //添加 DBHelper.ExecuteNonQuery(tran, "UPtInventoryDoc", parameter, CommandType.StoredProcedure); AddOrderDataDAL.AddDataTORemittances(tran, huidan, StoreID, totalFmoney, DocID, opip, opbh, qishu); DBHelper.ExecuteNonQuery(tran, "update storeinfo set totalaccountmoney=totalaccountmoney + @money where storeid=@storeid", new SqlParameter[2] { new SqlParameter("@money", totalFmoney), new SqlParameter("@storeid", StoreID) }, CommandType.Text); D_AccountDAL.AddStoreAccount(StoreID, totalFmoney, D_AccountSftype.StoreDingHuokuan, S_Sftype.dianhuo, D_AccountKmtype.ReturnRebate, DirectionEnum.AccountsIncreased, "店铺退货单退款" + DocID, tran); AddOrderDataDAL.AddDataTORemittances(tran, huidan, StoreID, (money * (-1)), DocID, opip, opbh, qishu); DBHelper.ExecuteNonQuery(tran, "update storeinfo set totalaccountmoney=totalaccountmoney - @money where storeid=@storeid", new SqlParameter[2] { new SqlParameter("@money", money), new SqlParameter("@storeid", StoreID) }, CommandType.Text); D_AccountDAL.AddStoreAccount(StoreID, money, D_AccountSftype.StoreDingHuokuan, S_Sftype.dianhuo, D_AccountKmtype.ReturnRebate, DirectionEnum.AccountReduced, "店铺退货单扣款" + DocID, tran); } tran.Commit(); } catch (Exception ex1) { tran.Rollback(); return(false); } finally { conn.Close(); } } } return(int.Parse(parameter[5].Value.ToString()) == 0 ? true : false); }