private void BindList() { #region __________Where语句__________ strWhere = " 1=1"; if (SearchName != "") { strWhere += " and (name like '%" + SearchName + "%')"; } if (brand != "") { strWhere += " and (brand='" + brand + "')"; } if (protype != "") { strWhere += " and (protype='" + protype + "')"; } #endregion rpt_List.PageLink = "appplatform.aspx?Search=Yes&SearchName=" + Utils.UrlEncode(SearchName) + "&brand=" + Utils.UrlEncode(brand) + "&protype=" + Utils.UrlEncode(protype); rpt_List.PageSize = 20; rpt_List.CurrentPage = LYRequest.GetInt("page", 1); DataSet ds = MW.BLL.mw_getlistbypage.GetDataSet_NoCache("mw_appplatform", "*", strWhere, "", "ID DESC", "ID", rpt_List.CurrentPage, rpt_List.PageSize, 1); rpt_List.RecordCount = Convert.ToInt32(ds.Tables[0].Rows[0][0]); JBind.BindList(rpt_List, ds.Tables[1]); }
private void BindList() { #region __________Where语句__________ string strWhere = " 1=1"; //if (SearchName != "") //{ // strWhere += " and (PlanName like '%" + SearchName + "%')"; //} //if (starttime != "") //{ // strWhere += " and (BeginTime>='" + starttime + "')"; //} //if (endtime != "") //{ // strWhere += " and (BeginTime<='" + endtime + "')"; //} //if (userid > 0) //{ // strWhere += " and dbo.inArray(" + userid + ",BelongTo)>0"; //} #endregion rpt_List.PageLink = "trainingplanslist.aspx?Search=Yes"; rpt_List.PageSize = 15; rpt_List.CurrentPage = LYRequest.GetInt("page", 1); DataSet ds = MW.BLL.mw_getlistbypage.GetDataSet_NoCache("TECH_TRAIN_COURSE", "*", strWhere, "", "ID DESC", "ID", rpt_List.CurrentPage, rpt_List.PageSize, 1); rpt_List.RecordCount = Convert.ToInt32(ds.Tables[0].Rows[0][0]); JBind.BindList(rpt_List, ds.Tables[1]); }
private void BindList() { strWhere = "1=1"; #region __________Where语句__________ if (typeid != "") { strWhere = " TypeId ='" + typeid + "'"; } else { strWhere = " TypeId ='" + PageID + "'"; } if (SearchName != "") { //strWhere += " and (title like '%" + SearchName + "%')"; } #endregion rpt_List.PageLink = "gglist.aspx?Search=Yes&pageid=" + PageID + "&TypeId=" + typeid + "&SearchName=" + Utils.UrlEncode(SearchName); rpt_List.PageSize = 15; rpt_List.CurrentPage = LYRequest.GetInt("page", 1); DataSet ds = MW.BLL.mw_getlistbypage.GetDataSet_NoCache("mw_article", "*", strWhere, "", "ID DESC", "ID", rpt_List.CurrentPage, rpt_List.PageSize, 1); rpt_List.RecordCount = Convert.ToInt32(ds.Tables[0].Rows[0][0]); JBind.BindList(rpt_List, ds.Tables[1]); }
private void BindList() { strWhere = " 1=1 "; #region __________Where语句__________ if (typeid > 0) { strWhere += " and N_Type=" + typeid; } if (SearchName != "") { strWhere += " and (C_Title like '%" + SearchName + "%')"; } if (teachername != "") { strWhere += " and (C_Tearcher like '%" + teachername + "%')"; } if (starttime != "") { strWhere += " and (DT_StartDate>='" + starttime + "')"; } if (endtime != "") { strWhere += " and (DT_StartDate<='" + endtime + "')"; } #endregion rpt_List.PageLink = "statvote.aspx?Search=Yes&pagesize=" + pagesize + "&TypeId=" + typeid + "&starttime=" + starttime + "&endtime=" + endtime + "&SearchName=" + Utils.UrlEncode(SearchName) + "&teachername=" + Utils.UrlEncode(teachername); rpt_List.PageSize = pagesize; rpt_List.CurrentPage = LYRequest.GetInt("page", 1); DataSet ds = mw_getlistbypage.GetDataSet_NoCache("mw_votecourse", "*", strWhere, "", "Id DESC", "Id", rpt_List.CurrentPage, rpt_List.PageSize, 1); rpt_List.RecordCount = Convert.ToInt32(ds.Tables[0].Rows[0][0]); JBind.BindList(rpt_List, ds.Tables[1]); }
private string callback = ""; //回调 protected void Page_Load(object sender, EventArgs e) { filesize = LYRequest.GetInt("filesize", 1024); filetype = LYRequest.GetString("filetype", "image"); tofilepath = LYRequest.GetString("filepath", "/UpLoads/"); recievetxtname = LYRequest.GetString("recievetxtname", ""); ismultifile = LYRequest.GetInt("ismultifile", 0); callback = LYRequest.GetString("callback", ""); int type = LYRequest.GetInt("type", 0); if (!IsPostBack) { if (!chkLogin(type)) { return; } if (recievetxtname == "") { Lbl_Tip.Text = "缺少参数recievetxtname"; File_Upload.Visible = false; Btn_Submit.Visible = false; } } }
private void BindData() { #region __________Where语句__________ string strWhere = " 1=1"; //strWhere += " and EndTime>='" + DateTime.Now + "' and BeginTime<='" + DateTime.Now + "'"; if (typeid != "") { strWhere += " and PRO_TYPE='" + typeid + "'"; } strWhere += " and ApplierID='" + (CurrentUser != null?CurrentUser.ID:"") + "' "; #endregion rpt_List.ShowPagenation = false; rpt_List.PageLink = ""; rpt_List.PageSize = 100; rpt_List.CurrentPage = LYRequest.GetInt("page", 1); /*SELECT p.`NAME`,p.DAYS,p.YEAR_VALUE,p.PLAN_WEEK,p.USER_TYPE,p.USER_ID,a.ApplyTime * FROM mw_applyplans AS a INNER JOIN mw_trainingplans AS p ON a.ApplyPlanID = p.ID * WHERE p.USER_TYPE = 'teacher'*/ string table = "mw_applyplans AS a INNER JOIN mw_TrainingPlans AS p ON a.ApplyPlanID = p.ID"; DataSet ds = MW.BLL.mw_getlistbypage.GetDataSet_NoCache(table, "p.ID,p.`NAME`,p.DAYS,p.YEAR_VALUE,p.PLAN_WEEK,p.USER_TYPE,p.UNAME,a.ApplyTime", strWhere, "", "ApplyTime DESC", "ID", rpt_List.CurrentPage, rpt_List.PageSize, 0); if (ds != null && ds.Tables[0] != null && ds.Tables[0].Rows.Count > 0) { DataView dv = ds.Tables[0].DefaultView; dv.Sort = "ApplyTime desc"; DataTable tmptb = dv.ToTable(true, new string[] { "ID", "NAME", "DAYS", "YEAR_VALUE", "PLAN_WEEK" }); DataTable DT = new DataTable(); DT.Columns.Add("ID"); DT.Columns.Add("PlanName"); DT.Columns.Add("Teacher"); DT.Columns.Add("BeginTime"); DT.Columns.Add("days"); foreach (DataRow row in tmptb.Rows) { var dr = DT.NewRow(); dr["ID"] = row["ID"]; dr["PlanName"] = BaseUi.GetLang(row["NAME"].ToString()); dr["days"] = row["DAYS"]; dr["BeginTime"] = row["YEAR_VALUE"] + " 第" + row["PLAN_WEEK"] + "周"; dv.RowFilter = "(ID='" + row["ID"] + "' and USER_TYPE='teacher')"; var ts = dv.ToTable(); { var sb = new System.Text.StringBuilder(); foreach (DataRow item in ts.Rows) //因为所查询的名字可能有多行 { sb.Append(item["UNAME"] + " ,"); } dr["Teacher"] = sb.ToString().Trim(','); } DT.Rows.Add(dr); } JBind.BindList(rpt_List, DT); } //rpt_List.RecordCount = Convert.ToInt32(ds.Tables[0].Rows[0][0]); }
protected void Page_Load(object sender, EventArgs e) { sysid = LYRequest.GetInt("sysid", 0); id = LYRequest.GetInt("id", 0); if (!IsPostBack) { InitData(); } }
protected void Page_Load(object sender, EventArgs e) { Id = MW.Common.LYRequest.GetInt("id", 0); parentid = LYRequest.GetInt("parentid", 0); if (!IsPostBack) { InitData(); } }
protected void Page_Load(object sender, EventArgs e) { SearchName = MW.Common.LYRequest.GetString("SearchName", true); sysid = LYRequest.GetInt("sysid", 0); if (!IsPostBack) { InitData(); BindList(); } }
protected void Page_Load(object sender, EventArgs e) { sysid = LYRequest.GetInt("VoteId", 0); voteid = LYRequest.GetInt("id", 0); if (!IsPostBack) { litNum.Text = bll.GetSum(voteid, sysid).ToString(); rpt_List.ShowPagenation = false; JBind.BindList(rpt_List, CreateTB(voteid, sysid)); } }
protected void Page_Load(object sender, EventArgs e) { sysid = LYRequest.GetInt("sysid", 0); id = LYRequest.GetInt("id", 0); if (!IsPostBack) { string path = Utils.GetMapPath(MW.BasePage.GetWebPath + "/mw/onlinesurvey/" + id + ".html"); this.Label3.Text = "引用相对路径: /uploads/文件名 ,若图像|视频等不显示,请参照修改路径"; InitData(path); hidid.Value = id.ToString(); } }
protected void Page_Load(object sender, EventArgs e) { sysid = LYRequest.GetInt("VoteId", 0); voteid = LYRequest.GetInt("id", 0); if (!IsPostBack) { string code = ""; string time = ""; string sta = tableOne(voteid, sysid, ref code, ref time); ExportExcelFile(sta, "vwac_survey_" + voteid + "_" + time + "_" + code); } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack && base.Request["VoteId"] != null && base.Request["id"] != null) { int sysid = LYRequest.GetInt("voteid", 0); int voteid = LYRequest.GetInt("id", 0); rpt_List.ShowPagenation = false; JBind.BindList(rpt_List, CreateTB(voteid, sysid)); litNum.Text = bll.GetSum(voteid, sysid).ToString(); } }
protected void Page_Load(object sender, EventArgs e) { SearchName = MW.Common.LYRequest.GetString("SearchName", true); teachername = MW.Common.LYRequest.GetString("teachername", true); starttime = MW.Common.LYRequest.GetString("starttime"); endtime = MW.Common.LYRequest.GetString("endtime"); typeid = LYRequest.GetInt("typeid", 0); pagesize = LYRequest.GetInt("pagesize", 20); if (!IsPostBack) { InitData(); BindList(); } }
protected void Page_Load(object sender, EventArgs e) { int page = LYRequest.GetInt("page", 1); string typeid = LYRequest.GetString("typeid"); if (typeid == "") { typeid = "XW"; } if (base.Request["cmd"] != null && base.Request["cmd"] == "list") { BindData(page, typeid); } }
private void BindData() { #region __________Where语句__________ string strWhere = " 1=1"; //strWhere += " and EndTime>='" + DateTime.Now + "' and BeginTime<='" + DateTime.Now + "'"; if (typeid != "") { strWhere += " and PRO_TYPE='" + typeid + "'"; } #endregion rpt_List.ShowPagenation = false; rpt_List.PageLink = ""; rpt_List.PageSize = 100; rpt_List.CurrentPage = LYRequest.GetInt("page", 1); DataSet ds = MW.BLL.mw_getlistbypage.GetDataSet_NoCache("mw_TrainingPlans", "ID,NAME,DAYS,YEAR_VALUE,PLAN_WEEK,USER_TYPE,UNAME", strWhere, "", "YEAR_VALUE DESC,PLAN_WEEK DESC", "ID", rpt_List.CurrentPage, rpt_List.PageSize, 0); if (ds != null && ds.Tables[0] != null && ds.Tables[0].Rows.Count > 0) { DataView dv = ds.Tables[0].DefaultView; DataTable tmptb = dv.ToTable(true, new string[] { "ID" }); DataTable DT = new DataTable(); DT.Columns.Add("ID"); DT.Columns.Add("PlanName"); DT.Columns.Add("Teacher"); DT.Columns.Add("BeginTime"); DT.Columns.Add("days"); foreach (DataRow rowt in tmptb.Rows) { var dr = DT.NewRow(); DataRow row = ds.Tables[0].Select("ID='" + rowt["ID"] + "'")[0]; dr["ID"] = row["ID"]; dr["PlanName"] = BaseUi.GetLang(row["NAME"].ToString()); dr["days"] = row["DAYS"]; dr["BeginTime"] = row["YEAR_VALUE"] + " 第" + row["PLAN_WEEK"] + "周"; dv.RowFilter = "(ID='" + row["ID"] + "' and USER_TYPE='teacher')"; var ts = dv.ToTable(); { var sb = new System.Text.StringBuilder(); foreach (DataRow item in ts.Rows) //因为所查询的名字可能有多行 { sb.Append(item["UNAME"] + " "); } dr["Teacher"] = sb.ToString(); } DT.Rows.Add(dr); } JBind.BindList(rpt_List, DT); } }
protected void Page_Load(object sender, EventArgs e) { Id = MW.Common.LYRequest.GetInt("id", 0); sysid = LYRequest.GetInt("sysid", 0); parentid = LYRequest.GetInt("parentid", 0); //#warning BasePage.IsPermissions(1) // if (!BasePage.IsPermissions(42)) // { // MessageBox.JSLoad(this, "alert('没有权限!!');reloadDlg();"); // return; // } if (!IsPostBack) { InitData(); } }
protected void Page_Load(object sender, EventArgs e) { Id = MW.Common.LYRequest.GetString("id"); type = LYRequest.GetInt("type", 0); if (base.Request["cmd"] != null && base.Request["cmd"] == "bm") { Baoming(); } else { if (!IsPostBack) { LoadInit(); } } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack && base.Request["VoteId"] != null && base.Request["id"] != null) { int sysid = LYRequest.GetInt("voteid", 0); int voteid = LYRequest.GetInt("id", 0); if (!bllcourse.GetStartDate(voteid)) { Response.Redirect("statreporttmp.aspx?voteid=" + sysid + "&id=" + voteid); Response.End(); } rpt_List.ShowPagenation = false; JBind.BindList(rpt_List, CreateTB(voteid, sysid)); litNum.Text = bllcourse.GetStartDate(voteid) ? bll.GetSum(voteid, sysid).ToString() : bll.GetSum(voteid, sysid).ToString(); } }
private void BindList() { StringBuilder builder = new StringBuilder(" 1=1 "); if (!string.IsNullOrEmpty(this.UserName)) { builder.Append(string.Format(" and C_Title like '%{0}%'", this.UserName)); } rptCustomer.PageLink = string.Format(MW.BasePage.GetAdminPath + "vwsurvey/_VoteDialog.aspx?hidCtl={0}&txtCtl={1}&UserName={2}&parentDlg={3}", base.Request.QueryString["hidCtl"], base.Request.QueryString["txtCtl"], UserName, parentDlg); rptCustomer.PageSize = 10; rptCustomer.CurrentPage = LYRequest.GetInt("page", 1); DataSet ds = MW.BLL.mw_getlistbypage.GetDataSet_NoCache("mw_votesystem", "N_SysId,C_Title", builder.ToString(), "", "N_SysId DESC", "N_SysId", rptCustomer.CurrentPage, rptCustomer.PageSize, 1); rptCustomer.RecordCount = Convert.ToInt32(ds.Tables[0].Rows[0][0]); JBind.BindList(rptCustomer, ds.Tables[1]); }
protected void Page_Load(object sender, EventArgs e) { sysid = LYRequest.GetInt("VoteId", 0); voteid = LYRequest.GetInt("id", 0); if (!new B_Votecourse().GetStartDate(voteid)) { Response.Redirect("statresulttmp.aspx?VoteId=" + sysid + "&id=" + voteid); Response.End(); } if (!IsPostBack) { litNum.Text = bll.GetSum(voteid, sysid).ToString(); rpt_List.ShowPagenation = false; JBind.BindList(rpt_List, CreateTB(voteid, sysid)); } }
protected void Page_Load(object sender, EventArgs e) { sysid = LYRequest.GetInt("VoteId", 0); voteid = LYRequest.GetInt("id", 0); if (!new B_Votecourse().GetStartDate(voteid)) { Response.Redirect("voteexporttmp.aspx?VoteId=" + sysid + "&id=" + voteid); Response.End(); } if (!IsPostBack) { string code = ""; string time = ""; string sta = tableOne(voteid, sysid, ref code, ref time); ExportExcelFile(sta, "vwac_survey_" + voteid + "_" + time + "_" + code); } }
private void BindList() { #region __________Where语句__________ strWhere = " 1=1"; //if (SearchName != "") //{ // strWhere += " and (PlanName like '%" + SearchName + "%')"; //} #endregion rpt_List.PageLink = string.Format("coursedetail.aspx?hidCtl={0}&txtCtl={1}&UserName={2}", base.Request.QueryString["hidCtl"], base.Request.QueryString["txtCtl"], C_course); rpt_List.PageSize = 7; rpt_List.CurrentPage = LYRequest.GetInt("page", 1); DataSet ds = MW.BLL.mw_getlistbypage.GetDataSet_NoCache("TECH_TRAIN_COURSE", "ID,NAME", strWhere, "", "ID DESC", "ID", rpt_List.CurrentPage, rpt_List.PageSize, 1); rpt_List.RecordCount = Convert.ToInt32(ds.Tables[0].Rows[0][0]); JBind.BindList(rpt_List, ds.Tables[1]); }
protected void Page_Load(object sender, EventArgs e) { Id = LYRequest.GetInt("id", 0); subid = LYRequest.GetInt("subid", 0); ntype = LYRequest.GetInt("type", 0); sysid = MW.Common.LYRequest.GetInt("sysid", 0); //#warning BasePage.IsPermissions(1) // if (!BasePage.IsPermissions(42)) // { // MessageBox.JSLoad(this, "alert('没有权限!!');reloadDlg();"); // return; // } if (!IsPostBack) { EnableDropList(subid); BindRule(); InitData(); } }
private void BindList() { #region __________Where语句__________ strWhere = " N_SysId=" + sysid; if (SearchName != "") { strWhere += " and (C_SubTitle like '%" + SearchName + "%')"; } #endregion rpt_List.PageLink = "voteunit.aspx?Search=Yes&sysid=" + sysid + "&SearchName=" + Utils.UrlEncode(SearchName); rpt_List.PageSize = 15; rpt_List.CurrentPage = LYRequest.GetInt("page", 1); DataSet ds = MW.BLL.mw_getlistbypage.GetDataSet_NoCache("mw_voteunit", "*", strWhere, "", "N_SubId DESC", "N_SubId", rpt_List.CurrentPage, rpt_List.PageSize, 1); rpt_List.RecordCount = Convert.ToInt32(ds.Tables[0].Rows[0][0]); JBind.BindList(rpt_List, ds.Tables[1]); }
private void BindList() { #region __________Where语句__________ strWhere = " 1=1"; if (SearchName != "") { strWhere += " and (C_Name like '%" + SearchName + "%')"; } #endregion rpt_List.PageLink = "testdriverlist.aspx?Search=Yes%SearchName=" + Utils.UrlEncode(SearchName); rpt_List.PageSize = 15; rpt_List.CurrentPage = LYRequest.GetInt("page", 1); DataSet ds = MW.BLL.mw_getlistbypage.GetDataSet_NoCache("mw_testdriver", "*", strWhere, "", "ID DESC", "ID", rpt_List.CurrentPage, rpt_List.PageSize, 1); rpt_List.RecordCount = Convert.ToInt32(ds.Tables[0].Rows[0][0]); JBind.BindList(rpt_List, ds.Tables[1]); }
private void BindList() { #region __________Where语句__________ strWhere = "1=1"; if (SearchName != "") { strWhere += " and (Chexi like '%" + SearchName + "%')"; } if (Student != "") { strWhere += " and (Student like '%" + Student + "%')"; } if (Changdi != "") { strWhere += " and (Changdi like '%" + Changdi + "%')"; } if (CreateTime != "") { strWhere += " and (CreateTime >= '" + CreateTime + "')"; } if (EndTime != "") { strWhere += " and (CreateTime <= '" + EndTime + "')"; } #endregion //StringBuilder builder = new StringBuilder(MW.BasePage.GetAdminPath + "testdriverpglist.aspx?Search=Yes"); //builder.Append("&SearchName=" + Utils.UrlEncode(SearchName)).ToString(); //builder.Append("&Student=" + Utils.UrlEncode(Student)).ToString(); //builder.Append("&Changdi=" + Utils.UrlEncode(Changdi)).ToString(); //builder.Append("&CreateTime=" + Utils.UrlEncode(CreateTime)).ToString(); rpt_List.PageLink = "testdriverpglist.aspx?Search=Yes&SearchName=" + Utils.UrlEncode(SearchName); //rpt_List.PageLink = builder.Append("&EndTime=" + Utils.UrlEncode(EndTime)).ToString(); rpt_List.PageSize = 10; rpt_List.CurrentPage = LYRequest.GetInt("page", 1); DataSet ds = MW.BLL.mw_getlistbypage.GetDataSet_NoCache("mw_testdriverpg", "*", strWhere, "", "ID DESC", "ID", rpt_List.CurrentPage, rpt_List.PageSize, 1); rpt_List.RecordCount = Convert.ToInt32(ds.Tables[0].Rows[0][0]); JBind.BindList(rpt_List, ds.Tables[1]); }
private void BindList() { StringBuilder builder = new StringBuilder(" ID not in(SELECT tc.ID FROM TECH_TRAIN_COURSE AS tp INNER JOIN mw_tempcode AS tc ON tp.tmpcode = tc.CardNumber WHERE tp.tmpcode IS NOT NULL) "); if (!string.IsNullOrEmpty(this.UserName)) { builder.Append(" and (CardNumber like '%" + UserName + "%')"); } if (GroupId > 0) { builder.Append(string.Format(" and type={0}", this.GroupId)); } rptCustomer.PageLink = string.Format("tmpcodedialog.aspx?hidCtl={0}&txtCtl={1}&UserName={2}&groupid={3}&parentDlg={4}", base.Request.QueryString["hidCtl"], base.Request.QueryString["txtCtl"], UserName, GroupId, parentDlg); rptCustomer.PageSize = 7; rptCustomer.CurrentPage = LYRequest.GetInt("page", 1); DataSet ds = MW.BLL.mw_getlistbypage.GetDataSet_NoCache("mw_tempcode", "ID,CardNumber", builder.ToString(), "", "ID DESC", "ID", rptCustomer.CurrentPage, rptCustomer.PageSize, 1); rptCustomer.RecordCount = Convert.ToInt32(ds.Tables[0].Rows[0][0]); JBind.BindList(rptCustomer, ds.Tables[1]); }
private void BindList() { #region __________Where语句__________ strWhere = "CId=" + CId + " and chapterid=" + Id; //strWhere = "1=1"; //if (SearchName != "") //{ // strWhere += " and (C_Name like '%" + SearchName + "%')"; //} #endregion rpt_List.PageLink = "sktitemlist.aspx?Search=Yes&type=" + Type + "&CId=" + CId + "&Id=" + Id + "&SearchName=" + Utils.UrlEncode(SearchName); rpt_List.PageSize = 15; rpt_List.CurrentPage = LYRequest.GetInt("page", 1); DataSet ds = MW.BLL.mw_getlistbypage.GetDataSet_NoCache("mw_sktitem", "*", strWhere, "", "ID DESC", "ID", rpt_List.CurrentPage, rpt_List.PageSize, 1); rpt_List.RecordCount = Convert.ToInt32(ds.Tables[0].Rows[0][0]); JBind.BindList(rpt_List, ds.Tables[1]); }
protected void Page_Load(object sender, EventArgs e) { SearchName = MW.Common.LYRequest.GetString("SearchName", true); Operator = LYRequest.GetString("Operator", ""); Begin_Time = LYRequest.GetString("Begin_Time", ""); End_Time = LYRequest.GetString("End_Time", ""); KeyWord = LYRequest.GetString("KeyWord", ""); type = LYRequest.GetString("type", ""); id = LYRequest.GetInt("id", 0); re = LYRequest.GetInt("re", 0); rurl = LYRequest.GetString("rurl", Server.UrlDecode(Request.Url.ToString())); if (type == "reset") { ResetSMS(); } if (!IsPostBack) { InitData(); BindList(); } }