/// <summary> /// 加载DataGrid /// <param name="page">查询页数</param> /// <param name="rows">每页记录数</param> /// </summary> public void LoadGrid(int page, int rows, string terminalId, string status, string supplierCode, string supplierBatch, string agentId, string siteId) { string strSQL = "select s.sitename,a.agentname,c.* from TBTerminal c left join tbsite s on c.siteid=s.siteid left join tbagent a on c.agentid=a.agentid where 1=1"; if (!string.IsNullOrEmpty(terminalId)) { strSQL += " and c.terminalId='" + terminalId + "'"; } if (!string.IsNullOrEmpty(status)) { strSQL += " and c.status='" + status + "'"; } if (!string.IsNullOrEmpty(supplierCode)) { strSQL += " and c.supplierCode='" + supplierCode + "'"; } if (!string.IsNullOrEmpty(supplierBatch)) { strSQL += " and c.supplierBatch='" + supplierBatch + "'"; } if (!string.IsNullOrEmpty(agentId)) { strSQL += " and c.agentId='" + agentId + "'"; } if (!string.IsNullOrEmpty(siteId)) { strSQL += " and c.siteId='" + siteId + "'"; } strSQL += " order by c.terminalId desc"; string str = commonDao.DataGrid(strSQL, null, page, rows); WebJson.Write(context, str); }
/// <summary> /// 加载DataGrid /// <param name="page">查询页数</param> /// <param name="rows">每页记录数</param> /// </summary> public void LoadGrid(int page, int rows, string agentId, string agentName, string payStatus, string startDate, string endDate) { string strSQL = @"select flowid, agentid, agentname, startdate, enddate, salefee, rebate, commissionfee, paystatus, modeid, settlementtime, settlementid, settlementname, cashierid, cashiername, case when payStatus='0' then '' else to_char(paytime,'yyyy-mm-dd hh24:mi:ss') end paytime from TTAGENTSETTLEMENT t where 1=1"; if (!string.IsNullOrEmpty(agentId)) { strSQL += " and agentId='" + agentId + "'"; } if (!string.IsNullOrEmpty(agentName)) { strSQL += " and agentName like '%" + agentName + "%'"; } if (!string.IsNullOrEmpty(payStatus)) { strSQL += " and payStatus='" + payStatus + "'"; } if (!string.IsNullOrEmpty(startDate)) { strSQL += " and settlementTime>=to_date('" + startDate + " 00:00:00','yyyy-MM-dd hh24:mi:ss')"; } if (!string.IsNullOrEmpty(endDate)) { strSQL += " and settlementTime<=to_date('" + endDate + " 23:59:59','yyyy-MM-dd hh24:mi:ss')"; } strSQL += " order by settlementTime desc"; string str = commonDao.DataGrid(strSQL, null, page, rows); WebJson.Write(context, str); }
/// <summary> /// 加载DataGrid /// <param name="page">查询页数</param> /// <param name="rows">每页记录数</param> /// </summary> public void LoadGrid(int page, int rows, string agentId, string siteId, string clientQuery, string clientQueryText, string status, string startDate, string endDate) { string strSQL = "select c.*,a.agentName,s.siteName from TBClient c,TBAgent a,TBSite s where c.agentId=a.agentId and c.siteId=s.siteId"; if (!string.IsNullOrEmpty(clientQueryText) && !string.IsNullOrEmpty(clientQuery)) { if (clientQuery == ((int)ClientQuery.CardId).ToString()) { strSQL += " and c.cardId='" + clientQueryText + "'"; } if (clientQuery == ((int)ClientQuery.ClientId).ToString()) { strSQL += " and c.clientId='" + clientQueryText + "'"; } if (clientQuery == ((int)ClientQuery.ClientName).ToString()) { strSQL += " and c.clientName='" + clientQueryText + "'"; } if (clientQuery == ((int)ClientQuery.ClinetPhone).ToString()) { strSQL += " and c.telephone='" + clientQueryText + "'"; } } if (!string.IsNullOrEmpty(agentId)) { strSQL += " and c.agentId='" + agentId + "'"; } if (!string.IsNullOrEmpty(siteId)) { strSQL += " and c.siteId='" + siteId + "'"; } if (!string.IsNullOrEmpty(status)) { strSQL += " and c.status='" + status + "'"; } if (!string.IsNullOrEmpty(startDate)) { strSQL += " and c.createTime>= To_date('" + startDate + " 00:00:00','yyyy-mm-dd hh24:mi:ss')"; } if (!string.IsNullOrEmpty(endDate)) { strSQL += " and c.createTime<= To_date('" + endDate + " 23:59:59','yyyy-mm-dd hh24:mi:ss')"; } strSQL += " order by c.agentId,c.siteId,c.clientId desc,c.createTime desc"; string str = commonDao.DataGrid(strSQL, null, page, rows); WebJson.Write(context, str); }
/// <summary> /// 加载DataGrid /// </summary> /// <param name="page">查询页数</param> /// <param name="rows">每页记录数</param> public void LoadGrid(int page, int rows, string period, string gameId, string startDate, string endDate) { string strSQL = @"select * from (select t.flowid,t.gameid,g.gamename,t.period,t.starttime,t.endtime,t.publishtime,t.numbers from TBPNUMNOTICE t left join TBGame g on t.gameid=g.gameid ) tt where 1=1 "; if (!string.IsNullOrEmpty(period)) { strSQL += " and tt.period='" + period + "'"; } if (!string.IsNullOrEmpty(gameId)) { strSQL += " and tt.gameId='" + gameId + "'"; } if (!string.IsNullOrEmpty(startDate)) { strSQL += " and tt.publishTime>= '" + startDate + " 00:00:00'"; } if (!string.IsNullOrEmpty(endDate)) { strSQL += " and tt.publishTime<= '" + endDate + " 23:59:59'"; } strSQL += " order by tt.period desc"; string str = commonDao.DataGrid(strSQL, null, page, rows); WebJson.Write(context, str); }
/// <summary> /// 加载DataGrid /// <param name="page">查询页数</param> /// <param name="rows">每页记录数</param> /// </summary> public void LoadGrid(int page, int rows, string uKeyId, string status, string siteName, string agentName, string agentId) { string strSQL = "select s.sitename,a.agentname,c.* from TBUKey c left join tbsite s on c.siteid=s.siteid left join tbagent a on c.agentid=a.agentid where 1=1"; if (!string.IsNullOrEmpty(uKeyId)) { strSQL += " and c.uKeyId='" + uKeyId + "'"; } if (!string.IsNullOrEmpty(status)) { strSQL += " and c.status='" + status + "'"; } if (!string.IsNullOrEmpty(agentId)) { strSQL += " and c.agentId ='" + agentId + "'"; } if (!string.IsNullOrEmpty(siteName)) { strSQL += " and s.siteName like '%" + siteName + "%'"; } if (!string.IsNullOrEmpty(agentName)) { strSQL += " and a.agentName like '%" + agentName + "%'"; } string str = commonDao.DataGrid(strSQL, null, page, rows); WebJson.Write(context, str); }
/// <summary> /// 加载DataGrid /// <param name="page">查询页数</param> /// <param name="rows">每页记录数</param> /// </summary> public void LoadGrid(int page, int rows, string agentId, string agentName, string startDate, string endDate) { string strSQL = "select a.*,p.modename from TTAgentTakeCash a,TBPayMode p where a.handlemode=p.modeid "; if (!string.IsNullOrEmpty(agentId)) { strSQL += " and a.agentId='" + agentId + "'"; } if (!string.IsNullOrEmpty(agentName)) { strSQL += " and a.agentName like '%" + agentName + "%'"; } if (!string.IsNullOrEmpty(startDate)) { strSQL += " and a.createTime >= To_date('" + startDate + " 00:00:00','yyyy-mm-dd hh24:mi:ss')"; } if (!string.IsNullOrEmpty(endDate)) { strSQL += " and a.createTime <= To_date('" + endDate + " 23:59:59','yyyy-mm-dd hh24:mi:ss')"; } strSQL += " order by agentId,createTime desc"; string str = commonDao.DataGrid(strSQL, null, page, rows); WebJson.Write(context, str); }
/// <summary> /// 加载DataGrid /// <param name="page">查询页数</param> /// <param name="rows">每页记录数</param> /// </summary> public void LoadGrid(int page, int rows) { string strSQL = "select TOP (100) PERCENT * from TSRole order by roleId asc"; string str = commonDao.DataGrid(strSQL, null, page, rows); WebJson.Write(context, str); }
/// <summary> /// 加载DataGrid /// <param name="page">查询页数</param> /// <param name="rows">每页记录数</param> /// <param name="agentName">代理商名称</param> /// <param name="agentId">代理商编号</param> /// <param name="bankCardId">银行卡号</param> /// <param name="auditStatus">审核状态</param> /// </summary> public void LoadGrid(int page, int rows, string agentName, string agentId, string bankCardId, string auditStatus) { string strSQL = "select a.*,b.areaName from TBAgent a,TBArea b where a.areaId=b.areaId "; if (!string.IsNullOrEmpty(agentName)) { strSQL += " and a.agentName like '%" + agentName + "%'"; } if (!string.IsNullOrEmpty(auditStatus)) { strSQL += " and a.auditStatus in(" + auditStatus + ")"; } if (!string.IsNullOrEmpty(agentId)) { strSQL += " and a.agentId='" + agentId + "'"; } if (!string.IsNullOrEmpty(bankCardId)) { strSQL += " and a.bankCardId='" + bankCardId + "'"; } strSQL += " order by a.agentId "; Param param = new Param(); param.Clear(); string str = commonDao.DataGrid(strSQL, param, page, rows); WebJson.Write(context, str); }
/// <summary> /// 加载DataGrid /// </summary> /// <param name="page">查询页数</param> /// <param name="rows">每页记录数</param> public void LoadGrid(int page, int rows, string agentId, string auditStatus, string startDate, string endDate) { string strSQL = "select * from TTAgentPreRechg where 1=1 "; if (!string.IsNullOrEmpty(agentId)) { strSQL += " and agentId='" + agentId + "'"; } if (!string.IsNullOrEmpty(auditStatus)) { strSQL += " and auditStatus='" + auditStatus + "'"; } if (!string.IsNullOrEmpty(startDate)) { strSQL += " and createtime>=to_date('" + startDate + " 00:00:00','yyyy-MM-dd hh24:mi:ss')"; } if (!string.IsNullOrEmpty(endDate)) { strSQL += " and createtime<=to_date('" + endDate + " 23:59:59','yyyy-MM-dd hh24:mi:ss')"; } strSQL += " order by auditStatus asc, createtime desc"; string str = commonDao.DataGrid(strSQL, null, page, rows); WebJson.Write(context, str); }
/// <summary> /// 加载DataGrid /// <param name="page">查询页数</param> /// <param name="rows">每页记录数</param> /// </summary> public void LoadGrid(int page, int rows) { string strSQL = "select * from TBGame"; string str = commonDao.DataGrid(strSQL, null, page, rows); WebJson.Write(context, str); }
/// <summary> /// 加载GRID /// </summary> /// <param name="page"></param> /// <param name="rows"></param> /// <param name="agentId"></param> /// <param name="siteId"></param> /// <param name="clientQuery"></param> /// <param name="clientQueryText"></param> /// <param name="startDate"></param> /// <param name="endDate"></param> public void LoadGrid(int page, int rows, string agentId, string siteId, string clientQuery, string clientQueryText, string startDate, string endDate) { //客户编号,客户名称,代理商编号,代理商名称,卡号,银行卡号,提现用户名 , 提现金额, 提现时间,发生时间,备注 string strSql = @"select t.flowId, t.ClientId,c.clientname,AgentName,t.CardId,t.CardNo as cardno,t.UserName as username,t.telphoneno as telphoneno,t.Fee,withDrawTime,t.createtime,t.withDrawState,t.remark from TTClientAccDetail t inner join tbagent a on t.agentid=a.agentid inner join tbclient c on t.clientid=c.clientid where t.SRCMODE in (7,8,9,10)"; if (!string.IsNullOrEmpty(clientQueryText) && !string.IsNullOrEmpty(clientQuery)) { if (clientQuery == ((int)ClientQuery.CardId).ToString()) { strSql += " and c.cardId='" + clientQueryText + "'"; } if (clientQuery == ((int)ClientQuery.ClientId).ToString()) { strSql += " and c.clientId='" + clientQueryText + "'"; } if (clientQuery == ((int)ClientQuery.ClientName).ToString()) { strSql += " and c.clientName='" + clientQueryText + "'"; } if (clientQuery == ((int)ClientQuery.ClinetPhone).ToString()) { strSql += " and c.telephone='" + clientQueryText + "'"; } } if (!string.IsNullOrEmpty(agentId)) { strSql += " and c.agentId='" + agentId + "'"; } if (!string.IsNullOrEmpty(siteId)) { strSql += " and c.siteId='" + siteId + "'"; } if (!string.IsNullOrEmpty(startDate)) { strSql += " and c.createTime>= To_date('" + startDate + " 00:00:00','yyyy-mm-dd hh24:mi:ss')"; } if (!string.IsNullOrEmpty(endDate)) { strSql += " and c.createTime<=To_date('" + endDate + " 23:59:59','yyyy-mm-dd hh24:mi:ss')"; } strSql += " order by c.agentId,c.siteId,c.clientId desc,c.createTime desc"; string str = commonDao.DataGrid(strSql, null, page, rows); WebJson.Write(context, str); }
/// <summary> /// 加载DataGrid /// </summary> /// <param name="page">查询页数</param> /// <param name="rows">每页记录数</param> /// <param name="orgId">机构编号</param> /// <param name="deptId">部门编号</param> /// <param name="userName">用户名称</param> public void LoadGrid(int page, int rows, string deptId, string userName) { string strSQL = " select TOP (100) PERCENT a.*,b.deptName from TSUser a ,TSDept b"; strSQL += " where a.deptId=b.deptId and b.status='1' "; if (deptId != null && !"".Equals(deptId)) { strSQL += " and b.deptId = '" + deptId + "' "; } if (userName != null && !"".Equals(userName)) { strSQL += " and a.userName = '******' "; } strSQL += " order by a.userId asc"; string str = commonDao.DataGrid(strSQL, null, page, rows); WebJson.Write(context, str); }
/// <summary> /// 加载DataGrid /// <param name="page">查询页数</param> /// <param name="rows">每页记录数</param> /// </summary> public void LoadGrid(string chaseOrderId, string chaseStatus, string alreadyOrNotChase, string agentId) { string strSQL = ""; if (chaseStatus == "0")//计划追号订单 { if (alreadyOrNotChase == "1") { strSQL = @"select * from Ttchaseplan c where c.period> (select case when max(l.period) is null then '0' else max(l.period) end from TTLotteryOrder l where 1=1 "; if (!string.IsNullOrEmpty(agentId)) { strSQL += " and l.agentId='" + agentId + "'"; } strSQL += " and l.chaseorderid='" + chaseOrderId + "') and c.chaseorderid='" + chaseOrderId + "'"; strSQL += " order by c.period desc"; } else if (alreadyOrNotChase == "0")//已追号的订单 { strSQL = @"select * from TTLotteryOrder l where l.chaseorderid='" + chaseOrderId + "'"; if (!string.IsNullOrEmpty(agentId)) { strSQL += " and l.agentId='" + agentId + "'"; } strSQL += " order by l.period desc"; } } else if (chaseStatus != "0")//已经完成追号的订单 { strSQL = @"select * from TTLotteryOrder l where l.chaseorderid='" + chaseOrderId + "'"; if (!string.IsNullOrEmpty(agentId)) { strSQL += " and l.agentId='" + agentId + "'"; } strSQL += " order by l.period desc"; } string str = commonDao.DataGrid(strSQL, null); WebJson.Write(context, str); }
/// <summary> /// 加载DataGrid /// <param name="page">查询页数</param> /// <param name="rows">每页记录数</param> /// </summary> public void LoadGrid(int page, int rows, string roleType, string userId, string staffName) { string strSQL = "select a.*,b.sitename,c.roleId,d.rolename from tbstaff a,tbsite b,tsagentuser c,tsagentrole d where a.siteid=b.siteid and a.staffid=c.userid and c.roleid=d.roleid and c.roleId!='001'"; if (!string.IsNullOrEmpty(staffName)) { strSQL += " and a.staffName like '%" + staffName + "%'"; } if (roleType == "0")//根据代理商查询员工 { strSQL += " and a.agentId='" + userId + "'"; } else //根据快开厅查询员工 { strSQL += " and a.siteId='" + userId + "'"; } string str = commonDao.DataGrid(strSQL, null, page, rows); WebJson.Write(context, str); }
/// <summary> /// 加载DataGrid /// <param name="page">查询页数</param> /// <param name="rows">每页记录数</param> /// </summary> public void LoadGrid(int page, int rows, string agentId, string startDate, string endDate) { string strSQL = "select a.* from TTAgentRechargeNotice a where 1=1"; if (!string.IsNullOrEmpty(agentId)) { strSQL += " and a.agentId='" + agentId + "'"; } if (!string.IsNullOrEmpty(startDate)) { strSQL += " and a.createTime >= To_date('" + startDate + " 00:00:00','yyyy-mm-dd hh24:mi:ss')"; } if (!string.IsNullOrEmpty(endDate)) { strSQL += " and a.createTime <= To_date('" + endDate + " 23:59:59','yyyy-mm-dd hh24:mi:ss')"; } strSQL += " order by a.createTime desc"; string str = commonDao.DataGrid(strSQL, null, page, rows); WebJson.Write(context, str); }
/// <summary> /// 加载DataGrid /// <param name="page">查询页数</param> /// <param name="rows">每页记录数</param> /// </summary> public void LoadGrid(int page, int rows, string userName, string startDate, string endDate) { string strSQL = "select * from TSAgentLog where 1=1"; if (startDate != null && !"".Equals(startDate)) { strSQL += " and createDate >= To_date('" + startDate + " 00:00:00','yyyy-mm-dd hh24:mi:ss')"; } if (endDate != null && !"".Equals(endDate)) { strSQL += " and createDate <= To_date('" + endDate + " 23:59:59','yyyy-mm-dd hh24:mi:ss')"; } if (userName != null && !"".Equals(userName)) { strSQL += " and userName ='******'"; } strSQL += " order by logId desc"; string str = commonDao.DataGrid(strSQL, null, page, rows); WebJson.Write(context, str); }
/// <summary> /// 加载DataGrid /// <param name="page">查询页数</param> /// <param name="rows">每页记录数</param> /// </summary> public void LoadGrid(int page, int rows, string terminalId, string startDate, string endDate) { string strSQL = "select * from TBTerminalLog where 1=1 "; if (!string.IsNullOrEmpty(startDate)) { strSQL += " and operateTime >= To_date('" + startDate + " 00:00:00','yyyy-mm-dd hh24:mi:ss')"; } if (!string.IsNullOrEmpty(endDate)) { strSQL += " and operateTime <= To_date('" + endDate + " 23:59:59','yyyy-mm-dd hh24:mi:ss')"; } if (!string.IsNullOrEmpty(terminalId)) { strSQL += " and terminalId ='" + terminalId + "'"; } strSQL += " order by logId desc"; string str = commonDao.DataGrid(strSQL, null, page, rows); WebJson.Write(context, str); }
/// <summary> /// 加载DataGrid /// </summary> /// <param name="page">查询页数</param> /// <param name="rows">每页记录数</param> /// <param name="orgName">机构名称</param> /// <param name="userName">用户名称</param> /// <param name="startDate">起始时间</param> /// <param name="endDate">结束时间</param> public void LoadGrid(int page, int rows, string userName, string startDate, string endDate) { string strSQL = "select TOP (100) PERCENT * from TSLog where 1=1 "; if (startDate != null && !"".Equals(startDate)) { strSQL += " and createDate >= '" + startDate + " 00:00:00'"; } if (endDate != null && !"".Equals(endDate)) { strSQL += " and createDate <= '" + endDate + " 23:59:59'"; } if (userName != null && !"".Equals(userName)) { strSQL += " and userName ='******'"; } strSQL += " order by logId desc"; string str = commonDao.DataGrid(strSQL, null, page, rows); WebJson.Write(context, str); }
/// <summary> /// 加载DataGrid /// <param name="page">查询页数</param> /// <param name="rows">每页记录数</param> /// </summary> public void LoadGrid(int page, int rows, string EnforcementTypeId, string EnforcementTypeName, string PunishmentTypeId) { string strSQL = "select * from TBEnforcementType a where 1=1 and a.statu=1 "; if (!string.IsNullOrEmpty(EnforcementTypeId)) { strSQL += " and a.EnforcementTypeId like '%" + EnforcementTypeId + "%'"; } if (!string.IsNullOrEmpty(EnforcementTypeName)) { strSQL += " and a.EnforcementTypeName like '%" + EnforcementTypeName + "%'"; } if (!string.IsNullOrEmpty(PunishmentTypeId)) { strSQL += " and a.PunishmentType = '" + PunishmentTypeId + "'"; } Param param = new Param(); param.Clear(); string str = commonDao.DataGrid(strSQL, param, page, rows); WebJson.Write(context, str); }
/// <summary> /// 加载DataGrid /// <param name="page">查询页数</param> /// <param name="rows">每页记录数</param> /// </summary> public void LoadGrid(int page, int rows, string EnforcementNameId, string EnforcementName, string EnforcementTypeId) { string strSQL = "select a.*,b.EnforcementTypeName ,c.TemplateName from TBEnForcementName a ,TBEnforcementType b ,TBEnforcementTemplate c where 1=1 and a.EnforcementTemplateId=c.TemplateId and a.EnforcementTypeId=b.EnforcementTypeId and a.statu=1 "; if (!string.IsNullOrEmpty(EnforcementNameId)) { strSQL += " and a.EnforcementNameId like '%" + EnforcementNameId + "%'"; } if (!string.IsNullOrEmpty(EnforcementName)) { strSQL += " and a.EnforcementName like '%" + EnforcementName + "%'"; } if (!string.IsNullOrEmpty(EnforcementTypeId)) { strSQL += " and a.EnforcementTypeId = '" + EnforcementTypeId + "'"; } Param param = new Param(); param.Clear(); string str = commonDao.DataGrid(strSQL, param, page, rows); WebJson.Write(context, str); }
/// <summary> /// 加载DataGrid /// </summary> /// <param name="page">查询页数</param> /// <param name="rows">每页记录数</param> public void LoadGrid(int page, int rows, string agentId, string siteId, string orderId, string period, string orderStatus, string srcType, string awardResult, string clientQuery, string clientQueryText, string startDate, string endDate) { string strSQL = @"select t.*,g.gamename from ttpointorder t,tbgame g,TBClient bc where t.gameid=g.gameid and t.clientId=bc.clientId "; if (!string.IsNullOrEmpty(orderId)) { strSQL += " and t.orderId like'%" + orderId + "%'"; } if (!string.IsNullOrEmpty(agentId)) { strSQL += " and t.agentId='" + agentId + "'"; } if (!string.IsNullOrEmpty(siteId)) { strSQL += " and t.siteId='" + siteId + "'"; } if (!string.IsNullOrEmpty(period)) { strSQL += " and t.period='" + period + "'"; } if (!string.IsNullOrEmpty(orderStatus)) { strSQL += " and t.orderStatus='" + orderStatus + "'"; } if (!string.IsNullOrEmpty(srcType)) { strSQL += " and t.srcType='" + srcType + "'"; } if (!string.IsNullOrEmpty(awardResult)) { strSQL += " and t.awardResult='" + awardResult + "'"; } if (!string.IsNullOrEmpty(clientQueryText) && !string.IsNullOrEmpty(clientQuery)) { if (clientQuery == ((int)ClientQuery.CardId).ToString()) { strSQL += " and t.cardId='" + clientQueryText + "'"; } if (clientQuery == ((int)ClientQuery.ClientId).ToString()) { strSQL += " and t.clientId='" + clientQueryText + "'"; } if (clientQuery == ((int)ClientQuery.ClientName).ToString()) { strSQL += " and t.clientName='" + clientQueryText + "'"; } if (clientQuery == ((int)ClientQuery.ClinetPhone).ToString()) { strSQL += " and bc.telephone='" + clientQueryText + "'"; } } if (!string.IsNullOrEmpty(startDate)) { strSQL += " and t.betTime>= '" + startDate + " 00:00:00'"; } if (!string.IsNullOrEmpty(endDate)) { strSQL += " and t.betTime<='" + endDate + " 23:59:59'"; } strSQL += " order by betTime desc"; string str = commonDao.DataGrid(strSQL, null, page, rows); WebJson.Write(context, str); }
/// <summary> /// 加载DataGrid /// <param name="page">查询页数</param> /// <param name="rows">每页记录数</param> /// </summary> public void LoadGrid(int page, int rows, string tbCaseId, string tbCaseReason, string openDateFrom, string openDateTo, string closeDateFrom, string closeDateTo, string caseState, string caseCarNo, string caseType, int CaseStatus) { Param param = new Param(); string strSQL = "SELECT CaseId,CaseReason,CaseFrom,CasePersonName,CasePersonSex ,CasePersonAge ,CasePersonAddress,CasePersonRepresentative,CasePersonCompanyName ,CasePersonCompanyLegalPerson,CasePersonCompanyLegalRepresentative" + " ,CasePersonCompanyLegalAgent,convert(varchar, CaseOpenDate, 111) as CaseOpenDate,convert(varchar, CaseCloseDate, 111)as CaseCloseDate ,CaseFillingDate,CaseExpirationDate,CaseExecutive,StationName ,CaseProcessPersonOne,CaseProcessPersonOneEnforcementNumberOne" + " ,CaseProcessPersonTwo,CaseProcessPersonOneEnforcementNumberTwo ,CaseProcessPersonThree ,CaseProcessPersonOneEnforcementNumberThree ,CaseCarNo ,CaseResult ,CaseTypeName ,CaseStateName ,CreateUserName,CreateDate from TBCase a where CaseStatus= " + CaseStatus; if (!string.IsNullOrEmpty(tbCaseId)) { strSQL += " and a.CaseId =@tbCaseId "; param.Add("@tbCaseId", tbCaseId); } if (!string.IsNullOrEmpty(caseType)) { PunishmentType punishmentType; if (Enum.TryParse(caseType, out punishmentType)) { strSQL += " and a.CaseTypeName=@CaseTypeName"; param.Add("@CaseTypeName", Enum.GetName(typeof(PunishmentType), punishmentType)); } } if (!string.IsNullOrEmpty(tbCaseReason)) { strSQL += " and a.CaseReason like @tbCaseReason"; param.Add("@tbCaseReason", "%" + tbCaseReason + "%"); } if (!string.IsNullOrEmpty(openDateFrom) && !string.IsNullOrEmpty(openDateTo)) { strSQL += " and CaseOpenDate between @CaseOpenDateFrom and @CaseOpenTo"; param.Add("@CaseOpenDateFrom", openDateFrom); param.Add("@CaseOpenTo", openDateTo); } else if (!string.IsNullOrEmpty(openDateFrom) && string.IsNullOrEmpty(openDateTo)) { strSQL += " and CaseOpenDate > @CaseOpenDateFrom"; param.Add("@CaseOpenDateFrom", openDateFrom); } else if (string.IsNullOrEmpty(openDateFrom) && !string.IsNullOrEmpty(openDateTo)) { strSQL += " and CaseOpenDate < @CaseOpenTo"; param.Add("@CaseOpenTo", openDateTo); } else { } if (!string.IsNullOrEmpty(closeDateFrom) && !string.IsNullOrEmpty(closeDateTo)) { strSQL += " and CaseCloseDate between @CaseCloseDateFrom and @CaseCloseDateTo"; param.Add("@CaseCloseDateFrom", closeDateFrom); param.Add("@CaseCloseDateTo", closeDateTo); } else if (!string.IsNullOrEmpty(closeDateFrom) && string.IsNullOrEmpty(closeDateTo)) { strSQL += " and CaseCloseDate > @CaseCloseDateFrom"; param.Add("@CaseCloseDateFrom", closeDateFrom); } else if (string.IsNullOrEmpty(closeDateFrom) && !string.IsNullOrEmpty(closeDateTo)) { strSQL += " and CaseCloseDate < @CaseCloseDateTo"; param.Add("@CaseCloseDateTo", closeDateTo); } else { } if (!string.IsNullOrEmpty(caseState)) { strSQL += " and CaseStateName = @CaseStateName "; param.Add("@CaseStateName", caseState); } if (!string.IsNullOrEmpty(caseCarNo)) { strSQL += " and CaseCarNo like @CaseCarNo "; param.Add("@CaseCarNo", '%' + caseCarNo + '%'); } string str = commonDao.DataGrid(strSQL, param, page, rows); param.Clear(); WebJson.Write(context, str); }
/// <summary> /// 加载DataGrid /// <param name="page">查询页数</param> /// <param name="rows">每页记录数</param> /// </summary> public void LoadGrid(int page, int rows, string agentId, string siteId, string chaseOrderId, string period, string srcType, string chaseStatus, string clientQuery, string clientQueryText, string startDate, string endDate) { string strSQL = @"select c.*,g.gamename ,l.lotterytypename from TTChaseOrder c,Tbgame g,Tblottery l where c.gameid=g.gameid and c.lotterytype=l.lotterytype "; if (!string.IsNullOrEmpty(chaseOrderId)) { strSQL += " and c.chaseOrderId like '%" + chaseOrderId + "%'"; } if (!string.IsNullOrEmpty(agentId)) { strSQL += " and c.agentId='" + agentId + "'"; } if (!string.IsNullOrEmpty(siteId)) { strSQL += " and c.siteId='" + siteId + "'"; } if (!string.IsNullOrEmpty(period)) { strSQL += " and c.period='" + period + "'"; } if (!string.IsNullOrEmpty(chaseStatus)) { strSQL += " and c.chaseStatus='" + chaseStatus + "'"; } if (!string.IsNullOrEmpty(srcType)) { strSQL += " and c.srcType='" + srcType + "'"; } if (!string.IsNullOrEmpty(clientQueryText) && !string.IsNullOrEmpty(clientQuery)) { if (clientQuery == ((int)ClientQuery.CardId).ToString()) { strSQL += " and c.cardId='" + clientQueryText + "'"; } if (clientQuery == ((int)ClientQuery.ClientId).ToString()) { strSQL += " and c.clientId='" + clientQueryText + "'"; } if (clientQuery == ((int)ClientQuery.ClientName).ToString()) { strSQL += " and c.clientName='" + clientQueryText + "'"; } if (clientQuery == ((int)ClientQuery.ClinetPhone).ToString()) { strSQL += " and bc.telephone='" + clientQueryText + "'"; } } if (!string.IsNullOrEmpty(startDate)) { strSQL += " and c.chaseTime>= '" + startDate + " 00:00:00'"; } if (!string.IsNullOrEmpty(endDate)) { strSQL += " and c.chaseTime<='" + endDate + " 23:59:59'"; } strSQL += " order by chaseTime desc"; string str = commonDao.DataGrid(strSQL, null, page, rows); WebJson.Write(context, str); }