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);
}
