public void EditPayType() { int Pay_Type_ID = tools.CheckInt(Request.Form["Pay_Type_ID"]); string Pay_Type_Name = tools.CheckStr(Request.Form["Pay_Type_Name"]); int Pay_Type_Sort = tools.CheckInt(Request.Form["Pay_Type_Sort"]); int Pay_Type_IsActive = tools.CheckInt(Request.Form["Pay_Type_IsActive"]); string Pay_Type_Site = tools.CheckStr(Request.Form["Pay_Type_Site"]); if (Pay_Type_Name.Length == 0) { Public.Msg("error", "错误信息", "请填写支付条件名称", false, "{back}"); return; } PayTypeInfo entity = GetPayTypeByID(Pay_Type_ID); if (entity != null) { entity.Pay_Type_Name = Pay_Type_Name; entity.Pay_Type_Sort = Pay_Type_Sort; entity.Pay_Type_IsActive = Pay_Type_IsActive; if (MyBLL.EditPayType(entity, Public.GetUserPrivilege())) { Public.Msg("positive", "操作成功", "操作成功", true, "pay_type_list.aspx"); } else { Public.Msg("error", "错误信息", "操作失败,请稍后重试", false, "{back}"); } } else { Public.Msg("error", "错误信息", "操作失败,请稍后重试", false, "{back}"); } }
public virtual bool AddPayType(PayTypeInfo entity) { string SqlAdd = null; DataTable DtAdd = null; DataRow DrAdd = null; SqlAdd = "SELECT TOP 0 * FROM Pay_Type"; DtAdd = DBHelper.Query(SqlAdd); DrAdd = DtAdd.NewRow(); DrAdd["Pay_Type_ID"] = entity.Pay_Type_ID; DrAdd["Pay_Type_Name"] = entity.Pay_Type_Name; DrAdd["Pay_Type_Sort"] = entity.Pay_Type_Sort; DrAdd["Pay_Type_IsActive"] = entity.Pay_Type_IsActive; DrAdd["Pay_Type_Site"] = entity.Pay_Type_Site; DtAdd.Rows.Add(DrAdd); try { DBHelper.SaveChanges(SqlAdd, DtAdd); return(true); } catch (Exception ex) { throw ex; } finally { DtAdd.Dispose(); } }
public virtual bool EditPayType(PayTypeInfo entity, RBACUserInfo UserPrivilege) { if (RBAC.CheckPrivilege(UserPrivilege, "fcd3782c-b791-40c6-a29d-9b43092de04f")) { return(MyDAL.EditPayType(entity)); } else { throw new TradePrivilegeException("没有权限,权限代码:fcd3782c-b791-40c6-a29d-9b43092de04f错误"); } }
public virtual bool AddPayType(PayTypeInfo entity, RBACUserInfo UserPrivilege) { if (RBAC.CheckPrivilege(UserPrivilege, "4f0daa32-ae16-4398-ae1e-d2400ca0fff0")) { return(MyDAL.AddPayType(entity)); } else { throw new TradePrivilegeException("没有权限,权限代码:4f0daa32-ae16-4398-ae1e-d2400ca0fff0错误"); } }
public int InsertPayType(PayTypeInfo oParam) { string sql = @"INSERT INTO PayType ( SysNo, PayTypeID, PayTypeName, PayTypeDesc, Period, PaymentPage, PayRate, IsNet, IsPayWhenRecv, OrderNumber, IsOnlineShow ) VALUES ( @SysNo, @PayTypeID, @PayTypeName, @PayTypeDesc, @Period, @PaymentPage, @PayRate, @IsNet, @IsPayWhenRecv, @OrderNumber, @IsOnlineShow )"; SqlCommand cmd = new SqlCommand(sql); SqlParameter paramSysNo = new SqlParameter("@SysNo", SqlDbType.Int, 4); SqlParameter paramPayTypeID = new SqlParameter("@PayTypeID", SqlDbType.NVarChar, 10); SqlParameter paramPayTypeName = new SqlParameter("@PayTypeName", SqlDbType.NVarChar, 50); SqlParameter paramPayTypeDesc = new SqlParameter("@PayTypeDesc", SqlDbType.NVarChar, 500); SqlParameter paramPeriod = new SqlParameter("@Period", SqlDbType.NVarChar, 50); SqlParameter paramPaymentPage = new SqlParameter("@PaymentPage", SqlDbType.NVarChar, 100); SqlParameter paramPayRate = new SqlParameter("@PayRate", SqlDbType.Decimal, 9); SqlParameter paramIsNet = new SqlParameter("@IsNet", SqlDbType.Int, 4); SqlParameter paramIsPayWhenRecv = new SqlParameter("@IsPayWhenRecv", SqlDbType.Int, 4); SqlParameter paramOrderNumber = new SqlParameter("@OrderNumber", SqlDbType.NVarChar, 10); SqlParameter paramIsOnlineShow = new SqlParameter("@IsOnlineShow", SqlDbType.Int, 4); paramSysNo.Value = oParam.SysNo; paramPayTypeID.Value = oParam.PayTypeID; paramPayTypeName.Value = oParam.PayTypeName; paramPayTypeDesc.Value = oParam.PayTypeDesc; paramPeriod.Value = oParam.Period; paramPaymentPage.Value = oParam.PaymentPage; paramPayRate.Value = oParam.PayRate; paramIsNet.Value = oParam.IsNet; paramIsPayWhenRecv.Value = oParam.IsPayWhenRecv; paramOrderNumber.Value = oParam.OrderNumber; paramIsOnlineShow.Value = oParam.IsOnlineShow; cmd.Parameters.Add(paramSysNo); cmd.Parameters.Add(paramPayTypeID); cmd.Parameters.Add(paramPayTypeName); cmd.Parameters.Add(paramPayTypeDesc); cmd.Parameters.Add(paramPeriod); cmd.Parameters.Add(paramPaymentPage); cmd.Parameters.Add(paramPayRate); cmd.Parameters.Add(paramIsNet); cmd.Parameters.Add(paramIsPayWhenRecv); cmd.Parameters.Add(paramOrderNumber); cmd.Parameters.Add(paramIsOnlineShow); return(SqlHelper.ExecuteNonQuery(cmd)); }
public virtual IList <PayTypeInfo> GetPayTypes(QueryInfo Query) { int PageSize; int CurrentPage; IList <PayTypeInfo> entitys = null; PayTypeInfo entity = null; string SqlList, SqlField, SqlOrder, SqlParam, SqlTable; SqlDataReader RdrList = null; try { CurrentPage = Query.CurrentPage; PageSize = Query.PageSize; SqlTable = "Pay_Type"; SqlField = "*"; SqlParam = DBHelper.GetSqlParam(Query.ParamInfos); SqlOrder = DBHelper.GetSqlOrder(Query.OrderInfos); SqlList = DBHelper.GetSqlPage(SqlTable, SqlField, SqlParam, SqlOrder, CurrentPage, PageSize); RdrList = DBHelper.ExecuteReader(SqlList); if (RdrList.HasRows) { entitys = new List <PayTypeInfo>(); while (RdrList.Read()) { entity = new PayTypeInfo(); entity.Pay_Type_ID = Tools.NullInt(RdrList["Pay_Type_ID"]); entity.Pay_Type_Name = Tools.NullStr(RdrList["Pay_Type_Name"]); entity.Pay_Type_Sort = Tools.NullInt(RdrList["Pay_Type_Sort"]); entity.Pay_Type_IsActive = Tools.NullInt(RdrList["Pay_Type_IsActive"]); entity.Pay_Type_Site = Tools.NullStr(RdrList["Pay_Type_Site"]); entitys.Add(entity); entity = null; } } return(entitys); } catch (Exception ex) { throw ex; } finally { if (RdrList != null) { RdrList.Close(); RdrList = null; } } }
/// <summary> /// 计算手续费 /// </summary> /// <param name="order"></param> private void CalculateCommissionAmount(OrderInfo order) { //先计算子单的手续费 PayTypeInfo payTypeInfo = PipelineDA.GetPayTypeBySysNo(order.PayTypeID); order.PayTypeName = payTypeInfo.PayTypeName; foreach (KeyValuePair <string, OrderInfo> sub in order.SubOrderList) { sub.Value.CommissionAmount = decimal.Round(payTypeInfo.PayRate * sub.Value.CashPayAmount, 2, MidpointRounding.AwayFromZero); sub.Value.PayTypeName = payTypeInfo.PayTypeName; } order.CommissionAmount = order.SubOrderList.Sum(subOrder => subOrder.Value.CommissionAmount); }
private bool InnerValidate(OrderInfo order, out string errorMsg) { if (string.IsNullOrEmpty(order.PayTypeID)) { errorMsg = "请选择一种支付方式"; return(false); } PayTypeInfo payTypeInfo = PipelineDA.GetPayTypeBySysNo(order.PayTypeID); if (payTypeInfo == null) { errorMsg = "不支持您选择的支付方式,请重新选择"; return(false); } errorMsg = null; return(true); }
/// <summary> /// 获取ro发票 /// </summary> /// <param name="roSysNo"></param> /// <returns></returns> public ROInvoiceInfo GetROInvoice(int roSysNo) { ROInvoiceInfo invoice = new ROInvoiceInfo(); ROInfo ro = this.LoadRO(roSysNo); RMAInfo rma = RMAManager.GetInstance().Load(ro.RMASysNo); SOInfo so = SaleManager.GetInstance().LoadSO(rma.SOSysNo); IcsonInfo son = new IcsonInfo(); invoice.AuditUserSysNo = ro.AuditUserSysNo; invoice.CompanyAddress = son.CompanyAddress; invoice.InvoiceNote = so.InvoiceNote; invoice.SOID = so.SOID; PayTypeInfo ptInfo = ASPManager.GetInstance().LoadPayType(so.PayTypeSysNo); invoice.PayTypeName = ptInfo.PayTypeName; invoice.ReceiveAddress = ro.ReceiveAddress; CustomerInfo customer = CustomerManager.GetInstance().Load(so.CustomerSysNo); invoice.CustomerName = customer.CustomerName; invoice.CustomerSysNo = customer.SysNo; invoice.ReceiveName = ro.ReceiveName; invoice.ReceivePhone = ro.ReceivePhone; invoice.ROID = ro.ROID; invoice.ROSysNo = ro.SysNo; ShipTypeInfo stInfo = ASPManager.GetInstance().LoadShipType(so.ShipTypeSysNo); invoice.ShipTypeName = stInfo.ShipTypeName; UserInfo employee = SysManager.GetInstance().LoadUser(so.OutUserSysNo); if (employee != null) { invoice.WarehouseUserCode = employee.UserID; } else { invoice.WarehouseUserCode = ""; } this.InitPageList(ro, invoice); invoice.TotalPage = invoice.ItemHash.Count; invoice.TotalWeight = ro.GetTotalWeight(); return(invoice); }
public virtual bool EditPayType(PayTypeInfo entity) { string SqlAdd = null; DataTable DtAdd = null; DataRow DrAdd = null; SqlAdd = "SELECT * FROM Pay_Type WHERE Pay_Type_ID = " + entity.Pay_Type_ID; DtAdd = DBHelper.Query(SqlAdd); try { if (DtAdd.Rows.Count > 0) { DrAdd = DtAdd.Rows[0]; DrAdd["Pay_Type_ID"] = entity.Pay_Type_ID; DrAdd["Pay_Type_Name"] = entity.Pay_Type_Name; DrAdd["Pay_Type_Sort"] = entity.Pay_Type_Sort; DrAdd["Pay_Type_IsActive"] = entity.Pay_Type_IsActive; DrAdd["Pay_Type_Site"] = entity.Pay_Type_Site; DBHelper.SaveChanges(SqlAdd, DtAdd); } else { return(false); } } catch (Exception ex) { throw ex; } finally { DtAdd.Dispose(); } return(true); }
public virtual PayTypeInfo GetPayTypeByID(int ID) { PayTypeInfo entity = null; SqlDataReader RdrList = null; try { string SqlList; SqlList = "SELECT * FROM Pay_Type WHERE Pay_Type_ID = " + ID; RdrList = DBHelper.ExecuteReader(SqlList); if (RdrList.Read()) { entity = new PayTypeInfo(); entity.Pay_Type_ID = Tools.NullInt(RdrList["Pay_Type_ID"]); entity.Pay_Type_Name = Tools.NullStr(RdrList["Pay_Type_Name"]); entity.Pay_Type_Sort = Tools.NullInt(RdrList["Pay_Type_Sort"]); entity.Pay_Type_IsActive = Tools.NullInt(RdrList["Pay_Type_IsActive"]); entity.Pay_Type_Site = Tools.NullStr(RdrList["Pay_Type_Site"]); } return(entity); } catch (Exception ex) { throw ex; } finally { if (RdrList != null) { RdrList.Close(); RdrList = null; } } }
private void BindPayTypeGrid() { DataTable dt = new DataTable("PayTypeTable"); dt.Columns.Add(new DataColumn("SysNo", typeof(System.Int32))); dt.Columns.Add(new DataColumn("PayTypeName", typeof(System.String))); dt.Columns.Add(new DataColumn("PayTypeDesc", typeof(System.String))); dt.Columns.Add(new DataColumn("Period", typeof(System.String))); dt.Columns.Add(new DataColumn("OrderNumber", typeof(System.String))); SortedList payTypeList = ASPManager.GetInstance().GetPayTypeListByShipType(soInfo.ShipTypeSysNo); if (payTypeList != null && payTypeList.Count != 0) { foreach (PayTypeInfo ptInfo in payTypeList.Keys) { if (ptInfo.IsOnlineShow == (int)AppEnum.YNStatus.Yes) { DataRow dr = dt.NewRow(); dr["SysNo"] = ptInfo.SysNo; dr["PayTypeName"] = ptInfo.PayTypeName; dr["PayTypeDesc"] = ptInfo.PayTypeDesc; dr["Period"] = ptInfo.Period; dr["OrderNumber"] = ptInfo.OrderNumber; dt.Rows.Add(dr); } } } //淘宝代理,增加支付宝免手续费的方式 if (oSession.sCustomer.CustomerType == (int)AppEnum.CustomerType.Taobao) { PayTypeInfo ptInfo = ASPManager.GetInstance().GetPayTypeHash()[9] as PayTypeInfo; DataRow dr = dt.NewRow(); dr["SysNo"] = ptInfo.SysNo; dr["PayTypeName"] = ptInfo.PayTypeName; dr["PayTypeDesc"] = ptInfo.PayTypeDesc; dr["Period"] = ptInfo.Period; dr["OrderNumber"] = ptInfo.OrderNumber; dt.Rows.Add(dr); } this.dgPayType.DataSource = dt; this.dgPayType.DataBind(); if (dgPayType.Items.Count != 0) { foreach (DataGridItem dgItem in dgPayType.Items) { RadioButton rdo = dgItem.FindControl("rdoSelectPayType") as RadioButton; int PayTypeSysNo = Int32.Parse(dgPayType.DataKeys[dgItem.ItemIndex].ToString()); if (PayTypeSysNo == 8) //财付通账号输入 { rdo.Attributes.Add("onclick", "SelectPayType(this,1);"); } else { rdo.Attributes.Add("onclick", "SelectPayType(this,0);"); } if (soInfo.PayTypeSysNo == AppConst.IntNull) { if (dgItem.ItemIndex == 0) { rdo.Checked = true; //break; //dgPayType.SelectedIndex = dgItem.ItemIndex; } } else if ((int)dgPayType.DataKeys[dgItem.ItemIndex] == soInfo.PayTypeSysNo) { rdo.Checked = true; //dgPayType.SelectedIndex = dgItem.ItemIndex; //break; } } } }
private void BindPage() { //Bind CustomerInfo this.lblName.Text = oSession.sCustomer.CustomerName; this.lblAddr.Text = oSession.sCustomer.DwellAddress; this.lblPhone.Text = oSession.sCustomer.Phone; this.lblCellPhone.Text = oSession.sCustomer.CellPhone; this.lblZip.Text = oSession.sCustomer.DwellZip; AreaInfo area = ASPManager.GetInstance().LoadArea(oSession.sCustomer.DwellAreaSysNo); this.lblProvince.Text = area.ProvinceName; this.lblCity.Text = area.CityName; this.lblDistrict.Text = area.DistrictName; //修改部分显示 txtRname.Text = soInfo.ReceiveName; txtRCellPhone.Text = soInfo.ReceiveCellPhone; txtRPhone.Text = soInfo.ReceivePhone; if (oSession.sCustomer.DwellAreaSysNo != 1)//这个是new user的默认值。 { RArea.AreaSysNo = soInfo.ReceiveAreaSysNo; } txtRaddress.Text = soInfo.ReceiveAddress; txtRzip.Text = soInfo.ReceiveZip; //Bind SO //Bind SOMaster this.lblSOID.Text = soInfo.SOID; this.lblReceiveName.Text = soInfo.ReceiveName; this.lblReceiveAddr.Text = soInfo.ReceiveAddress; this.lblReceivePhone.Text = soInfo.ReceivePhone; this.lblReceiveCellPhone.Text = soInfo.ReceiveCellPhone; this.lblReceiveZip.Text = soInfo.ReceiveZip; area = ASPManager.GetInstance().LoadArea(soInfo.ReceiveAreaSysNo); this.lblReceiveProvince.Text = area.ProvinceName; this.lblReceiveCity.Text = area.CityName; this.lblReceiveDistrict.Text = area.DistrictName; ShipTypeInfo stInfo = ASPManager.GetInstance().LoadShipType(soInfo.ShipTypeSysNo); PayTypeInfo ptInfo = ASPManager.GetInstance().LoadPayType(soInfo.PayTypeSysNo); this.lblShipType.Text = stInfo.ShipTypeName; this.lblPayType.Text = ptInfo.PayTypeName; this.lblPointAmt.Text = soInfo.PointAmt.ToString(); this.lblPointPay.Text = soInfo.PointPay.ToString(); this.lblFreeShipFeePay.Text = Util.ToMoney(soInfo.FreeShipFeePay).ToString(); this.lblPremiumAmt.Text = soInfo.PremiumAmt.ToString(AppConst.DecimalFormatWithCurrency); this.lblShipPrice.Text = soInfo.ShipPrice.ToString(AppConst.DecimalFormatWithCurrency); this.lblPayPrice.Text = soInfo.PayPrice.ToString(AppConst.DecimalFormatWithCurrency); if (soInfo.PayPrice > 0) { this.trPayPrice.Visible = true; } else { this.trPayPrice.Visible = false; } this.lblSOAmt.Text = soInfo.SOAmt.ToString(AppConst.DecimalFormatWithCurrency); //this.lblDiscountAmt.Text = soInfo.DiscountAmt.ToString(AppConst.DecimalFormatWithCurrency); this.lblDiscountAmt.Text = Convert.ToDecimal(soInfo.DiscountAmt + soInfo.CouponAmt).ToString(AppConst.DecimalFormatWithCurrency); //if(soInfo.DiscountAmt>0) // this.trSaleRule.Visible = true; //else // this.trSaleRule.Visible = false; if ((soInfo.DiscountAmt + soInfo.CouponAmt) > 0) { this.trSaleRule.Visible = true; } else { this.trSaleRule.Visible = false; } decimal total = soInfo.GetTotalAmt(); decimal subTotal = total - soInfo.PayPrice; decimal endMoney = SaleManager.GetInstance().GetEndMoney(soInfo); decimal change = total - endMoney; this.lblSubSum.Text = subTotal.ToString(AppConst.DecimalFormatWithCurrency); this.lblTotalMoney.Text = endMoney.ToString(AppConst.DecimalFormatWithCurrency); this.lblChange.Text = change.ToString(AppConst.DecimalFormatWithCurrency); this.lblSOWeight.Text = soInfo.GetTotalWeight().ToString(); this.lblStatus.Text = AppEnum.GetSOStatus(soInfo.Status); this.lblSODate.Text = soInfo.OrderDate.ToString(AppConst.DateFormat); if (soInfo.Memo == "") { lblMemo.Text = "没有留言!"; txtMessage.Text = "没有留言!"; } else { this.lblMemo.Text = soInfo.Memo; txtMessage.Text = soInfo.Memo; } //Bind SOItem Table this.BindSOItem(); //Bind SaleRule Table this.BindSaleRule(); //Set visible if (soInfo.Status == (int)AppEnum.SOStatus.Origin) { this.btnCancel.Visible = true; } else { this.btnCancel.Visible = false; } if (soInfo.HasExpectQty == (int)AppEnum.YNStatus.Yes) { this.dgItem.Columns[5].Visible = true; } else { this.dgItem.Columns[5].Visible = false; } }
protected string GetPayType() { PayTypeInfo payType = (PayTypeInfo)ASPManager.GetInstance().GetPayTypeHash()[soInfo.PayTypeSysNo]; return(payType.PayTypeName); }