/// <summary> /// 获取数据 /// </summary> /// <returns>参见模型</returns> public static DataTable getDT(JC_PERALARM_SW sw, out int total) { StringBuilder sb = new StringBuilder(); sb.AppendFormat(" FROM JC_PERALARM a"); sb.AppendFormat(" WHERE 1=1"); if (string.IsNullOrEmpty(sw.PERALARMID) == false) { sb.AppendFormat(" AND PERALARMID = '{0}'", ClsSql.EncodeSql(sw.PERALARMID)); } if (string.IsNullOrEmpty(sw.PERALARMPHONE) == false) { sb.AppendFormat(" AND PERALARMPHONE like '%{0}%'", ClsSql.EncodeSql(sw.PERALARMPHONE)); } if (string.IsNullOrEmpty(sw.PERALARMNAME) == false) { sb.AppendFormat(" AND PERALARMNAME like '%{0}%'", ClsSql.EncodeSql(sw.PERALARMNAME)); } if (!string.IsNullOrEmpty(sw.DateBegin)) { sb.AppendFormat(" AND PERALARMTIME>='{0} 00:00:00'", sw.DateBegin); } if (!string.IsNullOrEmpty(sw.DateEnd)) { sb.AppendFormat(" AND PERALARMTIME<='{0} 23:59:59'", sw.DateEnd); } if (string.IsNullOrEmpty(sw.MANSTATE) == false) { sb.AppendFormat(" AND MANSTATE = '{0}'", ClsSql.EncodeSql(sw.MANSTATE)); } if (string.IsNullOrEmpty(sw.BYORGNO) == false) { if (PublicCls.OrgIsShi(sw.BYORGNO)) { sb.AppendFormat(" and BYORGNO like '{0}%'", PublicCls.getShiIncOrgNo(sw.BYORGNO)); } else if (PublicCls.OrgIsXian(sw.BYORGNO)) { sb.AppendFormat(" and BYORGNO like '{0}%'", PublicCls.getXianIncOrgNo(sw.BYORGNO)); } else { sb.AppendFormat(" and BYORGNO = '{0}'", PublicCls.getZhenIncOrgNo(sw.BYORGNO)); } } string sql = "SELECT PERALARMID,BYORGNO, FIRENAME,PERALARMPHONE, PERALARMNAME, PERALARMTIME, PERALARMADDRESS, PERALARMCONTENT, MANSTATE, MANRESULT, MANTIME, MANUSERID,JD, WD, PEARLARMPRE, PEARLARMISSUED" + sb.ToString() + " order by PERALARMTIME DESC"; string sqlC = "select count(1) " + sb.ToString(); total = int.Parse(DataBaseClass.ReturnSqlField(sqlC)); sw.curPage = PagerCls.getCurPage(new PagerSW { curPage = sw.curPage, pageSize = sw.pageSize, rowCount = total }); DataSet ds = DataBaseClass.FullDataSet(sql, (sw.curPage - 1) * sw.pageSize, sw.pageSize, "a"); return(ds.Tables[0]); }
/// <summary> /// 获取用户列表(分页) /// </summary> /// <param name="sw">参见模型</param> /// <param name="total">记录总数</param> /// <returns>参见模型</returns> public static IEnumerable <JC_PERALARM_Model> getListModelPager(JC_PERALARM_SW sw, out int total) { var result = new List <JC_PERALARM_Model>(); DataTable dt = BaseDT.JC_PERALARM.getDT(sw, out total);//用户列表 DataTable dtUser = BaseDT.T_SYSSEC_USER.getDT(new T_SYSSEC_IPSUSER_SW { }); DataTable dtORG = BaseDT.T_SYS_ORG.getDT(new T_SYS_ORGSW { SYSFLAG = ConfigCls.getSystemFlag() }); //获取单位 for (int i = 0; i < dt.Rows.Count; i++) { JC_PERALARM_Model m = new JC_PERALARM_Model(); m.PERALARMID = dt.Rows[i]["PERALARMID"].ToString(); m.BYORGNO = dt.Rows[i]["BYORGNO"].ToString(); m.FIRENAME = dt.Rows[i]["FIRENAME"].ToString(); m.PERALARMPHONE = dt.Rows[i]["PERALARMPHONE"].ToString(); m.PERALARMNAME = dt.Rows[i]["PERALARMNAME"].ToString(); m.PERALARMTIME = ClsSwitch.SwitTM(dt.Rows[i]["PERALARMTIME"].ToString()); m.PERALARMADDRESS = dt.Rows[i]["PERALARMADDRESS"].ToString(); m.PERALARMCONTENT = dt.Rows[i]["PERALARMCONTENT"].ToString(); m.MANSTATE = dt.Rows[i]["MANSTATE"].ToString(); m.MANRESULT = dt.Rows[i]["MANRESULT"].ToString(); m.MANTIME = ClsSwitch.SwitTM(dt.Rows[i]["MANTIME"].ToString()); m.MANUSERID = dt.Rows[i]["MANUSERID"].ToString(); m.JD = dt.Rows[i]["JD"].ToString(); m.WD = dt.Rows[i]["WD"].ToString(); m.PEARLARMPRE = dt.Rows[i]["PEARLARMPRE"].ToString(); m.PEARLARMISSUED = dt.Rows[i]["PEARLARMISSUED"].ToString(); if (!string.IsNullOrEmpty(m.MANUSERID)) { DataRow[] drUser = dtUser.Select("USERID='" + m.MANUSERID + "'"); if (drUser.Length > 0) { m.ManUserName = drUser[0]["USERNAME"].ToString(); } } m.ORGNAME = BaseDT.T_SYS_ORG.getName(dtORG, m.BYORGNO); result.Add(m); } dtORG.Clear(); dtORG.Dispose(); dtUser.Clear(); dtUser.Dispose(); dt.Clear(); dt.Dispose(); return(result); }
/// <summary> /// 根据查询条件获取某一条信息记录 /// </summary> /// <param name="sw">参见模型</param> /// <returns>参见模型</returns> public static JC_PERALARM_Model getModel(JC_PERALARM_SW sw) { DataTable dt = BaseDT.JC_PERALARM.getDT(sw); JC_PERALARM_Model m = new JC_PERALARM_Model(); DataTable dtORG = BaseDT.T_SYS_ORG.getDT(new T_SYS_ORGSW { SYSFLAG = ConfigCls.getSystemFlag() }); //获取单位 if (dt.Rows.Count > 0) { int i = 0; m.PERALARMID = dt.Rows[i]["PERALARMID"].ToString(); m.BYORGNO = dt.Rows[i]["BYORGNO"].ToString(); m.FIRENAME = dt.Rows[i]["FIRENAME"].ToString(); m.PERALARMPHONE = dt.Rows[i]["PERALARMPHONE"].ToString(); m.PERALARMNAME = dt.Rows[i]["PERALARMNAME"].ToString(); m.PERALARMTIME = ClsSwitch.SwitTM(dt.Rows[i]["PERALARMTIME"].ToString()); m.PERALARMADDRESS = dt.Rows[i]["PERALARMADDRESS"].ToString(); m.PERALARMCONTENT = dt.Rows[i]["PERALARMCONTENT"].ToString(); m.MANSTATE = dt.Rows[i]["MANSTATE"].ToString(); m.MANRESULT = dt.Rows[i]["MANRESULT"].ToString(); m.MANTIME = ClsSwitch.SwitTM(dt.Rows[i]["MANTIME"].ToString()); m.MANUSERID = dt.Rows[i]["MANUSERID"].ToString(); m.JD = dt.Rows[i]["JD"].ToString(); m.WD = dt.Rows[i]["WD"].ToString(); m.PEARLARMPRE = dt.Rows[i]["PEARLARMPRE"].ToString(); m.PEARLARMISSUED = dt.Rows[i]["PEARLARMISSUED"].ToString(); if (!string.IsNullOrEmpty(m.MANUSERID)) { DataTable dtUser = BaseDT.T_SYSSEC_USER.getDT(new T_SYSSEC_IPSUSER_SW { USERID = m.MANUSERID }); DataRow[] drUser = dtUser.Select("USERID='" + m.MANUSERID + "'"); if (drUser.Length > 0) { m.ManUserName = drUser[0]["USERNAME"].ToString(); } dtUser.Clear(); dtUser.Dispose(); } m.ORGNAME = BaseDT.T_SYS_ORG.getName(dtORG, m.BYORGNO); } dtORG.Clear(); dtORG.Dispose(); dt.Clear(); dt.Dispose(); return(m); }
/// <summary> /// 获取数据 /// </summary> /// <returns>参见模型</returns> public static DataTable getDT(JC_PERALARM_SW sw) { StringBuilder sb = new StringBuilder(); //PERALARMID, PERALARMPHONE, PERALARMNAME, PERALARMTIME, PERALARMADDRESS, PERALARMCONTENT, MANSTATE, MANRESULT, MANTIME, MANUSERID sb.AppendFormat(" FROM JC_PERALARM a"); sb.AppendFormat(" WHERE 1=1"); if (string.IsNullOrEmpty(sw.PERALARMID) == false) { sb.AppendFormat(" AND PERALARMID = '{0}'", ClsSql.EncodeSql(sw.PERALARMID)); } if (string.IsNullOrEmpty(sw.PERALARMPHONE) == false) { sb.AppendFormat(" AND PERALARMPHONE = '{0}'", ClsSql.EncodeSql(sw.PERALARMPHONE)); } if (string.IsNullOrEmpty(sw.PERALARMNAME) == false) { sb.AppendFormat(" AND PERALARMNAME = '{0}'", ClsSql.EncodeSql(sw.PERALARMNAME)); } if (string.IsNullOrEmpty(sw.PERALARMTIME) == false) { sb.AppendFormat(" AND PERALARMTIME = '{0}'", ClsSql.EncodeSql(sw.PERALARMTIME)); } if (!string.IsNullOrEmpty(sw.DateBegin)) { sb.AppendFormat(" AND PERALARMTIME>='{0} 00:00:00'", sw.DateBegin); } if (!string.IsNullOrEmpty(sw.DateEnd)) { sb.AppendFormat(" AND PERALARMTIME<='{0} 23:59:59'", sw.DateEnd); } if (string.IsNullOrEmpty(sw.MANSTATE) == false) { sb.AppendFormat(" AND MANSTATE = '{0}'", ClsSql.EncodeSql(sw.MANSTATE)); } if (string.IsNullOrEmpty(sw.BYORGNO) == false) { sb.AppendFormat(" AND BYORGNO = '{0}'", ClsSql.EncodeSql(sw.BYORGNO)); //if (PublicCls.OrgIsShi(sw.BYORGNO)) //{ // sb.AppendFormat(" and BYORGNO like '{0}%'", PublicCls.getShiIncOrgNo(sw.BYORGNO)); //} //else if (PublicCls.OrgIsXian(sw.BYORGNO)) //{ // sb.AppendFormat(" and BYORGNO like '{0}%'", PublicCls.getXianIncOrgNo(sw.BYORGNO)); //} //else //{ // sb.AppendFormat(" and BYORGNO = '{0}'", PublicCls.getZhenIncOrgNo(sw.BYORGNO)); //} } string sql = "SELECT PERALARMID,BYORGNO,FIRENAME, PERALARMPHONE, PERALARMNAME, PERALARMTIME, PERALARMADDRESS, PERALARMCONTENT, MANSTATE, MANRESULT, MANTIME, MANUSERID,JD, WD, PEARLARMPRE, PEARLARMISSUED" + sb.ToString() + " order by PERALARMTIME DESC"; DataSet ds = DataBaseClass.FullDataSet(sql); return(ds.Tables[0]); }