/// <summary> ///[To_PaymentReturn]表查询实体的方法 /// </summary> public static To_PaymentReturn getTo_PaymentReturnById(int id) { To_PaymentReturn to_paymentreturn = null; string sql = "select * from To_PaymentReturn where id=@id"; SqlParameter[] sp = new SqlParameter[] { new SqlParameter("@id", id) }; DataTable dt = DBHelper.GetDataSet(sql, sp); if (dt.Rows.Count > 0) { to_paymentreturn = new To_PaymentReturn(); foreach (DataRow dr in dt.Rows) { to_paymentreturn.Id = Convert.ToInt32(dr["id"]); to_paymentreturn.PaymentID = Convert.ToString(dr["paymentID"]); to_paymentreturn.orderRetID = Convert.ToInt32(dr["orderRetID"]); to_paymentreturn.OrderNum = Convert.ToString(dr["orderNum"]); to_paymentreturn.ShouldReturn = Convert.ToDouble(dr["shouldReturn"]); to_paymentreturn.ReturnAmount = Convert.ToDouble(dr["returnAmount"]); } } return(to_paymentreturn); }
/// <summary> /// 保存退款信息 /// </summary> /// <param name="paymentId"></param> private void SavePaymentReturn(string paymentId) { IList <string> returnIDs = new List <string>(); To_PaymentReturn paymentReturn = new To_PaymentReturn(); paymentReturn.PaymentID = paymentId; if (hidPayReturn.Value.Trim().TrimEnd('@') != string.Empty) { IEnumerable <string> returnList = hidPayReturn.Value.Trim().TrimEnd('@').Split('@').Where(x => x.Trim() != string.Empty); if (returnList.Count() > 0) { foreach (string list in returnList) { string[] item = list.Split('$'); paymentReturn.orderRetID = int.Parse(item[0].Trim()); //订单退款信息明细表id if (!returnIDs.Contains(item[0].Trim())) { returnIDs.Add(item[0].Trim()); } paymentReturn.OrderNum = item[1].Trim(); //订单编号 paymentReturn.ShouldReturn = double.Parse(item[2].Trim()); //应退金额 paymentReturn.ReturnAmount = double.Parse(item[3].Trim()); //本次退付金额 To_PaymentReturnManager.addTo_PaymentReturn(paymentReturn); } } for (int i = 0; i < returnIDs.Count; i++) { if (returnIDs[i] != "") { double hasAmount = To_PaymentReturnManager.GetHasAmount(returnIDs[i]); //得到该退款信息明细表关联的所有退过款的金额 double shouldAmount = To_OrderRefunDetialManager.getTo_OrderRefunDetialById(int.Parse(returnIDs[i])).Money; //得到应退金额 string getstatus = ""; if (hasAmount == 0) { getstatus = "未退款"; } else if (shouldAmount > hasAmount) { getstatus = "部分退款"; } else { getstatus = "完成退款"; } To_OrderRefunDetialManager.updateDetialStatusAndMoney(returnIDs[i], getstatus, hasAmount.ToString()); } } } }
/// <summary> ///[To_PaymentReturn]表添加的方法 /// </summary> public static int addTo_PaymentReturn(To_PaymentReturn to_paymentreturn) { string sql = "insert into To_PaymentReturn([paymentID],[orderRetID],[orderNum],[shouldReturn],[returnAmount]) values (@paymentID,@orderRetID,@orderNum,@shouldReturn,@returnAmount)"; SqlParameter[] sp = new SqlParameter[] { new SqlParameter("@paymentID", to_paymentreturn.PaymentID), new SqlParameter("@orderRetID", to_paymentreturn.orderRetID), new SqlParameter("@orderNum", to_paymentreturn.OrderNum), new SqlParameter("@shouldReturn", to_paymentreturn.ShouldReturn), new SqlParameter("@returnAmount", to_paymentreturn.ReturnAmount) }; return(DBHelper.ExecuteCommand(sql, sp)); }
/// <summary> ///[To_PaymentReturn]表修改的方法 /// </summary> public static int updateTo_PaymentReturnById(To_PaymentReturn to_paymentreturn) { string sql = "update To_PaymentReturn set paymentID=@paymentID,orderRetID=@orderRetID,orderNum=@orderNum,shouldReturn=@shouldReturn,returnAmount=@returnAmount where id=@id"; SqlParameter[] sp = new SqlParameter[] { new SqlParameter("@id", to_paymentreturn.Id), new SqlParameter("@paymentID", to_paymentreturn.PaymentID), new SqlParameter("@orderRetID", to_paymentreturn.orderRetID), new SqlParameter("@orderNum", to_paymentreturn.OrderNum), new SqlParameter("@shouldReturn", to_paymentreturn.ShouldReturn), new SqlParameter("@returnAmount", to_paymentreturn.ReturnAmount) }; return(DBHelper.ExecuteCommand(sql, sp)); }
/// <summary> ///根据SQL语句获取实体 /// </summary> public static To_PaymentReturn getTo_PaymentReturnBySql(string sql) { To_PaymentReturn to_paymentreturn = null; DataTable dt = DBHelper.GetDataSet(sql); if (dt.Rows.Count > 0) { to_paymentreturn = new To_PaymentReturn(); foreach (DataRow dr in dt.Rows) { to_paymentreturn.Id = Convert.ToInt32(dr["id"]); to_paymentreturn.PaymentID = Convert.ToString(dr["paymentID"]); to_paymentreturn.orderRetID = Convert.ToInt32(dr["orderRetID"]); to_paymentreturn.OrderNum = Convert.ToString(dr["orderNum"]); to_paymentreturn.ShouldReturn = Convert.ToDouble(dr["shouldReturn"]); to_paymentreturn.ReturnAmount = Convert.ToDouble(dr["returnAmount"]); } } return(to_paymentreturn); }
public static int updateTo_PaymentReturn(To_PaymentReturn to_paymentreturn) { return(To_PaymentReturnService.updateTo_PaymentReturnById(to_paymentreturn)); }
public static int addTo_PaymentReturn(To_PaymentReturn to_paymentreturn) { return(To_PaymentReturnService.addTo_PaymentReturn(to_paymentreturn)); }