//加载所有信息
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;
}
