protected void Page_Load(object sender, EventArgs e) { if (string.IsNullOrEmpty(Request.UserAgent) || (!Request.UserAgent.Contains("MicroMessenger") && !Request.UserAgent.Contains("Windows Phone"))) { string jsonstrlist = JsonHelper.GetJsonString(new jsonResult { code = "非法访问", result = null, count = 2 }); jsHint.toUrl("/index.html"); } else { if (!IsPostBack) { code = Request.QueryString["code"]; //code = "345"; if (string.IsNullOrEmpty(code)) { GetCode(); } else { wxopid = GetOpid(code); using (WXDBEntities db = new WXDBEntities()) { var model = db.Forms.Where(s => s.Source.Equals(wxopid) && s.Type == 9).FirstOrDefault(); if (model != null) { isexit = "1"; curtid = model.Id + ""; } } } } } }
private void BindRepeater() { int page = AspNetPager1.CurrentPageIndex; if (!this.IsPostBack) { if (Request["page"] + "" != "") { page = int.Parse(Request["page"] + ""); } } using (WXDBEntities db = new WXDBEntities()) { IQueryable <Product> carlist = db.Product.Where(s => s.Extent3.Equals("0")).OrderBy(o => o.AddTime); if (!string.IsNullOrEmpty(txtKeywords.Text.Trim())) { carlist = carlist.Where(s => s.RealName.Contains(txtKeywords.Text)); } var dblist = carlist.ToPagedList(page, AspNetPager1.PageSize); AspNetPager1.RecordCount = dblist.TotalItemCount; ltlCount.Text = "<b>" + dblist.TotalItemCount + "</b>"; if (!this.IsPostBack) { if (Request["page"] + "" != "") { int temp = int.Parse(Request["page"] + ""); AspNetPager1.CurrentPageIndex = temp; } } WebUtil.CtrlToList <Product>(rptLoop, dblist); } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { using (WXDBEntities db = new WXDBEntities()) { if (!string.IsNullOrEmpty(Request["del"]) && WebUtil.IsDigit(Request["del"])) { int tmpid = Convert.ToInt32(Request["del"]); AResource model = //DbSession.Default.From<Article>().Where(s => s.AritcleID.Equals(tmpid)).ToFirstDefault(); db.AResource.Where(s => s.RId == tmpid).FirstOrDefault(); if (model != null) { //model.Attach(); db.AResource.DeleteObject(model); //model. = 2; //model.UpdateTime = DateTime.Now; // int ts = DbSession.Default.Update<Article>(model); db.SaveChanges(); } } } BindRepeater(); } }
private void BindRepeater() { int page = AspNetPager1.CurrentPageIndex; if (!this.IsPostBack) { if (Request["page"] + "" != "") { page = int.Parse(Request["page"] + ""); } } using (WXDBEntities db = new WXDBEntities()) { IQueryable <WXKewWords> carlist = db.WXKewWords.OrderBy(o => o.Orders).ThenByDescending(o => o.Id).Where(s => s.Type == 1); if (!string.IsNullOrEmpty(txtSearch.Text.Trim())) { carlist = carlist.Where(s => s.Title.Contains(txtSearch.Text)); } var dblist = carlist.ToPagedList(page, AspNetPager1.PageSize); AspNetPager1.RecordCount = dblist.TotalItemCount; ltlCount.Text = "<b>" + dblist.TotalItemCount + "</b>"; if (!this.IsPostBack) { if (Request["page"] + "" != "") { int temp = int.Parse(Request["page"] + ""); AspNetPager1.CurrentPageIndex = temp; } } WebUtil.CtrlToList <WXKewWords>(rptnews, dblist); } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { using (WXDBEntities db = new WXDBEntities()) { if (!string.IsNullOrEmpty(Request["del"]) && WebUtil.IsDigit(Request["del"])) { int tmpid = Convert.ToInt32(Request["del"]); Forms model = db.Forms.Where(s => s.Id.Equals(tmpid) && s.Type.Equals(27)).FirstOrDefault(); if (model != null) { model.Status = 2; db.SaveChanges(); } } if (!string.IsNullOrEmpty(Request["jeid"]) && WebUtil.IsDigit(Request["jeid"])) { int tmpid = Convert.ToInt32(Request["jeid"]); Forms model = db.Forms.Where(s => s.Id.Equals(tmpid) && s.Type.Equals(27)).FirstOrDefault(); if (model != null) { model.Status = 1; db.SaveChanges(); } } } BindRepeater(); } }
private void RptBind() { int page = AspNetPager1.CurrentPageIndex; if (!this.IsPostBack) { if (Request["page"] + "" != "") { page = int.Parse(Request["page"] + ""); } } using (WXDBEntities db = new WXDBEntities()) { IQueryable <Forms> carlist = db.Forms.Where(s => s.Type.Equals(8)).OrderBy(o => o.AddTime); if (!string.IsNullOrEmpty(txtKeywords.Text.Trim())) { carlist = carlist.Where(s => s.Name.Contains(txtKeywords.Text)); } var dblist = carlist.ToPagedList(page, AspNetPager1.PageSize); AspNetPager1.RecordCount = dblist.TotalItemCount; if (!this.IsPostBack) { if (Request["page"] + "" != "") { int temp = int.Parse(Request["page"] + ""); AspNetPager1.CurrentPageIndex = temp; } } WebUtil.CtrlToList <Forms>(rptLoop, dblist); } }
private void BindRepeater() { int page = AspNetPager1.CurrentPageIndex; if (!this.IsPostBack) { if (Request["page"] + "" != "") { page = int.Parse(Request["page"] + ""); } } using (WXDBEntities db = new WXDBEntities()) { IQueryable <Forms> carlist = db.Forms.Where(s => (!s.Status.Equals(2)) && s.Type.Equals(27)).OrderBy(o => o.Orders).ThenByDescending(o => o.AddTime); if (!string.IsNullOrEmpty(txtKeywords.Text.Trim())) { carlist = carlist.Where(s => s.Title.Contains(txtKeywords.Text)); } var dblist = carlist.ToPagedList(page, AspNetPager1.PageSize); AspNetPager1.RecordCount = dblist.TotalItemCount; ltlCount.Text = "<b>" + dblist.TotalItemCount + "</b>"; if (!this.IsPostBack) { if (Request["page"] + "" != "") { int temp = int.Parse(Request["page"] + ""); AspNetPager1.CurrentPageIndex = temp; } } WebUtil.CtrlToList <Forms>(rptLoop, dblist); } }
protected void btnSave_Click(object sender, ImageClickEventArgs e) { using (WXDBEntities db = new WXDBEntities()) { PicType model = new PicType(); model.Title = txttitle.Text; model.Description = txtDesc.Text; model.Orders = Convert.ToInt32(txtorders.Text); model.AddTime = DateTime.Now; model.Status = 0; model.UpdateTime = DateTime.Now; model.Extend = loginname; model.Extend1 = loginname; try { db.PicType.AddObject(model); db.SaveChanges(); jsHint.toUrl("信息" + model.Title + "增加成功!", "PicTypeList.aspx"); } catch (Exception ex) { jsHint.Alert(ex.Message); } } }
private void BindRepeater() { int page = AspNetPager1.CurrentPageIndex; if (!this.IsPostBack) { if (Request["page"] + "" != "") { page = int.Parse(Request["page"] + ""); } } using (WXDBEntities db = new WXDBEntities()) { IQueryable <PicType> carlist = db.PicType.OrderBy(o => o.Orders).ThenByDescending(o => o.Id).Where(s => s.Status == 0); var dblist = carlist.ToPagedList(page, AspNetPager1.PageSize); AspNetPager1.RecordCount = dblist.TotalItemCount; ltlCount.Text = "<b>" + dblist.TotalItemCount + "</b>"; if (!this.IsPostBack) { if (Request["page"] + "" != "") { int temp = int.Parse(Request["page"] + ""); AspNetPager1.CurrentPageIndex = temp; } } WebUtil.CtrlToList <PicType>(rptnews, dblist); } }
private void BindRepeater(string tid) { int page = AspNetPager1.CurrentPageIndex; if (!this.IsPostBack) { if (Request["page"] + "" != "") { page = int.Parse(Request["page"] + ""); } } using (WXDBEntities db = new WXDBEntities()) { IQueryable <UserPoinLog> carlist = db.UserPoinLog.Where(s => s.WxOpenid.Equals(topid)).OrderByDescending(s => s.AddTime); if (!string.IsNullOrEmpty(txtKeywords.Text.Trim())) { carlist = carlist.Where(s => s.UserPointDesc.Contains(txtKeywords.Text)); } var dblist = carlist.ToPagedList(page, AspNetPager1.PageSize); AspNetPager1.RecordCount = dblist.TotalItemCount; ltlCount.Text = "<b>" + dblist.TotalItemCount + "</b>"; if (!this.IsPostBack) { if (Request["page"] + "" != "") { int temp = int.Parse(Request["page"] + ""); AspNetPager1.CurrentPageIndex = temp; } } WebUtil.CtrlToList <UserPoinLog>(rptLoop, dblist); } }
protected void btnSave_Click(object sender, ImageClickEventArgs e) { if (string.IsNullOrEmpty(txttitle.Text.Trim())) { jsHint.Back("请输入进度名称信息!"); return; } using (WXDBEntities db = new WXDBEntities()) { int tmpid = Convert.ToInt32(Request.Params["id"]); var model = db.TuInfo.Where(s => s.Id == tmpid).FirstOrDefault(); model.name = txttitle.Text.Trim();// lat2 + ""; model.extend2 = txtsummary.Text.Trim(); model.updatetime = DateTime.Now; if (upPic.HasFile) { string _imgpath = Guid.NewGuid().ToString() + Path.GetExtension(upPic.FileName).ToLower(); upPic.PostedFile.SaveAs(globalVariables.NewsImgPath + _imgpath); model.varurl = _imgpath; } //db.TuInfo.AddObject(model); db.SaveChanges(); jsHint.toUrl("进度图信息编辑成功!", "jinduinfo.aspx"); } }
private void BindRepeater() { string tmptypid = hidtype.Value; int page = AspNetPager1.CurrentPageIndex; if (!this.IsPostBack) { if (Request["page"] + "" != "") { page = int.Parse(Request["page"] + ""); } } using (WXDBEntities db = new WXDBEntities()) { //FromSection<Article> fromsection = DbSession.Default.From<Article>() // .Where(s => (!s.Status.Equals(2)) && s.Type.In(1, 2, 3, 4)) // .OrderBy(Article._.Orders.Asc, Article._.AritcleID.Asc); IQueryable <AResource> carlist = db.AResource.Where(s => s.Extend.Equals(tmptypid)).OrderBy(s => s.ArticleID).ThenBy(o => o.RId); var dblist = carlist.ToPagedList(page, AspNetPager1.PageSize); //fromsection.ToPagedList(page, AspNetPager1.PageSize); AspNetPager1.RecordCount = dblist.TotalItemCount;// fromsection.Count(); ltlCount.Text = "<b>" + dblist.TotalItemCount + "</b>"; if (!this.IsPostBack) { if (Request["page"] + "" != "") { int temp = int.Parse(Request["page"] + ""); AspNetPager1.CurrentPageIndex = temp; } } WebUtil.CtrlToList <AResource>(rptLoop, dblist); } }
protected void btnSave_Click(object sender, ImageClickEventArgs e) { //if (drpActityType.SelectedValue == "-1") //{ // jsHint.Back("请选择活动信息类别!"); // return; //} if (string.IsNullOrEmpty(txttitle.Text.Trim())) { jsHint.Back("请输入活动标题!"); return; } if (string.IsNullOrEmpty(txtorders.Text.Trim())) { jsHint.Back("请输入排序号!"); return; } if (!WebUtil.IsDigit(txtorders.Text.Trim())) { jsHint.Back("排序号请输入数字!"); return; } if (string.IsNullOrEmpty(txtcontent.Value)) { jsHint.Back("请输入内容信息!"); return; } WXEF.Activity addobj = new WXEF.Activity(); addobj.Title = txttitle.Text; addobj.Entitle = ""; addobj.Author = loginname; addobj.UpdateAuthor = loginname; addobj.Orders = string.IsNullOrEmpty(txtorders.Text) ? 0 : int.Parse(txtorders.Text); addobj.Contents = txtcontent.Value;; addobj.Description = txtsummary.Text.Trim(); addobj.StartTime = Convert.ToDateTime(txtStart.Text.Trim()); addobj.EndTime = Convert.ToDateTime(txtEnd.Text.Trim()); addobj.AddTime = DateTime.Now; addobj.Status = rdisshow.SelectedValue == "0" ? 0 : 1; addobj.Type = 0;// Convert.ToInt32(drpActityType.SelectedValue); addobj.UpdateTime = DateTime.Now; if (upPic.HasFile) { string _imgpath = Guid.NewGuid().ToString() + Path.GetExtension(upPic.FileName).ToLower(); upPic.PostedFile.SaveAs(globalVariables.NewsImgPath + _imgpath); addobj.Conver = _imgpath; } else { addobj.Conver = ""; } using (WXDBEntities db = new WXDBEntities()) { db.Activity.AddObject(addobj); db.SaveChanges(); jsHint.toUrl("活动信息" + addobj.Title + "增加成功!", "ActivityList.aspx"); } }
private void BindRepeater() { int page = AspNetPager1.CurrentPageIndex; if (!this.IsPostBack) { if (Request["page"] + "" != "") { page = int.Parse(Request["page"] + ""); } } using (WXDBEntities db = new WXDBEntities()) { IQueryable <WXEF.QrCodeInfo> carlist = db.QrCodeInfo.OrderBy(o => o.Orders).ThenByDescending(o => o.AddTime); if (drpList.SelectedValue != "-1") { var tmeVal = drpList.SelectedValue; carlist = carlist.Where(s => s.QrCodeReslut.Contains(tmeVal)); } var dblist = carlist.ToPagedList(page, AspNetPager1.PageSize); AspNetPager1.RecordCount = dblist.TotalItemCount; ltlCount.Text = "<b>" + dblist.TotalItemCount + "</b>"; if (!this.IsPostBack) { if (Request["page"] + "" != "") { int temp = int.Parse(Request["page"] + ""); AspNetPager1.CurrentPageIndex = temp; } } WebUtil.CtrlToList <WXEF.QrCodeInfo>(rptnews, dblist); } }
/// <summary> /// 获取奖品信息 /// </summary> protected void GetListInfo() { using (WXDBEntities db = new WXDBEntities()) { var list = new List <lotterUserInfo>(); list = db.lotterUserInfo.Where(s => s.Type.Equals(15) && s.PriceNumber != 0).ToList(); List <object> listDesc = new List <object>(); if (list.Count > 0) { foreach (var item in list) { listDesc.Add(new { id = item.Id, name = item.NickName.Substring(0, 1) + "***", phone = item.Extend1.Substring(0, 3) + "****" + item.Extend1.Substring(7), ords = item.PriceName }); } string jsonstrlist = JsonHelper.GetJsonString(new jsonResult { code = "succ", result = listDesc, count = list.Count }); _ct.Response.Write(jsonstrlist); } else { string jsonstrlist = JsonHelper.GetJsonString(new jsonResult { code = "error", result = "", count = 0 }); _ct.Response.Write(jsonstrlist); } } }
private void BindRepeater() { int page = AspNetPager1.CurrentPageIndex; if (!this.IsPostBack) { if (Request["page"] + "" != "") { page = int.Parse(Request["page"] + ""); } } using (WXDBEntities db = new WXDBEntities()) { var tmodel = db.Article.Where(s => s.AritcleID.Equals(aid)).FirstOrDefault(); str = tmodel.Title; IQueryable <Forms> carlist = db.Forms.Where(s => s.Status.Equals(0) && s.Type.Equals(0) && s.FormType.Equals(aid)).OrderBy(o => o.Orders).ThenByDescending(o => o.Id); var dblist = carlist.ToPagedList(page, AspNetPager1.PageSize); AspNetPager1.RecordCount = dblist.TotalItemCount; ltlCount.Text = "<b>" + dblist.TotalItemCount + "</b>"; if (!this.IsPostBack) { if (Request["page"] + "" != "") { int temp = int.Parse(Request["page"] + ""); AspNetPager1.CurrentPageIndex = temp; } } WebUtil.CtrlToList <Forms>(rptLoop, dblist); } }
/// <summary> /// 修改保存操作 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void btnSave_Click(object sender, ImageClickEventArgs e) { using (WXDBEntities db = new WXDBEntities()) { int id = int.Parse(Request.QueryString["id"]); PageItem xPageItem = db.PageItem.Where(p => p.ItemID == id).FirstOrDefault(); xPageItem.PageName = txtPageName.Text; xPageItem.Url = txtUrl.Text; xPageItem.IsDisplay = IsDisplay.Checked; if (upPic.HasFile) { if (!string.IsNullOrEmpty(xPageItem.PicUrl) && File.Exists(globalVariables.SysDirString + xPageItem.PicUrl)) { File.Delete(globalVariables.SysDirString + xPageItem.PicUrl); } string _img = Guid.NewGuid().ToString() + Path.GetExtension(upPic.FileName).ToLower(); upPic.PostedFile.SaveAs(globalVariables.SysDirString + _img); xPageItem.PicUrl = _img; } db.SaveChanges(); } jsHint.toUrl("页面信息" + txtPageName.Text + "修改成功!", refer.Value); }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { using (WXDBEntities db = new WXDBEntities()) { if (!string.IsNullOrEmpty(Request["del"]) && WebUtil.IsDigit(Request["del"])) { int tmpid = Convert.ToInt32(Request["del"]); UserPoinLog model = db.UserPoinLog.Where(s => s.Id == tmpid).FirstOrDefault(); if (model != null) { var tm = db.Forms.Where(s => s.Source.Equals(topid) && s.Type.Equals(8)).FirstOrDefault(); if (tm != null) { //tm.JFCount = tm.JFCount - Convert.ToDecimal(model.Extent1); // tm.Status = tm.Status - 1; } db.UserPoinLog.DeleteObject(model); db.SaveChanges(); } } } BindRepeater(topid); } using (WXDBEntities db = new WXDBEntities()) { var tm = db.Forms.Where(s => s.Source.Equals(topid) && s.Type.Equals(8)).FirstOrDefault(); if (tm != null) { ctitile = tm.Name; } } }
//新增留言 public void AddQues(HttpContext context) { string opid = context.Request.Params["tmpopid"]; string uname = context.Request.Params["tmpuname"]; string cot = context.Request.Params["tmpcont"]; try { using (WXDBEntities db = new WXDBEntities()) { var qumod = new ZxFw(); qumod.wxopenid = opid; qumod.Extend1 = uname; qumod.status = 0; qumod.orders = 0; qumod.qucont = Utils.EncodeHtml(cot); qumod.anscont = ""; qumod.addtime = DateTime.Now; qumod.updatetime = DateTime.Now; qumod.extend2 = ""; qumod.extend3 = ""; db.ZxFw.AddObject(qumod); db.SaveChanges(); context.Response.Write("1"); return; } } catch (Exception) { context.Response.Write("0"); return; } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { //code = "345"; code = Request.QueryString["code"]; if (string.IsNullOrEmpty(code)) { GetCode(); } else { //获取opid //wxopid = "or0aAs_FI1HkTXouZM4UMG098obk"; wxopid = GetOpid(code); if (string.IsNullOrEmpty(Request.UserAgent) || (!Request.UserAgent.Contains("MicroMessenger") && !Request.UserAgent.Contains("Windows Phone"))) { jsHint.toUrl("ydhb.aspx"); } else { DateTime t1 = DateTime.Now; DateTime t2 = Convert.ToDateTime(WebConfigurationManager.AppSettings["starttime6"]); DateTime t3 = Convert.ToDateTime(WebConfigurationManager.AppSettings["endtime6"]); if (DateTime.Compare(t1, t2) > 0 && DateTime.Compare(t1, t3) < 0) { isexit = "1"; DateTime now = DateTime.Now; TimeSpan span = now.TimeOfDay; var tmsg = WebConfigurationManager.AppSettings["sjd6"].Split(new char[] { '|' }, StringSplitOptions.RemoveEmptyEntries); foreach (var item in tmsg) { ids++; var tmpinfo = item.Split(new char[] { '-' }, StringSplitOptions.RemoveEmptyEntries); TimeSpan begin = new TimeSpan(Convert.ToInt32(tmpinfo[0].Split(new char[] { ':' }, StringSplitOptions.RemoveEmptyEntries)[0]), Convert.ToInt32(tmpinfo[0].Split(new char[] { ':' }, StringSplitOptions.RemoveEmptyEntries)[1]), 0); TimeSpan end = new TimeSpan(Convert.ToInt32(tmpinfo[1].Split(new char[] { ':' }, StringSplitOptions.RemoveEmptyEntries)[0]), Convert.ToInt32(tmpinfo[1].Split(new char[] { ':' }, StringSplitOptions.RemoveEmptyEntries)[1]), 0); if ((span >= begin) && (span <= end)) { iscj = "1"; break; } } if (iscj.Equals("1")) { using (WXDBEntities db = new WXDBEntities()) { string ti = ids + ""; var order = db.Oders.Where(s => s.Soucre.Equals(wxopid) && s.Extent1.Equals("61") && s.AddUser.Equals(ti)).FirstOrDefault(); if (order != null) { curcj = "1"; } } } } } } } }
/// <summary> /// 获取当前活动名称 /// </summary> /// <param name="actyid"></param> /// <returns></returns> public string GetActivityName(object actyid) { using (WXDBEntities db = new WXDBEntities()) { int tmpid = Convert.ToInt32(actyid); return(db.Activity.Where(s => s.ID == tmpid).FirstOrDefault().Title); } }
private void InitCtrls() { using (WXDBEntities db = new WXDBEntities()) { WebUtil.DrpToListEx <ArticleType>(drptype, db.ArticleType.Where(s => s.Status == 0).OrderBy(s => s.ID).ToList(), "TypeName", "ID");//( } }
protected string GetCount(object obj) { using (WXDBEntities db = new WXDBEntities()) { int tmprid = Convert.ToInt32(obj); return(db.RecommendInfo.Where(s => s.RgeisterInfo == tmprid).Count().ToString()); } }
void GenerateData() { ISheet sheet1 = hssfworkbook.CreateSheet("Sheet1"); //sheet1.CreateRow(0).CreateCell(0).IsPartOfArrayFormulaGroup = true; IRow row2 = sheet1.CreateRow(0); ICell cell = row2.CreateCell(0); cell.SetCellValue(ltlServer.Text + "推荐的客户"); ICellStyle style = hssfworkbook.CreateCellStyle(); style.Alignment = HorizontalAlignment.Center; IFont font = hssfworkbook.CreateFont(); font.FontHeight = 20 * 20; style.SetFont(font); cell.CellStyle = style; sheet1.AddMergedRegion(new CellRangeAddress(0, 0, 0, 6)); IRow row1 = sheet1.CreateRow(1); row1.CreateCell(0).SetCellValue("姓名"); row1.CreateCell(1).SetCellValue("手机号码"); row1.CreateCell(2).SetCellValue("状态"); row1.CreateCell(3).SetCellValue("户型面积"); row1.CreateCell(4).SetCellValue("备注信息"); using (WXDBEntities db = new WXDBEntities()) { var tmpid = Convert.ToInt32(Request.Params["rgid"]); IQueryable <RecommendInfo> carlist = db.RecommendInfo.Where(s => s.RgeisterInfo == tmpid).OrderBy(o => o.Orders).ThenByDescending(o => o.Id); if (carlist.Count() > 0) { int x = 2; foreach (var item in carlist) { IRow row = sheet1.CreateRow(x); row.CreateCell(0).SetCellValue(item.Name); row.CreateCell(1).SetCellValue(item.Phone); row.CreateCell(2).SetCellValue(WX.Utils.Utils.GetStatus(Convert.ToInt32(item.Status))); row.CreateCell(3).SetCellValue(item.loupanInfo); row.CreateCell(4).SetCellValue(item.Extent1); x++; } } //int x = 1; //for (int i = 1; i <= 400; i++) //{ // IRow row = sheet1.CreateRow(i); // for (int j = 0; j < 20; j++) // { // row.CreateCell(j).SetCellValue(x++); // } //} } }
public List <Oders> GetNeastBuyerInfo() { using (var db = new WXDBEntities())//Ef code first { var list = db.Oders.Where(s => s.Extent1.Equals("61")).OrderByDescending(c => c.AddTime).Take(TakeCount) .OrderBy(c => c.Id).ToList(); return(list); } }
protected void Page_Load(object sender, EventArgs e) { if (!Page.IsPostBack) { // 处理删除模块操作 if (!string.IsNullOrEmpty(Request.QueryString["delid"])) { int mid = int.Parse(Request.QueryString["delid"]); using (WXDBEntities db = new WXDBEntities()) { //IList<PageItem> xList = db.PageItem.Where(p => p.ModuleID == mid).ToList(); //if (xList.Count > 0) //{ // foreach (var p in xList) // { // PageItem xPageItem = p; // db.PageItem.DeleteObject(xPageItem); // db.SaveChanges(); // } //} ModuleItem xModuleItem = db.ModuleItem.Where(m => m.ModuleID == mid).FirstOrDefault(); db.ModuleItem.DeleteObject(xModuleItem); db.SaveChanges(); jsHint.toUrl("删除成功!", "ModuleList.aspx"); } } // 处理删除页面操作 if (!string.IsNullOrEmpty(Request.QueryString["delpid"])) { int pid = int.Parse(Request.QueryString["delid"]); using (WXDBEntities db = new WXDBEntities()) { PageItem xPageItem = db.PageItem.Where(p => p.ItemID == pid).FirstOrDefault(); db.PageItem.DeleteObject(xPageItem); db.SaveChanges(); } jsHint.toUrl("删除成功!", "ModuleList.aspx"); } // 处理排序操作 if (!string.IsNullOrEmpty(Request.QueryString["action"])) { //if (!string.IsNullOrEmpty(Request.QueryString["id"])) // MaintenanceService.Instance.ModifyModuleOrdersById(int.Parse(Request.QueryString["id"]), Request.QueryString["action"]); //else if (!string.IsNullOrEmpty(Request.QueryString["pid"])) // MaintenanceService.Instance.ModifyPageOrdersById(int.Parse(Request.QueryString["pid"]), Request.QueryString["action"]); } // 进行数据绑定 InitCtrls(); } ((maintenancemaster)this.Master).txtTitle = "模块信息列表"; }
protected void btnSave_Click(object sender, ImageClickEventArgs e) { //if (drpActityType.SelectedValue == "-1") //{ // jsHint.Back("请选择活动信息类别!"); // return; //} if (string.IsNullOrEmpty(txtKeword.Text.Trim())) { jsHint.Back("请输入关键词!"); return; } if (string.IsNullOrEmpty(txtcontent.Value.Trim())) { jsHint.Back("请输入关键词信息!"); return; } using (WXDBEntities db = new WXDBEntities()) { var tmpid = Convert.ToInt32(Request.Params["id"]); var m1 = db.WXKewWords.Where(s => s.Title.Equals(txtKeword.Text.Trim())).Where(s => s.Id != tmpid).FirstOrDefault(); if (m1 != null) { jsHint.Back("已存在该关键词信息,请重新输入关键词!"); return; } var tmp = db.WXKewWords.Where(s => s.Id == tmpid).FirstOrDefault(); if (tmp != null) { tmp.Title = txtKeword.Text.Trim(); tmp.Description = txtcontent.Value; tmp.UpdateTime = DateTime.Now; } else { tmp = new WXKewWords(); tmp.Title = txtKeword.Text.Trim(); tmp.Status = 0; tmp.Orders = 0; tmp.AddTime = DateTime.Now; tmp.UpdateTime = DateTime.Now; tmp.Type = 1; tmp.Description = txtcontent.Value; db.WXKewWords.AddObject(tmp); } try { db.SaveChanges(); jsHint.toUrl("关键词信息编辑成功!", "keyword.aspx"); } catch (Exception et) { jsHint.Alert("错误信息" + et.Message); } } }
//private void SetZan(HttpContext context) //{ // try // { // int tmphid = 0; // int.TryParse(context.Request.Form["tmpid"], out tmphid); // string topid = context.Request.Form["tmpopenid"]; // var tmpopenid = Common.CryptHelper.DESEncrypt.Decrypt(topid, WebConfigurationManager.AppSettings["PassWordKey"]); // int nums1 = 0; // int ist = 0; // DateTime t1 = DateTime.Now.Date; // DateTime tm2 = DateTime.Now.AddDays(1).Date; // DateTime t2 = Convert.ToDateTime(WebConfigurationManager.AppSettings["endtime12"]); // DateTime t3 = t2.AddDays(1); // var userInfo = UserApi.Info(AccessTokenContainer.TryGetToken(WebConfigurationManager.AppSettings["wxappid1"], WebConfigurationManager.AppSettings["wxsecret1"]), tmpopenid); // if (string.IsNullOrEmpty(_ct.Request.UserAgent) || (!_ct.Request.UserAgent.Contains("MicroMessenger") && !_ct.Request.UserAgent.Contains("Windows Phone"))) // { // context.Response.Write("{\"ismsgs\":\"0\",\"ist\":\"" + 2 + "\"}"); // } // else // { // if (DateTime.Compare(t1, t2) < 0) // { // if (tmphid > 0) // { // int idnum = 0; // using (WXDBEntities db = new WXDBEntities()) // { // //var ctcount = db.HdPicHit.Where(s => s.wxopenid.Equals(tmpopenid) && s.addtime > t1 && s.addtime < tm2).Count(); // //if (ctcount >= 3) // //{ // // context.Response.Write("{\"ismsgs\":\"0\",\"ist\":\"" + 2 + "\"}"); // //} // //else // //{ // //var tmpdel = db.HdPicHit.Where(s => s.wxopenid.Equals(tmpopenid) && s.hdpicid.Equals(tmphid) && s.addtime > t1 && s.addtime < tm2).FirstOrDefault(); // var tmpdel = db.HdPicHit.Where(s => s.wxopenid.Equals(tmpopenid) && s.extend1.Equals("108")).FirstOrDefault(); // if (tmpdel != null) // { // context.Response.Write("{\"ismsgs\":\"0\",\"ist\":\"" + 5 + "\"}"); // } // else // { // HdPicHit model = new HdPicHit(); // model.addtime = DateTime.Now; // model.updatetime = DateTime.Now; // model.extend1 = "108"; // model.extend2 = ""; // model.orders = 0; // model.status = 0; // model.wxopenid = tmpopenid; // model.name = ""; // model.hdpicid = tmphid; // db.HdPicHit.AddObject(model); // db.SaveChanges(); // HdPic tmodel = db.HdPic.Where(s => s.Id == tmphid).FirstOrDefault(); // if (tmodel != null) // { // nums1 = tmodel.Orders + 1; // SqlParameter[] para = new SqlParameter[] { // new SqlParameter("@Id",tmodel.Id), // new SqlParameter("@Orders",tmodel.Orders+1), // new SqlParameter("@UpdateTime",DateTime.Now) // }; // var ct = db.ExecuteStoreCommand(" update HdPic set Orders=@Orders, UpdateTime=@UpdateTime where Id=@Id", para); // } // else // { // nums1 = 0; // } // ist = 1; // context.Response.Write("{\"ismsgs\":\"" + nums1 + "\",\"ist\":\"" + 1 + "\"}"); // //} // } // } // } // else // { // context.Response.Write("{\"ismsgs\":\"0\",\"ist\":\"" + 0 + "\"}"); // } // } // else // { // context.Response.Write("{\"ismsgs\":\"0\",\"ist\":\"" + 3 + "\"}"); // } // } // } // catch (Exception) // { // context.Response.Write("{\"ismsgs\":\"0\",\"ist\":\"" + 4 + "\"}"); // } //} protected void GetImgList() { int page = 0; int pagesize = 8; int.TryParse(_ct.Request.Form["tmppage"], out page); if (page < 1) { page = 0; } int.TryParse(_ct.Request.Form["pagesize"], out pagesize); using (WXDBEntities db = new WXDBEntities()) { int skipsize = page * pagesize; int tmpage = page + 1; //var list = new List<HdPic>(); //////.OrderByDescending(s => s.Orders). //list = db.HdPic.Where(s => s.Status == 0 && s.Extend2.Equals("108")).OrderByDescending(s => s.Orders).ThenBy(s => s.UpdateTime).Skip(skipsize).Take(pagesize).ToList(); FromSection <Dos.Model.HdPic> fromsection = DbSession.Default.From <Dos.Model.HdPic>() .Where(s => s.Extend2.Equals("108")) .OrderBy(Dos.Model.HdPic._.Orders.Desc, Dos.Model.HdPic._.UpdateTime.Asc); var list = fromsection.Page(pagesize, tmpage).ToList(); //DbSession.Default.FromSql("select row from (select row_number() over (order by orders desc,updatetime asc) row,extend1 from hdpic where Extend2='108') newtable where extend1=@extend1").AddInParameter("@extend1", DbType.String, "321").ToScalar(); //SqlSection str = new SqlSection(); //str.(DbSession) //IQueryable<HdPic> list = db.HdPic.OrderByDescending(s => s.Orders).ThenBy(s => s.UpdateTime).Where(s => s.Extend2.Equals("108")); //var dblist = list.ToPagedList(tmpage, pagesize); List <object> listDesc = new List <object>(); if (list.Count > 0) { foreach (var item in list) { listDesc.Add(new { id = item.Id, name = item.Name, nums = item.Orders, tcont = item.PicUrl }); } string jsonstrlist = JsonHelper.GetJsonString(new jsonResult { code = "succ", result = listDesc, count = list.Count }); _ct.Response.Write(jsonstrlist); } else { string jsonstrlist = JsonHelper.GetJsonString(new jsonResult { code = "error", result = "", count = 0 }); _ct.Response.Write(jsonstrlist); } } }
/// <summary> /// 页面初始化 /// </summary> private void InitCtrls(int Id) { using (WXDBEntities db = new WXDBEntities()) { ModuleItem xModuleItem = db.ModuleItem.Where(m => m.ModuleID == Id).FirstOrDefault(); txtModuleName.Text = xModuleItem.ModuleName; txtDefaultUrl.Text = xModuleItem.DefaultUrl; } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { using (WXDBEntities db = new WXDBEntities()) { if (!string.IsNullOrEmpty(Request["del"]) && WebUtil.IsDigit(Request["del"])) { int tmpid = Convert.ToInt32(Request["del"]); AResource model = //DbSession.Default.From<Article>().Where(s => s.AritcleID.Equals(tmpid)).ToFirstDefault(); db.AResource.Where(s => s.RId == tmpid).FirstOrDefault(); if (model != null) { //model.Attach(); db.AResource.DeleteObject(model); //model. = 2; //model.UpdateTime = DateTime.Now; // int ts = DbSession.Default.Update<Article>(model); db.SaveChanges(); } } } } BindRepeater(); WebConn.ManageInfoType sex = (WebConn.ManageInfoType)typid; switch (sex) { case WebConn.ManageInfoType.半岛美食: stTitle = WebConn.ManageInfoType.半岛美食.ToString(); break; case WebConn.ManageInfoType.万宁四诊: stTitle = WebConn.ManageInfoType.万宁四诊.ToString(); break; case WebConn.ManageInfoType.其他美食: stTitle = WebConn.ManageInfoType.其他美食.ToString(); break; case WebConn.ManageInfoType.特色小吃: stTitle = WebConn.ManageInfoType.特色小吃.ToString(); break; case WebConn.ManageInfoType.美食餐厅: stTitle = WebConn.ManageInfoType.美食餐厅.ToString(); break; } string reqStrUrl = "BDMSList.aspx?tid=" + typid; //if (Request.UrlReferrer != null) //{ // reqStrUrl = Request.UrlReferrer.ToString(); //} btn_Back.Attributes.Add("onclick", "window.location.href='" + reqStrUrl + "';return false;"); }