/// <summary>
/// 获取记录
/// </summary>
/// <param name="sw"></param>
/// <returns></returns>
public static DataTable getDT(JC_FIRE_PLAN_SW sw)
{
StringBuilder sb = new StringBuilder();
sb.AppendFormat(" FROM JC_FIRE_PLAN");
sb.AppendFormat(" WHERE 1=1");
if (string.IsNullOrEmpty(sw.JC_FIRE_PLANID) == false)
{
sb.AppendFormat(" AND JC_FIRE_PLANID = '{0}'", ClsSql.EncodeSql(sw.JC_FIRE_PLANID));
}
if (string.IsNullOrEmpty(sw.FIRELEVEL) == false)//火险等级
{
sb.AppendFormat(" AND FIRELEVEL = '{0}'", ClsSql.EncodeSql(sw.FIRELEVEL));
}
if (string.IsNullOrEmpty(sw.PLANTITLE) == false)
{
sb.AppendFormat(" AND PLANTITLE like '%{0}%'", ClsSql.EncodeSql(sw.PLANTITLE));
}
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));
}
}
if (string.IsNullOrEmpty(sw.searchOrgNo) == false)//根据当前单位编码，反查上级单位预案,主要用于调度指挥
{
if (PublicCls.OrgIsShi(sw.searchOrgNo))
{
sb.AppendFormat(" and BYORGNO = '{0}'", PublicCls.getShiIncOrgNo(sw.searchOrgNo) + "00000");
}
else if (PublicCls.OrgIsXian(sw.searchOrgNo))
{
sb.AppendFormat(" and BYORGNO in ('{0}','{1}')", PublicCls.getXianIncOrgNo(sw.searchOrgNo) + "000", PublicCls.getShiIncOrgNo(sw.searchOrgNo) + "00000");
}
else
{
sb.AppendFormat(" and BYORGNO in ('{0}','{1}','{2}')", PublicCls.getXianIncOrgNo(sw.searchOrgNo) + "000", PublicCls.getShiIncOrgNo(sw.searchOrgNo) + "00000", sw.searchOrgNo);
}
}
string sql = "SELECT JC_FIRE_PLANID, BYORGNO, FIRELEVEL, PLANTITLE, PLANCONTENT, PLANFILENAME"
+ sb.ToString()
+ " order by BYORGNO DESC, FIRELEVEL";
DataSet ds = DataBaseClass.FullDataSet(sql);
return(ds.Tables[0]);
}
/// <summary>
/// 判断记录是否存在
/// </summary>
/// <param name="sw">参见模型</param>
/// <returns>true存在 false不存在</returns>
public static bool isExists(JC_FIRE_PLAN_SW sw)
{
StringBuilder sb = new StringBuilder();
sb.AppendFormat("select 1 from JC_FIRE_PLAN where 1=1");
if (string.IsNullOrEmpty(sw.JC_FIRE_PLANID) == false)
{
sb.AppendFormat(" where JC_FIRE_PLANID= '{0}'", ClsSql.EncodeSql(sw.JC_FIRE_PLANID));
}
return(DataBaseClass.JudgeRecordExists(sb.ToString()));
}
/// <summary>
/// 获取分页列表
/// </summary>
/// <param name="sw"></param>
/// <param name="total"></param>
/// <returns></returns>
public static DataTable getDT(JC_FIRE_PLAN_SW sw, out int total)
{
StringBuilder sb = new StringBuilder();
sb.AppendFormat(" FROM JC_FIRE_PLAN");
sb.AppendFormat(" WHERE 1=1");
if (string.IsNullOrEmpty(sw.JC_FIRE_PLANID) == false)
{
sb.AppendFormat(" AND JC_FIRE_PLANID = '{0}'", ClsSql.EncodeSql(sw.JC_FIRE_PLANID));
}
if (string.IsNullOrEmpty(sw.FIRELEVEL) == false)
{
sb.AppendFormat(" AND FIRELEVEL = '{0}'", ClsSql.EncodeSql(sw.FIRELEVEL));
}
if (string.IsNullOrEmpty(sw.PLANTITLE) == false)
{
sb.AppendFormat(" AND PLANTITLE like '%{0}%'", ClsSql.EncodeSql(sw.PLANTITLE));
}
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 if (PublicCls.OrgIsZhen(sw.BYORGNO))
{
sb.AppendFormat(" and BYORGNO like '{0}%'", PublicCls.getZhenIncOrgNo(sw.BYORGNO));
}
else
{
sb.AppendFormat(" and BYORGNO = '{0}'", sw.BYORGNO);
}
}
string sql = "SELECT JC_FIRE_PLANID, BYORGNO, FIRELEVEL, PLANTITLE, PLANCONTENT, PLANFILENAME"
+ sb.ToString()
+ " order by BYORGNO ,FIRELEVEL";
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">sw</param>
/// <param name="org">org</param>
/// <returns></returns>
public static IEnumerable <JC_FIRE_PLAN_Model> getModelList(JC_FIRE_PLAN_SW sw, string org = "")
{
var result = new List <JC_FIRE_PLAN_Model>();
DataTable dt = BaseDT.JC_FIRE_PLAN.getDT(sw);//列表
DataTable dtORG = BaseDT.T_SYS_ORG.getDT(new T_SYS_ORGSW {
SYSFLAG = ConfigCls.getSystemFlag()
}); //获取单位
DataTable dtFIRELEVEL = BaseDT.T_SYS_DICT.getDT(new T_SYS_DICTSW {
DICTTYPEID = "22"
}); //火险等级
if (dt != null)
{
ArrayList aList = new ArrayList();
if (PublicCls.OrgIsZhen(org))//乡镇
{
aList.Add(org);
}
aList.Add(PublicCls.getXianIncOrgNo(org) + "000"); //县
aList.Add(PublicCls.getShiIncOrgNo(org) + "00000"); //市
for (int i = 0; i < aList.Count; i++)
{
DataRow[] arrayDR = dt.Select(string.Format("BYORGNO='{0}'", aList[i].ToString()));
var list = GetYAList(arrayDR, dtORG, dtFIRELEVEL, org);
result.AddRange(list);
}
}
dt.Clear();
dt.Dispose();
dtFIRELEVEL.Clear();
dtFIRELEVEL.Dispose();
dtFIRELEVEL.Clear();
dtFIRELEVEL.Dispose();
return(result);
}
/// <summary>
/// 根据查询条件获取某一条用户信息记录，用于修改、删除、用户登录验证
/// </summary>
/// <param name="sw">参见模型</param>
/// <returns>参见模型</returns>
public static JC_FIRE_PLAN_Model getModel(JC_FIRE_PLAN_SW sw)
{
var result = new List <JC_FIRE_PLAN_Model>();
DataTable dt = BaseDT.JC_FIRE_PLAN.getDT(sw);//列表
JC_FIRE_PLAN_Model m = new JC_FIRE_PLAN_Model();
if (dt.Rows.Count > 0)
{
int i = 0;
m.JC_FIRE_PLANID = dt.Rows[i]["JC_FIRE_PLANID"].ToString();
m.BYORGNO = dt.Rows[i]["BYORGNO"].ToString();
m.FIRELEVEL = dt.Rows[i]["FIRELEVEL"].ToString();
m.PLANTITLE = dt.Rows[i]["PLANTITLE"].ToString();
m.PLANCONTENT = dt.Rows[i]["PLANCONTENT"].ToString();
m.PLANFILENAME = dt.Rows[i]["PLANFILENAME"].ToString();
DataTable dtORG = BaseDT.T_SYS_ORG.getDT(new T_SYS_ORGSW {
SYSFLAG = ConfigCls.getSystemFlag()
}); //获取单位
m.BYORGNOName = BaseDT.T_SYS_ORG.getName(dtORG, m.BYORGNO); //单位名称
DataTable dtFIRELEVEL = BaseDT.T_SYS_DICT.getDT(new T_SYS_DICTSW {
DICTTYPEID = "22"
}); //预案
m.FIRELEVELName = BaseDT.T_SYS_DICT.getName(dtFIRELEVEL, m.FIRELEVEL);
dtFIRELEVEL.Clear();
dtFIRELEVEL.Dispose();
dtFIRELEVEL.Clear();
dtFIRELEVEL.Dispose();
}
dt.Clear();
dt.Dispose();
return(m);
}
/// <summary>
/// 获取分页
/// </summary>
/// <param name="sw">参见模型</param>
/// <param name="total">记录总数</param>
/// <returns>参见模型</returns>
public static IEnumerable <JC_FIRE_PLAN_Model> getModelList(JC_FIRE_PLAN_SW sw, out int total)
{
var result = new List <JC_FIRE_PLAN_Model>();
DataTable dt = BaseDT.JC_FIRE_PLAN.getDT(sw, out total);//列表
DataTable dtORG = BaseDT.T_SYS_ORG.getDT(new T_SYS_ORGSW {
SYSFLAG = ConfigCls.getSystemFlag()
}); //获取单位
DataTable dtFIRELEVEL = BaseDT.T_SYS_DICT.getDT(new T_SYS_DICTSW {
DICTTYPEID = "22"
}); //预案
for (int i = 0; i < dt.Rows.Count; i++)
{
JC_FIRE_PLAN_Model m = new JC_FIRE_PLAN_Model();
m.JC_FIRE_PLANID = dt.Rows[i]["JC_FIRE_PLANID"].ToString();
m.BYORGNO = dt.Rows[i]["BYORGNO"].ToString();
m.FIRELEVEL = dt.Rows[i]["FIRELEVEL"].ToString();
m.PLANTITLE = dt.Rows[i]["PLANTITLE"].ToString();
m.PLANCONTENT = dt.Rows[i]["PLANCONTENT"].ToString();
m.PLANFILENAME = dt.Rows[i]["PLANFILENAME"].ToString();
m.BYORGNOName = BaseDT.T_SYS_ORG.getName(dtORG, m.BYORGNO);//单位名称
m.FIRELEVELName = BaseDT.T_SYS_DICT.getName(dtFIRELEVEL, m.FIRELEVEL);
result.Add(m);
}
dt.Clear();
dt.Dispose();
dtFIRELEVEL.Clear();
dtFIRELEVEL.Dispose();
dtFIRELEVEL.Clear();
dtFIRELEVEL.Dispose();
return(result);
}
