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"]); } MSShopContactsDAL dal = new MSShopContactsDAL(); switch (strAction) { case "del": if (dal.UpdateMSSContactState(strID)) { strMessage = "操作成功!"; } else { strMessage = "操作失败!"; } break; } Response.Write(strMessage); Response.End(); }
protected void btnSave_Click(object sender, EventArgs e) { if (Session["strLoginName"].ToString() != null && Session["strLoginName"].ToString() != "") { if (nickname.Text.Trim() != null && nickname.Text.Trim() != "" && phone.Text.Trim() != null && phone.Text.Trim() != "" && ddlcontactlist.SelectedValue.Trim() != null && ddlcontactlist.SelectedValue.Trim() != "") { MSShopContactsDAL contactdal = new MSShopContactsDAL(); if (contactdal.ExistContact(phone.Text, nickname.Text, ddlcontactlist.SelectedValue, "")) { MessageBox.Show(this, "该联系方式已经存在!"); } else { MSShopContacts contactmodel = new MSShopContacts(); contactmodel.Phone = phone.Text; contactmodel.SID = ddlcontactlist.SelectedValue; contactmodel.NickName = nickname.Text; string cityselect = string.Empty; if (qqnum.Text.Trim() != null && qqnum.Text.Trim() != "") { contactmodel.QQnum = Convert.ToInt32(qqnum.Text); } if (email.Text.Trim() != null && email.Text.Trim() != "") { contactmodel.Email = email.Text; } if (address.Value.Trim() != null && address.Value.Trim() != "") { contactmodel.Address = address.Value; } contactmodel.IsDefault = isyes.Checked ? 1 : 0; contactmodel.IsDel = 0; contactmodel.ID = Guid.NewGuid().ToString("N").ToUpper(); if (contactdal.AddMSSContacts(contactmodel)) { MessageBox.Show(this, "操作成功!"); } else { MessageBox.Show(this, "操作失败!"); } } } else { MessageBox.Show(this, "请输入相应名称或电话!"); } } else { return; } }
/// <summary> /// 加载数据 /// </summary> /// <param name="strWhere">条件</param> void LoadData(string strWhere) { MSShopContactsDAL shopdal = new MSShopContactsDAL(); DataSet ds = shopdal.GetMSShopContactsList(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 showdetailinfo() { MSProductDAL productDal = new MSProductDAL(); DataSet productDs = productDal.GetProductDetail(strID); MSProduct productModel = DataConvert.DataRowToModel <MSProduct>(productDs.Tables[0].Rows[0]); price.Text = productModel.Price.ToString(); pname.Text = productModel.Ptitle; hd_content.Value = productModel.Pcontent; if (productModel.IsSecHand == 0) { isstateno.Checked = true; } else { isstateyes.Checked = true; } if (strAction == "show") { this.btnReset.Visible = false; this.btnSave.Visible = false; } MSProductAtlasDAL atlasDal = new MSProductAtlasDAL(); DataSet atlasds = atlasDal.GetProductAtlasByPID(strID); if (atlasds != null && atlasds.Tables.Count > 0 && atlasds.Tables[0].Rows.Count > 0) { atlaslist = ""; string atlasimg = string.Empty; for (int i = 0; i < atlasds.Tables[0].Rows.Count; i++) { atlasimg = atlasds.Tables[0].Rows[i]["PimgUrl"].ToString(); atlaslist += "<img src=\"../../PalmShop/ShopCode/" + atlasimg + "\" />"; } } MSShopContactsDAL contactDal = new MSShopContactsDAL(); DataSet contactDs = contactDal.GetContactDetailByPID(strID); if (contactDs != null && contactDs.Tables.Count > 0 && contactDs.Tables[0].Rows.Count > 0) { string uphone = string.Empty; string uname = string.Empty; uphone = contactDs.Tables[0].Rows[0]["Phone"].ToString(); uname = contactDs.Tables[0].Rows[0]["NickName"].ToString(); UserContact.Text = "联系电话:" + uphone + " " + "联系人:" + uname; } }
protected void btnSave_Click(object sender, EventArgs e) { if (Session["strLoginName"].ToString() != null && Session["strLoginName"].ToString() != "") { if (nickname.Text.Trim() != null && nickname.Text.Trim() != "" && phone.Text.Trim() != null && phone.Text.Trim() != "" && ddlcontactlist.SelectedValue.Trim() != null && ddlcontactlist.SelectedValue.Trim() != "") { MSShopContactsDAL contactdal = new MSShopContactsDAL(); MSShopContacts contactmodel = new MSShopContacts(); contactmodel.Phone = phone.Text; contactmodel.SID = ddlcontactlist.SelectedValue; if (qqnum.Text.Trim() != null && qqnum.Text.Trim() != "") { contactmodel.QQnum = Convert.ToInt32(qqnum.Text); } if (email.Text.Trim() != null && email.Text.Trim() != "") { contactmodel.Email = email.Text; } if (address.Value.Trim() != null && address.Value.Trim() != "") { contactmodel.Address = address.Value; } contactmodel.IsDel = 0; contactmodel.IsDefault = isyes.Checked ? 1 : 0; contactmodel.ID = strID; if (contactdal.UpdateMSSContacts(contactmodel)) { MessageBox.Show(this, "操作成功!"); } else { MessageBox.Show(this, "操作失败!"); } } else { MessageBox.Show(this, "请输入相应名称或电话!"); } } else { return; } }
void showdetailinfo() { ddlcontactlist.Items.Clear(); MSShopDAL actDal = new MSShopDAL(); DataSet ds = new DataSet(); ds = actDal.GetMSShopList(""); ddlcontactlist.DataSource = ds.Tables[0].DefaultView; ddlcontactlist.DataTextField = "ShopName"; ddlcontactlist.DataValueField = "ID"; ddlcontactlist.DataBind(); MSShopContactsDAL contactdal = new MSShopContactsDAL(); DataSet contactds = contactdal.GetContactDetail(strID); MSShopContacts contactdel = DataConvert.DataRowToModel <MSShopContacts>(contactds.Tables[0].Rows[0]); phone.Text = contactdel.Phone; ddlcontactlist.SelectedIndex = ddlcontactlist.Items.IndexOf(ddlcontactlist.Items.FindByValue(contactdel.SID)); nickname.Text = contactdel.NickName; qqnum.Text = contactdel.QQnum.ToString(); email.Text = contactdel.Email; address.Value = contactdel.Address; if (contactdel.IsDefault == 1) { isyes.Checked = true; } else { isno.Checked = true; } if (strAction == "show") { this.btnReset.Visible = false; this.btnSave.Visible = false; } }
protected void uploadbtn_Click(object sender, EventArgs e) { #region 信息判断 if (Session["customerID"] == null || Session["customerID"].ToString() == "") { JQDialog.SetCookies("pageurl", "PubSecHand.aspx?ishand=" + ishand, 2); errorscript = JQDialog.alertOKMsgBox(5, "操作失败<br/>请登录后再操作!", "UserLogin.aspx", "error"); return; } MSProduct productModel = new MSProduct(); if (setpvalue.Value.Trim() != null && setpvalue.Value.Trim() != "") { productModel.Cid = setpvalue.Value; } if (pdesc.Value.Trim() != null && pdesc.Value.Trim() != "") { productModel.Pcontent = pdesc.Value; } if (price.Value.Trim() != null && price.Value.Trim() != "") { productModel.Price = Convert.ToDecimal(price.Value); } if (ptitle.Value.Trim() != null && ptitle.Value.Trim() != "") { productModel.Ptitle = ptitle.Value; } if (price.Value.Trim() != null && price.Value.Trim() != "") { productModel.Price = Convert.ToDecimal(price.Value); } #endregion Random random = new Random(); int r1 = (int)(random.Next(0, 9)); //产生2个0-9的随机数 int r2 = (int)(random.Next(0, 9)); string now = DateTime.Now.ToString("yyMMddhhmmssf"); //一个13位的时间戳 String paymentID = r1.ToString() + r2.ToString() + now; pid = "R" + paymentID; productModel.ID = pid; productModel.IsSecHand = ishand; productModel.Pstate = 0; productModel.Review = 1; productModel.CustomerID = Session["customerID"].ToString(); MSProductDAL productDal = new MSProductDAL(); MSShopContacts contactModel = new MSShopContacts(); MSShopContactsDAL contactDal = new MSShopContactsDAL(); contactModel.ID = Guid.NewGuid().ToString("N").ToUpper(); contactModel.PID = pid; contactModel.IsDel = 0; contactModel.SID = ""; contactModel.NickName = UserName.Value; contactModel.Phone = UserPhone.Value; string pageurl = "NewProduct.aspx?ishand=" + ishand; if (productDal.AddMSProduct(productModel) && SaveImages() && contactDal.AddMSSContacts(contactModel)) { if (ishand == 1) { pageurl = "MySecHand.aspx"; } errorscript = JQDialog.alertOKMsgBox(5, "操作成功!", pageurl, "succeed"); } else { errorscript = JQDialog.alertOKMsgBox(3, "操作失败<br/>请核对后再操作!", "", "error"); return; } }
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); }
/// <summary> /// 获取类别 /// </summary> void getinfo() { #region -----------一级导航绑定----------- ddlbigcategorylist.Items.Clear(); MSProductCategoryDAL categoryDal = new MSProductCategoryDAL(); DataSet ds = new DataSet(); ds = categoryDal.GetSecHandCategoryList(" and UpID='' and CsecHand=" + ishand); ddlbigcategorylist.DataSource = ds.Tables[0].DefaultView; ddlbigcategorylist.DataTextField = "Cname"; ddlbigcategorylist.DataValueField = "ID"; ddlbigcategorylist.DataBind(); #endregion string cid = string.Empty; string bigcid = string.Empty; if (pid.Trim() != null && pid.Trim() != "") { MSProductDAL productDal = new MSProductDAL(); DataSet productds = productDal.GetProductDetail(pid); MSProduct productModel = DataConvert.DataRowToModel <MSProduct>(productds.Tables[0].Rows[0]); cid = productModel.Cid; ptitle.Value = productModel.Ptitle; pdesc.Value = productModel.Pcontent; price.Value = productModel.Price.ToString(); Review = productModel.Review; #region -----------获取一级类别编号------------ if (cid != null && cid != "") { string upid = string.Empty; try { upid = categoryDal.GetMSPCategoryValueByID("UpID", cid).ToString(); } catch (Exception) { } if (upid != null && upid != "") { bigcid = upid; } else { bigcid = cid; } setpvalue.Value = cid; } #endregion ddlbigcategorylist.SelectedIndex = ddlbigcategorylist.Items.IndexOf(ddlbigcategorylist.Items.FindByValue(bigcid)); #region ------------二级导航绑定------------------ if (bigcid != null && bigcid != "") { ddlsmallcategorylist.Items.Clear(); ds = categoryDal.GetSecHandCategoryList(" and UpID='" + bigcid + "' "); ddlsmallcategorylist.DataSource = ds.Tables[0].DefaultView; ddlsmallcategorylist.DataTextField = "Cname"; ddlsmallcategorylist.DataValueField = "ID"; ddlsmallcategorylist.DataBind(); if (cid != null && cid != "") { ddlsmallcategorylist.SelectedIndex = ddlsmallcategorylist.Items.IndexOf(ddlsmallcategorylist.Items.FindByValue(cid)); } } #endregion #region -------------获取图集--------------- MSProductAtlasDAL atlasDal = new MSProductAtlasDAL(); DataSet atlasDs = atlasDal.GetProductAtlasByPID(pid); int rowcount = 0; atlaslist = ""; if (atlasDs != null && atlasDs.Tables.Count > 0 && atlasDs.Tables[0].Rows.Count > 0) { rowcount = atlasDs.Tables[0].Rows.Count; for (int i = 0; i < rowcount; i++) { string imgurl = atlasDs.Tables[0].Rows[i]["PimgUrl"].ToString(); string imgid = atlasDs.Tables[0].Rows[i]["ID"].ToString(); string datarow = string.Empty; atlaslist += "\r\n<dd type=\"image\">\r\n" + "<input type=\"file\" accept=\"image/jpg, image/jpeg, image/png\" " + "onchange=\"form_pics.addImg(this);\" name=\"pics" + i + "\"><img dataid=\"" + imgid + "\" src=\"" + imgurl + "\">" + "\r\n<span onclick=\"form_pics.removeImg(this);\"> </span>\r\n" + "</dd>"; } } if (rowcount < 8) { atlaslist += "\r\n<dd datacount=\"" + rowcount + "\">\r\n" + "<input type=\"file\" accept=\"image/jpg, image/jpeg, image/png\" " + "onchange=\"form_pics.addImg(this);\" name=\"pics" + rowcount + "\"><img src=\"images/upload.png\">" + "\r\n<span onclick=\"form_pics.removeImg(this);\"> </span>\r\n" + "</dd>"; } altascount = rowcount; #endregion #region ----------------根据产品编号获取联系方式-------------------- MSShopContactsDAL contactDal = new MSShopContactsDAL(); DataSet contactDs = contactDal.GetContactDetailByPID(pid); if (contactDs != null && contactDs.Tables.Count > 0 && contactDs.Tables[0].Rows.Count > 0) { string uphone = string.Empty; string uname = string.Empty; uphone = contactDs.Tables[0].Rows[0]["Phone"].ToString(); uname = contactDs.Tables[0].Rows[0]["NickName"].ToString(); contactID = contactDs.Tables[0].Rows[0]["ID"].ToString(); UserPhone.Value = uphone; UserName.Value = uname; } #endregion } }
protected void uploadbtn_Click(object sender, EventArgs e) { #region 信息判断 if (Session["customerID"] != null && Session["customerID"].ToString() != "") { MSCustomersDAL customerDal = new MSCustomersDAL(); phone = customerDal.GetCustomerValueByID("phone", Session["customerID"].ToString()).ToString(); } else { JQDialog.SetCookies("pageurl", "PubSecHandEdit.aspx?ishand=" + ishand, 2); errorscript = JQDialog.alertOKMsgBox(5, "操作失败<br/>请登录后再操作!", "UserLogin.aspx", "error"); return; } MSProduct productModel = new MSProduct(); if (setpvalue.Value.Trim() != null && setpvalue.Value.Trim() != "") { productModel.Cid = setpvalue.Value; } if (pdesc.Value.Trim() != null && pdesc.Value.Trim() != "") { productModel.Pcontent = pdesc.Value; } if (price.Value.Trim() != null && price.Value.Trim() != "") { productModel.Price = Convert.ToDecimal(price.Value); } if (ptitle.Value.Trim() != null && ptitle.Value.Trim() != "") { productModel.Ptitle = ptitle.Value; } if (price.Value.Trim() != null && price.Value.Trim() != "") { productModel.Price = Convert.ToDecimal(price.Value); } #endregion productModel.ID = pid; productModel.IsSecHand = ishand; productModel.Pstate = 0; productModel.Review = Review; productModel.CustomerID = Session["customerID"].ToString(); MSProductDAL productDal = new MSProductDAL(); MSShopContacts contactModel = new MSShopContacts(); MSShopContactsDAL contactDal = new MSShopContactsDAL(); contactModel.PID = pid; contactModel.IsDel = 0; contactModel.SID = ""; contactModel.NickName = UserName.Value; contactModel.Phone = UserPhone.Value; bool contactflag = false; if (contactDal.ExistContact("", "", "", pid)) { contactModel.ID = contactID; contactflag = contactDal.UpdateMSSContacts(contactModel); } else { contactModel.ID = Guid.NewGuid().ToString("N").ToUpper(); contactflag = contactDal.AddMSSContacts(contactModel); } if (productDal.UpdateMSProduct(productModel) && SaveImages()) { errorscript = JQDialog.alertOKMsgBox(3, "操作成功!", "MySecHand.aspx", "error"); } else { errorscript = JQDialog.alertOKMsgBox(4, "操作失败,请核对后再操作!", "", "error"); return; } }