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