private void Show() { string sql = ""; QuerySession.QueryGuestTrack QGuestTrack = new VAN_OA.QuerySession.QueryGuestTrack(); if (txtGuestName.Text.Trim() != "") { sql += string.Format(" and GuestName like '%{0}%'", txtGuestName.Text.Trim()); QGuestTrack.GuestName = txtGuestName.Text.Trim(); } // sql += string.Format(@" and (TB_GuestTrack.id in (select allE_id from tb_EForm where proId =17 and state='通过') //or TB_GuestTrack.id not in (select allE_id from tb_EForm where proId =17))"); PagerDomain page = new PagerDomain(); page.CurrentPageIndex = AspNetPager1.CurrentPageIndex; List <TB_GuestTrack> GuestTracks = this.GuestTrackSer.GetListArrayToPage(sql, page).OrderByDescending(t => t.Time).ToList(); AspNetPager1.RecordCount = GuestTracks.Count; this.gvList.PageIndex = AspNetPager1.CurrentPageIndex - 1; Session[Query] = QGuestTrack; this.gvList.DataSource = GuestTracks; this.gvList.DataBind(); }
private void Show() { string sql = " 1=1 "; QuerySession.QueryGuestTrack QSupplierTrack = new VAN_OA.QuerySession.QueryGuestTrack(); if (txtFrom.Text != "") { if (CommHelp.VerifesToDateTime(txtFrom.Text) == false) { base.ClientScript.RegisterStartupScript(base.GetType(), null, "<script>alert('登记日期 格式错误!');</script>"); return; } sql += string.Format(" and Time>='{0} 00:00:00'", txtFrom.Text); QSupplierTrack.FromTime = txtFrom.Text; } if (txtTo.Text != "") { if (CommHelp.VerifesToDateTime(txtTo.Text) == false) { base.ClientScript.RegisterStartupScript(base.GetType(), null, "<script>alert('登记日期 格式错误!');</script>"); return; } sql += string.Format(" and Time<='{0} 23:59:59'", txtTo.Text); QSupplierTrack.ToTime = txtTo.Text; } if (txtSupplierName.Text.Trim() != "") { if (cbPiPei.Checked == false) { sql += string.Format(" and SupplierName like '%{0}%'", txtSupplierName.Text.Trim()); } else { sql += string.Format(" and SupplierName='{0}'", txtSupplierName.Text.Trim()); } QSupplierTrack.GuestName = txtSupplierName.Text; } if (txtProNo.Text.Trim() != "") { if (CheckProNo(txtProNo.Text) == false) { return; } sql += string.Format(" and ProNo like '%{0}%'", txtProNo.Text.Trim()); } if (txtSupplieSimpeName.Text.Trim() != "") { sql += string.Format(" and SupplieSimpeName like '%{0}%'", txtSupplieSimpeName.Text.Trim()); } if (txtPhone.Text != "") { sql += string.Format(" and Phone like '%{0}%'", txtPhone.Text); } if (txtLikeMan.Text != "") { sql += string.Format(" and LikeMan like '%{0}%'", txtLikeMan.Text); } if (ddlShow.Text != "-1") { sql += string.Format(" and IsUse={0} ", ddlShow.Text); } if (ddlSpecial.Text != "-1") { sql += string.Format(" and IsSpecial={0} ", ddlSpecial.Text); } if (ddlPeculiarity.Text != "全部") { sql += string.Format(" and Peculiarity='{0}'", ddlPeculiarity.Text); } sql += string.Format(@" and Status='通过' "); List <TB_SupplierInfo> SupplierTracks = this.supplierSer.GetListArray(sql); AspNetPager1.RecordCount = SupplierTracks.Count; this.gvList.PageIndex = AspNetPager1.CurrentPageIndex - 1; Session[Query] = QSupplierTrack; this.gvList.DataSource = SupplierTracks; this.gvList.DataBind(); }
private void Show() { string sql = " 1=1 "; QuerySession.QueryGuestTrack QGuestTrack = new VAN_OA.QuerySession.QueryGuestTrack(); if (txtFrom.Text != "") { if (CommHelp.VerifesToDateTime(txtFrom.Text) == false) { base.ClientScript.RegisterStartupScript(base.GetType(), null, "<script>alert('登记日期 格式错误!');</script>"); return; } sql += string.Format(" and Time>='{0} 00:00:00'", txtFrom.Text); QGuestTrack.FromTime = txtFrom.Text; } if (txtTo.Text != "") { if (CommHelp.VerifesToDateTime(txtTo.Text) == false) { base.ClientScript.RegisterStartupScript(base.GetType(), null, "<script>alert('登记日期 格式错误!');</script>"); return; } sql += string.Format(" and Time<='{0} 23:59:59'", txtTo.Text); QGuestTrack.ToTime = txtTo.Text; } if (txtGuestName.Text.Trim() != "") { sql += string.Format(" and GuestName like '%{0}%'", txtGuestName.Text.Trim()); QGuestTrack.GuestName = txtGuestName.Text.Trim(); } if (ddlAE.Text != "" && ddlAE.Text != "0") { sql += string.Format(" and AE={0}", ddlAE.SelectedItem.Value); //QGuestTrack.Apper = txtLoginName.Text; } if (txtProNo.Text.Trim() != "") { if (CheckProNo(txtProNo.Text) == false) { return; } sql += string.Format(" and ProNo like '%{0}%'", txtProNo.Text.Trim()); } sql += string.Format(" and INSIDE={0}", Session["currentUserId"].ToString()); sql += string.Format(@" and (TB_GuestTrack.id in (select allE_id from tb_EForm where proId in ( select pro_Id from A_ProInfo where pro_Type='客户联系跟踪表') and state='通过') or TB_GuestTrack.id not in (select allE_id from tb_EForm where proId in ( select pro_Id from A_ProInfo where pro_Type='客户联系跟踪表') ))"); List <TB_GuestTrack> GuestTracks = this.GuestTrackSer.GetListArray(sql); AspNetPager1.RecordCount = GuestTracks.Count; this.gvList.PageIndex = AspNetPager1.CurrentPageIndex - 1; Session[Query] = QGuestTrack; this.gvList.DataSource = GuestTracks; this.gvList.DataBind(); }
private void Show() { GuestTypeBaseInfoService dal = new GuestTypeBaseInfoService(); GetListArray = dal.GetListArray(""); allGuestTypes = GetListArray.Select(t => t.GuestType).ToList(); GuestProBaseInfoService guestProDal = new GuestProBaseInfoService(); GetGuestProListArray = guestProDal.GetListArray(""); allGuestPros = GetGuestProListArray.Select(t => t.GuestPro.ToString()).ToList(); string sql = " 1=1 "; QuerySession.QueryGuestTrack QGuestTrack = new VAN_OA.QuerySession.QueryGuestTrack(); if (txtFrom.Text != "") { if (CommHelp.VerifesToDateTime(txtFrom.Text) == false) { base.ClientScript.RegisterStartupScript(base.GetType(), null, "<script>alert('登记日期 格式错误!');</script>"); return; } sql += string.Format(" and Time>='{0} 00:00:00'", txtFrom.Text); QGuestTrack.FromTime = txtFrom.Text; } if (txtTo.Text != "") { if (CommHelp.VerifesToDateTime(txtTo.Text) == false) { base.ClientScript.RegisterStartupScript(base.GetType(), null, "<script>alert('登记日期 格式错误!');</script>"); return; } sql += string.Format(" and Time<='{0} 23:59:59'", txtTo.Text); QGuestTrack.ToTime = txtTo.Text; } if (txtGuestName.Text.Trim() != "") { sql += string.Format(" and GuestName like '%{0}%'", txtGuestName.Text.Trim()); QGuestTrack.GuestName = txtGuestName.Text.Trim(); } if (ddlAE.Text != "" && ddlAE.Text != "0") { sql += string.Format(" and AE={0}", ddlAE.SelectedItem.Value); //QGuestTrack.Apper = txtLoginName.Text; } if (ddlINSIDE.Text != "" && ddlINSIDE.Text != "0") { sql += string.Format(" and INSIDE={0}", ddlINSIDE.SelectedItem.Value); //QGuestTrack.Apper = txtLoginName.Text; } if (txtProNo.Text.Trim() != "") { if (CheckProNo(txtProNo.Text) == false) { return; } sql += string.Format(" and ProNo like '%{0}%'", txtProNo.Text.Trim()); } if (ddlJidu.Text != "") { sql += string.Format(" and QuartNo='{1}' and YearNo='{0}' ", ddlSelectYears.Text, ddlJidu.Text); } if (ddlSpecial.Text != "-1") { sql += string.Format(" and IsSpecial ={0}", ddlSpecial.Text); } if (ddlGuestTypeList.Text != "-1") { sql += string.Format(" and MyGuestType ='{0}'", ddlGuestTypeList.Text); } if (ddlGuestProList.Text != "-1") { sql += string.Format(" and MyGuestPro like '%{0}%'", ddlGuestProList.Text); } if (txtPhone.Text != "") { sql += string.Format(" and Phone like '%{0}%'", txtPhone.Text); } if (txtLikeMan.Text != "") { sql += string.Format(" and LikeMan like '%{0}%'", txtLikeMan.Text); } sql += string.Format(@" and (TB_GuestTrack.id in (select allE_id from tb_EForm where proId in ( select pro_Id from A_ProInfo where pro_Type='客户联系跟踪表') and state='通过') or TB_GuestTrack.id not in (select allE_id from tb_EForm where proId in ( select pro_Id from A_ProInfo where pro_Type='客户联系跟踪表') ))"); List <TB_GuestTrack> GuestTracks = this.GuestTrackSer.GetListArrayGuilei(sql, dllAddGuest.Text, ddlDiffMyGuestType.Text, dllDiffMyGuestPro.Text, ddlSelectYears.Text, ddlJidu.Text); AspNetPager1.RecordCount = GuestTracks.Count; this.gvList.PageIndex = AspNetPager1.CurrentPageIndex - 1; Session[Query] = QGuestTrack; this.gvList.DataSource = GuestTracks; this.gvList.DataBind(); }