/// <summary> /// 根据id获取单据名称 /// </summary> /// <param name="obj"></param> /// <returns></returns> protected string Type(object obj) { int id = Convert.ToInt32(obj); string codee = DocTypeTableDAL.GetDocTypeNameByID(id); string typename = string.Empty; switch (codee) { case "入库单": typename = GetTran("005381", "入库单"); break; case "出库单": typename = GetTran("005382", "出库单"); break; case "报溢单": typename = GetTran("000584", "报溢单"); break; case "报损单": typename = GetTran("000768", "报损单"); break; case "调拨单": typename = GetTran("000581", "调拨单"); break; case "退货单": typename = GetTran("000583", "退货单"); break; case "换货退货单": typename = GetTran("005409", "换货退货单"); break; case "发货单": typename = GetTran("005410", "发货单"); break; } return(typename); }
protected void btnsetwangyin_Click(object sender, EventArgs e) { int ck = cbkwangyinqiyong.Checked ? 1 : 0; int count = DocTypeTableDAL.UpdPaymentwangyinType(Convert.ToInt32(this.rdowangyinlist.SelectedValue), 8, ck); if (count > 0) { ClientScript.RegisterStartupScript(this.GetType(), "", "<script>alert('" + GetTran("005820", "设置成功!") + "');</script>"); } }
/// <summary> /// 在线支付转向路径 /// </summary> /// <param name="money"></param> /// <returns></returns> public string Getposturl(string hkid) { int dotype = Convert.ToInt32(ViewState["dotype"]); int roletype = Convert.ToInt32(ViewState["roletype"]); double totalmoney = Convert.ToDouble(ViewState["tm"]); string posturl = ""; string banklcode = ""; if (rdoaliypay.Checked) { posturl = "payment/Default.aspx?total_fee=" + totalmoney + "&out_trade_no=" + hkid; } else if (rdoquickpay.Checked) //快钱支付 { posturl = "quickPay/sendpki.aspx?totalmoney=" + totalmoney + "&hkid=" + hkid; } else if (rdohxpay.Checked) //环迅支付 { posturl = "huanxun/redirect.aspx?totalmoney=" + totalmoney + "&hkid=" + hkid; } else if (rdosft.Checked) //盛付通支付 { posturl = "shengpay/SendOrderSFT.aspx?totalmoney=" + totalmoney + "&hkid=" + hkid; } else { //网银充入接口 支付宝 if (DocTypeTableDAL.Getpaytypeisusebyid(1, 8)) { banklcode = Getbankcode(1); posturl = "payment/Default.aspx?total_fee=" + totalmoney + "&out_trade_no=" + hkid + "&defaultbank=" + banklcode; } else if (DocTypeTableDAL.Getpaytypeisusebyid(2, 8)) //快钱 { banklcode = Getbankcode(2); posturl = "quickPay/sendpki.aspx?totalmoney=" + totalmoney + "&hkid=" + hkid + "&defaultbank=" + banklcode; } else if (DocTypeTableDAL.Getpaytypeisusebyid(3, 8)) //盛付通 { banklcode = Getbankcode(3); posturl = "shengpay/SendOrderSFT.aspx?totalmoney=" + totalmoney + "&hkid=" + hkid + "&defaultbank=" + banklcode; } } return(posturl); }
protected void Page_Load(object sender, EventArgs e) { Permissions.ComRedirect(Page, Permissions.redirUrl); Response.Cache.SetExpires(DateTime.Now); Permissions.CheckManagePermission(EnumCompanyPermission.StorageBrowseBills); if (!Common.WPermission(Session["Company"].ToString())) { vistable.Visible = false; vistable1.Visible = false; Response.Write(Common.ReturnAlert("该管理员没有仓库权限!!")); return; } vistable.Visible = true; vistable1.Visible = true; if (!IsPostBack) { //绑定单据类型 ddltype.DataSource = DocTypeTableDAL.GetDocTypeTableInfo(); ddltype.DataTextField = "DocTypeName"; ddltype.DataValueField = "DocTypeID"; ddltype.DataBind(); CountryModel mode = CountryBLL.GetCountryModels()[0]; DataView dataev = new DataView(BillOutOrderBLL.GetWareHouseName()); dataev.RowFilter = "[CountryCode]=" + CountryBLL.GetCountryByCode(mode.ID); ddlcangku.DataSource = dataev; ddlcangku.DataTextField = "WareHouseName"; ddlcangku.DataValueField = "WareHouseID"; ddlcangku.DataBind(); if (string.IsNullOrEmpty(ddlcangku.SelectedValue)) { ViewState["Ekuc"] = "false"; } else { ViewState["Ekuc"] = "true"; } ddlcangku_SelectedIndexChanged(null, null); btnSeach_Click(null, null); this.txtshenheren.Text = GetTran("000881", "不限"); this.txtkaichuren.Text = GetTran("000881", "不限"); Translations(); } }
private int UpdatePayment(CheckBoxList cbl, int isStore, SqlTransaction tran) { int count = 0; for (int i = 0; i < cbl.Items.Count; i++) { int availability = 0; if (cbl.Items[i].Selected) { availability = 1; } count += DocTypeTableDAL.UpdPaymentType(availability, Convert.ToInt32(cbl.Items[i].Value), isStore, tran); } return(count); }
/// <summary> /// 获取指定的单据类型行数 /// </summary> /// <param name="docTypeID">单据类型ID</param> /// <param name="docTypeName">单据类型名称</param> /// <returns>返回获取指定的单据类型行数</returns> public static int GetDocTypeTableCountByIDName(int docTypeID, string docTypeName) { return(DocTypeTableDAL.GetDocTypeTableCountByIDName(docTypeID, docTypeName)); }
/// <summary> /// 获取指定的单据类型行数 /// </summary> /// <param name="docTypeName">单据类型名称</param> /// <returns>返回获取指定的单据类型行数</returns> public static int GetDocTypeTableCountByName(string docTypeName) { return(DocTypeTableDAL.GetDocTypeTableCountByName(docTypeName)); }
/// <summary> /// 获取指定单据类型(冲红)信息 /// </summary> /// <param name="docTypeID">单据类型ID</param> /// <returns>返回DataTable对象</returns> public static DataTable GetDocTypeTableInfoByID(int docTypeID) { return(DocTypeTableDAL.GetDocTypeTableInfoByID(docTypeID)); }
/// <summary> /// 获取单据类型(冲红)信息 /// </summary> /// <returns>返回DataTable对象</returns> public static DataTable GetDocTypeTableInfo() { return(DocTypeTableDAL.GetDocTypeTableInfo()); }
/// <summary> /// 根据单据名称获得单据的ID /// </summary> /// <param name="typeName"></param> /// <returns></returns> public static int GetDocTypeIDByDocTypeName(string typeName) { return(DocTypeTableDAL.GetDocTypeIDByDocTypeName(typeName)); }
/// <summary> /// 根据公司设置使用的支付方式显示 /// </summary> public void loadpaytype() { if (ViewState["roletype"] != null && ViewState["roletype"].ToString() == "1") { //账户支付 if (DocTypeTableDAL.Getpaytypeisusebyid(2, 5)) { this.div_1.Style.Add("display", ""); } //店铺支付 if (DocTypeTableDAL.Getpaytypeisusebyid(1, 5)) { this.div_2.Style.Add("display", ""); } //环迅支付 if (DocTypeTableDAL.Getpaytypeisusebyid(5, 5)) { this.div_3.Style.Add("display", ""); hxpayspan.Style.Add("display", ""); hxpic.Style.Add("display", ""); rdohxpay.Checked = true; } else { rdohxpay.Visible = false; rdohxpay.Checked = false; } //快钱支付 if (DocTypeTableDAL.Getpaytypeisusebyid(4, 5)) { this.div_3.Style.Add("display", ""); qkpayspan.Style.Add("display", ""); qkpic.Style.Add("display", ""); rdoquickpay.Checked = true; } else { rdoquickpay.Visible = false; rdoquickpay.Checked = false; } //支付宝支付 if (DocTypeTableDAL.Getpaytypeisusebyid(3, 5)) { this.div_3.Style.Add("display", ""); rdoaliypay.Checked = true; alipayspan.Style.Add("display", ""); appic.Style.Add("display", ""); } else { rdoaliypay.Visible = false; rdoaliypay.Checked = false; } if (DocTypeTableDAL.Getpaytypeisusebyid(6, 5)) { this.div_4.Style.Add("display", ""); } if (DocTypeTableDAL.Getpaytypeisusebyid(7, 5)) { this.div_3.Style.Add("display", ""); rdosft.Checked = true; sftspan.Style.Add("display", ""); sftpic.Style.Add("display", ""); } //是否启用网银支付 if (DocTypeTableDAL.Getpaytypeisusebyid(1, 9)) { this.div_3.Style.Add("display", ""); banklist.Style.Add("display", ""); if (!(DocTypeTableDAL.Getpaytypeisusebyid(3, 5) || DocTypeTableDAL.Getpaytypeisusebyid(4, 5) || DocTypeTableDAL.Getpaytypeisusebyid(5, 5))) { rdoapbankicbc.Checked = true; if (DocTypeTableDAL.Getpaytypeisusebyid(3, 8)) { //盛付通特有银行 RadioHXB.Visible = true; RadioBOS.Visible = true; RadioCBHB.Visible = true; RadioHKBCHINA.Visible = true; RadioGZCB.Visible = true; RadioHKBEA.Visible = true; RadioNJCB.Visible = true; RadioWZCB.Visible = true; //RadioSDE.Visible = true; //RadioZHNX.Visible = true; //RadioYDXH.Visible = true; RadioCZCB.Visible = true; RadioGNXS.Visible = true; RadioPSBC.Visible = true; RadioSDB.Visible = true; RadioHXB1.Visible = true; RadioBOS1.Visible = true; RadioCBHB1.Visible = true; RadioHKBCHINA1.Visible = true; RadioGZCB1.Visible = true; RadioHKBEA1.Visible = true; RadioNJCB1.Visible = true; RadioWZCB1.Visible = true; //RadioSDE1.Visible = true; //RadioZHNX1.Visible = true; //RadioYDXH1.Visible = true; RadioCZCB1.Visible = true; RadioGNXS1.Visible = true; RadioPSBC1.Visible = true; RadioSDB1.Visible = true; } else if (DocTypeTableDAL.Getpaytypeisusebyid(1, 8)) { RadioBJBANK.Visible = true; RadioPSBC.Visible = true; RadioFDB.Visible = true; RadioSDB.Visible = true; RadioSDB1.Visible = true; RadioFDB1.Visible = true; RadioPSBC1.Visible = true; RadioBJBANK1.Visible = true; } } } } else if (ViewState["roletype"] != null && ViewState["roletype"].ToString() == "2") { //账户支付 if (DocTypeTableDAL.Getpaytypeisusebyid(2, 1)) { this.div_6.Style.Add("display", ""); } //环迅支付 if (DocTypeTableDAL.Getpaytypeisusebyid(5, 1)) { this.div_3.Style.Add("display", ""); hxpayspan.Style.Add("display", ""); hxpic.Style.Add("display", ""); rdohxpay.Checked = true; } else { rdohxpay.Visible = false; rdohxpay.Checked = false; } //快钱支付 if (DocTypeTableDAL.Getpaytypeisusebyid(4, 1)) { this.div_3.Style.Add("display", ""); qkpayspan.Style.Add("display", ""); qkpic.Style.Add("display", ""); rdoquickpay.Checked = true; } else { rdoquickpay.Visible = false; rdoquickpay.Checked = false; } //支付宝支付 if (DocTypeTableDAL.Getpaytypeisusebyid(3, 1)) { this.div_3.Style.Add("display", ""); rdoaliypay.Checked = true; alipayspan.Style.Add("display", ""); appic.Style.Add("display", ""); } else { rdoaliypay.Visible = false; rdoaliypay.Checked = false; } if (DocTypeTableDAL.Getpaytypeisusebyid(3, 1)) //盛付通 { this.div_3.Style.Add("display", ""); rdosft.Checked = true; sftspan.Style.Add("display", ""); sftpic.Style.Add("display", ""); } else { rdosft.Visible = false; rdosft.Checked = false; } //店铺离线支付 if (DocTypeTableDAL.Getpaytypeisusebyid(1, 1)) { this.div_4.Style.Add("display", ""); } //是否启用网银支付 if (DocTypeTableDAL.Getpaytypeisusebyid(1, 9)) { this.div_3.Style.Add("display", ""); banklist.Style.Add("display", ""); if (!(DocTypeTableDAL.Getpaytypeisusebyid(3, 1) || DocTypeTableDAL.Getpaytypeisusebyid(4, 1) || DocTypeTableDAL.Getpaytypeisusebyid(5, 1))) { rdoapbankicbc.Checked = true; if (DocTypeTableDAL.Getpaytypeisusebyid(3, 8)) { //盛付通特有银行 RadioHXB.Visible = true; RadioBOS.Visible = true; RadioCBHB.Visible = true; RadioHKBCHINA.Visible = true; RadioGZCB.Visible = true; RadioHKBEA.Visible = true; RadioNJCB.Visible = true; RadioWZCB.Visible = true; //RadioSDE.Visible = true; //RadioZHNX.Visible = true; //RadioYDXH.Visible = true; RadioCZCB.Visible = true; RadioGNXS.Visible = true; RadioPSBC.Visible = true; RadioSDB.Visible = true; RadioHXB1.Visible = true; RadioBOS1.Visible = true; RadioCBHB1.Visible = true; RadioHKBCHINA1.Visible = true; RadioGZCB1.Visible = true; RadioHKBEA1.Visible = true; RadioNJCB1.Visible = true; RadioWZCB1.Visible = true; //RadioSDE1.Visible = true; //RadioZHNX1.Visible = true; //RadioYDXH1.Visible = true; RadioCZCB1.Visible = true; RadioGNXS1.Visible = true; RadioPSBC1.Visible = true; RadioSDB1.Visible = true; } else if (DocTypeTableDAL.Getpaytypeisusebyid(1, 8)) { RadioBJBANK.Visible = true; RadioPSBC.Visible = true; RadioFDB.Visible = true; RadioSDB.Visible = true; RadioSDB1.Visible = true; RadioFDB1.Visible = true; RadioPSBC1.Visible = true; RadioBJBANK1.Visible = true; } } } } }
/// <summary> /// 向单据类型(冲红)表中插入记录 /// </summary> /// <param name="docTypeTable">单据类型(冲红)模型</param> /// <returns>返回向单据类型(冲红)表中插入记录所影响的行数</returns> public static int AddDocTypeTable(DocTypeTableModel docTypeTable) { return(DocTypeTableDAL.AddDocTypeTable(docTypeTable)); }
/// <summary> /// 根据订单类型名称查询出订单ID /// </summary> /// <param name="docTypeName"></param> /// <returns></returns> public string GetDocTypeIdByDocTypeName(string docTypeName) { return(DocTypeTableDAL.GetDocTypeIDByDocTypeName(docTypeName).ToString()); }
/// <summary> /// 根据单据名称获得单据的ID /// </summary> /// <param name="typeName"></param> /// <returns></returns> public static int GetDocTypeIDEByDocTypeCode(string typeCode) { return(DocTypeTableDAL.GetDocTypeIDEByDocTypeCode(typeCode)); }
/// <summary> /// Judge the DocTypeID whether has operation by DocTypeID /// </summary> /// <param name="docTypeID">DocTypeID</param> /// <returns>Return counts</returns> public static int DocTypeIDWhetherHasOperation(int docTypeID) { return(DocTypeTableDAL.DocTypeIDWhetherHasOperation(docTypeID)); }
/// <summary> /// Judge the DocTypeID whether exist by DocTypeID before delete or update /// </summary> /// <param name="docTypeID">DocTypeID</param> /// <returns>Return counts</returns> public static int DocTypeIDIsExist(int docTypeID) { return(DocTypeTableDAL.DocTypeIDIsExist(docTypeID)); }
/// <summary> /// Out to excel of the data of DocTypeTable /// </summary> /// <returns>Return DataTable Object</returns> public static DataTable OutToExcel_DocTypeTable() { return(DocTypeTableDAL.OutToExcel_DocTypeTable()); }
protected void Page_Load(object sender, EventArgs e) { Permissions.ThreeRedirect(Page, "../Member/" + Permissions.redirUrl); bzCurrency = CommonDataBLL.GetStandard(); //AjaxPro.Utility.RegisterTypeForAjax(typeof(AjaxMemShopCart)); if (Session["Store"] != null) { Literal1.Text = "<a href='../Store/First.aspx'>我的首页</a><a href='../Store/auditingmemberorders.aspx'>注册确认</a><a href='../Store/auditingmemberagain.aspx'>复消确认</a><a href='../Store/CheckOutOrders.aspx'>订单支付</a><a href='../Store/ViewAccountCircs.aspx'>充值浏览</a><a href='../Logout.aspx'>退出系统</a>"; } if (Session["Member"] != null) { Literal1.Text = "<a href='../Member/First.aspx'>我的首页</a><a href='../Member/AuditingMemberOrder.aspx'>报单支付</a><a href='../Member/ResultBrowse.aspx'>充值浏览</a><a href='../Logout.aspx'>退出系统</a>"; } if (!IsPostBack) { Translations(); lbltype.Text = GetTran("007286", "报单支付"); lblot.Text = GetTran("000079", "订单号"); if (Request.QueryString["blif"] != null && Request.QueryString["blif"] != "") { string blif = Request.QueryString["blif"].ToString(); string[] strs = EncryKey.GetDecrypt(blif); if (strs.Length >= 3) { ViewState["billid"] = strs[0]; ViewState["dotype"] = strs[1]; ViewState["roletype"] = strs[2]; if (ViewState["billid"] != null && ViewState["dotype"] != null && ViewState["roletype"] != null) { if (ViewState["dotype"].ToString() == "2") { loadpaytype(); LoadData1(); //数据加载 } else { if (ViewState["roletype"].ToString() == "2") { loadpaytype(); LoadData1(); //数据加载 } else { DataTable dt_one = DAL.DBHelper.ExecuteDataTable("select ordertype from memberorder where OrderID=" + strs[0]); string ordertype = dt_one.Rows[0]["ordertype"].ToString(); //订单类型 loadpaytype(); LoadData(ordertype); //数据加载 } } ViewState["loginnumber"] = loginnumber; //店铺离线支付 if (DocTypeTableDAL.Getpaytypeisusebyid(1, 1) || DocTypeTableDAL.Getpaytypeisusebyid(6, 5)) { Loadmk(); //生成标识 } } else { Response.Redirect("payerror.aspx"); } } else { Response.Redirect("payerror.aspx"); } } else { Response.Redirect("../default.aspx"); } } div_3.Visible = false;//暂时未有在线支付 }
/// <summary> /// 删除指定单据类型(冲红)记录 /// </summary> /// <param name="docTypeID">单据类型ID</param> /// <returns>返回删除指定单据类型(冲红)记录</returns> public static int DelDocTypeTableByID(int docTypeID) { return(DocTypeTableDAL.DelDocTypeTableByID(docTypeID)); }
/// <summary> /// 更新指定单据类型(冲红)表中记录 /// </summary> /// <param name="docTypeTable">单据类型(冲红)模型</param> /// <returns>返回更新指定单据类型(冲红)表中记录所影响的行数</returns> public static int UpdDocTypeTableByID(DocTypeTableModel docTypeTable) { return(DocTypeTableDAL.UpdDocTypeTableByID(docTypeTable)); }
protected void Page_Load(object sender, EventArgs e) { //获取标准币种 bzCurrency = CommonDataBLL.GetStandard(); huilv = (AjaxClass.GetCurrency(Convert.ToInt32(bzCurrency), Convert.ToInt32(Session["Default_Currency"].ToString()))); Permissions.ThreeRedirect(Page, "../Member/" + Permissions.redirUrl); //AjaxPro.Utility.RegisterTypeForAjax(typeof(AjaxMemShopCart)); if (!IsPostBack) { Translations(); lbltype.Text = GetTran("007286", "报单支付"); lblot.Text = GetTran("000079", "订单号"); if (Request.QueryString["blif"] != null && Request.QueryString["blif"] != "") { string blif = Request.QueryString["blif"].ToString(); string[] strs = EncryKey.GetDecrypt(blif); if (strs.Length >= 3) { ViewState["billid"] = strs[0]; ViewState["dotype"] = strs[1]; ViewState["roletype"] = strs[2]; if (ViewState["billid"] != null && ViewState["dotype"] != null && ViewState["roletype"] != null) { if (ViewState["dotype"].ToString() == "2") { loadpaytype(); LoadData1(); //数据加载 } else { if (ViewState["roletype"].ToString() == "2") { loadpaytype(); LoadData1(); //数据加载 } else { DataTable dt_one = DAL.DBHelper.ExecuteDataTable("select ordertype from memberorder where OrderID=" + strs[0]); string ordertype = dt_one.Rows[0]["ordertype"].ToString(); //订单类型 loadpaytype(); LoadData(ordertype); //数据加载 } } ViewState["loginnumber"] = loginnumber; //店铺离线支付 if (DocTypeTableDAL.Getpaytypeisusebyid(1, 1) || DocTypeTableDAL.Getpaytypeisusebyid(6, 5)) { Loadmk(); //生成标识 } } else { Response.Redirect("payerror1.aspx"); } } else { Response.Redirect("payerror1.aspx"); } } else { Response.Redirect("../default.aspx"); } } }