/// <summary> /// 验证电话和旧密码 /// </summary> void valitepwd() { string phone = string.Empty; string oldpwd = string.Empty; if (Request["phone"] != null && Request["phone"] != "") { phone = Request["phone"]; } if (Request["oldpwd"] != null && Request["oldpwd"] != "") { oldpwd = Request["oldpwd"]; } MSCustomersDAL customerDal = new MSCustomersDAL(); if (phone != null && phone != "" && oldpwd != null && oldpwd != "") { if (customerDal.ExistPhoneAndPwd(phone, Common.Common.MD5(oldpwd))) { Response.Write("{\"success\":true}"); } else { Response.Write("{\"error\":true,\"msg\":\"原密码不正确\"}"); } } else { Response.Write("{\"error\":true,\"msg\":\"请正确输入信息后再操作\"}"); } Response.End(); }
/// <summary> /// 获取类别 /// </summary> void getinfo() { ddlbigcategorylist.Items.Clear(); MSProductCategoryDAL categoryDal = new MSProductCategoryDAL(); DataSet ds = new DataSet(); ds = categoryDal.GetSecHandCategoryList(" and UpID='' and CsecHand=" + ishand); DataTable dt = ds.Tables[0]; DataRow dr = ds.Tables[0].NewRow(); dr["ID"] = ""; dr["Cname"] = "--请选择类别--"; dt.Rows.InsertAt(dr, 0); ddlbigcategorylist.DataSource = ds.Tables[0].DefaultView; ddlbigcategorylist.DataTextField = "Cname"; ddlbigcategorylist.DataValueField = "ID"; ddlbigcategorylist.DataBind(); MSCustomersDAL customerDal = new MSCustomersDAL(); if (Session["customerID"] != null && Session["customerID"].ToString() != "") { phone = customerDal.GetCustomerValueByID("Phone", Session["customerID"].ToString()).ToString(); } UserPhone.Value = phone; }
/// <summary> /// 修改密码 /// </summary> void EditePhone() { string phone = string.Empty; string newpwd = string.Empty; if (Request["phone"] != null && Request["phone"] != "") { phone = Request["phone"]; } if (Request["newpwd"] != null && Request["newpwd"] != "") { newpwd = Request["newpwd"]; } MSCustomersDAL customerDal = new MSCustomersDAL(); if (phone != null && phone != "" && newpwd != null && newpwd != "") { if (customerDal.UpdatePwdByPhone(phone, Common.Common.MD5(newpwd))) { Response.Write("{\"success\":true}"); } else { Response.Write("{\"error\":true,\"msg\":\"操作失败,请重新操作\"}"); } } else { Response.Write("{\"error\":true,\"msg\":\"请正确输入信息后再操作\"}"); } Response.End(); }
void showdetailinfo() { MSCustomersDAL CustomerDal = new MSCustomersDAL(); DataSet ds = CustomerDal.GetCustomerDetail(strID); MSCustomers CustomerModel = DataConvert.DataRowToModel <MSCustomers>(ds.Tables[0].Rows[0]); phone.Text = CustomerModel.Phone; hd_content.Value = CustomerModel.Pnote; NickName.Text = CustomerModel.NickName; email.Text = CustomerModel.Email; QQnum.Text = CustomerModel.QQnum; if (CustomerModel.HeadImg != null && CustomerModel.HeadImg != "") { img0.Src = "../../PalmShop/ShopCode/" + CustomerModel.HeadImg; oldimg = CustomerModel.HeadImg; } if (CustomerModel.Sex == 0) { isstateyes.Checked = true; } else { isstateno.Checked = true; } if (strAction == "show") { this.btnReset.Visible = false; this.btnSave.Visible = false; } }
void showdetailinfo() { MSShopDAL shopdal = new MSShopDAL(); DataSet ds = shopdal.GetMSShopDetail(strID); MSShop shopmodel = DataConvert.DataRowToModel <MSShop>(ds.Tables[0].Rows[0]); hd_content.Value = shopmodel.ShopDesc; MSCustomersDAL customerDal = new MSCustomersDAL(); userphone.Text = customerDal.GetCustomerValueByID("Phone", shopmodel.UID).ToString(); shopname.Text = shopmodel.ShopName; if (shopmodel.ShopLogo != null && shopmodel.ShopLogo != "") { img0.Src = "../../PalmShop/ShopCode/" + shopmodel.ShopLogo; oldimg = shopmodel.ShopLogo; } if (shopmodel.ShopBackImg != null && shopmodel.ShopBackImg != "") { img1.Src = "../../PalmShop/ShopCode/" + shopmodel.ShopBackImg; oldbackimg = shopmodel.ShopBackImg; } wxname.Text = shopmodel.WXName; wxnum.Text = shopmodel.WXNum; if (strAction == "show") { this.btnReset.Visible = false; this.btnSave.Visible = false; } }
protected void Page_Load(object sender, EventArgs e) { if (null != Common.Common.NoHtml(Request.QueryString["action"])) { strAction = Common.Common.NoHtml(Request.QueryString["action"]); } if (null != Common.Common.NoHtml(Request.QueryString["id"])) { strID = Common.Common.NoHtml(Request.QueryString["id"]); } MSCustomersDAL dal = new MSCustomersDAL(); switch (strAction) { case "del": if (dal.UpdateCustomerState(strID)) { strMessage = "操作成功!"; } else { strMessage = "操作失败!"; } break; } Response.Write(strMessage); Response.End(); }
/// <summary> /// 订单收货 /// </summary> void ReceiveOrder() { string oid = string.Empty; if (Request["oid"] != null && Request["oid"] != "") { oid = Common.Common.NoHtml(Request["oid"]); } if (oid != null && oid != "") { MSProductOrderDAL OrderDal = new MSProductOrderDAL(); if (OrderDal.UpdateOrderState("isReceive", oid)) { string buyName = string.Empty; try { buyName = OrderDal.GetOrderValueByID("BuyName", oid).ToString(); if (strOpenID == null || strOpenID == "") { string customerid = OrderDal.GetOrderDetailValueByOID("CustomerID", oid).ToString(); MSCustomersDAL CustomerDal = new MSCustomersDAL(); try { strOpenID = CustomerDal.GetCustomerValueByID("OpenID", customerid).ToString(); } catch (Exception) { } } WeiXinCore.WeiXin wx = WXHelper.CreateWeiXinInstanceBySiteCode("VYIGO"); List <TemplateMessageParam> paramList = new List <TemplateMessageParam>(); paramList.Add(new TemplateMessageParam("first", "尊敬的" + buyName)); paramList.Add(new TemplateMessageParam("OrderSn", oid)); paramList.Add(new TemplateMessageParam("OrderStatus", "已收货")); paramList.Add(new TemplateMessageParam("Remark", "请关注公众号【vgo2013】进入“服务中心进行查询”查看完整信息")); wx.SendTemplateMessage(strOpenID, "wmrxCKRq1hG3cHR0BXsuUnNq1chcbVosqYLqlsBBRCc", "http://www.vgo2013.com/PalmShop/ShopCode/CustomerOrder.aspx?receive=1", paramList.ToArray(), ""); MSOrderLogDAL.AddMSOrderLog("提示客户订单【" + oid + "】已确认收货,发送模板消息到客户OpenID【" + strOpenID + "】"); } catch (Exception) { } Response.Write("{\"success\":true}"); } else { Response.Write("{\"error\":true,\"msg\":\"操作失败,请稍后再操作\"}"); } } else { Response.Write("{\"error\":true,\"msg\":\"操作失败,请稍后再操作\"}"); } Response.End(); }
/// <summary> /// 获取用户OpenID /// </summary> void GetUserOpenID() { if (null == Request.QueryString["state"]) { //return; } else { strSiteCode = Common.Common.NoHtml(Request.QueryString["state"].ToString()); Session["strSiteCode"] = strSiteCode; } string code = Request.QueryString["code"] as string; if (!string.IsNullOrEmpty(code)) { WXConfigDAL dal = new WXConfigDAL(); Model.WeiXin.WXConfig wxConfig = dal.GetWXConfigBySiteCode(strSiteCode); if (wxConfig != null) { WeiXinCore.Models.WeiXinConfig weixinConfig = new WeiXinCore.Models.WeiXinConfig() { ID = wxConfig.WXID, Name = wxConfig.WXName, Token = wxConfig.WXToken, AppId = wxConfig.WXAppID, AppSecret = wxConfig.WXAppSecret }; WeiXinCore.WeiXin weixin = new WeiXinCore.WeiXin(weixinConfig); Oauth2AccessToken oauth2AccessToken = weixin.GetOauth2AccessToken(code); if (oauth2AccessToken != null) { strOpenID = oauth2AccessToken.OpenID; } } else { strOpenID = code; } } if (strOpenID == null || strOpenID == "") { if (Session["customerID"] != null && Session["customerID"].ToString() != "") { MSCustomersDAL CustomerDal = new MSCustomersDAL(); try { strOpenID = CustomerDal.GetCustomerValueByID("OpenID", Session["customerID"].ToString()).ToString(); } catch (Exception) { } } } if (strOpenID != null && strOpenID != "") { Session["OpenID"] = strOpenID; } }
/// <summary> /// 用户登录 /// </summary> void ToUserLogin() { string logphone = string.Empty; string logpwd = string.Empty; if (Request["logphone"] != null && Request["logphone"] != "") { logphone = Common.Common.NoHtml(Request["logphone"]); } if (Request["logpwd"] != null && Request["logpwd"] != "") { logpwd = Common.Common.NoHtml(Request["logpwd"]); } if (logphone.Trim() != null && logphone.Trim() != "" && logpwd.Trim() != null && logpwd.Trim() != "") { MSCustomersDAL customerDal = new MSCustomersDAL(); MSShopDAL shopDal = new MSShopDAL(); string usrsid = string.Empty; DataSet loginds = null; loginds = customerDal.CustomerLogin(strOpenID, logphone, Common.Common.MD5(logpwd)); if (loginds != null && loginds.Tables.Count > 0 && loginds.Tables[0].Rows.Count > 0) { string customerID = loginds.Tables[0].Rows[0]["ID"].ToString(); string useropenid = loginds.Tables[0].Rows[0]["OpenID"].ToString(); if (useropenid == null || useropenid == "") { if (strOpenID != null && strOpenID != "") { customerDal.UpdateUserOpenID(customerID, strOpenID); } } Session["customerID"] = customerID; Session["OpenID"] = strOpenID; if (customerID != null && customerID != "") { try { usrsid = shopDal.GetSidByUid("ID", customerID).ToString(); } catch (Exception) { usrsid = ""; } } if (usrsid != null && usrsid != "") { Session["SID"] = usrsid; } Response.Write("{\"success\":true}"); } else { Response.Write("{\"error\":true,\"msg\":\"非法操作,请核对后再操作\"}"); } } Response.End(); }
void GetOpenId() { if (customid != null && customid != "") { MSCustomersDAL CustomerDal = new MSCustomersDAL(); openid = CustomerDal.GetCustomerValueByID("OpenID", customid).ToString(); Session["OpenID"] = openid; } else { openid = ""; } }
void GetOpenId() { if (customerid != null && customerid != "") { MSCustomersDAL CustomerDal = new MSCustomersDAL(); strOpenID = CustomerDal.GetCustomerValueByID("OpenID", customerid).ToString(); Session["OpenID"] = strOpenID; } else { strOpenID = ""; } }
/// <summary> /// 验证电话是否注册 /// </summary> void validatephone() { string valphone = string.Empty; if (Request["inputphone"] != null && Request["inputphone"] != "") { valphone = Common.Common.NoHtml(Request["inputphone"]); } if (valphone != null && valphone != "") { MSCustomersDAL customerDal = new MSCustomersDAL(); if (action != null && action != "" && action == "wxphone") { if (strOpenID != null && strOpenID != "") { if (customerDal.ExistCustomer(strOpenID, "", "", "")) { Response.Write("{\"error\":true,\"msg\":\"该微信已被注册\"}"); } else { Response.Write("{\"success\":true}"); } } else { Response.Write("{\"success\":true}"); } } else { if (customerDal.ExistCustomer("", valphone, "", "")) { Response.Write("{\"error\":true,\"msg\":\"该号码已被注册\"}"); } else { Response.Write("{\"success\":true}"); } } } else { Response.Write("{\"success\":true}"); } Response.End(); }
/// <summary> /// 验证电话是否正确 /// </summary> void validatephone() { string valphone = string.Empty; if (Request["phone"] != null && Request["phone"] != "") { valphone = Common.Common.NoHtml(Request["phone"]); } if (valphone != null && valphone != "") { MSCustomersDAL customerDal = new MSCustomersDAL(); if (customerDal.ExistCustomer("", valphone, "", "")) { if (strOpenID != null && strOpenID != "") { if (customerDal.ExistCustomer(strOpenID, "", "", "")) { if (customerDal.ExistCustomer(strOpenID, valphone, "", "")) { Response.Write("{\"success\":true}"); } else { Response.Write("{\"error\":true,\"msg\":\"该微信号与注册电话不一致\"}"); } } else { Response.Write("{\"error\":true,\"msg\":\"该微信还未注册\"}"); } } else { Response.Write("{\"success\":true}"); } } else { Response.Write("{\"error\":true,\"msg\":\"未找到该用户资料\"}"); } } else { Response.Write("{\"success\":true}"); } Response.End(); }
/// <summary> /// 加载数据 /// </summary> /// <param name="strWhere">条件</param> void LoadData(string strWhere) { MSCustomersDAL customerDal = new MSCustomersDAL(); DataSet ds = customerDal.GetCustomersList(strWhere); DataView dv = ds.Tables[0].DefaultView; AspNetPager1.RecordCount = dv.Count; PagedDataSource pds = new PagedDataSource(); pds.DataSource = dv; pds.AllowPaging = true; pds.CurrentPageIndex = AspNetPager1.CurrentPageIndex - 1; pds.PageSize = AspNetPager1.PageSize; Repeater1.DataSource = pds; Repeater1.DataBind(); }
void GetHtmlPage() { MSShop shopModel = new MSShop(); MSCustomers UserModel = new MSCustomers(); #region -----------------店铺详情----------------------- if (strSID != null && strSID != "") { MSShopDAL shopDal = new MSShopDAL(); DataSet shopds = shopDal.GetMSShopDetail(strSID); if (shopds != null && shopds.Tables.Count > 0 && shopds.Tables[0].Rows.Count > 0) { shopModel = DataConvert.DataRowToModel <MSShop>(shopds.Tables[0].Rows[0]); } } #endregion #region ---------------店铺用户资料详情-------------------- if (strUid != null && strUid != "") { MSCustomersDAL UserDal = new MSCustomersDAL(); DataSet userds = UserDal.GetCustomerDetail(strUid); if (userds != null && userds.Tables.Count > 0 && userds.Tables[0].Rows.Count > 0) { UserModel = DataConvert.DataRowToModel <MSCustomers>(userds.Tables[0].Rows[0]); } } #endregion string text = System.IO.File.ReadAllText(Server.MapPath("../ShopPage/ApplyShop.html")); JinianNet.JNTemplate.TemplateContext context = new JinianNet.JNTemplate.TemplateContext(); context.TempData["footer"] = "奥琦微商易"; context.TempData["errorscript"] = errorscript; context.TempData["shopdetail"] = shopModel; context.TempData["usredetail"] = UserModel; context.TempData["action"] = action; context.TempData["sid"] = strSID; JinianNet.JNTemplate.Template t = new JinianNet.JNTemplate.Template(context, text); t.Render(Response.Output); }
/// <summary> /// 页面加载事件 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { if (Session["strLoginName"].ToString() != null && Session["strLoginName"].ToString() != "") { #region 初始化界面 if (null != Common.Common.NoHtml(Request.QueryString["action"])) { strAction = Common.Common.NoHtml(Request.QueryString["action"]); } if (null != Common.Common.NoHtml(Request.QueryString["id"])) { strID = Common.Common.NoHtml(Request.QueryString["id"]); } ddlphonelist.Items.Clear(); MSCustomersDAL phoneDal = new MSCustomersDAL(); DataSet ds = new DataSet(); ds = phoneDal.GetCustomersList(""); DataTable dt = ds.Tables[0]; DataRow dr = ds.Tables[0].NewRow(); dr["ID"] = ""; dr["Phone"] = "--请选择用户电话--"; dt.Rows.InsertAt(dr, 0); ddlphonelist.DataSource = ds.Tables[0].DefaultView; ddlphonelist.DataTextField = "Phone"; ddlphonelist.DataValueField = "ID"; ddlphonelist.DataBind(); #endregion } else { return; } } }
void getTemplate() { #region --------------获取客户详细----------------- MSCustomers customerModel = new MSCustomers(); MSCustomersDAL customerDal = new MSCustomersDAL(); DataSet customerDs = customerDal.GetCustomerDetail(strUid); if (null != customerDs && customerDs.Tables.Count > 0 && customerDs.Tables[0].Rows.Count > 0) { customerModel = DataConvert.DataRowToModel <MSCustomers>(customerDs.Tables[0].Rows[0]); if (customerModel.HeadImg != null && customerModel.HeadImg != "") { oldimgname = customerModel.HeadImg; } } #endregion string text = System.IO.File.ReadAllText(Server.MapPath("HtmlPage/customerinfo.html")); JinianNet.JNTemplate.TemplateContext context = new JinianNet.JNTemplate.TemplateContext(); JinianNet.JNTemplate.Template t = new JinianNet.JNTemplate.Template(context, text); context.TempData["customer"] = customerModel; context.TempData["errorscript"] = errorscript; context.TempData["fid"] = strfid; context.TempData["footer"] = "奥琦微商易"; t.Render(Response.Output); }
/// <summary> /// 用户注册 /// </summary> void ToSaveUserInfo() { string inputphone = string.Empty; string logpwd = string.Empty; if (Request["inputphone"] != null && Request["inputphone"] != "") { inputphone = Common.Common.NoHtml(Request["inputphone"]); } if (Request["logpwd"] != null && Request["logpwd"] != "") { logpwd = Common.Common.NoHtml(Request["logpwd"]); } if (inputphone.Trim() != null && inputphone.Trim() != "" && logpwd.Trim() != null && logpwd.Trim() != "") { MSCustomersDAL customerDal = new MSCustomersDAL(); if (customerDal.ExistCustomer(strOpenID, inputphone, "", "")) { Response.Write("{\"error\":true,\"msg\":\"该用户已经存在\"}"); } else { MSCustomers customerModel = new MSCustomers(); string strID = string.Empty; strID = Guid.NewGuid().ToString("N").ToUpper(); customerModel.ID = strID; customerModel.Phone = inputphone; customerModel.OpenID = strOpenID; customerModel.NickName = regNickName; customerModel.Sex = regSex; customerModel.HeadImg = regHeadImg; customerModel.UserPwd = Common.Common.MD5(logpwd); customerModel.IsDel = 0; MSVAcctDetailDAL vacctdetailDal = new MSVAcctDetailDAL(); MSVAcctDAL vacctDal = new MSVAcctDAL(); if (customerDal.AddCustomers(customerModel)) { int vcount = 2; if (!vacctDal.ExistMSVAcct(strID, "")) { MSVAcct vaccModel = new MSVAcct(); vaccModel.CustID = strID; vaccModel.SiteCode = "VYIGO"; vaccModel.V_Amont = vcount; MSVAcctDetail vaccDetailModel = new MSVAcctDetail(); vaccDetailModel.Amount = vcount; vaccDetailModel.ChargeType = "注册"; vaccDetailModel.CustID = strID; vaccDetailModel.Ext_Fld1 = ""; vaccDetailModel.IsReceive = 1; vaccDetailModel.SiteCode = "VYIGO"; //vacctDal.AddMSVAcct(vaccModel); //vacctdetailDal.AddMSVAcctDetail(vaccDetailModel); } Response.Write("{\"success\":true,\"msg\":\"操作成功\"}"); } else { Response.Write("{\"error\":true,\"msg\":\"操作失败,请核对后再操作\"}"); } } } Response.End(); }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { errormsg = ""; #region ------------获取请求信息---------------- if (Request["pname"] != null && Request["pname"] != "") { pname = Request["pname"]; } if (Request["ordernum"] != null && Request["ordernum"] != "") { ordernum = Request["ordernum"]; } if (Request["countcost"] != null && Request["countcost"] != "") { countcost = Request["countcost"]; } if (Request["customid"] != null && Request["customid"] != "") { customid = Request["customid"]; } #endregion #region -获取用户openid if (Session["OpenID"] == null || Session["OpenID"].ToString() == "") { if (customid != null && customid != "") { MSCustomersDAL customerDal = new MSCustomersDAL(); try { strOpenID = customerDal.GetCustomerValueByID("OpenID", customid).ToString(); } catch (Exception) { } } } else { strOpenID = Session["OpenID"].ToString(); } #endregion if (Request["action"] != null && Request["action"] != "") { action = Request["action"]; string strSiteCode = "VYIGO"; WXJSAPIPay wxpay = new WXJSAPIPay(strSiteCode); MSProductOrderDAL ptitleDal = new MSProductOrderDAL(); switch (action.Trim().ToLower()) { case "alipay": //ptitleDal.UpdateOrderPayWay(ordernum, "alipay"); //payway= WapPayHelper.BuildRequest(pname, ordernum, countcost, customid); AliWapPay pay = new AliWapPay("VYIGO"); string notify_url = "http://www.vgo2013.com/PalmShop/ShopCode/NotifyUrl.aspx"; string call_back_url = "http://www.vgo2013.com/PalmShop/ShopCode/Alipayreturn.aspx"; pay.DirectAliWayPay(this.Response, pname, ordernum, countcost, customid, call_back_url, notify_url); break; case "wxpay": ptitle = ptitleDal.GetOrderTitleByOID(ordernum); strIP = System.Web.HttpContext.Current.Request.ServerVariables["REMOTE_ADDR"]; decimal countcostx = decimal.Parse(countcost); int v = (Int32)Math.Round(countcostx * 100, 0); try { wxpay.DirectWXJSAPIPay(this.Response, ptitle, ordernum, v, strIP, strOpenID, "http://www.vgo2013.com/PalmShop/ShopCode/PayState.aspx", null, ""); } catch (Exception emsg) { errormsg = JQDialog.alertOKMsgBox(5, emsg.Message, "", "error"); } break; } } GetHtmlPage(); } }
/// <summary> /// 订单提交 /// </summary> void submitOrder() { string ordernum = string.Empty; int imgcount = 0; string img1 = string.Empty; string img2 = string.Empty; string openid = string.Empty; string userid = string.Empty; if (Session["OpenID"] != null && Session["OpenID"].ToString() != "") { openid = Session["OpenID"].ToString(); } if (openid != null && openid != "") { MSCustomersDAL customerDal = new MSCustomersDAL(); try { userid = customerDal.GetCustomerValueByOpenID("ID", openid).ToString(); } catch (Exception) { } } #region -------------获取请求值------------ try { ordernum = Request.Form.Get("ordernum").ToString(); } catch (Exception) { ordernum = ""; } #endregion try { imgcount = Request.Files.Count; } catch (Exception) { } if (imgcount == 2) { img1 = UploadImg(0, "printimg", ordernum); img2 = UploadImg(1, "shareimg", ordernum); if (userid == null || userid == "" && ordernum != null && ordernum != "") { MSProductOrderDAL orderDal = new MSProductOrderDAL(); userid = orderDal.GetOrderValueByID("CustomerID", ordernum).ToString(); } if (ordernum != null && ordernum != "") { MSPhotoSubmit photoModel = new MSPhotoSubmit(); MSPhotoSubmitDAL photoDal = new MSPhotoSubmitDAL(); photoModel.OrderNum = ordernum; photoModel.Img1 = img1; photoModel.Img2 = img2; photoModel.UID = userid; photoModel.ID = Guid.NewGuid().ToString("N").ToUpper(); if (!photoDal.AddPhotoSubmit(photoModel)) { errormsg = JQDialog.alertOKMsgBoxGoBack(3, "操作失败,请重新操作!", false); } else { errormsg = JQDialog.alertOKMsgBox(3, "操作成功,请等待审核!", "PrintImgOrder.aspx", "succeed"); } } else { errormsg = JQDialog.alertOKMsgBoxGoBack(3, "请输入正确的订单!", false); } } else { errormsg = JQDialog.alertOKMsgBoxGoBack(3, "请选择您要打印的照片和分享的照片!", false); } }
void editeCustomerinfo() { string nickname = string.Empty; string modelimgurl = string.Empty; try { nickname = HttpContext.Current.Request.Form.Get("nickname").ToString(); } catch (Exception) { nickname = ""; } MSCustomers customerModel = new MSCustomers(); MSCustomersDAL customerDal = new MSCustomersDAL(); customerModel.ID = strUid; if (nickname != null && nickname != "") { #region -----------------头像上传------------------- HttpFileCollection files = HttpContext.Current.Request.Files; if (files.Count > 0) { //检查文件扩展名字 HttpPostedFile postedFile = files[0]; string fileName, fileExtension, file_oldid, file_id; //取出精确到毫秒的时间做文件的名称 string my_file_id = DateTime.Now.ToString("yyyyMMddHHmmssfff"); fileName = System.IO.Path.GetFileName(postedFile.FileName); fileExtension = System.IO.Path.GetExtension(fileName); file_id = my_file_id + fileExtension; if (fileName != "" && fileName != null && fileName.Length > 0) { fileExtension = System.IO.Path.GetExtension(fileName); string saveurl; modelimgurl = "HeadImg/"; saveurl = "../PalmShop/ShopCode/" + modelimgurl; saveurl = Server.MapPath(saveurl); if (!Directory.Exists(saveurl)) { Directory.CreateDirectory(saveurl); } int length = postedFile.ContentLength; if (length > 512000) { file_oldid = "old" + file_id; postedFile.SaveAs(saveurl + file_oldid); JQDialog.ystp(saveurl + file_oldid, saveurl + file_id, 15); File.Delete(saveurl + file_oldid); } else { postedFile.SaveAs(saveurl + file_id); } modelimgurl = modelimgurl + file_id; } } #endregion customerModel.NickName = nickname; if (modelimgurl != null && modelimgurl != "") { customerModel.HeadImg = modelimgurl; } customerModel.IsDel = 0; if (customerDal.UpdateCustomers(customerModel)) { if (modelimgurl != null && modelimgurl != "") { if (oldimgname != null && oldimgname != "") { File.Delete(String.Format(@"{0}PalmShop/ShopCode/{1}", Server.MapPath("~"), oldimgname)); } } errorscript = JQDialog.alertOKMsgBox(3, "操作成功", "MyTopicList.aspx?fid=" + strfid, "succeed"); } else { errorscript = JQDialog.alertOKMsgBox(3, "操作失败,请核对后再操作", "Customerinfo.aspx?fid=" + strfid, "error"); } } else { errorscript = JQDialog.alertOKMsgBox(3, "操作失败,请核对后再操作", "Customerinfo.aspx?fid=" + strfid, "error"); } }
public void getTemplate() { #region -----------获取客户信息--------- MSCustomers CustomerModel = new MSCustomers(); MSCustomersDAL CustomerDal = new MSCustomersDAL(); DataSet CustomerDs; if (strUid != null && strUid != "") { CustomerDs = CustomerDal.GetCustomerDetail(strUid); if (null != CustomerDs && CustomerDs.Tables.Count > 0 && CustomerDs.Tables[0].Rows.Count > 0) { CustomerModel = DataConvert.DataRowToModel <MSCustomers>(CustomerDs.Tables[0].Rows[0]); if (CustomerModel.NickName == null || CustomerModel.NickName == "" || CustomerModel.NickName.ToLower() == "null") { CustomerModel.NickName = "游客"; } } } #endregion #region ---------评论列表以及信息回复------------ List <CommentListGetSet> commentModelList = new List <CommentListGetSet>(); MSForumCommentDAL commentDal = new MSForumCommentDAL(); DataSet commentDs = commentDal.GetCommentList(" and a.[uid]='" + strUid + "' "); DataSet repcommentds; List <CommentListGetSet> repcommentModelList = new List <CommentListGetSet>(); int commentcount = 0; if (commentDs != null && commentDs.Tables.Count > 0 && commentDs.Tables[0].Rows.Count > 0) { foreach (DataRow row in commentDs.Tables[0].Rows) { CommentListGetSet commentModel = DataConvert.DataRowToModel <CommentListGetSet>(row); if (commentModel.NickName == null || commentModel.NickName == "") { commentModel.NickName = "游客"; } #region ----------------获取回复信息----------------------- string repid = commentModel.ID; repcommentds = commentDal.GetRepCommentList(" and a.[uid]='" + strUid + "' and a.UpID='" + repid + "' "); if (repcommentds != null && repcommentds.Tables.Count > 0 && repcommentds.Tables[0].Rows.Count > 0) { foreach (DataRow reprow in repcommentds.Tables[0].Rows) { CommentListGetSet repcommentModel = DataConvert.DataRowToModel <CommentListGetSet>(reprow); if (repcommentModel.NickName == null || repcommentModel.NickName == "") { repcommentModel.NickName = "游客"; } repcommentModelList.Add(repcommentModel); } } #endregion commentModelList.Add(commentModel); } } try { commentcount = commentDs.Tables[0].Rows.Count; } catch (Exception) { commentcount = 0; } #endregion #region --------------获取喜欢 总数------------------ int likecount = 0; MSForumTopicLoveDAL likeDal = new MSForumTopicLoveDAL(); try { likecount = likeDal.GetLoveOrLikeCountByUID(strUid, "tlike"); } catch (Exception) { likecount = 0; } #endregion #region ------------获取消息总数--------------- int msgcount = 0; try { msgcount = commentDal.GetCommentCountByUID(strUid); } catch (Exception) { msgcount = 0; } #endregion #region ---------帖子总数------------- int topiccount = 0; MSForumTopicDAL topicdal = new MSForumTopicDAL(); try { topiccount = topicdal.GetTopicCountByUID(strUid); } catch (Exception) { topiccount = 0; } #endregion string text = System.IO.File.ReadAllText(Server.MapPath("HtmlPage/Mycommentlist.html")); JinianNet.JNTemplate.TemplateContext context = new JinianNet.JNTemplate.TemplateContext(); JinianNet.JNTemplate.Template t = new JinianNet.JNTemplate.Template(context, text); context.TempData["customer"] = CustomerModel; context.TempData["commentlist"] = commentModelList; context.TempData["repcommentlist"] = repcommentModelList; context.TempData["fid"] = strfid; context.TempData["likecount"] = likecount; context.TempData["msgcount"] = msgcount; context.TempData["topiccount"] = topiccount; context.TempData["errorscript"] = errorscript; context.TempData["uid"] = strUid; context.TempData["footer"] = "奥琦微商易"; t.Render(Response.Output); }
void GetProductDetail() { string ptitle = string.Empty; string shopID = string.Empty; string puid = string.Empty; int paracount = 0; #region 产品详细 MSProductDAL productDal = new MSProductDAL(); MSProduct productModel = new MSProduct(); DataSet productds = productDal.GetProductDetail(strpid); if (null != productds && productds.Tables.Count > 0 && productds.Tables[0].Rows.Count > 0) { productModel = DataConvert.DataRowToModel <MSProduct>(productds.Tables[0].Rows[0]); ptitle = productModel.Ptitle; puid = productModel.CustomerID; if (productModel.SID != null && productModel.SID != "") { shopID = productModel.SID; } } #endregion #region 店铺详细 MSShop shopModel = new MSShop(); if (shopID != null && shopID != "") { MSShopDAL shopDal = new MSShopDAL(); DataSet shopds = shopDal.GetMSShopDetail(shopID); if (shopds != null && shopds.Tables.Count > 0 && shopds.Tables[0].Rows.Count > 0) { shopModel = DataConvert.DataRowToModel <MSShop>(shopds.Tables[0].Rows[0]); } } #endregion #region 图集列表 MSProductAtlasDAL atlasDal = new MSProductAtlasDAL(); List <MSProductAtlas> AtlasListModel = new List <MSProductAtlas>(); DataSet atlasds = atlasDal.GetProductAtlasByPID(strpid); if (null != atlasds && atlasds.Tables.Count > 0 && atlasds.Tables[0].Rows.Count > 0) { foreach (DataRow row in atlasds.Tables[0].Rows) { MSProductAtlas atlasModel = DataConvert.DataRowToModel <MSProductAtlas>(row); AtlasListModel.Add(atlasModel); } } #endregion #region 产品参数列表 //MSProductParaDAL paraDal = new MSProductParaDAL(); //DataSet paramds = paraDal.GetProductParamByPID(strpid); //string paramlist = string.Empty; //if (null != paramds && paramds.Tables.Count > 0 && paramds.Tables[0].Rows.Count > 0) //{ // for (int i = 0; i < paramds.Tables[0].Rows.Count; i++) // { // paramlist += "<tr>\r\n"; // string paraname = paramds.Tables[0].Rows[i]["ParName"].ToString(); // string paravalue = paramds.Tables[0].Rows[i]["ParValue"].ToString(); // paramlist += "<td class=\"td_title\">" + paraname + "</td><td>" + paravalue + "</td>\r\n"; // try // { // i = i + 1; // paraname = paramds.Tables[0].Rows[i]["ParName"].ToString(); // paravalue = paramds.Tables[0].Rows[i]["ParValue"].ToString(); // paramlist += "<td class=\"td_title\">" + paraname + "</td><td>" + paravalue + "</td>\r\n"; // } // catch (Exception) // { // paramlist += "<td class=\"td_title\"> </td><td> </td>\r\n"; // } // paramlist += "</tr>\r\n"; // } //} #endregion #region -------获取产品型号及价格------------ ProductPara ParaModel = new ProductPara(); List <MSProductPara> paralistmodel = new List <MSProductPara>(); MSProductParaDAL paraDal = new MSProductParaDAL(); DataSet parads = paraDal.GetMaxMinPrice(strpid); if (parads != null && parads.Tables.Count > 0 && parads.Tables[0].Rows.Count > 0) { paracount = parads.Tables[0].Rows.Count; ParaModel = DataConvert.DataRowToModel <ProductPara>(parads.Tables[0].Rows[0]); } parads = null; parads = paraDal.GetProductParamByPID(strpid); if (parads != null && parads.Tables.Count > 0 && parads.Tables[0].Rows.Count > 0) { foreach (DataRow item in parads.Tables[0].Rows) { MSProductPara paramodel = DataConvert.DataRowToModel <MSProductPara>(item); paralistmodel.Add(paramodel); } } #endregion #region ----------------根据产品编号获取联系方式-------------------- MSShopContactsDAL contactDal = new MSShopContactsDAL(); MSShopContacts contactModel = new MSShopContacts(); DataSet contactDs = contactDal.GetContactDetailByPID(strpid); MSCustomersDAL CustomerDal = new MSCustomersDAL(); MSCustomers CustomerModel = new MSCustomers(); DataSet PuidDs = null; int contactcount = 0; if (contactDs != null && contactDs.Tables.Count > 0 && contactDs.Tables[0].Rows.Count > 0) { contactModel = DataConvert.DataRowToModel <MSShopContacts>(contactDs.Tables[0].Rows[0]); contactcount = 1; } else { if (puid != null && puid != "") { PuidDs = CustomerDal.GetCustomerDetail(puid); } if (PuidDs != null && PuidDs.Tables.Count > 0 && PuidDs.Tables[0].Rows.Count > 0) { CustomerModel = DataConvert.DataRowToModel <MSCustomers>(PuidDs.Tables[0].Rows[0]); } } #endregion string text = System.IO.File.ReadAllText(Server.MapPath("../ShopPage/Product_detail.html")); JinianNet.JNTemplate.TemplateContext context = new JinianNet.JNTemplate.TemplateContext(); context.TempData["title"] = ptitle; if (shopModel != null) { context.TempData["shopdetail"] = shopModel; } context.TempData["productdetail"] = productModel; context.TempData["atlaslist"] = AtlasListModel; if (contactcount > 0) { context.TempData["contactdetail"] = contactModel; } else { context.TempData["contactdetail"] = CustomerModel; } context.TempData["customid"] = customid; //context.TempData["paramlist"] = paramlist; context.TempData["paracount"] = paracount; context.TempData["paramodel"] = ParaModel; context.TempData["paralist"] = paralistmodel; context.TempData["footer"] = "奥琦微商易"; context.TempData["errorscript"] = errorscript; JinianNet.JNTemplate.Template t = new JinianNet.JNTemplate.Template(context, text); t.Render(Response.Output); }
void RegOrUpdateShop() { string shopname = string.Empty; string wxname = string.Empty; string wxnum = string.Empty; string isnull = ""; string ShopLogo = string.Empty; string ShopBackImg = string.Empty; string RealName = string.Empty; string IDnum = string.Empty; string IDimg = string.Empty; #region --------------------获取请求参数值------------------------------- try { shopname = Request.Form.Get("shopname").ToString(); } catch (Exception) { shopname = isnull; } try { wxname = Request.Form.Get("wxname").ToString(); } catch (Exception) { wxname = isnull; } try { wxnum = Request.Form.Get("wxnum").ToString(); } catch (Exception) { wxnum = isnull; } try { ShopLogo = Request.Files.Get("logoimg").FileName.ToString(); } catch (Exception) { ShopLogo = isnull; } try { ShopBackImg = Request.Files.Get("backimg").FileName.ToString(); } catch (Exception) { ShopBackImg = isnull; } try { RealName = Request.Files.Get("realname").FileName.ToString(); } catch (Exception) { RealName = isnull; } try { IDnum = Request.Form.Get("idnum").ToString(); } catch (Exception) { IDnum = isnull; } try { IDimg = Request.Files.Get("idimg").FileName.ToString(); } catch (Exception) { IDimg = isnull; } #endregion #region ---------------------获取图像--------------------------- if (ShopLogo != null && ShopLogo != "") { ShopLogo = "ShopLogo/" + UploadImg("logoimg"); } if (ShopBackImg != null && ShopBackImg != "") { ShopBackImg = "ShopLogo/" + UploadImg("backimg"); } if (IDimg != null && IDimg != "") { IDimg = "ShopLogo/" + UploadImg("idimg"); } #endregion MSShop shopModel = new MSShop(); MSShopDAL shopDal = new MSShopDAL(); #region ----------------------设置Model值----------------------------------- if (shopname != null && shopname != "") { shopModel.ShopName = shopname; } shopModel.WXName = wxname; shopModel.WXNum = wxnum; shopModel.ShopLogo = ShopLogo; shopModel.ShopBackImg = ShopBackImg; string regSid = string.Empty; if (strUid != null && strUid != "") { shopModel.UID = strUid; } if (strSID != null && strSID != "") { shopModel.ID = strSID; } else { regSid = Guid.NewGuid().ToString("N").ToUpper(); shopModel.ID = regSid; } #endregion #region ------------------更新注册店铺用户身份信息--------------------------- if (strUid != null && strUid != "") { MSCustomersDAL UserDal = new MSCustomersDAL(); UserDal.UpdateUserIDnum(strUid, RealName, IDnum, IDimg); } #endregion #region ---------------------更新或注册店铺信息-------------------------------------- if (strSID != null && strSID != "" && action == "uedite") { if (shopDal.UpdateMSShop(shopModel)) { errorscript = JQDialog.alertOKMsgBox(3, "操作成功!", "MyShop.aspx", "succeed"); } else { errorscript = JQDialog.alertOKMsgBox(3, "操作失败,请核对后再操作!", "ApplyShop.aspx", "error"); } } else { if (!shopDal.ExistMSShop(shopname, strUid)) { if (shopDal.AddMSShop(shopModel)) { Session["SID"] = regSid; errorscript = JQDialog.alertOKMsgBox(3, "操作成功!", "MyShop.aspx", "succeed"); } else { errorscript = JQDialog.alertOKMsgBox(3, "操作失败,请核对后再操作!", "ApplyShop.aspx", "error"); } } else { JQDialog.SetCookies("pageurl", "MyShop.aspx", 2); errorscript = JQDialog.alertOKMsgBox(3, "改店铺已经存在,请登录后操作", "UserLogin.aspx", "error"); } } #endregion }
void GetHtmlPage() { string strWhere = string.Empty; string productmodelid = string.Empty; string orderstate = string.Empty; string paystate = string.Empty; string receive = string.Empty; string oid = string.Empty;//支付成功返回订单 #region -获取用户信息 if (strOpenID != null && strOpenID != "") { MSCustomersDAL customerDal = new MSCustomersDAL(); try { customerid = customerDal.GetCustomerValueByOpenID("ID", strOpenID).ToString(); } catch (Exception) { } } else { if (Session["customerID"] != null && Session["customerID"].ToString() != "") { customerid = Session["customerID"].ToString(); } else { JQDialog.SetCookies("pageurl", "CustomerOrder.aspx", 2); errormsg = JQDialog.alertOKMsgBox(5, "操作失败<br/>请登录后再操作!", "UserLogin.aspx", "error"); } } #endregion List <MyOrderList> myorderlistModel = new List <MyOrderList>(); if (customerid != null && customerid != "") { MSProductOrderDAL orderDal = new MSProductOrderDAL(); #region -获取请求信息 if (Request["oid"] != null && Request["oid"] != "") { oid = Common.Common.NoHtml(Request["oid"]); } if (Request["orderstate"] != null && Request["orderstate"] != "") { orderstate = Common.Common.NoHtml(Request["orderstate"]); } if (Request["paystate"] != null && Request["paystate"] != "") { paystate = Common.Common.NoHtml(Request["paystate"]); } if (Request["receive"] != null && Request["receive"] != "") { receive = Common.Common.NoHtml(Request["receive"]); } strWhere = " and a.CustomerID='" + customerid + "' "; if (orderstate.Trim() != null && orderstate.Trim() != "") { strWhere += " and OrderState=" + orderstate; } if (paystate.Trim() != null && paystate.Trim() != "") { strWhere += " and PayState=" + paystate; } else { strWhere += " and PayState=1 "; } if (receive.Trim() != null && receive.Trim() != "") { strWhere += " and IsReceive=" + receive; } else { strWhere += " and IsReceive=0 "; } if (oid.Trim() != null && oid.Trim() != "") { strWhere += " and a.ID='" + oid + "' "; } #endregion strWhere += " and a.CustomerID='" + customerid + "' "; DataSet orderds = orderDal.GetCustomerOrderList(strWhere); if (orderds != null && orderds.Tables.Count > 0 && orderds.Tables[0].Rows.Count > 0) { foreach (DataRow item in orderds.Tables[0].Rows) { MyOrderList ordermodel = DataConvert.DataRowToModel <MyOrderList>(item); productmodelid = ordermodel.Mid; if (ordermodel.Ptitle.Length > 10) { ordermodel.Ptitle = ordermodel.Ptitle.ToString().Substring(0, 10) + ".."; } myorderlistModel.Add(ordermodel); } } } else { JQDialog.SetCookies("pageurl", "CustomerOrder.aspx", 2); errormsg = JQDialog.alertOKMsgBox(5, "操作失败<br/>请登录后再操作!", "UserLogin.aspx", "error"); } string text = System.IO.File.ReadAllText(Server.MapPath("../ShopPage/CustomerOrder.html")); JinianNet.JNTemplate.TemplateContext context = new JinianNet.JNTemplate.TemplateContext(); //context.TempData["artList"] = liArtList; context.TempData["myorderlist"] = myorderlistModel; context.TempData["errormsg"] = errormsg; context.TempData["customerid"] = customerid; JinianNet.JNTemplate.Template t = new JinianNet.JNTemplate.Template(context, text); t.Render(Response.Output); }
void getTemplate() { #region -----------获取客户信息--------- MSCustomers CustomerModel = new MSCustomers(); MSCustomersDAL CustomerDal = new MSCustomersDAL(); DataSet CustomerDs; if (strUid != null && strUid != "") { CustomerDs = CustomerDal.GetCustomerDetail(strUid); if (null != CustomerDs && CustomerDs.Tables.Count > 0 && CustomerDs.Tables[0].Rows.Count > 0) { CustomerModel = DataConvert.DataRowToModel <MSCustomers>(CustomerDs.Tables[0].Rows[0]); if (CustomerModel.NickName == null || CustomerModel.NickName == "" || CustomerModel.NickName.ToLower() == "null") { CustomerModel.NickName = "游客"; } } } #endregion #region ----------获取帖子列表---------------- MSForumTopicDAL topicDal = new MSForumTopicDAL(); List <TopicModelList> topicModellist = new List <TopicModelList>(); int topicCount = 0; DataSet topiclistds = topicDal.GetMSForumTopicList(" and a.[UID]='" + strUid + "' ", 0); if (topiclistds != null && topiclistds.Tables.Count > 0 && topiclistds.Tables[0].Rows.Count > 0) { topicCount = topiclistds.Tables[0].Rows.Count; foreach (DataRow row in topiclistds.Tables[0].Rows) { TopicModelList topicmodel = DataConvert.DataRowToModel <TopicModelList>(row); if (topicmodel.NickName == null || topicmodel.NickName == "" || topicmodel.NickName.Length < 1) { topicmodel.NickName = "游客"; } if (topicmodel.HeadImg == null || topicmodel.HeadImg == "") { topicmodel.HeadImg = "images/2.png"; } string msg = topicmodel.TopicDesc; msg = JQDialog.GetTextFromHTML(msg); if (msg.Length > 250) { msg = msg.ToString().Substring(0, 100) + "..."; } topicmodel.TopicDesc = msg; topicModellist.Add(topicmodel); } } #endregion #region --------------获取喜欢 总数------------------ int likecount = 0; MSForumTopicLoveDAL likeDal = new MSForumTopicLoveDAL(); try { likecount = likeDal.GetLoveOrLikeCountByUID(strUid, "tlike"); } catch (Exception) { likecount = 0; } #endregion #region ------------获取消息总数--------------- int msgcount = 0; MSForumCommentDAL commentDal = new MSForumCommentDAL(); try { msgcount = commentDal.GetCommentCountByUID(strUid); } catch (Exception) { msgcount = 0; } #endregion string text = System.IO.File.ReadAllText(Server.MapPath("HtmlPage/othertopiclist.html")); JinianNet.JNTemplate.TemplateContext context = new JinianNet.JNTemplate.TemplateContext(); JinianNet.JNTemplate.Template t = new JinianNet.JNTemplate.Template(context, text); context.TempData["mytopiclist"] = topicModellist; context.TempData["topiccount"] = topicCount; context.TempData["customer"] = CustomerModel; context.TempData["fid"] = strfid; context.TempData["likecount"] = likecount; context.TempData["msgcount"] = msgcount; context.TempData["errorscript"] = errorscript; context.TempData["uid"] = strUid; context.TempData["myuid"] = strMyUid; context.TempData["footer"] = "奥琦微商易"; t.Render(Response.Output); }
public override void OnPaySucceed(AliWapPayCallBackInfo info) { ExceptionLog log = new ExceptionLog(); log.Message = string.Format("订单号:{0},支付宝交易号:{1}", info.out_trade_no, info.trade_no); ExceptionLogDAL.InsertExceptionLog(log); if (info.result.ToLower() == "success") { oid = info.out_trade_no; payid = info.trade_no; MSProductOrderDAL ptitleDal = new MSProductOrderDAL(); int paystate = 0; try { paystate = Convert.ToInt32(ptitleDal.GetOrderValueByID("PayState", info.out_trade_no).ToString()); } catch (Exception) { } if (paystate == 0) { bool updatepayway = ptitleDal.UpdateOrderPayWay(info.out_trade_no, "alipay"); bool updateOrderNum = MSProductOrderDAL.UpdateOrderPayState(info.out_trade_no, "1"); MSOrderLogDAL.AddMSOrderLog("订单【" + info.out_trade_no + "】支付成功,支付方式:支付宝支付"); if (updatepayway == true && updateOrderNum == true) { string countcost = string.Empty; string pid = string.Empty; string pname = string.Empty; #region -获取用户数据 string strOpenID = string.Empty; string customerid = string.Empty; try { customerid = ptitleDal.GetOrderValueByID("CustomerID", info.out_trade_no).ToString(); } catch (Exception) { } if (customerid != null && customerid != "") { MSCustomersDAL CustomerDal = new MSCustomersDAL(); try { strOpenID = CustomerDal.GetCustomerValueByID("OpenID", customerid).ToString(); } catch (Exception) { } } #endregion #region -获取产品信息 try { countcost = ptitleDal.GetOrderDetailValueByOID("UnitCost", info.out_trade_no).ToString(); } catch (Exception) { } try { pid = ptitleDal.GetOrderDetailValueByOID("PID", info.out_trade_no).ToString(); } catch (Exception) { } if (pid != null && pid != "") { MSProductDAL ProductDal = new MSProductDAL(); pname = ProductDal.GetMSProductVaueByID("Ptitle", pid).ToString(); } #endregion string strSiteCode = GetSiteCode(); WXConfigDAL dal = new WXConfigDAL(); WeiXinCore.WeiXin wx = WXHelper.CreateWeiXinInstanceBySiteCode(strSiteCode); List <TemplateMessageParam> paramList = new List <TemplateMessageParam>(); paramList.Add(new TemplateMessageParam("first", "我们已收到您的货款,订单号为:" + info.out_trade_no + ";我们将尽快为您打包商品,请耐心等待: )")); paramList.Add(new TemplateMessageParam("orderMoneySum", countcost + " 元")); paramList.Add(new TemplateMessageParam("orderProductName", pname)); paramList.Add(new TemplateMessageParam("Remark", "如有问题请致电400-885-5790或直接在微信留言,小V将第一时间为您服务!")); wx.SendTemplateMessage(strOpenID, "IR3TlAC2Y3lW0jaksuPRwHrVHe5nmbWRcD6ZeUPZPlA", "http://www.vgo2013.com/PalmShop/ShopCode/OrderDetail.aspx?oid=" + info.out_trade_no, paramList.ToArray(), ""); MSOrderLogDAL.AddMSOrderLog("发送模板消息到客户OpenID为【" + strOpenID + "】大致为:我们已收到您的货款" + countcost + "元,产品名称【" + pname + "】我们将尽快为您打包商品,请耐心等待: )"); } } } }
/// <summary> /// 获取购物信息 /// </summary> void GetInfo() { #region 产品详细 MSProductDAL productDal = new MSProductDAL(); MSProduct productModel = new MSProduct(); DataSet productds = productDal.GetProductDetail(strpid); MSProductAtlasDAL atlasDal = new MSProductAtlasDAL(); MSProductAtlas atlasdetailmodel = null; DataSet atlasDs = null; if (null != productds && productds.Tables.Count > 0 && productds.Tables[0].Rows.Count > 0) { productModel = DataConvert.DataRowToModel <MSProduct>(productds.Tables[0].Rows[0]); } #endregion #region 获取产品默认展示图 atlasDs = atlasDal.GetDefaultAtlasByPid(strpid); foreach (DataRow atlasrow in atlasDs.Tables[0].Rows) { atlasdetailmodel = DataConvert.DataRowToModel <MSProductAtlas>(atlasrow); } #endregion #region -----------获取型号尺码---------------- MSProductPara paraModel = new MSProductPara(); MSProductParaDAL paraDal = new MSProductParaDAL(); DataSet parads = paraDal.GetParaDetail(mid); if (parads != null && parads.Tables.Count > 0 && parads.Tables[0].Rows.Count > 0) { paraModel = DataConvert.DataRowToModel <MSProductPara>(parads.Tables[0].Rows[0]); } #endregion #region 获取收货地址 MSDeliveryAddressDAL addressDal = new MSDeliveryAddressDAL(); MSDeliveryAddress defaultadModel = new MSDeliveryAddress(); List <MSDeliveryAddress> damodellist = new List <MSDeliveryAddress>(); string stradwhere = string.Empty; stradwhere = "and [UID]='" + customid + "' "; DataSet addressds = addressDal.GetDAList(3, stradwhere); if (null != addressds && addressds.Tables.Count > 0 && addressds.Tables[0].Rows.Count > 0) { foreach (DataRow row in addressds.Tables[0].Rows) { MSDeliveryAddress damodel = DataConvert.DataRowToModel <MSDeliveryAddress>(row); damodellist.Add(damodel); } } #endregion string customerphone = string.Empty; MSCustomers customerModel = new MSCustomers(); if (customid != null && customid != "") { MSCustomersDAL CustomerDal = new MSCustomersDAL(); DataSet customerds = CustomerDal.GetCustomerDetail(customid); if (customerds != null && customerds.Tables.Count > 0 && customerds.Tables[0].Rows.Count > 0) { customerModel = DataConvert.DataRowToModel <MSCustomers>(customerds.Tables[0].Rows[0]); } } string text = System.IO.File.ReadAllText(Server.MapPath("../ShopPage/setOrder.html")); JinianNet.JNTemplate.TemplateContext context = new JinianNet.JNTemplate.TemplateContext(); context.TempData["productdetail"] = productModel; context.TempData["atlas"] = atlasdetailmodel; context.TempData["paramodel"] = paraModel; context.TempData["errorscript"] = errorscript; context.TempData["dalist"] = damodellist; context.TempData["customer"] = customerModel; context.TempData["openid"] = openid; context.TempData["footer"] = "奥琦微商易"; JinianNet.JNTemplate.Template t = new JinianNet.JNTemplate.Template(context, text); t.Render(Response.Output); }
/// <summary> /// 图集上传 /// </summary> /// <returns></returns> bool SaveImages() { bool result = false; if (customerid != null && customerid != "") { MSCustomersDAL customer = new MSCustomersDAL(); phone = customer.GetCustomerValueByID("Phone", customerid).ToString() + "/"; } HttpFileCollection files = HttpContext.Current.Request.Files; try { MSProductAtlas atlasModel = new MSProductAtlas(); MSProductAtlasDAL atlasDal = new MSProductAtlasDAL(); atlasModel.PID = pid; for (int iFile = 0; iFile < files.Count; iFile++) { //检查文件扩展名字 HttpPostedFile postedFile = files[iFile]; string fileName, fileExtension, file_oldid, file_id; //取出精确到毫秒的时间做文件的名称 string my_file_id = DateTime.Now.ToString("yyyyMMddHHmmssfff") + iFile.ToString(); fileName = System.IO.Path.GetFileName(postedFile.FileName); fileExtension = System.IO.Path.GetExtension(fileName); file_id = my_file_id + fileExtension; if (fileName != "" && fileName != null) { fileExtension = System.IO.Path.GetExtension(fileName); string saveurl, modelimgurl; saveurl = modelimgurl = "Atlas/" + phone; saveurl = Server.MapPath(saveurl); if (!Directory.Exists(saveurl)) { Directory.CreateDirectory(saveurl); } int length = postedFile.ContentLength; if (length > 512000) { file_oldid = "old" + file_id; postedFile.SaveAs(saveurl + file_oldid); JQDialog.ystp(saveurl + file_oldid, saveurl + file_id, 15); File.Delete(saveurl + file_oldid); } else { postedFile.SaveAs(saveurl + file_id); } atlasModel.ID = Guid.NewGuid().ToString("N").ToUpper(); if (iFile == 0) { if (!atlasDal.IsExitDefaultImg(pid)) { atlasModel.IsDefault = 1; } } atlasModel.ImgState = 0; atlasModel.PimgUrl = modelimgurl + file_id; atlasModel.AtlasName = ""; if (atlasDal.AddMSProductAtlas(atlasModel)) { result = true; } } } } catch (System.Exception Ex) { result = false; } return(result); }
/// <summary> /// 把购物车添加到订单 /// </summary> void setAddOrder() { string uname = string.Empty; string uphone = string.Empty; string address = string.Empty; string payway = string.Empty; string carryway = string.Empty; string countcost = string.Empty; string leavemsg = string.Empty; string zipcode = string.Empty; string num = string.Empty; #region --------------获取请求信息--------------- if (Request["num"] != null && Request["num"] != "") { num = Request["num"]; } if (Request["uname"] != null && Request["uname"] != "") { uname = Common.Common.NoHtml(Request["uname"]); } if (Request["uphone"] != null && Request["uphone"] != "") { uphone = Common.Common.NoHtml(Request["uphone"]); } if (Request["address"] != null && Request["address"] != "") { address = Request["address"]; } if (Request["payway"] != null && Request["payway"] != "") { payway = Common.Common.NoHtml(Request["payway"]); } if (Request["carryway"] != null && Request["carryway"] != "") { carryway = Common.Common.NoHtml(Request["carryway"]); } if (Request["countcost"] != null && Request["countcost"] != "") { countcost = Common.Common.NoHtml(Request["countcost"]); } if (Request["leavemsg"] != null && Request["leavemsg"] != "") { leavemsg = Common.Common.NoHtml(Request["leavemsg"]); } if (Request["zipcode"] != null && Request["zipcode"] != "") { zipcode = Common.Common.NoHtml(Request["zipcode"]); } #endregion if (customid.Trim() != null && customid.Trim() != "") { MSShoppingCartDAL cartDal = new MSShoppingCartDAL(); MSProductOrderDAL OrderDal = new MSProductOrderDAL(); if (OrderDal.ExistOrderByUID(customid, strpid)) { Response.Write("{\"error\":true,\"exist\":true}"); } else { try { string strOrdernum = cartDal.SubOrder(customid, uname, uphone, leavemsg, address, zipcode, strpid, countcost, num, mid); if (strOrdernum != null && strOrdernum != "") { strSiteCode = "VYIGO"; MSOrderLogDAL.AddMSOrderLog("客户【" + customid + "】下单成功,订单号为【" + strOrdernum + "】"); MSProductDAL productDal = new MSProductDAL(); string pnam = string.Empty; if (strpid != null && strpid != "") { pnam = productDal.GetMSProductVaueByID("Ptitle", strpid).ToString(); } #region -发消息到店铺注册用户 string p_uid = string.Empty; string p_openid = string.Empty; if (strpid != null && strpid != "") { try { p_uid = productDal.GetMSProductVaueByID("CustomerID", strpid).ToString(); } catch (Exception) { } } if (p_uid != null && p_uid != "") { MSCustomersDAL P_UDal = new MSCustomersDAL(); try { p_openid = P_UDal.GetCustomerValueByID("OpenID", p_uid).ToString(); } catch (Exception) { } } if (p_openid != null && p_openid != "" && strSiteCode != null && strSiteCode != "") { JQDialog.SendWeiXinMsg(strSiteCode, p_openid, "亲爱的店长大人,您的宝贝【" + pnam + "】已于" + DateTime.Now.ToString("yyyy年MM月dd日 HH:mm:ss") + "被" + uname + "成功买下,单号【" + strOrdernum + "】赶紧去小店看看吧!"); } MSOrderLogDAL.AddMSOrderLog("下单成功,通知到OpenID为【" + p_openid + "】的店长"); #endregion #region -产品属性 MSProductParaDAL paraDal = new MSProductParaDAL(); int stock = 0; if (paraDal.ExistMSPPara("", strpid) && mid != null && mid != "") { try { stock = int.Parse(paraDal.GetMSPParaValueByID("Stock", mid).ToString()); } catch (Exception) { } if (stock > 0) { int buynum = 0; try { buynum = Convert.ToInt32(quantity); } catch (Exception) { } if (buynum != 0 && buynum < stock) { stock = stock - buynum; paraDal.UpdateStock(stock, mid); } } } #endregion DataSet orderds = cartDal.GetMyOrderDetail(strOrdernum); string payinfo = string.Empty; string productname = string.Empty; //用户购买的商品名称 string ordernum = string.Empty; //订单号 if (orderds != null && orderds.Tables.Count > 0 && orderds.Tables[0].Rows.Count > 0) { productname = orderds.Tables[0].Rows[0]["Ptitle"].ToString(); ordernum = orderds.Tables[0].Rows[0]["ID"].ToString(); //payinfo= WapPayHelper.BuildRequest(productname, ordernum, countcost, customid); } if (productname.Trim() != null && productname.Trim() != "" && ordernum != null && ordernum != "") { //Response.Write("{\"success\":true,\"payinfo\":\"" + payinfo + "\"}"); Response.Write("{\"success\":true,\"pname\":\"" + productname + "\",\"ordernum\":\"" + ordernum + "\",\"countcost\":\"" + countcost + "\",\"customid\":\"" + customid + "\",\"openid\":\"" + openid + "\"}"); } } else { Response.Write("{\"error\":true,\"msg\":\"操作失败,重新操作\"}"); } } catch (Exception) { Response.Write("{\"error\":true,\"msg\":\"操作失败,重新操作\"}"); } } } else { setCookies(); Response.Write("{\"error\":true,\"msg\":\"操作失败,请登录后再操作\",\"loginurl\":\"UserLogin.aspx\"}"); } Response.End(); }