//加载所有信息 public void LoadDataBind() { int pageSize = AspNetPager1.PageSize; int recordCount = 0; int pageIndex = ViewState["PageIndex"].ToInt(); TB_Order_Orders order = new TB_Order_Orders(); List <Expression> expression = new List <Expression>(); expression.Add(new Expression("IsDelete", "=", "1")); if (Request.QueryString["state"] != null) { int state = CommonClass.ReturnRequestInt("state", 0); expression.Add(new Expression("OrderStateID", "=", state.ToStr())); } var list = OrderService.OrdersService.Search(pageSize, pageIndex, expression, ref recordCount); if (ViewState["StartDate"] != null && ViewState["EndDate"] != null) { expression.Add(new Expression("OrderDate", ">=", ViewState["StartDate"].ToStr())); expression.Add(new Expression("OrderDate", "<=", ViewState["EndDate"].ToStr())); list = list.Where(o => o.OrderDate >= Convert.ToDateTime(ViewState["StartDate"]) && o.OrderDate <= Convert.ToDateTime(ViewState["EndDate"])).ToList(); } RepList.DataSource = list; RepList.DataBind(); }
//加载所有信息 public void LoadDataBind() { int pageSize = AspNetPager1.PageSize; int recordCount = 0; int pageIndex = ViewState["PageIndex"].ToInt(); List <Expression> expression = new List <Expression>(); //只显示已销售的订单 expression.Add(new Expression("OrderStateID", "=", "6")); if (ViewState["StartDate"] != null) { expression.Add(new Expression("OrderDate", ">=", ViewState["StartDate"].ToStr())); } if (ViewState["EndDate"] != null) { expression.Add(new Expression("OrderDate", "<=", ViewState["EndDate"].ToStr())); } var list = OrderService.OrdersService.Search(pageSize, pageIndex, expression, "orderDate desc", ref recordCount); RepList.DataSource = list; RepList.DataBind(); }
//加载所有信息 public void LoadDataBind() { int id = CommonClass.ReturnRequestInt("id", 0); orders = OrderService.OrdersService.Get(id); if (orders.IsPassing == 1) { RadioPassing.Checked = true; } if (orders.IsPassing == 2) { RadioNoPassing.Checked = true; } TbPassingReason.Text = orders.PassingReason; List <Expression> express = new List <Expression>(); express.Add(new Expression("OrderNumber", "=", orders.OrderNumber)); distribution = OrderService.DistributionService.Get(express); RepList.DataSource = OrderService.OrderDetailsService.Search(express); RepList.DataBind(); }
//加载所有信息 public void LoadDataBind() { DDLPaymentType.DataSource = Dictionaries.GetDictionaries(DictionariesEnum.支付方式); DDLPaymentType.DataValueField = "ID"; DDLPaymentType.DataTextField = "Title"; DDLPaymentType.DataBind(); //订单信息 int id = CommonClass.ReturnRequestInt("id", 0); orders = OrderService.OrdersService.Get(id); if (orders.IsPassing == 1) { RadioPassing.Checked = true; } if (orders.IsPassing == 2) { RadioNoPassing.Checked = true; } TbPassingReason.Text = orders.PassingReason; //支付信息 List <Expression> express = new List <Expression>(); express.Add(new Expression("OrderNumber", "=", orders.OrderNumber)); distribution = OrderService.DistributionService.Get(express); DDLPaymentType.SelectedValue = distribution.PaymentID.ToStr(); RepList.DataSource = OrderService.OrderDetailsService.Search(express); RepList.DataBind(); }
protected void LoadDataBind() { List <TB_Product_Categorys> list = ProductService.CategoryService.Search(); RepList.DataSource = GetChilds(list, 0); RepList.DataBind(); }
//加载所有信息 public void LoadDataBind() { int pageSize = AspNetPager1.PageSize; int recordCount = 0; int pageIndex = ViewState["PageIndex"].ToInt(); List <Expression> expression = new List <Expression>(); expression.Add(new Expression("ProName", "like", TbKey.Text.Trim())); if (DDLMark.SelectedValue != "") { expression.Add(new Expression("Mark", "like", DDLMark.SelectedValue)); } if (CategoryId.CategoryID != 0) { expression.Add(new Expression("CategoryID", "=", CategoryId.CategoryID.ToStr())); } if (TbStartDate.Text.Trim() != string.Empty) { expression.Add(new Expression("AddDate", ">=", TbStartDate.Text)); } if (TbStopDate.Text.Trim() != string.Empty) { DateTime stopDate = Convert.ToDateTime(TbStopDate.Text).AddDays(1); expression.Add(new Expression("AddDate", "<", stopDate.ToShortDateString())); } List <TB_Product_Products> list = ProductService.ProductsService.Search(pageSize, pageIndex, expression, " Id desc,AddDate desc", ref recordCount); RepList.DataSource = list; RepList.DataBind(); AspNetPager1.RecordCount = recordCount; }
//加载所有信息 public void LoadDataBind() { int pageSize = AspNetPager1.PageSize; int recordCount = 0; int pageIndex = ViewState["PageIndex"].ToInt(); int categoryId = 0; if (!string.IsNullOrEmpty(Request["categoryId"])) { categoryId = Request["categoryId"].ToInt(); } else { categoryId = ProductCategory.CategoryId; } List <Expression> expression = new List <Expression>(); if (categoryId > 0) { expression.Add(new Expression("ProCategoryId", "=", categoryId)); } RepList.DataSource = ProductService.PropertiesService.Search(pageSize, pageIndex, expression, " OrderBy asc,AddDate desc", ref recordCount); RepList.DataBind(); AspNetPager1.RecordCount = recordCount; }
//加载所有信息 public void LoadDataBind() { List <Expression> express = new List <Expression>(); express.Add(new Expression("ParentId", "=", "0")); RepList.DataSource = ProductService.BrandsService.Search(express); RepList.DataBind(); }
public void dataBind() { string sql = "select * from productType order by orderId Desc"; DataSet ds = crm.Querys(sql, null); RepList.DataSource = ds; RepList.DataBind(); }
//加载所有信息 public void LoadDataBind() { int pageSize = AspNetPager1.PageSize; int recordCount = 0; int pageIndex = ViewState["PageIndex"].ToInt(); RepList.DataSource = OrderService.ConsigumentService.Search(pageSize, pageIndex, new List <Expression>(), ref recordCount); RepList.DataBind(); }
//加载所有信息 public void LoadDataBind() { int pageSize = AspNetPager1.PageSize; int recordCount = 0; int pageIndex = ViewState["PageIndex"].ToInt(); RepList.DataSource = ProductService.GroupService.Search(pageSize, pageIndex, new List <Expression>(), " Id desc,AddDate desc", ref recordCount); RepList.DataBind(); AspNetPager1.RecordCount = recordCount; }
protected void LoadDataBind(int pageIndex) { List <Expression> expression = new List <Expression>(); expression.Add(new Expression("OrderNumber", "=", Request["OrderNumber"])); List <TB_Order_OrderDetails> list = OrderService.OrderDetailsService.Search(expression); RepList.DataSource = list; RepList.DataBind(); }
//加载所有信息 public void LoadDataBind() { int pageSize = AspNetPager1.PageSize; int recordCount = 0; int pageIndex = ViewState["PageIndex"].ToInt(); var list = ProductService.BrowerRecordService.Search(pageSize, pageIndex, new List <Expression>(), "BrowerDate desc", ref recordCount); RepList.DataSource = list; RepList.DataBind(); }
//加载 public void LoadDataBind() { //创建列 DataColumn column1 = new DataColumn("ID", typeof(string)); DataColumn column2 = new DataColumn("CategoryName", typeof(string)); DataColumn column3 = new DataColumn("ParentID", typeof(string)); DataColumn column4 = new DataColumn("OrderBy", typeof(string)); DataColumn column5 = new DataColumn("IsVouch", typeof(string)); DataColumn column6 = new DataColumn("IsHidden", typeof(string)); DataColumn column7 = new DataColumn("AddDate", typeof(string)); DataColumn column8 = new DataColumn("Type", typeof(string)); //添加列 dt.Columns.Add(column1); dt.Columns.Add(column2); dt.Columns.Add(column3); dt.Columns.Add(column4); dt.Columns.Add(column5); dt.Columns.Add(column6); dt.Columns.Add(column7); dt.Columns.Add(column8); int cid = CommonClass.ReturnRequestInt("cid", 0); List <Expression> express = new List <Expression>() { new Expression("ParentID", "=", cid.ToStr()), new Expression("IsDelete", "=", "0") }; List <TB_Product_Categorys> list = ProductService.CategoryService.Search(express, "OrderBy asc"); foreach (TB_Product_Categorys model in list) { DataRow dr = dt.NewRow(); dr["ID"] = model.ID.ToStr(); dr["CategoryName"] = model.CategoryName; dr["ParentID"] = model.ParentID.ToStr(); dr["OrderBy"] = model.OrderBy.ToStr(); dr["IsVouch"] = model.VouchType.ToStr(); dr["IsHidden"] = model.IsHidden.ToStr(); dr["AddDate"] = model.AddDate.ToStr(); dr["Type"] = model.TypeID == 0 ? "普通" : "团购"; //添加行 dt.Rows.Add(dr); jiantou = "";//记录级别 //获取子类 GetChildClass(model.ID); } RepList.DataSource = dt; RepList.DataBind(); }
//加载所有信息 public void LoadDataBind() { int pageSize = AspNetPager1.PageSize; int recordCount = 0; List <Expression> expression = new List <Expression>(); expression.Add(new Expression("ParentID", "=", "0")); List <TB_Admin_Resources> list = AdminService.ResourcesService.Search(pageSize, 1, expression, "OrderBy asc", ref recordCount); RepList.DataSource = CommonClass.EntityListToDataTable <TB_Admin_Resources>(list); RepList.DataBind(); }
//加载所有信息 public void LoadDataBind() { int pageSize = AspNetPager1.PageSize; int recordCount = 0; int pageIndex = ViewState["PageIndex"].ToInt(); List <TB_Sys_Organizations> list = SysOrganizationsService.OrganizationsService.Search(pageSize, pageIndex, new List <Expression>(), " Id desc,CreatedOn desc", ref recordCount); RepList.DataSource = list; RepList.DataBind(); AspNetPager1.RecordCount = recordCount; }
//加载所有信息 public void LoadDataBind() { int recordCount = 0; string key = ViewState["search"].ToString(); int pageIndex = Convert.ToInt32(ViewState["PageIndex"]); int pageSize = AspNetPager1.PageSize; RepList.DataSource = AdminService.LogService.Search (pageSize, pageIndex, new List <Expression>(), "AddDate desc", ref recordCount); RepList.DataBind(); AspNetPager1.RecordCount = recordCount; }
//加载所有信息 public void LoadDataBind() { int pageSize = AspNetPager1.PageSize; int recordCount = 0; int pageIndex = ViewState["PageIndex"].ToInt(); List <TB_Employee_InfoCategory> list = EmployeeService.InfoCategoryService.Search(pageSize, pageIndex, new List <Expression>(), " OrderBy asc,Id asc,AddDate asc", ref recordCount); RepList.DataSource = list; RepList.DataBind(); AspNetPager1.RecordCount = recordCount; }
//加载所有信息 public void LoadDataBind() { int pageSize = AspNetPager1.PageSize; int recordCount = 0; int pageIndex = ViewState["PageIndex"].ToInt(); List <Expression> expression = new List <Expression>(); List <YK.Models.Examination.ExamPrinciple> list = BasicService.ExamPrincipleService.Search(pageSize, 1, expression, "CreatedOn asc", ref recordCount); RepList.DataSource = list; RepList.DataBind(); AspNetPager1.RecordCount = recordCount; }
//加载所有信息 public void LoadDataBind() { int recordCount = 0; string key = ViewState["search"].ToString(); int pageIndex = Convert.ToInt32(ViewState["PageIndex"]); int pageSize = AspNetPager1.PageSize; List <Expression> express = new List <Expression>(); express.Add(new Expression("RoleName", "like", TbKey.Text)); RepList.DataSource = AdminService.RoleService.Search(pageSize, pageIndex, express, "AddDate desc", ref recordCount); RepList.DataBind(); AspNetPager1.RecordCount = recordCount; }
//加载所有信息 public void LoadDataBind() { int pageSize = AspNetPager1.PageSize; int recordCount = 0; int pageIndex = ViewState["PageIndex"].ToInt(); List <Expression> expression = new List <Expression>(); expression.Add(new Expression("ProductID", "=", Request["pid"])); RepList.DataSource = ProductService.CommentsService.Search(pageSize, pageIndex, expression, "AddDate desc", ref recordCount); RepList.DataBind(); AspNetPager1.RecordCount = recordCount; }
//加载所有信息 public void LoadDataBind() { int recordCount = 0; string key = ViewState["search"].ToString(); int pageIndex = ViewState["PageIndex"].ToInt(); int pageSize = AspNetPager1.PageSize; List <Expression> express = new List <Expression>(); express.Add(new Expression("Name", "like", TbKey.Text)); RepList.DataSource = SystemService.AdverCategoryService.Search (pageSize, pageIndex, express, "OrderBy asc,AddDate desc", ref recordCount); RepList.DataBind(); AspNetPager1.RecordCount = recordCount; }
//加载所有信息 public void LoadDataBind() { int id = CommonClass.ReturnRequestInt("id", 0); orders = OrderService.OrdersService.Get(id); List <Expression> express = new List <Expression>(); express.Add(new Expression("OrderNumber", "=", orders.OrderNumber)); distribution = OrderService.DistributionService.Get(express); RepList.DataSource = OrderService.OrderDetailsService.Search(express); RepList.DataBind(); }
//加载所有信息 public void LoadDataBind() { string OrderNumber = CommonClass.ReturnRequestStr("OrderNumber"); List <Expression> express = new List <Expression>(); express.Add(new Expression("OrderNumber", "=", OrderNumber)); orders = OrderService.ReturnGoodOrderService.Get(express); RepList.DataSource = OrderService.ReturnGoodOrderDetailsService.Search(express); RepList.DataBind(); }
protected void Page_Load(object sender, EventArgs e) { DecodeURL(); if (CreateTable().Rows.Count > 0) { gridView.DataSource = CreateTable(); gridView.DataBind(); } else { RepList.DataSource = GetHander(); RepList.DataBind(); divRep.Visible = true; } }
//加载所有信息 public void LoadDataBind() { int recordCount = 0; string adverId = Request["adverId"]; int pageIndex = ViewState["PageIndex"].ToInt(); int pageSize = AspNetPager1.PageSize; List <Expression> express = new List <Expression>(); express.Add(new Expression("AdverId", "=", adverId)); RepList.DataSource = SystemService.AdverPicService.Search (pageSize, pageIndex, express, "OrderBy asc,AddDate desc", ref recordCount); RepList.DataBind(); AspNetPager1.RecordCount = recordCount; }
protected void LoadDataBind() { cid = CommonClass.ReturnRequestInt("cid"); num = CommonClass.ReturnRequestInt("num"); if (num <= 3) { num++; } List <Expression> express = new List <Expression>() { new Expression("ParentID", "=", cid.ToStr()) }; RepList.DataSource = ProductService.CategoryService.Search(express).OrderBy(c => c.OrderBy); RepList.DataBind(); }
//加载所有信息 public void LoadDataBind() { int pageSize = AspNetPager1.PageSize; int recordCount = 0; int pageIndex = ViewState["PageIndex"].ToInt(); List <Expression> expression = new List <Expression>(); expression.Add(new Expression("Name", "like", TbKey.Text.Trim())); List <TB_Project_Projects> list = ProjectService.ProjectsService.Search(pageSize, pageIndex, expression, " Id desc,AddDate desc", ref recordCount); RepList.DataSource = list; RepList.DataBind(); AspNetPager1.RecordCount = recordCount; }
public void LoadDataBind() { List <Expression> expression = new List <Expression>(); expression.Add(new Expression("MemberID", "=", MemberID.ToStr())); RepList.DataSource = MemberService.BuyerInfoService.Search(expression); RepList.DataBind(); int id = Request.QueryString["id"].ToInt(); if (id > 0) { TB_Member_BuyerInfo entity = MemberService.BuyerInfoService.Get(id); if (entity.ID > 0) { TbRealName.Text = entity.BuyerName; TbEmail.Text = entity.Email; TbPosted.Text = entity.PostalCode; TbMobile.Text = entity.Mobile; string[] zone = entity.Zone.Split('|'); Address.Value = zone[0]; TbAddress.Text = entity.Address; if (entity.Phone != "--") { string[] phone = entity.Phone.Split('-'); switch (phone.Length) { case 1: TbPhone.Text = phone[0]; break; case 2: TbPhone.Text = phone[0]; TbPhone2.Text = phone[1]; break; case 3: TbPhone.Text = phone[0]; TbPhone2.Text = phone[1]; TbPhone3.Text = phone[2]; break; } } ViewState["id"] = entity.ID; } } }
//加载所有信息 public void LoadDataBind() { int recordCount = 0; string key = ViewState["search"].ToString(); int pageIndex = Convert.ToInt32(ViewState["PageIndex"]); int pageSize = AspNetPager1.PageSize; int activityID = CommonClass.ReturnRequestInt("activityID", 0); List <Expression> express = new List <Expression>(); express.Add(new Expression("ActivityID", "=", activityID.ToStr())); RepList.DataSource = ActivityService.CouponNosService.Search (pageSize, pageIndex, express, "SendDate desc", ref recordCount); RepList.DataBind(); AspNetPager1.RecordCount = recordCount; }