/// <summary>
/// 获取分页
/// </summary>
/// <param name="sw">参见模型</param>
/// <param name="total">记录总数</param>
/// <returns>参见模型</returns>
public static IEnumerable <DC_REPOSITORY_Model> getModelList(DC_REPOSITORY_SW sw, out int total)
{
var result = new List <DC_REPOSITORY_Model>();
DataTable dt = BaseDT.DC_REPOSITORY.getDT(sw, out total);//列表
DataTable dtORG = BaseDT.T_SYS_ORG.getDT(new T_SYS_ORGSW {
SYSFLAG = ConfigCls.getSystemFlag()
});
for (int i = 0; i < dt.Rows.Count; i++)
{
DC_REPOSITORY_Model m = new DC_REPOSITORY_Model();
m.DCREPOSITORYID = dt.Rows[i]["DCREPOSITORYID"].ToString();
m.NAME = dt.Rows[i]["NAME"].ToString();
m.ADDRESS = dt.Rows[i]["ADDRESS"].ToString();
m.BYORGNO = dt.Rows[i]["BYORGNO"].ToString();
if (m.BYORGNO.Substring(6, 3) != "000" && m.BYORGNO.Substring(9, 6) == "000000")
{
m.ORGName = BaseDT.T_SYS_ORG.getName(dtORG, m.BYORGNO);
}
m.ORGXSName = BaseDT.T_SYS_ORG.getSXName(dtORG, m.BYORGNO);
//m.ORGName = BaseDT.T_SYS_ORG.getName(dtORG, m.BYORGNO);
//string orgname = BaseDT.T_SYS_ORG.getName(dtORG, m.BYORGNO);
m.COMNAME = "[" + m.ORGName + "]" + m.NAME + "";
m.RESPONSIBLEMAN = dt.Rows[i]["RESPONSIBLEMAN"].ToString();
m.LINKWAY = dt.Rows[i]["LINKWAY"].ToString();
m.REPTYPEID = dt.Rows[i]["REPTYPEID"].ToString();
m.JD = dt.Rows[i]["JD"].ToString();
m.WD = dt.Rows[i]["WD"].ToString();
result.Add(m);
}
dt.Clear();
dt.Dispose();
dtORG.Clear();
dtORG.Dispose();
return(result);
}
/// <summary>
/// 根据查询条件获取某一条记录
/// </summary>
/// <param name="sw">参见模型</param>
/// <returns>参见模型</returns>
public static JC_UAV_Model getModel(JC_UAV_SW sw)
{
JC_UAV_Model m = new JC_UAV_Model();
DataTable dt = BaseDT.JC_UAV.getDT(sw);//列表
DataTable dtORG = BaseDT.T_SYS_ORG.getDT(new T_SYS_ORGSW {
SYSFLAG = ConfigCls.getSystemFlag()
}); //获取单位
if (dt.Rows.Count > 0)
{
int i = 0;
m.UAVID = dt.Rows[i]["UAVID"].ToString();
m.UAVNAME = dt.Rows[i]["UAVNAME"].ToString();
m.UAVEQUIPNAME = dt.Rows[i]["UAVEQUIPNAME"].ToString();
m.BYORGNO = dt.Rows[i]["BYORGNO"].ToString();
m.ORGNAME = BaseDT.T_SYS_ORG.getName(dtORG, m.BYORGNO);
m.ORDERBY = dt.Rows[i]["ORDERBY"].ToString();
}
dt.Clear();
dt.Dispose();
dtORG.Clear();
dtORG.Dispose();
return(m);
}
/// <summary>
/// 获取森林防火统计单条数据
/// </summary>
/// <param name="sw">参见模型</param>
/// <returns>参见模型</returns>
public static FIRERECORD_REPORT8_Model getModel(FIRERECORD_REPORT8_SW sw)
{
DataTable dt = BaseDT.FIRERECORD_REPORT8.getDT(sw);
FIRERECORD_REPORT8_Model m = new FIRERECORD_REPORT8_Model();
DataTable dtORG = BaseDT.T_SYS_ORG.getDT(new T_SYS_ORGSW {
SYSFLAG = ConfigCls.getSystemFlag()
}); //获取单位
if (dt != null && dt.Rows.Count > 0)
{
int i = 0;
m.FIRERECORD_REPORT8ID = dt.Rows[i]["FIRERECORD_REPORT8ID"].ToString();
m.BYORGNO = dt.Rows[i]["BYORGNO"].ToString();
m.REPORTYEAR = dt.Rows[i]["REPORTYEAR"].ToString();
m.REPORTCODE = dt.Rows[i]["REPORTCODE"].ToString();
m.SSXTYPELEVELCODE = dt.Rows[i]["SSXTYPELEVELCODE"].ToString();
m.REPORTVALUE = dt.Rows[i]["REPORTVALUE"].ToString();
}
dt.Clear();
dt.Dispose();
dtORG.Clear();
dtORG.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);
}
/// <summary>
/// 巡检距离误差（用于判断怠工 单位米（m））
/// </summary>
/// <returns>米（m）</returns>
public static float getPatrolLengthError()
{
return(float.Parse(T_SYS_PARAMETERCls.getValueByFlag(new T_SYS_PARAMETER_SW {
SYSFLAG = ConfigCls.getSystemFlag(), PARAMFLAG = "getPatrolLengthError"
})));
}
/// <summary>
/// 判断护林员是否在线时间间隔 分
/// </summary>
/// <returns>分</returns>
public static int inLineTimeInterval()
{
return(Convert.ToInt32(T_SYS_PARAMETERCls.getValueByFlag(new T_SYS_PARAMETER_SW {
SYSFLAG = ConfigCls.getSystemFlag(), PARAMFLAG = "inLineTimeInterval"
})));
}
/// <summary>
/// 巡检路线统计总表
/// </summary>
/// <param name="sw">参见PatrolRouteStat_SW</param>
/// <returns>参见HUReport_PatrolRouteStat_Model</returns>
public static IEnumerable <HUReport_PatrolRouteStat_Model> getPatrolRouteStatModel(PatrolRouteStat_SW sw)
{
var result = new List <HUReport_PatrolRouteStat_Model>();
if (string.IsNullOrEmpty(sw.DateBegin))//开始时间为空
{
return(result);
}
if (string.IsNullOrEmpty(sw.DateEnd))//结束时间为空
{
return(result);
}
//DataTable dtOrg = BaseDT.T_SYS_ORG.getDT(new T_SYS_ORGSW { SYSFLAG = ConfigCls.getSystemFlag(), TopORGNO=sw.orgNo });
//获取护林员每日巡检信息
//DataTable dtHRRealData = BaseDT.T_IPS_REALDATATEMPORARY.getHRAndRealDataDT(new T_IPS_REALDATATEMPORARYSW { DateBegin = sw.DateBegin, DateEnd = sw.DateEnd });
//获取具体巡检情况
//DataTable dtPatrol = BaseDT.T_IPSFR_ROUTERAIL_PATROL.getDT(new T_IPSFR_ROUTERAIL_PATROL_SW { DateBegin = sw.DateBegin, DateEnd = sw.DateEnd });
// DataTable dtHRRealData = new DataTable();
//DataTable dtPatrol = new DataTable();
DataTable dtHU = new DataTable();
DataTable dtHRRealData = BaseDT.T_IPS_REALDATATEMPORARY.getDTByOrgNo(sw);
//DataTable dtPatrol = BaseDT.T_IPS_REALDATATEMPORARY.getPATROLCOUNTDTByOrgNo(sw);//获取巡检信息 含未检和已检
if (PublicCls.OrgIsShi(sw.TopORGNO))
{
//dtHRRealData = BaseDT.T_IPS_REALDATATEMPORARY.getDTShi(sw);
//dtPatrol = BaseDT.T_IPSFR_ROUTERAIL_PATROL.getDTShi(sw);//获取巡检信息 含未检和已检
dtHU = BaseDT.T_IPSFR_USER.getDTShi(new T_IPSFR_USER_SW {
});
}
else if (PublicCls.OrgIsXian(sw.TopORGNO))
{
//dtHRRealData = BaseDT.T_IPS_REALDATATEMPORARY.getDTXain(sw);
//dtPatrol = BaseDT.T_IPSFR_ROUTERAIL_PATROL.getDTXain(sw);//获取巡检信息 含未检和已检
dtHU = BaseDT.T_IPSFR_USER.getDTXain(new T_IPSFR_USER_SW {
BYORGNO = sw.TopORGNO
});
}
else
{
//dtHRRealData = BaseDT.T_IPS_REALDATATEMPORARY.getDTZhen(sw);
//dtPatrol = BaseDT.T_IPSFR_ROUTERAIL_PATROL.getDTZhen(sw);//获取巡检信息 含未检和已检
dtHU = BaseDT.T_IPSFR_USER.getDT(new T_IPSFR_USER_SW {
ISENABLE = "1", BYORGNO = sw.TopORGNO
});
}
int days = ClsStr.getDateDiff(sw.DateBegin, sw.DateEnd) + 1;//日期包含天数
if (PublicCls.OrgIsZhen(sw.TopORGNO))
{
DataRow[] drOrg = dtHU.Select("", "");
for (int i = 0; i < drOrg.Length; i++)
{
HUReport_PatrolRouteStat_Model m = new HUReport_PatrolRouteStat_Model();
m.ORGName = drOrg[i]["HNAME"].ToString();
m.ORGNo = drOrg[i]["HID"].ToString();
string CHr = "";// BaseDT.T_IPSFR_USER.getCountByOrgNo(dtHU, m.ORGNo).ToString();
if (CHr != "0")
{
CHr = days.ToString();
string Chr0 = BaseDT.T_IPS_REALDATATEMPORARY.getDTByOrgNoSum(dtHRRealData, m.ORGNo).ToString();
string Chr1 = ClsStr.getDiff(CHr, Chr0).ToString("F0");
string Chr2 = ClsStr.getPercent(Chr0, CHr).ToString("F0");
m.LineCount = CHr; //总
m.LineCount0 = Chr0; //完成
m.LineCount1 = Chr1; //未完成
m.LineCount2 = Chr2 + "%"; //完成率
}
//巡检与漏检
string CCHr = dtHRRealData.Compute("sum(C1)", "BYORGNO='" + m.ORGNo + "'").ToString();
CCHr = (string.IsNullOrEmpty(CCHr) ? "0" : CCHr);
if (CCHr != "0")
{
string Chr0 = dtHRRealData.Compute("sum(C2)", "BYORGNO='" + m.ORGNo + "'").ToString(); // BaseDT.T_IPSFR_ROUTERAIL_PATROL.getSumByOrgNo(dtPatrol, m.ORGNo, "1");
Chr0 = (string.IsNullOrEmpty(Chr0) ? "0" : Chr0);
string Chr1 = dtHRRealData.Compute("sum(C3)", "BYORGNO='" + m.ORGNo + "'").ToString(); // BaseDT.T_IPSFR_ROUTERAIL_PATROL.getSumByOrgNo(dtPatrol, m.ORGNo, "0");
Chr1 = (string.IsNullOrEmpty(Chr1) ? "0" : Chr1);
string Chr2 = ClsStr.getPercent(Chr0, CCHr).ToString("F0");
m.PointCount = CCHr;
m.PointCount0 = Chr0;
m.PointCount1 = Chr1;
m.PointCount2 = Chr2 + "%";
}
result.Add(m);
}
dtHU.Clear();
dtHU.Dispose();
}
else
{
T_SYS_ORGSW swOrg = new T_SYS_ORGSW();
swOrg.SYSFLAG = ConfigCls.getSystemFlag();
swOrg.TopORGNO = sw.TopORGNO;
if (PublicCls.OrgIsShi(sw.TopORGNO))
{
swOrg.GetContyORGNOByCity = sw.TopORGNO;//获取所有县
}
if (PublicCls.OrgIsXian(sw.TopORGNO))
{
swOrg.GetXZOrgNOByConty = sw.TopORGNO;//获取所有镇
}
DataTable dtOrg = BaseDT.T_SYS_ORG.getDT(swOrg);
DataRow[] drOrg = dtOrg.Select("", "ORGNO");//取所有
for (int i = 0; i < drOrg.Length; i++)
{
// string orgName = drOrg[i]["ORGNAME"].ToString();
//string orgNo = drOrg[i]["ORGNO"].ToString();
HUReport_PatrolRouteStat_Model m = new HUReport_PatrolRouteStat_Model();
m.ORGName = drOrg[i]["ORGNAME"].ToString();
m.ORGNo = drOrg[i]["ORGNO"].ToString();
string CHr = BaseDT.T_IPSFR_USER.getSumByOrgNo(dtHU, m.ORGNo);//各单位护林员个数
if (CHr != "0")
{
CHr = (int.Parse(CHr) * days).ToString();
string Chr0 = BaseDT.T_IPS_REALDATATEMPORARY.getDTByOrgNoSum(dtHRRealData, m.ORGNo).ToString();
string Chr1 = ClsStr.getDiff(CHr, Chr0).ToString("F0");
string Chr2 = ClsStr.getPercent(Chr0, CHr).ToString("F0");
m.LineCount = CHr; //总
m.LineCount0 = Chr0; //完成
m.LineCount1 = Chr1; //未完成
m.LineCount2 = Chr2 + "%"; //完成率
}
//巡检与漏检
//巡检与漏检
string CCHr = dtHRRealData.Compute("sum(C1)", "BYORGNO='" + m.ORGNo + "'").ToString();
CCHr = (string.IsNullOrEmpty(CCHr) ? "0" : CCHr);
if (CCHr != "0")
{
string Chr0 = dtHRRealData.Compute("sum(C2)", "BYORGNO='" + m.ORGNo + "'").ToString(); // BaseDT.T_IPSFR_ROUTERAIL_PATROL.getSumByOrgNo(dtPatrol, m.ORGNo, "1");
Chr0 = (string.IsNullOrEmpty(Chr0) ? "0" : Chr0);
string Chr1 = dtHRRealData.Compute("sum(C3)", "BYORGNO='" + m.ORGNo + "'").ToString(); // BaseDT.T_IPSFR_ROUTERAIL_PATROL.getSumByOrgNo(dtPatrol, m.ORGNo, "0");
Chr1 = (string.IsNullOrEmpty(Chr1) ? "0" : Chr1);
string Chr2 = ClsStr.getPercent(Chr0, CCHr).ToString("F0");
m.PointCount = CCHr;
m.PointCount0 = Chr0;
m.PointCount1 = Chr1;
m.PointCount2 = Chr2 + "%";
}
result.Add(m);
}
dtOrg.Clear();
dtOrg.Dispose();
}
//dtPatrol.Clear();
//dtPatrol.Dispose();
dtHRRealData.Clear();
dtHRRealData.Dispose();
if (1 == 1)
{
HUReport_PatrolRouteStat_Model m = new HUReport_PatrolRouteStat_Model();
m.ORGName = "合计";
string LineCount = result.Sum(item => Convert.ToDecimal(item.LineCount)).ToString();
string LineCount0 = result.Sum(item => Convert.ToDecimal(item.LineCount0)).ToString();
string PointCount = result.Sum(item => Convert.ToDecimal(item.PointCount)).ToString();
string PointCount0 = result.Sum(item => Convert.ToDecimal(item.PointCount0)).ToString();
m.LineCount = LineCount;
m.LineCount0 = LineCount0;
m.LineCount1 = result.Sum(item => Convert.ToDecimal(item.LineCount1)).ToString();
m.LineCount2 = ClsStr.getPercent(LineCount0, LineCount).ToString("F0") + "%";
m.PointCount = PointCount;
m.PointCount0 = PointCount0;
m.PointCount1 = result.Sum(item => Convert.ToDecimal(item.PointCount1)).ToString();
m.PointCount2 = ClsStr.getPercent(PointCount0, PointCount).ToString("F0") + "%";
result.Insert(0, m);
}
return(result);
}
/// <summary>
/// 分页获取用户列表
/// </summary>
/// <param name="sw">参见模型</param>
/// <param name="total">记录总数</param>
/// <returns>参见模型</returns>
public static IEnumerable <PEST_COLLECTDATA_Model> getModeList(PEST_COLLECTDATA_SW sw, out int total)
{
var result = new List <PEST_COLLECTDATA_Model>();
DataTable dt = BaseDT.PEST_COLLECTDATA.getDT(sw, out total);
DataTable dtORG = BaseDT.T_SYS_ORG.getDT(new T_SYS_ORGSW {
SYSFLAG = ConfigCls.getSystemFlag()
}); //获取单位
DataTable dtBiolo = BaseDT.T_SYS_BIOLOGICALTYPE.getDT(new T_SYS_BIOLOGICALTYPE_SW()); //生物类别
DataTable dt102 = BaseDT.T_SYS_DICT.getDT(new T_SYS_DICTSW {
DICTTYPEID = "102"
}); //危害部位
DataTable dt103 = BaseDT.T_SYS_DICT.getDT(new T_SYS_DICTSW {
DICTTYPEID = "103"
}); //危害程度
DataTable dt104 = BaseDT.T_SYS_DICT.getDT(new T_SYS_DICTSW {
DICTTYPEID = "104"
}); //处理状态
DataTable dt123 = BaseDT.T_SYS_DICT.getDT(new T_SYS_DICTSW {
DICTTYPEID = "123"
}); //调查类型
for (int i = 0; i < dt.Rows.Count; i++)
{
PEST_COLLECTDATA_Model m = new PEST_COLLECTDATA_Model();
m.PESTCOLLDATAID = dt.Rows[i]["PESTCOLLDATAID"].ToString();
m.HID = dt.Rows[i]["HID"].ToString();
m.COLLECTRESOURCE = dt.Rows[i]["COLLECTRESOURCE"].ToString();
m.BYORGNO = dt.Rows[i]["BYORGNO"].ToString();
m.BYORGNONAME = BaseDT.T_SYS_ORG.getName(dtORG, m.BYORGNO);
m.VILLAGENAME = dt.Rows[i]["VILLAGENAME"].ToString();
m.SMALLADDRESS = dt.Rows[i]["SMALLADDRESS"].ToString();
m.SMALLCLASSCODE = dt.Rows[i]["SMALLCLASSCODE"].ToString();
m.SMALLCLASSAREA = dt.Rows[i]["SMALLCLASSAREA"].ToString();
m.HOSTTREESPECIESCODE = dt.Rows[i]["HOSTTREESPECIESCODE"].ToString();
m.HOSTTREESPECIESNAME = BaseDT.T_SYS_BIOLOGICALTYPE.getName(dtBiolo, m.HOSTTREESPECIESCODE);
m.SEARCHTYPE = dt.Rows[i]["SEARCHTYPE"].ToString();
m.SEARCHTYPENAME = BaseDT.T_SYS_DICT.getName(dt123, m.SEARCHTYPE);
m.COLLECTPESTCODE = dt.Rows[i]["COLLECTPESTCODE"].ToString();
m.COLLECTPESTNAME = BaseDT.T_SYS_BIOLOGICALTYPE.getName(dtBiolo, m.COLLECTPESTCODE);
m.HARMPOSITION = dt.Rows[i]["HARMPOSITION"].ToString();
m.HARMPOSITIONNAME = BaseDT.T_SYS_DICT.getName(dt102, m.HARMPOSITION);
m.HARMLEVEL = dt.Rows[i]["HARMLEVEL"].ToString();
m.HARMLEVELNAME = BaseDT.T_SYS_DICT.getName(dt103, m.HARMPOSITION);
m.DEADCOUNT = dt.Rows[i]["DEADCOUNT"].ToString();
m.UNKNOWNDIEOFFCOUNT = dt.Rows[i]["UNKNOWNDIEOFFCOUNT"].ToString();
m.ELSEDIEOFFCOUNT = dt.Rows[i]["ELSEDIEOFFCOUNT"].ToString();
m.SAMPLECOUNT = dt.Rows[i]["SAMPLECOUNT"].ToString();
m.MARK = dt.Rows[i]["MARK"].ToString();
m.UPLOADTIME = PublicClassLibrary.ClsSwitch.SwitDate(dt.Rows[i]["UPLOADTIME"].ToString());
m.MANSTATE = dt.Rows[i]["MANSTATE"].ToString();
m.MANSTATENAME = BaseDT.T_SYS_DICT.getName(dt104, m.MANSTATE);
m.MANRESULT = dt.Rows[i]["MANRESULT"].ToString();
m.MANTIME = PublicClassLibrary.ClsSwitch.SwitDate(dt.Rows[i]["MANTIME"].ToString());
m.MANUSERID = dt.Rows[i]["MANUSERID"].ToString();
m.KID = dt.Rows[i]["KID"].ToString();
m.JWDLIST = dt.Rows[i]["JWDLIST"].ToString();
result.Add(m);
}
dt.Clear();
dt.Dispose();
dtORG.Clear();
dtORG.Dispose();
dtBiolo.Clear();
dtBiolo.Dispose();
dt102.Clear();
dt102.Dispose();
dt103.Clear();
dt103.Dispose();
dt104.Clear();
dt104.Dispose();
dt123.Clear();
dt123.Dispose();
return(result);
}
/// <summary>
/// 组合队伍的树形菜单
/// </summary>
/// <returns></returns>
public static string getArmytree()
{
JArray childobjArray = new JArray();
JObject root = new JObject
{
{ "text", "专职人员" },
};
DataTable dtOrg = BaseDT.T_SYS_ORG.getDT(new T_SYS_ORGSW {
SYSFLAG = ConfigCls.getSystemFlag()
});
DataTable dtUser = BaseDT.DC_FULLTIMEUSER.getDT(new DC_FULLTIMEUSER_SW {
});
if (dtOrg.Rows.Count > 0)
{
root.Add("children", DC_FULLTIMEUSERCls.getFULLTIMEUSERORGChild(dtOrg, dtUser));
childobjArray.Add(root);
}
DataRow[] drOrg = dtOrg.Select("", "ORGNO");
JObject root1 = new JObject
{
{ "text", "护林员" },
};
DataTable dtFRUser = BaseDT.T_IPSFR_USER.getDT(new T_IPSFR_USER_SW {
});
if (drOrg.Length > 0)
{
root1.Add("children", T_IPSFR_USERCls.getDatacenterTreeChild(dtOrg, dtFRUser, drOrg[0]["ORGNO"].ToString()));
childobjArray.Add(root1);
}
JObject root2 = new JObject
{
{ "text", "专业队" },
};
DataTable dtTYPE = BaseDT.DC_TYPE.getDT(new DC_TYPE_SW {
DCTYPEFLAG = "Army"
});
DataTable dtPROTEAM = BaseDT.DC_PROTEAM.getDT(new DC_PROTEAM_SW {
});
string dctypetopid = BaseDT.DC_TYPE.getID(new DC_TYPE_SW {
DCTYPEFLAG = "Army", DCTYPETOPID = "0"
});
root2.Add("children", DC_PROTEAMCls.getPROTEAMchild(dtTYPE, dtPROTEAM, dctypetopid));
childobjArray.Add(root2);
JObject root3 = new JObject
{
{ "text", "瞭望" },
};
//childobjArray.Add(root3);
DataTable dtWATCHTOWER = BaseDT.DC_WATCHTOWER.getDT(new DC_WATCHTOWER_SW {
});
if (drOrg.Length > 0)
{
root3.Add("children", DC_WATCHTOWERCls.getWATCHTOWERRORGChild(dtOrg, dtWATCHTOWER));
childobjArray.Add(root3);
}
dtFRUser.Clear();
dtFRUser.Dispose();
dtOrg.Clear();
dtOrg.Dispose();
dtUser.Clear();
dtUser.Dispose();
return(JsonConvert.SerializeObject(childobjArray));
}
/// <summary>
/// 获取分页
/// </summary>
/// <param name="sw">参见模型</param>
/// <param name="total">记录总数</param>
/// <returns>参见模型</returns>
public static IEnumerable <DC_EQUIP_NEW_Model> getModelList(DC_EQUIP_NEW_SW sw, out int total)
{
var result = new List <DC_EQUIP_NEW_Model>();
DataTable dt = BaseDT.DC_EQUIP_NEW.getDT(sw, out total);//列表
DataTable dtORG = BaseDT.T_SYS_ORG.getDT(new T_SYS_ORGSW {
SYSFLAG = ConfigCls.getSystemFlag()
}); //获取单位
DataTable dt32 = BaseDT.T_SYS_DICT.getDT(new T_SYS_DICTSW {
DICTTYPEID = "32"
}); //数据中心装备类型
DataTable dt36 = BaseDT.T_SYS_DICT.getDT(new T_SYS_DICTSW {
DICTTYPEID = "36"
}); //使用现状
for (int i = 0; i < dt.Rows.Count; i++)
{
DC_EQUIP_NEW_Model m = new DC_EQUIP_NEW_Model();
m.DC_EQUIP_NEW_ID = dt.Rows[i]["DC_EQUIP_NEW_ID"].ToString();
m.EQUIPTYPE = dt.Rows[i]["EQUIPTYPE"].ToString();
m.EQUIPTYPEName = BaseDT.T_SYS_DICT.getName(dt32, m.EQUIPTYPE);
m.NUMBER = dt.Rows[i]["NUMBER"].ToString();
m.NAME = dt.Rows[i]["NAME"].ToString();
m.BYORGNO = dt.Rows[i]["BYORGNO"].ToString();
//m.ORGName = BaseDT.T_SYS_ORG.getName(dtORG, m.BYORGNO);
if (m.BYORGNO.Substring(6, 3) != "000" && m.BYORGNO.Substring(9, 6) == "000000")
{
m.ORGName = BaseDT.T_SYS_ORG.getName(dtORG, m.BYORGNO);
}
m.ORGXSName = BaseDT.T_SYS_ORG.getSXName(dtORG, m.BYORGNO);
m.MODEL = dt.Rows[i]["MODEL"].ToString();
m.BUYYEAR = PublicClassLibrary.ClsSwitch.SwitDate(dt.Rows[i]["BUYYEAR"].ToString());
m.USESTATE = dt.Rows[i]["USESTATE"].ToString();
m.USESTATEName = BaseDT.T_SYS_DICT.getName(dt36, m.USESTATE);
m.STOREADDR = dt.Rows[i]["STOREADDR"].ToString();
m.MARK = dt.Rows[i]["MARK"].ToString();
m.JD = dt.Rows[i]["JD"].ToString();
m.WD = dt.Rows[i]["WD"].ToString();
m.WORTH = dt.Rows[i]["WORTH"].ToString();
m.EQUIPAMOUNT = dt.Rows[i]["EQUIPAMOUNT"].ToString();
m.REPID = dt.Rows[i]["REPID"].ToString();
m.DCSUPPROPUNIT = dt.Rows[i]["DCSUPPROPUNIT"].ToString();
m.PRICE = dt.Rows[i]["PRICE"].ToString();
if (string.IsNullOrEmpty(m.REPID) == false)
{
m.REPNAME = DC_REPOSITORYCls.getdepotname(m.REPID);
}
else
{
m.REPNAME = "";
}
result.Add(m);
}
dt.Clear();
dt.Dispose();
dtORG.Clear();
dtORG.Dispose();
dt32.Clear();
dt32.Dispose();
dt36.Clear();
dt36.Dispose();
return(result);
}
/// <summary>
/// 根据查询条件获取某一条用户信息记录，用于修改、删除、用户登录验证
/// </summary>
/// <param name="sw">参见模型</param>
/// <returns>参见模型</returns>
public static DC_UTILITY_ISOLATIONSTRIP_Model getModel(DC_UTILITY_ISOLATIONSTRIP_SW sw)
{
var result = new List <DC_UTILITY_ISOLATIONSTRIP_Model>();
DataTable dt = BaseDT.DC_UTILITY_ISOLATIONSTRIP.getDT(sw);//列表
DataTable dtORG = BaseDT.T_SYS_ORG.getDT(new T_SYS_ORGSW {
SYSFLAG = ConfigCls.getSystemFlag()
}); //获取单位
DataTable dt35 = BaseDT.T_SYS_DICT.getDT(new T_SYS_DICTSW {
DICTTYPEID = "35"
}); //防火隔离带类型
DataTable dt36 = BaseDT.T_SYS_DICT.getDT(new T_SYS_DICTSW {
DICTTYPEID = "36"
}); //使用现状
DataTable dt37 = BaseDT.T_SYS_DICT.getDT(new T_SYS_DICTSW {
DICTTYPEID = "37"
}); //维护类型
DataTable dt52 = BaseDT.T_SYS_DICT.getDT(new T_SYS_DICTSW {
DICTTYPEID = "52"
}); //树种
DataTable dt53 = BaseDT.T_SYS_DICT.getDT(new T_SYS_DICTSW {
DICTTYPEID = "53"
}); //规划生物隔离带位置
DC_UTILITY_ISOLATIONSTRIP_Model m = new DC_UTILITY_ISOLATIONSTRIP_Model();
if (dt.Rows.Count > 0)
{
int i = 0;
m.DC_UTILITY_ISOLATIONSTRIP_ID = dt.Rows[i]["DC_UTILITY_ISOLATIONSTRIP_ID"].ToString();
m.ISOLATIONTYPE = dt.Rows[i]["ISOLATIONTYPE"].ToString();
m.ISOLATIONTYPEName = BaseDT.T_SYS_DICT.getName(dt35, m.ISOLATIONTYPE);
m.NUMBER = dt.Rows[i]["NUMBER"].ToString();
m.NAME = dt.Rows[i]["NAME"].ToString();
m.BYORGNO = dt.Rows[i]["BYORGNO"].ToString();
m.BUILDDATE = PublicClassLibrary.ClsSwitch.SwitDate(dt.Rows[i]["BUILDDATE"].ToString());
m.ENTRYTIME = PublicClassLibrary.ClsSwitch.SwitDate(dt.Rows[i]["ENTRYTIME"].ToString());
//m.ENTRYTIME = ClsSwitch.SwitTM(dt.Rows[i]["ENTRYTIME"].ToString());
m.USESTATE = dt.Rows[i]["USESTATE"].ToString();
m.USESTATEName = BaseDT.T_SYS_DICT.getName(dt36, m.USESTATE);
m.MANAGERSTATE = dt.Rows[i]["MANAGERSTATE"].ToString();
m.MANAGERSTATEName = BaseDT.T_SYS_DICT.getName(dt37, m.MANAGERSTATE);
m.WIDTH = dt.Rows[i]["WIDTH"].ToString();
m.LENGTH = dt.Rows[i]["LENGTH"].ToString();
m.JDBEGIN = dt.Rows[i]["JDBEGIN"].ToString();
m.WDBEGIN = dt.Rows[i]["WDBEGIN"].ToString();
m.JDEND = dt.Rows[i]["JDEND"].ToString();
m.WDEND = dt.Rows[i]["WDEND"].ToString();
m.JWDLIST = dt.Rows[i]["JWDLIST"].ToString();
m.PLANAREA = dt.Rows[i]["PLANAREA"].ToString();
m.REALAREA = dt.Rows[i]["REALAREA"].ToString();
m.WORTH = dt.Rows[i]["WORTH"].ToString();
m.KINDTYPE = dt.Rows[i]["KINDTYPE"].ToString();
m.TREETYPE = dt.Rows[i]["TREETYPE"].ToString();
m.TREETYPEName = BaseDT.T_SYS_DICT.getName(dt52, m.TREETYPE);
m.Position = dt.Rows[i]["POSITION"].ToString();
m.PositionName = BaseDT.T_SYS_DICT.getName(dt53, m.Position);
m.Price = dt.Rows[i]["PRICE"].ToString();
m.AlleywayWideth = dt.Rows[i]["ALLEYWAYWIDETH"].ToString();
m.ORGName = BaseDT.T_SYS_ORG.getName(dtORG, m.BYORGNO);
m.BUILDDATEBEGIN = PublicClassLibrary.ClsSwitch.SwitDate(dt.Rows[i]["BUILDDATEBEGIN"].ToString());
m.BUILDDATEEND = PublicClassLibrary.ClsSwitch.SwitDate(dt.Rows[i]["BUILDDATEEND"].ToString());
}
dt.Clear();
dt.Dispose();
dtORG.Clear();
dtORG.Dispose();
dt35.Clear();
dt35.Dispose();
dt36.Clear();
dt36.Dispose();
dt37.Clear();
dt37.Dispose();
return(m);
}
/// <summary>
/// 根据查询条件获取某一条用户信息记录，用于修改、删除、用户登录验证
/// </summary>
/// <param name="sw">参见模型</param>
/// <returns>参见模型</returns>
public static DC_UTILITY_FIRECHANNEL_Model getModel(DC_UTILITY_FIRECHANNEL_SW sw)
{
var result = new List <DC_UTILITY_FIRECHANNEL_Model>();
DataTable dt = BaseDT.DC_UTILITY_FIRECHANNEL.getDT(sw);//列表
DataTable dtORG = BaseDT.T_SYS_ORG.getDT(new T_SYS_ORGSW {
SYSFLAG = ConfigCls.getSystemFlag()
}); //获取单位
DataTable dt36 = BaseDT.T_SYS_DICT.getDT(new T_SYS_DICTSW {
DICTTYPEID = "36"
}); //使用现状
DataTable dt37 = BaseDT.T_SYS_DICT.getDT(new T_SYS_DICTSW {
DICTTYPEID = "37"
}); //维护类型
DataTable dt38 = BaseDT.T_SYS_DICT.getDT(new T_SYS_DICTSW {
DICTTYPEID = "38"
}); //防火通道等级类型
DataTable dt39 = BaseDT.T_SYS_DICT.getDT(new T_SYS_DICTSW {
DICTTYPEID = "39"
}); //防火通道使用性质
DC_UTILITY_FIRECHANNEL_Model m = new DC_UTILITY_FIRECHANNEL_Model();
if (dt.Rows.Count > 0)
{
int i = 0;
m.DC_UTILITY_FIRECHANNEL_ID = dt.Rows[i]["DC_UTILITY_FIRECHANNEL_ID"].ToString();
m.NUMBER = dt.Rows[i]["NUMBER"].ToString();
m.NAME = dt.Rows[i]["NAME"].ToString();
m.BYORGNO = dt.Rows[i]["BYORGNO"].ToString();
m.BUILDDATE = PublicClassLibrary.ClsSwitch.SwitDate(dt.Rows[i]["BUILDDATE"].ToString());
m.BUILDDATEBEGIN = PublicClassLibrary.ClsSwitch.SwitDate(dt.Rows[i]["BUILDDATEBEGIN"].ToString());
m.BUILDDATEEND = PublicClassLibrary.ClsSwitch.SwitDate(dt.Rows[i]["BUILDDATEEND"].ToString());
m.USESTATE = dt.Rows[i]["USESTATE"].ToString();
m.USESTATEName = BaseDT.T_SYS_DICT.getName(dt36, m.USESTATE);
m.MANAGERSTATE = dt.Rows[i]["MANAGERSTATE"].ToString();
m.MANAGERSTATEName = BaseDT.T_SYS_DICT.getName(dt37, m.MANAGERSTATE);
m.FIRECHANNELLEVELTYPE = dt.Rows[i]["FIRECHANNELLEVELTYPE"].ToString();
m.FIRECHANNELLEVELTYPEName = BaseDT.T_SYS_DICT.getName(dt38, m.FIRECHANNELLEVELTYPE);
m.FIRECHANNELUSERTYPE = dt.Rows[i]["FIRECHANNELUSERTYPE"].ToString();
m.FIRECHANNELUSERTYPEName = BaseDT.T_SYS_DICT.getName(dt39, m.FIRECHANNELUSERTYPE);
m.LENGTH = dt.Rows[i]["LENGTH"].ToString();
m.JDBEGIN = dt.Rows[i]["JDBEGIN"].ToString();
m.WDBEGIN = dt.Rows[i]["WDBEGIN"].ToString();
m.JDEND = dt.Rows[i]["JDEND"].ToString();
m.WDEND = dt.Rows[i]["WDEND"].ToString();
m.JWDLIST = dt.Rows[i]["JWDLIST"].ToString();
m.WORTH = dt.Rows[i]["WORTH"].ToString();
m.ORGName = BaseDT.T_SYS_ORG.getName(dtORG, m.BYORGNO);
}
dt.Clear();
dt.Dispose();
dtORG.Clear();
dtORG.Dispose();
dt36.Clear();
dt36.Dispose();
dt37.Clear();
dt37.Dispose();
dt38.Clear();
dt38.Dispose();
dt39.Clear();
dt39.Dispose();
return(m);
}
/// <summary>
/// 获取档案统计列表
/// </summary>
/// <param name="sw">参见模型</param>
/// <returns>参见模型</returns>
public static IEnumerable <JC_FIRE_Model> getList(JC_FIRE_SW sw)
{
var result = new List <JC_FIRE_Model>();
var dt = new DataTable();
DataTable dtprop = BaseDT.JC_FIRE_PROP.getDT(new JC_FIRE_PROP_SW {
});
if (sw.TYPE == "3")
{
dt = BaseDT.JC_FIRE.GetArchivalDT(sw);
}
if (sw.TYPE == "1")
{
dt = BaseDT.JC_FIRE.GetDTHottype(sw);
}
if (sw.TYPE == "2")
{
dt = BaseDT.JC_FIRE.GetDTFirelevel(sw);
}
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()
}); //获取单位
DataTable dt10 = BaseDT.T_SYS_DICT.getDT(new T_SYS_DICTSW {
DICTTYPEID = "10"
}); //热点类别
DataTable dt22 = BaseDT.T_SYS_DICT.getDT(new T_SYS_DICTSW {
DICTTYPEID = "22"
}); //火灾等级
for (int i = 0; i < dt.Rows.Count; i++)
{
JC_FIRE_Model m = new JC_FIRE_Model();
m.JCFID = dt.Rows[i]["JCFID"].ToString();
m.BYORGNO = dt.Rows[i]["BYORGNO"].ToString();
m.ORGNAME = BaseDT.T_SYS_ORG.getName(dtORG, dt.Rows[i]["BYORGNO"].ToString());
m.FIRENAME = dt.Rows[i]["FIRENAME"].ToString();
//m.FIRELEVEL = BaseDT.JC_FIRE_PROP.getfirelevel(dtprop, dt.Rows[i]["JCFID"].ToString());
m.FIRELEVEL = dt.Rows[i]["FIRELEVEL"].ToString();
m.FIRELEVELName = BaseDT.T_SYS_DICT.getName(dt22, m.FIRELEVEL);
m.FIREFROM = dt.Rows[i]["FIREFROM"].ToString();//火情来源
if (m.FIREFROM == "1")
{
m.FIREFROMName = "红外相机";
}
if (m.FIREFROM == "2")
{
m.FIREFROMName = "卫星监控";
}
if (m.FIREFROM == "3")
{
m.FIREFROMName = "电话报警";
}
if (m.FIREFROM == "4")
{
m.FIREFROMName = "电子监控";
}
if (m.FIREFROM == "5")
{
m.FIREFROMName = "瞭望护林员";
}
if (m.FIREFROM == "6")
{
m.FIREFROMName = "无人机巡护";
}
//DataTable dtfireticking = BaseDT.JC_FIRETICKLING.Latestfeedback(new JC_FIRETICKLING_SW { JCFID = dt.Rows[i]["JCFID"].ToString()});
//m.HOTTYPE = BaseDT.JC_FIRETICKLING.gethotetype(dtfireticking, dt.Rows[i]["JCFID"].ToString());
m.HOTTYPE = dt.Rows[i]["HOTTYPE"].ToString();
m.HOTTYPEName = BaseDT.T_SYS_DICT.getName(dt10, m.HOTTYPE);
m.FIREFROMID = dt.Rows[i]["FIREFROMID"].ToString(); //原始记录序号
m.FIRETIME = ClsSwitch.SwitTM(dt.Rows[i]["FIRETIME"].ToString()); //起火时间
m.MARK = dt.Rows[i]["MARK"].ToString();
m.JD = dt.Rows[i]["JD"].ToString();
m.WD = dt.Rows[i]["WD"].ToString();
m.ZQWZ = dt.Rows[i]["ZQWZ"].ToString();
m.WXBH = dt.Rows[i]["WXBH"].ToString();
m.DQRDBH = dt.Rows[i]["DQRDBH"].ToString();
m.RSMJ = dt.Rows[i]["RSMJ"].ToString();
m.DL = dt.Rows[i]["DL"].ToString();
m.YY = dt.Rows[i]["YY"].ToString();
m.ISOUTFIRE = dt.Rows[i]["ISOUTFIRE"].ToString();
m.JXHQSJ = dt.Rows[i]["JXHQSJ"].ToString();
m.RECEIVETIME = ClsSwitch.SwitTM(dt.Rows[i]["RECEIVETIME"].ToString());
m.FIREENDTIME = ClsSwitch.SwitTM(dt.Rows[i]["FIREENDTIME"].ToString());
m.ISSUEDTIME = ClsSwitch.SwitTM(dt.Rows[i]["ISSUEDTIME"].ToString());
m.MANSTATE = dt.Rows[i]["MANSTATE"].ToString();
//m.ISSUEDTIME = ClsSwitch.SwitTM(dt.Rows[i]["LASTPROCESSTIME"].ToString());
//m.FIRELEVEL = dt.Rows[i]["FIRELEVEL"].ToString();
m.ORGNAME = BaseDT.T_SYS_ORG.getName(dtORG, m.BYORGNO);
m.PFUSERID = dt.Rows[i]["PFUSERID"].ToString();
m.PFNAME = BaseDT.T_SYSSEC_USER.getName(dtUser, m.PFUSERID);
m.FirePropModel = null;//需要再扩充
result.Add(m);
}
dt.Clear();
dt.Dispose();
dtUser.Clear();
dtUser.Dispose();
dtORG.Clear();
dtORG.Dispose();
return(result);
}
/// <summary>
/// 获取火灾等级单条记录
/// </summary>
/// <param name="sw"></param>
/// <returns></returns>
public static JC_FIRE_Model getModel(JC_FIRE_SW sw)
{
DataTable dt = BaseDT.JC_FIRE.GetDT(sw);
DataTable dtORG = BaseDT.T_SYS_ORG.getDT(new T_SYS_ORGSW {
SYSFLAG = ConfigCls.getSystemFlag()
}); //获取单位
DataTable dtUser = BaseDT.T_SYSSEC_USER.getDT(new T_SYSSEC_IPSUSER_SW {
});
JC_FIRE_Model m = new JC_FIRE_Model();
if (dt.Rows.Count > 0)
{
int i = 0;
m.JCFID = dt.Rows[i]["JCFID"].ToString();
m.BYORGNO = dt.Rows[i]["BYORGNO"].ToString();
m.FIRENAME = dt.Rows[i]["FIRENAME"].ToString();
m.FIREFROM = dt.Rows[i]["FIREFROM"].ToString();//火情来源
// 红外相机 = 1,
//卫星监控 = 2,
//电话报警 = 3,
//电子监控 = 4,
//瞭望护林员 = 5,
//无人机巡护 = 6
if (m.FIREFROM == "1")
{
m.FIREFROMName = "红外相机";
}
if (m.FIREFROM == "2")
{
m.FIREFROMName = "卫星热点";
}
if (m.FIREFROM == "3")
{
m.FIREFROMName = "电话报警";
}
if (m.FIREFROM == "4")
{
m.FIREFROMName = "电子监控";
}
if (m.FIREFROM == "5")
{
m.FIREFROMName = "瞭望护林员";
}
if (m.FIREFROM == "6")
{
m.FIREFROMName = "无人机巡护";
}
if (m.FIREFROM == "50")
{
m.FIREFROMName = "历史补录";
}
m.FIREFROMID = dt.Rows[i]["FIREFROMID"].ToString(); //原始记录序号
m.FIRETIME = ClsSwitch.SwitTM(dt.Rows[i]["FIRETIME"].ToString()); //起火时间
m.MARK = dt.Rows[i]["MARK"].ToString();
m.JD = dt.Rows[i]["JD"].ToString();
m.WD = dt.Rows[i]["WD"].ToString();
m.ZQWZ = dt.Rows[i]["ZQWZ"].ToString();
m.WXBH = dt.Rows[i]["WXBH"].ToString();
m.DQRDBH = dt.Rows[i]["DQRDBH"].ToString();
m.RSMJ = dt.Rows[i]["RSMJ"].ToString();
m.DL = dt.Rows[i]["DL"].ToString();
m.YY = dt.Rows[i]["YY"].ToString();
m.JXHQSJ = dt.Rows[i]["JXHQSJ"].ToString();
m.ISOUTFIRE = dt.Rows[i]["ISOUTFIRE"].ToString();
m.RECEIVETIME = ClsSwitch.SwitTM(dt.Rows[i]["RECEIVETIME"].ToString());
m.ISSUEDTIME = ClsSwitch.SwitTM(dt.Rows[i]["ISSUEDTIME"].ToString());
m.PFUSERID = dt.Rows[i]["PFUSERID"].ToString();
//m.FIRELEVEL = dt.Rows[i]["FIRELEVEL"].ToString();
m.MANSTATE = dt.Rows[i]["MANSTATE"].ToString();
m.FIREENDTIME = ClsSwitch.SwitTM(dt.Rows[i]["FIREENDTIME"].ToString());
m.PFNAME = BaseDT.T_SYSSEC_USER.getName(dtUser, m.PFUSERID);
m.PFORGNO = dt.Rows[i]["PFORGNO"].ToString();
m.PFORGNOName = BaseDT.T_SYS_ORG.getName(dtORG, dt.Rows[i]["PFORGNO"].ToString());
m.ORGNAME = BaseDT.T_SYS_ORG.getName(dtORG, m.BYORGNO);
m.FirePropModel = null;//需要再扩充
}
dt.Clear();
dt.Dispose();
dtUser.Clear();
dtUser.Dispose();
dtORG.Clear();
dtORG.Dispose();
return(m);
}
/// <summary>
/// 获取视频列表异步树
/// </summary>
/// <param name="OrgNo"></param>
/// <param name="eid"></param>
/// <returns></returns>
public static string getTree(string OrgNo, string eid)
{
JArray jObjects = new JArray();
string curUserOrg = SystemCls.getCurUserOrgNo();//获取当前登录用户的机构编码
if (string.IsNullOrEmpty(OrgNo) == false)
{
curUserOrg = OrgNo;
}
DataTable dtOrg = BaseDT.T_SYS_ORG.getDT(new T_SYS_ORGSW {
TopORGNO = curUserOrg, SYSFLAG = ConfigCls.getSystemFlag()
}); //获取当前登录用户有权限查看的单位
DataTable dtFRUser = BaseDT.JC_MONITOR_BASICINFO.getDT(new JC_MONITOR_BASICINFO_SW {
BYORGNO = curUserOrg, EMID = eid
}); //获取所有有权限的监控摄像
#region 市级用户
if (PublicCls.OrgIsShi(curUserOrg))
{
DataRow[] drOrg = dtOrg.Select("", "ORGNO");
if (drOrg.Length > 0)
{
JObject root = new JObject
{
{ "id", drOrg[0]["ORGNO"].ToString() },//ORGNO
{ "text", drOrg[0]["ORGNAME"].ToString() },
{ "treeType", "org" },
};
JArray childArray = new JArray();
DataRow[] drOrgC = dtOrg.Select("SUBSTRING(ORGNO,1,4) = '" + curUserOrg.Substring(0, 4) + "' AND ORGNO<>'" + curUserOrg + "' and SUBSTRING(ORGNO,7,3)='000'", "");//获取所有县且〈〉市的
for (int i = 0; i < drOrgC.Length; i++)
{
JObject rootC = new JObject
{
{ "id", drOrgC[i]["ORGNO"].ToString() },//ORGNO
{ "text", drOrgC[i]["ORGNAME"].ToString() },
{ "state", "closed" },
{ "treeType", "org" }
};
childArray.Add(rootC);
}
root.Add("children", childArray);
jObjects.Add(root);
}
}
#endregion
#region 县级用户
else if (PublicCls.OrgIsXian(curUserOrg))
{
DataRow[] drOrg = dtOrg.Select("", "ORGNO");
if (drOrg.Length > 0)
{
JObject root = new JObject
{
{ "id", drOrg[0]["ORGNO"].ToString() },//ORGNO
{ "text", drOrg[0]["ORGNAME"].ToString() },
{ "state", "closed" },
{ "treeType", "org" }
};
JArray jObjectsC = new JArray();
DataRow[] drOrgC = dtOrg.Select("SUBSTRING(ORGNO,1,6) = '" + curUserOrg.Substring(0, 6) + "' AND ORGNO<>'" + curUserOrg + "'", ""); //获取所有县且〈〉市的
for (int i = 0; i < drOrgC.Length; i++)
{
JObject rootC = new JObject
{
{ "id", drOrgC[i]["ORGNO"].ToString() },//ORGNO
{ "text", drOrgC[i]["ORGNAME"].ToString() },
{ "state", "closed" },
{ "treeType", "org" }
};
//root.Add("children", getTreeChild(dtOrg, dtFRUser, dtRealTmp, drOrg[i]["ORGNO"].ToString()));//继续获取护林员
jObjectsC.Add(rootC);
if (string.IsNullOrEmpty(OrgNo) == false)//异步加载，不显示县名
{
jObjects.Add(rootC);
}
}
if (string.IsNullOrEmpty(OrgNo))//县级用户登录
{
jObjects.Add(root);
root.Add("children", jObjectsC);
}
}
}
#endregion
#region 乡镇用户
else
{
DataRow[] drOrg = dtOrg.Select("", "ORGNO");
if (drOrg.Length > 0)
{
JObject root = new JObject
{
{ "id", drOrg[0]["ORGNO"].ToString() },//ORGNO
{ "text", drOrg[0]["ORGNAME"].ToString() },
{ "state", "closed" },
{ "treeType", "org" }
};
DataRow[] drFRUser = dtFRUser.Select("BYORGNO = '" + curUserOrg + "'", "");//获取所有县且〈〉市的
JArray jObjectsC = new JArray();
for (int i = 0; i < drFRUser.Length; i++)
{
StringBuilder sb = new StringBuilder();
JObject rootC = new JObject {
{ "id", drFRUser[i]["EMID"].ToString() }, { "text", drFRUser[i]["EMNAME"].ToString() }, { "objId", drFRUser[i]["OBJID"].ToString() }, { "templateId", drFRUser[i]["TEMPLATEDID"].ToString() }, { "ip", drFRUser[i]["ip"].ToString() }, { "port", drFRUser[i]["PORT"].ToString() }, { "isVideo", true }
};
jObjectsC.Add(rootC);
if (string.IsNullOrEmpty(OrgNo) == false)//异步加载，不显示乡镇名
{
jObjects.Add(rootC);
}
}
if (string.IsNullOrEmpty(OrgNo))//乡镇级用户登录
{
jObjects.Add(root);
root.Add("children", jObjectsC);
}
}
}
#endregion
dtOrg.Clear();
dtOrg.Dispose();
return(JsonConvert.SerializeObject(jObjects));
}
/// <summary>
/// 护林员定位 获取护林员最新一条位置信息
/// </summary>
/// <param name="sw">传递护林员列表 参见条件模型T_IPS_REALDATATEMPORARYSW</param>
/// <returns>参见模型T_IPS_REALDATATEMPORARYModel</returns>
public static IEnumerable <T_IPS_REALDATATEMPORARYModel> getTopOneModelList(T_IPS_REALDATATEMPORARYSW sw)
{
var result = new List <T_IPS_REALDATATEMPORARYModel>();
DataTable dt = BaseDT.T_IPS_REALDATATEMPORARY.getTopOneDT(sw);
DataTable dtOrg = BaseDT.T_SYS_ORG.getDT(new T_SYS_ORGSW {
SYSFLAG = ConfigCls.getSystemFlag()
}); //获取当前登录用户有权限查看的组织机构
DataTable dtFRUser = BaseDT.T_IPSFR_USER.getDT(new T_IPSFR_USER_SW {
ISENABLE = "1", HID = sw.USERID
}); //获取所有有权限查看的护林员
for (int i = 0; i < dt.Rows.Count; i++)
{
T_IPS_REALDATATEMPORARYModel m = new T_IPS_REALDATATEMPORARYModel();
//m.REALDATAID = dt.Rows[i]["REALDATAID"].ToString();
m.USERID = dt.Rows[i]["USERID"].ToString();
m.LONGITUDE = dt.Rows[i]["LONGITUDE"].ToString();
m.LATITUDE = dt.Rows[i]["LATITUDE"].ToString();
m.ORILONGITUDE = dt.Rows[i]["LONGITUDE"].ToString(); //原经度
m.ORILATITUDE = dt.Rows[i]["LATITUDE"].ToString(); //原纬度
if (sw.MapType != "Skyline")
{
//******************计算坐标偏移量
string[] arr = PublicCls.switJWD(m.LATITUDE, m.LONGITUDE);
m.LATITUDE = arr[0];
m.LONGITUDE = arr[1];
//******************计算坐标偏移量 End
}
m.HEIGHT = dt.Rows[i]["HEIGHT"].ToString();
m.ELECTRIC = dt.Rows[i]["ELECTRIC"].ToString();
m.SPEED = dt.Rows[i]["SPEED"].ToString();
m.DIRECTION = dt.Rows[i]["DIRECTION"].ToString();
m.SBTIME = dt.Rows[i]["SBTIME"].ToString();
if (string.IsNullOrEmpty(m.SBTIME) == false)
{
m.SBTIME = PublicClassLibrary.ClsSwitch.SwitTM(m.SBTIME);
}
m.NOTE = dt.Rows[i]["NOTE"].ToString();
m.ORGNO = dt.Rows[i]["ORGNO"].ToString();
m.SBDATE = dt.Rows[i]["SBDATE"].ToString();
m.ISOUTRAIL = dt.Rows[i]["ISOUTRAIL"].ToString();//是否出围
if (string.IsNullOrEmpty(m.SBDATE) == false)
{
m.SBDATE = PublicClassLibrary.ClsSwitch.SwitDate(m.SBDATE);
}
m.SBTIMEBEGIN = dt.Rows[i]["SBTIMEBEGIN"].ToString();
m.PATROLLENGTH = dt.Rows[i]["PATROLLENGTH"].ToString();
DataRow[] drFRUser = dtFRUser.Select("HID=" + m.USERID);
if (drFRUser.Length > 0)
{
m.HNAME = drFRUser[0]["HNAME"].ToString();
m.PHONE = drFRUser[0]["PHONE"].ToString();
m.ORGNO = drFRUser[0]["BYORGNO"].ToString();
m.ORGNAME = BaseDT.T_SYS_ORG.getName(dtOrg, m.ORGNO);
}
double intervalTime = ConfigCls.inLineTimeInterval();
var absTime = Math.Abs(ClsStr.getMinutesDiff(DateTime.Now, m.SBTIME));
m.HSTATE = absTime > intervalTime ? "0" : "1";//护林员在线状态 0 表示离线 1 表示在线
//
//m.ISOUTRAIL
result.Add(m);
}
dt.Clear();
dt.Dispose();
dtOrg.Clear();
dtOrg.Dispose();
dtFRUser.Clear();
dtFRUser.Dispose();
return(result);
}
/// <summary>
/// 根据护林员ID获取在线状态 ，用于点名｜
/// </summary>
/// <param name="sw">参见条件模型T_IPS_REALDATATEMPORARYSW</param>
/// <example>
/// sw.USERID 用户序号（多用户以逗号分隔）
/// sw.SearchTime 判断时间 可为空，为空默认为当前时间
/// </example>
/// <param name="FRUserCount">总人数</param>
/// <param name="FRUserOnLineCount">在线人数</param>
/// <returns>
/// m.HID 护林员序号
/// m.HNAME 姓名
/// m.PHONE 电话
/// m.BYORGNO 机构编码
/// m.ORGNAME 机构名称
/// m.isOnLine 在线状态 1在线 0离线
/// </returns>
public static IEnumerable <T_IPSFR_USER_Model> getFROnLineByUID(T_IPS_REALDATATEMPORARYSW sw, out int FRUserCount, out int FRUserOnLineCount)
{
var result = new List <T_IPSFR_USER_Model>();
DataTable dtOrg = BaseDT.T_SYS_ORG.getDT(new T_SYS_ORGSW {
SYSFLAG = ConfigCls.getSystemFlag()
}); //获取当前登录用户有权限查看的组织机构
DataTable dtOnState = BaseDT.T_SYS_DICT.getDT(new T_SYS_DICTSW {
DICTFLAG = "固兼职状态"
});
DataTable dtFRUser = BaseDT.T_IPSFR_USER.getDT(new T_IPSFR_USER_SW {
ISENABLE = "1", HID = sw.USERID
}); //获取所有有权限查看的护林员
//当前在线的护林员
DataTable dtRealTmp = BaseDT.T_IPS_REALDATATEMPORARY.getOnLineDtByOrgno(new T_IPS_REALDATATEMPORARYSW {
USERID = sw.USERID
});
FRUserCount = dtFRUser.Rows.Count;
FRUserOnLineCount = dtRealTmp.Rows.Count;
//获取在线人员列表
for (int i = 0; i < dtRealTmp.Rows.Count; i++)
{//HID, HNAME, SN, PHONE, SEX, BIRTH, ONSTATE, BYORGNO,ISENABLE,SBTIME
T_IPSFR_USER_Model m = new T_IPSFR_USER_Model();
m.HID = dtRealTmp.Rows[i]["HID"].ToString();
m.HNAME = dtRealTmp.Rows[i]["HNAME"].ToString();
m.PHONE = dtRealTmp.Rows[i]["PHONE"].ToString();
m.BYORGNO = dtRealTmp.Rows[i]["BYORGNO"].ToString();
m.ORGNAME = BaseDT.T_SYS_ORG.getName(dtOrg, m.BYORGNO);
m.ONSTATE = dtRealTmp.Rows[i]["ONSTATE"].ToString();
m.ONSTATENAME = BaseDT.T_SYS_DICT.getName(dtOnState, m.ONSTATE);
m.SBTIME = dtRealTmp.Rows[i]["SBTIME"].ToString();
m.isOnLine = "1";
result.Add(m);
}
//获取非在线人员列表
for (int i = 0; i < dtFRUser.Rows.Count; i++)
{
//判断该用户是否是在线状态
if (dtRealTmp.Select("HID=" + dtFRUser.Rows[i]["HID"].ToString()).Length == 0)
{
T_IPSFR_USER_Model m = new T_IPSFR_USER_Model();
m.HID = dtFRUser.Rows[i]["HID"].ToString();
m.HNAME = dtFRUser.Rows[i]["HNAME"].ToString();
m.PHONE = dtFRUser.Rows[i]["PHONE"].ToString();
m.BYORGNO = dtFRUser.Rows[i]["BYORGNO"].ToString();
m.ORGNAME = BaseDT.T_SYS_ORG.getName(dtOrg, m.BYORGNO);
m.ONSTATE = dtFRUser.Rows[i]["ONSTATE"].ToString();
m.ONSTATENAME = BaseDT.T_SYS_DICT.getName(dtOnState, m.ONSTATE);
m.SBTIME = "";
m.isOnLine = "0";
result.Add(m);
}
}
dtOnState.Clear();
dtOnState.Dispose();
dtOrg.Clear();
dtOrg.Dispose();
dtFRUser.Clear();
dtFRUser.Dispose();
dtRealTmp.Clear();
dtRealTmp.Dispose();
return(result);
}
/// <summary>
/// 顶部菜单提醒数量刷新时间设置 分钟
/// </summary>
/// <returns>分钟</returns>
public static string noticeRefreshTimeInterval()
{
return(T_SYS_PARAMETERCls.getValueByFlag(new T_SYS_PARAMETER_SW {
SYSFLAG = ConfigCls.getSystemFlag(), PARAMFLAG = "noticeRefreshTimeInterval"
}));
}
/// <summary>
/// 查询怠工统计
/// </summary>
/// <param name="sw">参见SabotageCount_SW</param>
/// <returns>参见SabotageDetail_Model</returns>
public static IEnumerable <SabotageDetail_Model> getSabotageDetailModel(SabotageCount_SW sw)
{
var result = new List <SabotageDetail_Model>();
if (string.IsNullOrEmpty(sw.DateBegin))//开始时间为空
{
return(result);
}
if (string.IsNullOrEmpty(sw.DateEnd))//结束时间为空
{
return(result);
}
if (string.IsNullOrEmpty(sw.ORGNO))//组织机构编码
{
return(result);
}
//根据机构编码获取下属组织机构 注意：这个函数含本级及所有下级的
DataTable dtOrg = BaseDT.T_SYS_ORG.getDT(new T_SYS_ORGSW {
TopORGNO = sw.ORGNO
});
DataTable dtHU = BaseDT.T_IPSFR_USER.getDT(new T_IPSFR_USER_SW {
ISENABLE = "1", BYORGNO = sw.ORGNO, PhoneHname = sw.PhoneHname
});
//获取护林员每日巡检信息
DataTable dtHRRealData = BaseDT.T_IPS_REALDATATEMPORARY.getHRAndRealDataDT(new T_IPS_REALDATATEMPORARYSW {
DateBegin = sw.DateBegin, DateEnd = sw.DateEnd, ORGNO = sw.ORGNO, PhoneHname = sw.PhoneHname
});
float LengthError = ConfigCls.getPatrolLengthError() / 1000;//巡检距离误差
//仅查怠工DataRow[] dr = dtHRRealData.Select("PatrolLenError<=" + LengthError.ToString(), "SBDATE DESC");
DataRow[] dr = dtHRRealData.Select("", "HID,SBDATE DESC");
for (int i = 0; i < dr.Length; i++)
{
SabotageDetail_Model m = new SabotageDetail_Model();
string hid = dr[i]["HID"].ToString();
m.HID = hid;
string orgNo = dr[i]["BYORGNO"].ToString();
m.ORGNo = orgNo;
m.ORGName = BaseDT.T_SYS_ORG.getName(dtOrg, orgNo);
m.HNAME = dr[i]["HNAME"].ToString(); //护林员姓名
m.PHONE = dr[i]["PHONE"].ToString(); //电话
m.Date = PublicClassLibrary.ClsSwitch.SwitDate(dr[i]["SBDATE"].ToString()); //日期
m.Count0 = Convert.ToDouble(dr[i]["PATROLLENGTH"].ToString()).ToString("F2"); //应巡长度
m.Count1 = Convert.ToDouble(dr[i]["RealPATROLLENGTH"].ToString()).ToString("F2"); //实巡长度
m.CountPer = ClsStr.getPercent(dr[i]["RealPATROLLENGTH"].ToString(), dr[i]["PATROLLENGTH"].ToString());
//string wcl1 = wcl.ToString("F0");
//if (wcl <= 100)
// wcl1 = "<font color=red>" + wcl1 + "</font>";
//m.CountPer = wcl1;
result.Add(m);
}
dtHRRealData.Clear();
dtHRRealData.Dispose();
dtHU.Clear();
dtHU.Dispose();
dtOrg.Clear();
dtOrg.Dispose();
return(result);
}
/// <summary>
/// 考勤统计 Model
/// </summary>
/// <param name="sw">参见HUCheckINCount_SW</param>
/// <returns>参见HUCheck_CheckInCount_Model</returns>
public static IEnumerable <HUCheck_CheckInCount_Model> getCheckInModel(HUCheckINCount_SW sw)
{
var result = new List <HUCheck_CheckInCount_Model>();
if (string.IsNullOrEmpty(sw.DateBegin))//开始时间为空
{
return(result);
}
if (string.IsNullOrEmpty(sw.DateEnd))//结束时间为空
{
return(result);
}
if (string.IsNullOrEmpty(sw.ORGNO))//组织机构编码
{
return(result);
}
DateTime dt1 = Convert.ToDateTime(sw.DateBegin);
DateTime dt2 = Convert.ToDateTime(sw.DateEnd);
int days = ClsStr.getDateDiff(sw.DateBegin, sw.DateEnd) + 1;//日期包含天数
//根据机构编码获取下属组织机构 注意：这个函数含本级及所有下级的
//DataTable dtOrg = BaseDT.T_SYS_ORG.getDT(new T_SYS_ORGSW { TopORGNO = sw.ORGNO });
DataTable dtHRRealData = BaseDT.T_IPS_REALDATATEMPORARY.getDTByOrgNoToDate(new PatrolRouteStat_SW {
DateBegin = sw.DateBegin, DateEnd = sw.DateEnd, TopORGNO = sw.ORGNO
});
DataTable dtHU = BaseDT.T_IPSFR_USER.getDTByOrgSum(new T_IPSFR_USER_SW {
BYORGNO = sw.ORGNO, ISENABLE = "1"
});
if (PublicCls.OrgIsZhen(sw.ORGNO) == false) //市、县处理
{ //只获取该市下面的县 县下面的乡
T_SYS_ORGSW swOrg = new T_SYS_ORGSW();
swOrg.SYSFLAG = ConfigCls.getSystemFlag();
swOrg.TopORGNO = sw.ORGNO;
if (PublicCls.OrgIsShi(sw.ORGNO))
{
swOrg.GetContyORGNOByCity = sw.ORGNO;//获取所有县
}
if (PublicCls.OrgIsXian(sw.ORGNO))
{
swOrg.GetXZOrgNOByConty = sw.ORGNO;//获取所有镇
}
DataTable dtOrg = BaseDT.T_SYS_ORG.getDT(swOrg);
DataRow[] drOrg = dtOrg.Select("", "ORGNO");//取所有
for (int i = 0; i < drOrg.Length; i++)
{
HUCheck_CheckInCount_Model m = new HUCheck_CheckInCount_Model();
m.ORGName = drOrg[i]["ORGNAME"].ToString();
m.ORGNo = drOrg[i]["ORGNO"].ToString();
string CHr = dtHU.Compute("sum(C)", "BYORGNO=" + m.ORGNo).ToString(); //计算该单位下总人数
CHr = (string.IsNullOrEmpty(CHr) ? "0" : CHr);
m.HUCount = CHr; //考勤人数
string cList = "";
for (DateTime tm = dt1; tm <= dt2; tm = tm.AddDays(1))
{
string tm1 = PublicClassLibrary.ClsSwitch.SwitDate(tm).ToString();
if (string.IsNullOrEmpty(cList) == false)
{
cList += ",";
}
string tmp = dtHRRealData.Compute("sum(C)", "BYORGNO='" + m.ORGNo + "' and SBDATE='" + tm1 + "'").ToString(); //计算该日期下人数
cList += (string.IsNullOrEmpty(tmp) ? "0" : tmp); //各日期以逗号分隔
}
m.DayCountList = cList; //日期考勤列表
if (CHr != "0")
{
CHr = (int.Parse(CHr) * days).ToString();
string Chr0 = dtHRRealData.Compute("sum(C)", "BYORGNO='" + m.ORGNo + "'").ToString();
Chr0 = (string.IsNullOrEmpty(Chr0) ? "0" : Chr0);; // BaseDT.T_IPS_REALDATATEMPORARY.getCountByOrgNo(dtHRRealData, orgNo).ToString();
string Chr1 = ClsStr.getDiff(CHr, Chr0).ToString("F0");
Chr1 = (string.IsNullOrEmpty(Chr1) ? "0" : Chr1);
string Chr2 = ClsStr.getPercent(Chr0, CHr).ToString("F0");
Chr2 = (string.IsNullOrEmpty(Chr2) ? "0" : Chr2);
m.daysC = CHr; //总
m.daysOK = Chr0; //完成
m.daysPer = Chr2 + "%"; //完成率
}
result.Add(m);
}
dtOrg.Clear();
dtOrg.Dispose();
}
else//显示乡的，乡的列出各个护林员
{
DataRow[] drOrg = dtHU.Select("", "");//取所有
for (int i = 0; i < drOrg.Length; i++)
{
HUCheck_CheckInCount_Model m = new HUCheck_CheckInCount_Model();
m.ORGName = drOrg[i]["hname"].ToString();
m.ORGNo = drOrg[i]["hid"].ToString();
string CHr = "1"; // dtHU.Compute("BYORGNO=" + m.ORGNo, "").ToString();//计算该单位下总人数
m.HUCount = (string.IsNullOrEmpty(CHr) ? "0" : CHr); //考勤人数
string cList = "";
for (DateTime tm = dt1; tm <= dt2; tm = tm.AddDays(1))
{
if (string.IsNullOrEmpty(cList) == false)
{
cList += ",";
}
string tmp = dtHRRealData.Compute("sum(C)", "BYORGNO='" + m.ORGNo + "' and SBDATE='" + PublicClassLibrary.ClsSwitch.SwitDate(tm).ToString() + "'").ToString(); //计算该日期下人数
cList += (string.IsNullOrEmpty(tmp) ? "0" : tmp); //各日期以逗号分隔
}
m.DayCountList = cList; //日期考勤列表
if (CHr != "0")
{
CHr = (int.Parse(CHr) * days).ToString();
string Chr0 = dtHRRealData.Compute("sum(C)", "BYORGNO='" + m.ORGNo + "'").ToString();
Chr0 = (string.IsNullOrEmpty(Chr0) ? "0" : Chr0);; // BaseDT.T_IPS_REALDATATEMPORARY.getCountByOrgNo(dtHRRealData, orgNo).ToString();
string Chr1 = ClsStr.getDiff(CHr, Chr0).ToString("F0");
Chr1 = (string.IsNullOrEmpty(Chr1) ? "0" : Chr1);
string Chr2 = ClsStr.getPercent(Chr0, CHr).ToString("F0");
Chr2 = (string.IsNullOrEmpty(Chr2) ? "0" : Chr2);
m.daysC = CHr; //总
m.daysOK = Chr0; //完成
m.daysPer = Chr2 + "%"; //完成率
}
result.Add(m);
}
}
dtHU.Clear();
dtHU.Dispose();
//根据机构编码获取所有护林员信息
// DataTable dtHU = BaseDT.T_IPSFR_USER.getDT(new T_IPSFR_USER_SW { BYORGNO = sw.ORGNO, ISENABLE = "1" });
dtHRRealData.Clear();
dtHRRealData.Dispose();
if (1 == 1)
{
HUCheck_CheckInCount_Model m = new HUCheck_CheckInCount_Model();
m.ORGName = "合计";
string HUCount = result.Sum(item => Convert.ToDecimal(item.HUCount)).ToString();//总数
string daysC = result.Sum(item => Convert.ToDecimal(item.daysC)).ToString();
string daysOK = result.Sum(item => Convert.ToDecimal(item.daysOK)).ToString();
HUCount = (string.IsNullOrEmpty(HUCount) ? "0" : HUCount);
daysC = (string.IsNullOrEmpty(daysC) ? "0" : daysC);
daysOK = (string.IsNullOrEmpty(daysOK) ? "0" : daysOK);
//string PointCount0 = result.Sum(item => Convert.ToDecimal(item.PointCount0)).ToString();
m.HUCount = HUCount;
m.daysC = daysC; //总天数
m.daysOK = daysOK; //已出勤
int[] arrI = new int[days];
foreach (var v in result)
{
string[] a = v.DayCountList.Split(',');//组合列表
for (int i = 0; i < days; i++)
{
if (string.IsNullOrEmpty(arrI[i].ToString()))
{
arrI[i] = 0;
}
arrI[i] += int.Parse(a[i]);
}
}
string cList = "";
for (int i = 0; i < days; i++)
{
if (string.IsNullOrEmpty(cList) == false)
{
cList += ",";
}
cList += arrI[i];
}
m.DayCountList = cList;
//m.LineCount2 = ClsStr.getPercent(LineCount0, LineCount).ToString("F0") + "%";
//m.PointCount = PointCount;
//m.PointCount0 = PointCount0;
//m.PointCount1 = result.Sum(item => Convert.ToDecimal(item.PointCount1)).ToString();
m.daysPer = ClsStr.getPercent(m.daysOK, m.daysC).ToString("F0") + "%";
result.Insert(0, m);
}
return(result);
}
/// <summary>
/// 考勤统计 Model
/// </summary>
/// <param name="sw">参见HUCheckINCount_SW</param>
/// <returns>参见HUCheck_CheckInCount_Model</returns>getOutRaiLCountModel
public static IEnumerable <OutRaiLCount_Model> getOutRaiLCountModel(OutRaiLCount_SW sw)
{
var result = new List <OutRaiLCount_Model>();
if (string.IsNullOrEmpty(sw.DateBegin))//开始时间为空
{
return(result);
}
if (string.IsNullOrEmpty(sw.DateEnd))//结束时间为空
{
return(result);
}
if (string.IsNullOrEmpty(sw.TopORGNO))//组织机构编码
{
return(result);
}
DateTime dt1 = Convert.ToDateTime(sw.DateBegin);
DateTime dt2 = Convert.ToDateTime(sw.DateEnd);
int days = ClsStr.getDateDiff(sw.DateBegin, sw.DateEnd) + 1;//日期包含天数
DataTable dt = BaseDT.T_IPSFR_ROUTERAIL_RAIL.getDTByOrgNoToDate(new OutRaiLCount_SW {
DateBegin = sw.DateBegin, DateEnd = sw.DateEnd, TopORGNO = sw.TopORGNO
});
DataTable dtHU = BaseDT.T_IPSFR_USER.getDTByOrgSum(new T_IPSFR_USER_SW {
BYORGNO = sw.TopORGNO, ISENABLE = "1"
});
if (PublicCls.OrgIsZhen(sw.TopORGNO) == false) //市、县处理
{ //只获取该市下面的县 县下面的乡
T_SYS_ORGSW swOrg = new T_SYS_ORGSW();
swOrg.SYSFLAG = ConfigCls.getSystemFlag();
swOrg.TopORGNO = sw.TopORGNO;
if (PublicCls.OrgIsShi(sw.TopORGNO))
{
swOrg.GetContyORGNOByCity = sw.TopORGNO;//获取所有县
}
if (PublicCls.OrgIsXian(sw.TopORGNO))
{
swOrg.GetXZOrgNOByConty = sw.TopORGNO;//获取所有镇
}
DataTable dtOrg = BaseDT.T_SYS_ORG.getDT(swOrg);
DataRow[] drOrg = dtOrg.Select("", "ORGNO");//取所有
for (int i = 0; i < drOrg.Length; i++)
{
OutRaiLCount_Model m = new OutRaiLCount_Model();
m.ORGName = drOrg[i]["ORGNAME"].ToString();
m.ORGNo = drOrg[i]["ORGNO"].ToString();
string CHr = dt.Compute("sum(C)", "BYORGNO=" + m.ORGNo).ToString();//计算该单位下总数
CHr = (string.IsNullOrEmpty(CHr) ? "0" : CHr);
m.Count = CHr;
string cList = "";
for (DateTime tm = dt1; tm <= dt2; tm = tm.AddDays(1))
{
string tm1 = PublicClassLibrary.ClsSwitch.SwitDate(tm).ToString();
if (string.IsNullOrEmpty(cList) == false)
{
cList += ",";
}
string tmp = dt.Compute("sum(C)", "BYORGNO='" + m.ORGNo + "' and SBDATE='" + tm1 + "'").ToString(); //计算该日期下数量
cList += (string.IsNullOrEmpty(tmp) ? "0" : tmp); //各日期以逗号分隔
}
m.DayCountList = cList; //日期考勤列表
result.Add(m);
}
dtOrg.Clear();
dtOrg.Dispose();
}
else//显示乡的，乡的列出各个护林员
{
DataRow[] drOrg = dtHU.Select("", "");//取所有
for (int i = 0; i < drOrg.Length; i++)
{
OutRaiLCount_Model m = new OutRaiLCount_Model();
m.ORGName = drOrg[i]["hname"].ToString();
m.ORGNo = drOrg[i]["hid"].ToString();
string CHr = dt.Compute("sum(C)", "BYORGNO=" + m.ORGNo).ToString();//计算该单位下总数
CHr = (string.IsNullOrEmpty(CHr) ? "0" : CHr);
m.Count = CHr;
string cList = "";
for (DateTime tm = dt1; tm <= dt2; tm = tm.AddDays(1))
{
if (string.IsNullOrEmpty(cList) == false)
{
cList += ",";
}
string tmp = dt.Compute("sum(C)", "BYORGNO='" + m.ORGNo + "' and SBDATE='" + PublicClassLibrary.ClsSwitch.SwitDate(tm).ToString() + "'").ToString(); //计算该日期下人数
cList += (string.IsNullOrEmpty(tmp) ? "0" : tmp); //各日期以逗号分隔
}
m.DayCountList = cList; //日期列表
result.Add(m);
}
}
dtHU.Clear();
dtHU.Dispose();
dt.Clear();
dt.Dispose();
if (1 == 1)
{
OutRaiLCount_Model m = new OutRaiLCount_Model();
m.ORGName = "合计";
string CHr = result.Sum(item => Convert.ToDecimal(item.Count)).ToString();//总数//计算该单位下总数
CHr = (string.IsNullOrEmpty(CHr) ? "0" : CHr);
m.Count = CHr;
int[] arrI = new int[days];
foreach (var v in result)
{
string[] a = v.DayCountList.Split(',');//组合列表
for (int i = 0; i < days; i++)
{
if (string.IsNullOrEmpty(arrI[i].ToString()))
{
arrI[i] = 0;
}
arrI[i] += int.Parse(a[i]);
}
}
string cList = "";
for (int i = 0; i < days; i++)
{
if (string.IsNullOrEmpty(cList) == false)
{
cList += ",";
}
cList += arrI[i];
}
m.DayCountList = cList;
result.Insert(0, m);
}
return(result);
}
/// <summary>
/// 巡检路线明细表
/// </summary>
/// <param name="sw">参见PatrolRouteStat_SW</param>
/// <returns>参见HUReport_PatrolRouteDetail_Model</returns>
public static IEnumerable <HUReport_PatrolRouteDetail_Model> getPatrolRouteDetailModel(PatrolRouteStat_SW sw)
{
var result = new List <HUReport_PatrolRouteDetail_Model>();
if (string.IsNullOrEmpty(sw.DateBegin))//开始时间为空
{
return(result);
}
if (string.IsNullOrEmpty(sw.DateEnd))//结束时间为空
{
return(result);
}
if (string.IsNullOrEmpty(sw.orgNo))//组织机构编码
{
return(result);
}
T_SYS_ORGSW swOrg = new T_SYS_ORGSW();
swOrg.SYSFLAG = ConfigCls.getSystemFlag();
swOrg.TopORGNO = sw.TopORGNO;
if (PublicCls.OrgIsShi(sw.TopORGNO))
{
swOrg.GetContyORGNOByCity = sw.TopORGNO;//获取所有县
}
if (PublicCls.OrgIsXian(sw.TopORGNO))
{
swOrg.GetXZOrgNOByConty = sw.TopORGNO;//获取所有镇
}
DataTable dtOrg = BaseDT.T_SYS_ORG.getDT(swOrg);
//DataTable dtOrg = BaseDT.T_SYS_ORG.getDT(new T_SYS_ORGSW { SYSFLAG = ConfigCls.getSystemFlag() });
DataTable dtHU = BaseDT.T_IPSFR_USER.getDT(new T_IPSFR_USER_SW {
ISENABLE = "1", PhoneHname = sw.PhoneHname, BYORGNO = sw.orgNo
});
//获取护林员每日巡检信息
DataTable dtHRRealData = BaseDT.T_IPS_REALDATATEMPORARY.getHRAndRealDataDT(new T_IPS_REALDATATEMPORARYSW {
DateBegin = sw.DateBegin, DateEnd = sw.DateEnd, ORGNO = sw.orgNo, PhoneHname = sw.PhoneHname
});
//获取具体巡检情况
DataTable dtPatrol = BaseDT.T_IPSFR_ROUTERAIL_PATROL.getDT(new T_IPSFR_ROUTERAIL_PATROL_SW {
DateBegin = sw.DateBegin, DateEnd = sw.DateEnd
});
int days = ClsStr.getDateDiff(sw.DateBegin, sw.DateEnd) + 1; //日期包含天数
for (int i = 0; i < dtHU.Rows.Count; i++) //获取每个护林员
{
string orgNo = dtHU.Rows[i]["BYORGNO"].ToString();
string HID = dtHU.Rows[i]["HID"].ToString();
string orgName = BaseDT.T_SYS_ORG.getName(dtOrg, orgNo);
HUReport_PatrolRouteDetail_Model m = new HUReport_PatrolRouteDetail_Model();
m.ORGName = orgName;
m.ORGNo = orgNo;
m.HNAME = dtHU.Rows[i]["HNAME"].ToString();
m.PHONE = dtHU.Rows[i]["PHONE"].ToString();
string CHr = "1";//每天一条路线
if (CHr != "0")
{
CHr = (int.Parse(CHr) * days).ToString();
string Chr0 = BaseDT.T_IPS_REALDATATEMPORARY.getCountByHID(dtHRRealData, HID).ToString();
string Chr1 = ClsStr.getDiff(CHr, Chr0).ToString("F0");
string Chr2 = ClsStr.getPercent(Chr0, CHr).ToString("F0");
m.LineCount = CHr; //总
m.LineCount0 = Chr0; //完成
m.LineCount1 = Chr1; //未完成
m.LineCount2 = Chr2 + "%"; //完成率
}
//巡检与漏检
string CCHr = BaseDT.T_IPSFR_ROUTERAIL_PATROL.getCountByHID(dtPatrol, HID, "").ToString();
if (CCHr != "0")
{
// CCHr = (int.Parse(CCHr) * days).ToString();
string Chr0 = BaseDT.T_IPSFR_ROUTERAIL_PATROL.getCountByHID(dtPatrol, HID, "1").ToString();
string Chr1 = ClsStr.getDiff(CCHr, Chr0).ToString("F0");
string Chr2 = ClsStr.getPercent(Chr0, CCHr).ToString("F0");
m.PointCount = CCHr; //总
m.PointCount0 = Chr0; //完成
m.PointCount1 = Chr1; //未完成
m.PointCount2 = Chr2 + "%"; //完成率
}
result.Add(m);
}
dtHU.Clear();
dtHU.Dispose();
dtHRRealData.Clear();
dtHRRealData.Dispose();
dtPatrol.Clear();
dtPatrol.Dispose();
dtOrg.Clear();
dtOrg.Dispose();
return(result);
}
/// <summary>
/// 查询怠工统计
/// </summary>
/// <param name="sw">参见SabotageCount_SW</param>
/// <returns>参见getSabotageCount_Model</returns>
public static IEnumerable <getSabotageCount_Model> getSabotageCountModel(SabotageCount_SW sw)
{
var result = new List <getSabotageCount_Model>();
if (string.IsNullOrEmpty(sw.DateBegin))//开始时间为空
{
return(result);
}
if (string.IsNullOrEmpty(sw.DateEnd))//结束时间为空
{
return(result);
}
DateTime dt1 = Convert.ToDateTime(sw.DateBegin);
DateTime dt2 = Convert.ToDateTime(sw.DateEnd);
int days = ClsStr.getDateDiff(sw.DateBegin, sw.DateEnd) + 1;//日期包含天数
DataTable dtHU = new DataTable();
DataTable dt = BaseDT.T_IPS_REALDATATEMPORARY.getDTSabotageByOrgNo(sw);
if (PublicCls.OrgIsShi(sw.TopORGNO))
{
dtHU = BaseDT.T_IPSFR_USER.getDTShi(new T_IPSFR_USER_SW {
});
}
else if (PublicCls.OrgIsXian(sw.TopORGNO))
{
dtHU = BaseDT.T_IPSFR_USER.getDTXain(new T_IPSFR_USER_SW {
BYORGNO = sw.TopORGNO
});
}
else
{
dtHU = BaseDT.T_IPSFR_USER.getDT(new T_IPSFR_USER_SW {
ISENABLE = "1", BYORGNO = sw.TopORGNO
});
}
if (PublicCls.OrgIsZhen(sw.TopORGNO))
{
DataRow[] drOrg = dtHU.Select("", "");
for (int i = 0; i < drOrg.Length; i++)
{
getSabotageCount_Model m = new getSabotageCount_Model();
m.ORGName = drOrg[i]["HNAME"].ToString();
m.ORGNo = drOrg[i]["HID"].ToString();
string CHr = dt.Compute("sum(C)", "BYORGNO='" + m.ORGNo + "'").ToString();
CHr = (string.IsNullOrEmpty(CHr) ? "0" : CHr);
string cList = "";
for (DateTime tm = dt1; tm <= dt2; tm = tm.AddDays(1))
{
string tm1 = PublicClassLibrary.ClsSwitch.SwitDate(tm).ToString();
if (string.IsNullOrEmpty(cList) == false)
{
cList += ",";
}
string tmp = dt.Compute("sum(C)", "BYORGNO='" + m.ORGNo + "' and SBDATE='" + tm1 + "' and PatrolLenErro=1").ToString(); //计算该日期下人数
cList += (string.IsNullOrEmpty(tmp) ? "0" : tmp); //各日期以逗号分隔
}
m.DayCountList = cList; //日期考勤列表
string Chr0 = dt.Compute("sum(C)", "BYORGNO='" + m.ORGNo + "' and PatrolLenErro=0").ToString();
Chr0 = (string.IsNullOrEmpty(Chr0) ? "0" : Chr0);
string Chr1 = ClsStr.getDiff(CHr, Chr0).ToString("F0");
string Chr2 = ClsStr.getPercent(Chr0, CHr).ToString("F0");
m.Count = CHr; //总
m.Count0 = Chr0; //完成
m.Count1 = Chr1; //未完成
m.CountPer = Chr2 + "%"; //完成率
result.Add(m);
}
dtHU.Clear();
dtHU.Dispose();
}
else
{
T_SYS_ORGSW swOrg = new T_SYS_ORGSW();
swOrg.SYSFLAG = ConfigCls.getSystemFlag();
swOrg.TopORGNO = sw.TopORGNO;
if (PublicCls.OrgIsShi(sw.TopORGNO))
{
swOrg.GetContyORGNOByCity = sw.TopORGNO;//获取所有县
}
if (PublicCls.OrgIsXian(sw.TopORGNO))
{
swOrg.GetXZOrgNOByConty = sw.TopORGNO;//获取所有镇
}
DataTable dtOrg = BaseDT.T_SYS_ORG.getDT(swOrg);
DataRow[] drOrg = dtOrg.Select("", "ORGNO");//取所有
for (int i = 0; i < drOrg.Length; i++)
{
// string orgName = drOrg[i]["ORGNAME"].ToString();
//string orgNo = drOrg[i]["ORGNO"].ToString();
getSabotageCount_Model m = new getSabotageCount_Model();
m.ORGName = drOrg[i]["ORGNAME"].ToString();
m.ORGNo = drOrg[i]["ORGNO"].ToString();
string CHr = dt.Compute("sum(C)", "BYORGNO='" + m.ORGNo + "'").ToString();
CHr = (string.IsNullOrEmpty(CHr) ? "0" : CHr);
string cList = "";
for (DateTime tm = dt1; tm <= dt2; tm = tm.AddDays(1))
{
string tm1 = PublicClassLibrary.ClsSwitch.SwitDate(tm).ToString();
if (string.IsNullOrEmpty(cList) == false)
{
cList += ",";
}
string tmp = dt.Compute("sum(C)", "BYORGNO='" + m.ORGNo + "' and SBDATE='" + tm1 + "' and PatrolLenErro=0").ToString(); //计算该日期下人数
cList += (string.IsNullOrEmpty(tmp) ? "0" : tmp); //各日期以逗号分隔
}
m.DayCountList = cList; //日期考勤列表
string Chr0 = dt.Compute("sum(C)", "BYORGNO='" + m.ORGNo + "' and PatrolLenErro=1").ToString();
Chr0 = (string.IsNullOrEmpty(Chr0) ? "0" : Chr0);
string Chr1 = ClsStr.getDiff(CHr, Chr0).ToString("F0");
string Chr2 = ClsStr.getPercent(Chr0, CHr).ToString("F0");
m.Count = CHr; //总
m.Count0 = Chr0; //完成
m.Count1 = Chr1; //未完成
m.CountPer = Chr2 + "%"; //完成率
result.Add(m);
}
dtOrg.Clear();
dtOrg.Dispose();
}
dt.Clear();
dt.Dispose();
if (1 == 1)
{
getSabotageCount_Model m = new getSabotageCount_Model();
m.ORGName = "合计";
string LineCount = result.Sum(item => Convert.ToDecimal(item.Count)).ToString();
string Count0 = result.Sum(item => Convert.ToDecimal(item.Count0)).ToString();
string Count1 = result.Sum(item => Convert.ToDecimal(item.Count1)).ToString();
m.Count = LineCount;
m.Count0 = Count0;
m.Count1 = Count1;
m.CountPer = ClsStr.getPercent(m.Count0, m.Count).ToString("F0") + "%";
int[] arrI = new int[days];
foreach (var v in result)
{
string[] a = v.DayCountList.Split(',');//组合列表
for (int i = 0; i < days; i++)
{
if (string.IsNullOrEmpty(arrI[i].ToString()))
{
arrI[i] = 0;
}
arrI[i] += int.Parse(a[i]);
}
}
string cList = "";
for (int i = 0; i < days; i++)
{
if (string.IsNullOrEmpty(cList) == false)
{
cList += ",";
}
cList += arrI[i];
}
m.DayCountList = cList;
result.Insert(0, m);
}
return(result);
}
/// <summary>
/// 获取最新的火情反馈信息
/// </summary>
/// <param name="sw"></param>
/// <returns></returns>
public static JC_FIRETICKLING_Model getLatestfeedback(JC_FIRETICKLING_SW sw)
{
DataTable dt = BaseDT.JC_FIRETICKLING.Latestfeedback(sw);
DataTable dtORG = BaseDT.T_SYS_ORG.getDT(new T_SYS_ORGSW {
SYSFLAG = ConfigCls.getSystemFlag()
}); //获取单位
DataTable dt7 = BaseDT.T_SYS_DICT.getDT(new T_SYS_DICTSW {
DICTTYPEID = "7"
}); //数据中心地类类型
DataTable dt8 = BaseDT.T_SYS_DICT.getDT(new T_SYS_DICTSW {
DICTTYPEID = "8"
}); //数据中心林火类型
DataTable dt9 = BaseDT.T_SYS_DICT.getDT(new T_SYS_DICTSW {
DICTTYPEID = "9"
}); //数据中心可燃物类别
DataTable dt10 = BaseDT.T_SYS_DICT.getDT(new T_SYS_DICTSW {
DICTTYPEID = "10"
}); //热点类别
JC_FIRETICKLING_Model m = new JC_FIRETICKLING_Model();
//JCFireFKInfoModel m = new JCFireFKInfoModel();
if (dt.Rows.Count == 1)
{
m.DL = dt.Rows[0]["DL"].ToString();
m.DLName = BaseDT.T_SYS_DICT.getName(dt7, m.DL);
m.FORESTNAME = dt.Rows[0]["FORESTNAME"].ToString();
m.FORESTFIRETYPE = dt.Rows[0]["FORESTFIRETYPE"].ToString();
m.FORESTFIRETYPENAME = BaseDT.T_SYS_DICT.getName(dt8, m.FORESTFIRETYPE);
m.FUELTYPE = dt.Rows[0]["FUELTYPE"].ToString();
m.FUELTYPEName = BaseDT.T_SYS_DICT.getName(dt9, m.FUELTYPE);
m.HOTTYPE = dt.Rows[0]["HOTTYPE"].ToString();
m.HOTTYPEName = BaseDT.T_SYS_DICT.getName(dt10, m.HOTTYPE);
m.CHECKTIME = ClsSwitch.SwitTM(dt.Rows[0]["CHECKTIME"].ToString());
m.YY = dt.Rows[0]["YY"].ToString();
m.JXHQSJ = dt.Rows[0]["JXHQSJ"].ToString();
m.FIREBEGINTIME = ClsSwitch.SwitTM(dt.Rows[0]["FIREBEGINTIME"].ToString());
m.FIREENDTIME = ClsSwitch.SwitTM(dt.Rows[0]["FIREENDTIME"].ToString());
m.ISOUTFIRE = dt.Rows[0]["ISOUTFIRE"].ToString();
m.BURNEDAREA = dt.Rows[0]["BURNEDAREA"].ToString();
m.OVERDOAREA = dt.Rows[0]["OVERDOAREA"].ToString();
m.LOSTFORESTAREA = dt.Rows[0]["LOSTFORESTAREA"].ToString();
m.ELSELOSSINTRO = dt.Rows[0]["ELSELOSSINTRO"].ToString();
m.FIREINTRO = dt.Rows[0]["FIREINTRO"].ToString();
m.BYORGNO = dt.Rows[0]["BYORGNO"].ToString();
m.MANUSERID = dt.Rows[0]["MANUSERID"].ToString();
m.MANSTATE = dt.Rows[0]["MANSTATE"].ToString();
m.MANTIME = dt.Rows[0]["MANTIME"].ToString();
m.AUDITREASON = dt.Rows[0]["AUDITREASON"].ToString(); //审核不通过理由
m.ADDRESS = dt.Rows[0]["ADDRESS"].ToString(); //实际发生地
m.JD = dt.Rows[0]["JD"].ToString();
m.WD = dt.Rows[0]["WD"].ToString();
m.ORGNAME = BaseDT.T_SYS_ORG.getName(dtORG, m.BYORGNO);
//m.JC_FireFKData.JD = string.IsNullOrEmpty(dt.Rows[0]["JD"].ToString()) ? dt.Rows[0]["JCJD"].ToString() : dt.Rows[0]["JD"].ToString();//实际发生经度
//m.JC_FireFKData.WD = string.IsNullOrEmpty(dt.Rows[0]["WD"].ToString()) ? dt.Rows[0]["JCWD"].ToString() : dt.Rows[0]["WD"].ToString();//实际发生纬度
}
dt.Clear();
dt.Dispose();
dt7.Clear();
dt7.Dispose();
dt8.Clear();
dt8.Dispose();
dt9.Clear();
dt9.Dispose();
dt10.Clear();
dt10.Dispose();
return(m);
}
/// <summary>
/// 获取最低级的tree
/// </summary>
/// <param name="car"></param>
/// <returns></returns>
public static JObject getLastJobjectCar(DC_CAR_Model car)
{
var model = T_SYS_DICTCls.getListModel(new T_SYS_DICTSW {
DICTTYPEID = "33", DICTVALUE = car.CARTYPE
}).FirstOrDefault();
var name = car.NAME + "【" + model.DICTNAME + "】";
//getPosition
StringBuilder sb = new StringBuilder();
string carimage = "car_" + car.CARTYPE;
//偏移量计算
// double[] arr = ClsPositionUtil.gcj_To_Gps84(double.Parse(car.WD), double.Parse(car.JD));
if (!string.IsNullOrEmpty(car.JD) || !string.IsNullOrEmpty(car.WD))
{
double[] arr = ClsPositionTrans.GpsTransform(double.Parse(car.WD), double.Parse(car.JD), ConfigCls.getSDELonLatTransform());
if (arr.Length > 0)
{
car.JD = arr[1].ToString();
car.WD = arr[0].ToString();
}
//string sb = "<a onClick="">" + name + "</a>";
sb.AppendFormat("<font onClick='movetocar(\"{0}\",\"{1}\",\"{2}\")'>{3}</font>", car.JD, car.WD, carimage, name);
}
else
{
sb.AppendFormat("<font onClick='alert(\"缺少经纬度无法定位。\")'>{0}</font>", name);
}
JObject root = new JObject {
{ "id", car.DC_CAR_ID }, { "text", sb.ToString() }
};
return(root);
}
/// <summary>
/// 获取单条数据
/// </summary>
/// <param name="sw">参见模型</param>
/// <returns>参见模型</returns>
public static PEST_MONITORINGSTATION_Model getModel(PEST_MONITORINGSTATION_SW sw)
{
DataTable dt = BaseDT.PEST_MONITORINGSTATION.getDT(sw);//列表
DataTable dtORG = BaseDT.T_SYS_ORG.getDT(new T_SYS_ORGSW {
SYSFLAG = ConfigCls.getSystemFlag()
}); //获取单位
DataTable dt119 = BaseDT.T_SYS_DICT.getDT(new T_SYS_DICTSW {
DICTTYPEID = "119"
}); //无线电传输方式
DataTable dt120 = BaseDT.T_SYS_DICT.getDT(new T_SYS_DICTSW {
DICTTYPEID = "120"
}); //使用现状
DataTable dt121 = BaseDT.T_SYS_DICT.getDT(new T_SYS_DICTSW {
DICTTYPEID = "121"
}); //维护类型
PEST_MONITORINGSTATION_Model m = new PEST_MONITORINGSTATION_Model();
if (dt.Rows.Count > 0)
{
int i = 0;
m.PEST_MONITORINGSTATIONID = dt.Rows[i]["PEST_MONITORINGSTATIONID"].ToString();
m.NUMBER = dt.Rows[i]["NUMBER"].ToString();
m.NAME = dt.Rows[i]["NAME"].ToString();
m.ADDRESS = dt.Rows[i]["ADDRESS"].ToString();
m.MODEL = dt.Rows[i]["MODEL"].ToString();
m.BYORGNO = dt.Rows[i]["BYORGNO"].ToString();
if (PublicCls.OrgIsShi(m.BYORGNO) || PublicCls.OrgIsXian(m.BYORGNO))
{
m.ORGName = BaseDT.T_SYS_ORG.getName(dtORG, m.BYORGNO);
m.ORGXSName = "--";
}
else
{
m.ORGName = BaseDT.T_SYS_ORG.getName(dtORG, m.BYORGNO.Substring(0, 6) + "000");
m.ORGXSName = BaseDT.T_SYS_ORG.getName(dtORG, m.BYORGNO);
}
m.TRANSFERMODETYPE = dt.Rows[i]["TRANSFERMODETYPE"].ToString();
m.TRANSFERMODETYPEName = BaseDT.T_SYS_DICT.getName(dt119, m.TRANSFERMODETYPE);
m.MONICONTENT = dt.Rows[i]["MONICONTENT"].ToString();
m.BUILDDATE = PublicClassLibrary.ClsSwitch.SwitDate(dt.Rows[i]["BUILDDATE"].ToString());
m.USESTATE = dt.Rows[i]["USESTATE"].ToString();
m.USESTATEName = BaseDT.T_SYS_DICT.getName(dt120, m.USESTATE);
m.MANAGERSTATE = dt.Rows[i]["MANAGERSTATE"].ToString();
m.MANAGERSTATEName = BaseDT.T_SYS_DICT.getName(dt121, m.MANAGERSTATE);
m.MARK = dt.Rows[i]["MARK"].ToString();
m.JD = dt.Rows[i]["JD"].ToString();
m.WD = dt.Rows[i]["WD"].ToString();
m.WORTH = dt.Rows[i]["WORTH"].ToString();
}
dt.Clear();
dt.Dispose();
dtORG.Clear();
dtORG.Dispose();
dt119.Clear();
dt119.Dispose();
dt120.Clear();
dt120.Dispose();
dt121.Clear();
dt121.Dispose();
return(m);
}
/// <summary>
/// 获取所有系统菜单
/// </summary>
/// <param name="sw">参见T_SYS_MENU_SW</param>
/// <returns>参见SystemMenu_Model</returns>
public static IEnumerable <SystemMenu_Model> getT_SYS_MENUModel(T_SYS_MENU_SW sw)
{
var result = new List <SystemMenu_Model>();
if (string.IsNullOrEmpty(SystemCls.getUserID()))
{
return(result);
}
StringBuilder sb = new StringBuilder(1000);
sb.AppendFormat(" FROM T_SYS_MENU WHERE 1=1");
sb.AppendFormat(" AND SYSFLAG='{0}' ", sw.SYSFLAG);
sb.AppendFormat(" AND MENURIGHTFLAG in (select RIGHTID from T_SYSSEC_ROLE_RIGHT where (ROLEID in (select ROLEID from T_SYSSEC_USER_ROLE where USERID={0} ) and RIGHTID in(select RIGHTID from T_SYSSEC_RIGHT where SYSFLAG='{1}')) and roleid in (select roleid from T_SYSSEC_ROLE where SYSFLAG='{1}') )", SystemCls.getUserID(), ConfigCls.getSystemFlag());
if (string.IsNullOrEmpty(sw.MENUCODE) == false)
{
sb.AppendFormat(" AND left(MENUCODE,3) in({0}) ", sw.MENUCODE);
}
if (string.IsNullOrEmpty(sw.MenuCodeList) == false)
{
sb.AppendFormat(" AND left(MENUCODE,3) in({0}) ", sw.MenuCodeList);
}
string sql = "SELECT MENUID,MENUCODE,MENUNAME,MENUURL,MENUICO,LICLASS,ORDERBY,MENURIGHTFLAG,SYSFLAG,MENUOPENMETHOD, MENULINKMODE, MENUDROWMTHOD, ISTOPMENU " + sb.ToString() + " ";
DataSet ds = DataBaseClass.FullDataSet(sql);
DataTable dt = ds.Tables[0];
DataRow[] dr = dt.Select("len(MENUCODE)=3", "ORDERBY");
//获取上报数据
DataTable dtR = BaseDT.T_IPSRPT_REPORT.getDT(new T_IPSRPT_REPORT_SW {
MANSTATE = "0", orgNo = SystemCls.getCurUserOrgNo()
});
CookieModel cookieInfo = SystemCls.getCookieInfo();//登录用户信息
for (int i = 0; i < dr.Length; i++)
{
SystemMenu_Model m = new SystemMenu_Model();
m.MENUCODE = dr[i]["MENUCODE"].ToString();
m.MENUICO = dr[i]["MENUICO"].ToString();
m.MENUNAME = dr[i]["MENUNAME"].ToString();
m.LICLASS = dr[i]["LICLASS"].ToString();
m.MENUOPENMETHOD = dr[i]["MENUOPENMETHOD"].ToString();
m.MENULINKMODE = dr[i]["MENULINKMODE"].ToString();
m.MENUDROWMTHOD = dr[i]["MENUDROWMTHOD"].ToString();
m.ISTOPMENU = dr[i]["ISTOPMENU"].ToString();
long mShowCount = 0;//一级菜单显示数量
var SubM = new List <T_SYS_MENU_Model>();
DataRow[] dr1 = dt.Select("len(MENUCODE)=6 and SUBSTRING(MENUCODE,1,3)='" + dr[i]["MENUCODE"].ToString() + "'", "ORDERBY");
for (int k = 0; k < dr1.Length; k++)
{
T_SYS_MENU_Model mm = new T_SYS_MENU_Model();
mm.MENUCODE = dr1[k]["MENUCODE"].ToString();
mm.MENUURL = dr1[k]["MENUURL"].ToString().Replace("[USERID]", cookieInfo.UID).Replace("[LOGINUSERNAME]", cookieInfo.userName);
mm.MENUNAME = dr1[k]["MENUNAME"].ToString();
mm.MENUICO = dr1[k]["MENUICO"].ToString();
mm.LICLASS = dr1[k]["LICLASS"].ToString();
//获取需要显示提醒数量的菜单
string MENUCODE = dr1[k]["MENUCODE"].ToString();
string count = "0";
if (MENUCODE == "001004")
{
count = BaseDT.T_IPS_ALARM.getDT(new T_IPS_ALARM_SW {
orgNo = SystemCls.getCurUserOrgNo(), MANSTATE = "0"
}).Rows.Count.ToString();
}
if (MENUCODE == "001003")
{
count = BaseDT.T_IPS_HOTS.getDT(new T_IPS_HOTS_SW {
MANSTATE = "0"
}).Rows.Count.ToString();
}
if (MENUCODE.Substring(0, 3) == "002")
{
string tmpCode = MENUCODE.Substring(3, 3);
if (tmpCode.Substring(0, 2) == "00")
{
tmpCode = tmpCode.Substring(2, 1);
}
else if (tmpCode.Substring(0, 1) == "0")
{
tmpCode = tmpCode.Substring(1, 2);
}
else
{
tmpCode = tmpCode.Substring(2, 1);
}
count = BaseDT.T_IPSRPT_REPORT.getCountByType(dtR, tmpCode);
mm.TID = tmpCode;//类别ＩＤ 上报序号
}
if (MENUCODE.Substring(0, 3) == "003")
{
string tmpCode = MENUCODE.Substring(3, 3);
if (tmpCode.Substring(0, 2) == "00")
{
tmpCode = tmpCode.Substring(2, 1);
}
else if (tmpCode.Substring(0, 1) == "0")
{
tmpCode = tmpCode.Substring(1, 2);
}
else
{
tmpCode = tmpCode.Substring(2, 1);
}
//count = BaseDT.T_IPSRPT_REPORT.getCountByType(dtR, tmpCode);
mm.TID = tmpCode; //类别ＩＤ 上报序号
}
mShowCount += Convert.ToInt64(count);
if (count == "0")
{
count = "";
}
mm.showCount = count;
SubM.Add(mm);
}
m.showCount = (mShowCount == 0) ? "" : mShowCount.ToString();
m.subMenuModel = SubM;
result.Add(m);
}
ds.Clear();
ds.Dispose();
dt.Clear();
dt.Dispose();
return(result);
}
/// <summary>
/// 采集数据统计
/// </summary>
/// <param name="sw">参见模型 sw.TopORGNO 顶级单位编码 sw.DateBegin 开始日期 年月日 sw.DateEnd 结束日期 年月日</param>
/// <param name="typeModel">参见模型</param>
/// <returns>参见模型</returns>
public static IEnumerable <T_IPSCOL_COLLECT_OrgCountModel> getModelCount(T_IPSCOL_COLLECT_SW sw, out IEnumerable <T_IPSCOL_COLLECT_TypeCountModel> typeModel)
{
var result = new List <T_IPSCOL_COLLECT_OrgCountModel>();
//获取采集信息
DataTable dt = BaseDT.T_IPSCOL_COLLECT.getDTByOrgHUse(sw);
//获取单位
T_SYS_ORGSW swOrg = new T_SYS_ORGSW();
swOrg.SYSFLAG = ConfigCls.getSystemFlag();
swOrg.TopORGNO = sw.TopORGNO;
if (PublicCls.OrgIsShi(sw.TopORGNO))
{
swOrg.GetContyORGNOByCity = sw.TopORGNO;//获取所有县
}
if (PublicCls.OrgIsXian(sw.TopORGNO))
{
swOrg.GetXZOrgNOByConty = sw.TopORGNO;//获取所有镇
}
DataTable dtOrg = BaseDT.T_SYS_ORG.getDT(swOrg);
//采集类别
DataTable dtReportType = BaseDT.T_SYS_DICT.getDT(new T_SYS_DICTSW {
DICTTYPEID = "4"
}); //采集类别
//out 类别
var resultReportType = new List <T_IPSCOL_COLLECT_TypeCountModel>();
for (int i = 0; i < dtReportType.Rows.Count; i++)
{
T_IPSCOL_COLLECT_TypeCountModel m = new T_IPSCOL_COLLECT_TypeCountModel();
m.typeName = dtReportType.Rows[i]["DICTNAME"].ToString();
resultReportType.Add(m);
}
typeModel = resultReportType;
if (1 == 1)
{
T_IPSCOL_COLLECT_OrgCountModel m = new T_IPSCOL_COLLECT_OrgCountModel();
m.HName = BaseDT.T_SYS_ORG.getName(sw.TopORGNO) + "合计";
m.ORGName = m.HName;
m.CollectCount = BaseDT.T_IPSRPT_REPORT.getCountByOrgHUse(dt, sw.TopORGNO, "");//总数
var typeResult = new List <T_IPSCOL_COLLECT_TypeCountModel>();
//循环类别
for (int k = 0; k < dtReportType.Rows.Count; k++)
{
T_IPSCOL_COLLECT_TypeCountModel mm = new T_IPSCOL_COLLECT_TypeCountModel();
mm.typeID = dtReportType.Rows[k]["DICTVALUE"].ToString();
mm.typeName = dtReportType.Rows[k]["DICTNAME"].ToString();
mm.typeCount = BaseDT.T_IPSRPT_REPORT.getCountByOrgHUse(dt, sw.TopORGNO, mm.typeID);//分类别统计
typeResult.Add(mm);
}
m.TypeCountModel = typeResult;
result.Add(m);
}
if (PublicCls.OrgIsZhen(sw.TopORGNO) == false)
{
//循环单位
for (int i = 0; i < dtOrg.Rows.Count; i++)
{
T_IPSCOL_COLLECT_OrgCountModel m = new T_IPSCOL_COLLECT_OrgCountModel();
m.ORGName = dtOrg.Rows[i]["ORGNAME"].ToString();
m.ORGNo = dtOrg.Rows[i]["ORGNO"].ToString();
//m.HID = dt.Rows[i]["HID"].ToString();
m.CollectCount = BaseDT.T_IPSCOL_COLLECT.getCountByOrgHUse(dt, m.ORGNo, "");//总数
var typeResult = new List <T_IPSCOL_COLLECT_TypeCountModel>();
//循环类别
for (int k = 0; k < dtReportType.Rows.Count; k++)
{
T_IPSCOL_COLLECT_TypeCountModel mm = new T_IPSCOL_COLLECT_TypeCountModel();
mm.typeID = dtReportType.Rows[k]["DICTVALUE"].ToString();
mm.typeName = dtReportType.Rows[k]["DICTNAME"].ToString();
mm.typeCount = BaseDT.T_IPSCOL_COLLECT.getCountByOrgHUse(dt, m.ORGNo, mm.typeID);//分类别统计
typeResult.Add(mm);
}
m.TypeCountModel = typeResult;
result.Add(m);
}
}
else//if (PublicCls.OrgIsZhen(sw.TopORGNO))//如果查询的单位为镇，显示所有护林员的统计信息
{
DataTable dtHUser = BaseDT.T_IPSFR_USER.getDT(new T_IPSFR_USER_SW
{
BYORGNO = sw.TopORGNO
});
for (int i = 0; i < dtHUser.Rows.Count; i++)
{
T_IPSCOL_COLLECT_OrgCountModel m = new T_IPSCOL_COLLECT_OrgCountModel();
m.HID = dtHUser.Rows[i]["HID"].ToString();
m.HName = dtHUser.Rows[i]["HNAME"].ToString();
m.CollectCount = BaseDT.T_IPSCOL_COLLECT.getCountByHID(dt, m.HID, "");//总数
var typeResult = new List <T_IPSCOL_COLLECT_TypeCountModel>();
//循环类别
for (int k = 0; k < dtReportType.Rows.Count; k++)
{
T_IPSCOL_COLLECT_TypeCountModel mm = new T_IPSCOL_COLLECT_TypeCountModel();
mm.typeID = dtReportType.Rows[k]["DICTVALUE"].ToString();
mm.typeName = dtReportType.Rows[k]["DICTNAME"].ToString();
mm.typeCount = BaseDT.T_IPSCOL_COLLECT.getCountByHID(dt, m.HID, mm.typeID);//分类别统计
typeResult.Add(mm);
}
m.TypeCountModel = typeResult;
result.Add(m);
}
dtHUser.Clear();
dtHUser.Dispose();
}
dt.Clear();
dt.Dispose();
dtOrg.Clear();
dtOrg.Dispose();
dtReportType.Clear();
dtReportType.Dispose();
return(result);
}
/// <summary>
/// 获取单条数据
/// </summary>
/// <param name="sw">参见模型</param>
/// <returns>参见模型</returns>
public static PEST_COLLECTDATA_Model getModel(PEST_COLLECTDATA_SW sw)
{
DataTable dt = BaseDT.PEST_COLLECTDATA.getDT(sw);//列表
DataTable dtORG = BaseDT.T_SYS_ORG.getDT(new T_SYS_ORGSW {
SYSFLAG = ConfigCls.getSystemFlag()
}); //获取单位
DataTable dtBiolo = BaseDT.T_SYS_BIOLOGICALTYPE.getDT(new T_SYS_BIOLOGICALTYPE_SW()); //生物类别
DataTable dt55 = BaseDT.T_SYS_DICT.getDT(new T_SYS_DICTSW {
DICTTYPEID = "55"
}); //危害部位
DataTable dt56 = BaseDT.T_SYS_DICT.getDT(new T_SYS_DICTSW {
DICTTYPEID = "56"
}); //危害程度
DataTable dt57 = BaseDT.T_SYS_DICT.getDT(new T_SYS_DICTSW {
DICTTYPEID = "57"
}); //处理状态
DataTable dt123 = BaseDT.T_SYS_DICT.getDT(new T_SYS_DICTSW {
DICTTYPEID = "123"
}); //调查类型
PEST_COLLECTDATA_Model m = new PEST_COLLECTDATA_Model();
if (dt.Rows.Count > 0)
{
int i = 0;
m.PESTCOLLDATAID = dt.Rows[i]["PESTCOLLDATAID"].ToString();
m.HID = dt.Rows[i]["HID"].ToString();
m.COLLECTRESOURCE = dt.Rows[i]["COLLECTRESOURCE"].ToString();
m.BYORGNO = dt.Rows[i]["BYORGNO"].ToString();
m.BYORGNONAME = BaseDT.T_SYS_ORG.getName(dtORG, m.BYORGNO);
m.VILLAGENAME = dt.Rows[i]["VILLAGENAME"].ToString();
m.SMALLADDRESS = dt.Rows[i]["SMALLADDRESS"].ToString();
m.SMALLCLASSCODE = dt.Rows[i]["SMALLCLASSCODE"].ToString();
m.SMALLCLASSAREA = dt.Rows[i]["SMALLCLASSAREA"].ToString();
m.HOSTTREESPECIESCODE = dt.Rows[i]["HOSTTREESPECIESCODE"].ToString();
m.HOSTTREESPECIESNAME = BaseDT.T_SYS_BIOLOGICALTYPE.getName(dtBiolo, m.HOSTTREESPECIESCODE);
m.SEARCHTYPE = dt.Rows[i]["SEARCHTYPE"].ToString();
m.SEARCHTYPENAME = BaseDT.T_SYS_DICT.getName(dt123, m.SEARCHTYPE);
m.COLLECTPESTCODE = dt.Rows[i]["COLLECTPESTCODE"].ToString();
m.COLLECTPESTNAME = BaseDT.T_SYS_BIOLOGICALTYPE.getName(dtBiolo, m.COLLECTPESTCODE);
m.HARMPOSITION = dt.Rows[i]["HARMPOSITION"].ToString();
m.HARMPOSITIONNAME = BaseDT.T_SYS_DICT.getName(dt55, m.HARMPOSITION);
m.HARMLEVEL = dt.Rows[i]["HARMLEVEL"].ToString();
m.HARMLEVELNAME = BaseDT.T_SYS_DICT.getName(dt56, m.HARMPOSITION);
m.DEADCOUNT = dt.Rows[i]["DEADCOUNT"].ToString();
m.UNKNOWNDIEOFFCOUNT = dt.Rows[i]["UNKNOWNDIEOFFCOUNT"].ToString();
m.ELSEDIEOFFCOUNT = dt.Rows[i]["ELSEDIEOFFCOUNT"].ToString();
m.SAMPLECOUNT = dt.Rows[i]["SAMPLECOUNT"].ToString();
m.MARK = dt.Rows[i]["MARK"].ToString();
m.UPLOADTIME = PublicClassLibrary.ClsSwitch.SwitDate(dt.Rows[i]["UPLOADTIME"].ToString());
m.MANSTATE = dt.Rows[i]["MANSTATE"].ToString();
m.MANSTATENAME = BaseDT.T_SYS_DICT.getName(dt57, m.MANSTATE);
m.MANRESULT = dt.Rows[i]["MANRESULT"].ToString();
m.MANTIME = PublicClassLibrary.ClsSwitch.SwitDate(dt.Rows[i]["MANTIME"].ToString());
m.MANUSERID = dt.Rows[i]["MANUSERID"].ToString();
m.KID = dt.Rows[i]["KID"].ToString();
m.JWDLIST = dt.Rows[i]["JWDLIST"].ToString();
}
dt.Clear();
dt.Dispose();
dtORG.Clear();
dtORG.Dispose();
dtBiolo.Clear();
dtBiolo.Dispose();
dt55.Clear();
dt55.Dispose();
dt56.Clear();
dt56.Dispose();
dt57.Clear();
dt57.Dispose();
return(m);
}
/// <summary>
/// 根据查询条件获取某一条用户信息记录，用于修改、删除、用户登录验证
/// </summary>
/// <param name="sw">参见模型</param>
/// <returns>参见模型</returns>
public static DC_RESOURCE_NEW_Model getModel(DC_RESOURCE_NEW_SW sw)
{
var result = new List <DC_RESOURCE_NEW_Model>();
DataTable dt = BaseDT.DC_RESOURCE_NEW.getDT(sw);//列表
DataTable dtORG = BaseDT.T_SYS_ORG.getDT(new T_SYS_ORGSW {
SYSFLAG = ConfigCls.getSystemFlag()
}); //获取单位
DataTable dt27 = BaseDT.T_SYS_DICT.getDT(new T_SYS_DICTSW {
DICTTYPEID = "27"
}); //林龄类型
DataTable dt28 = BaseDT.T_SYS_DICT.getDT(new T_SYS_DICTSW {
DICTTYPEID = "28"
}); //数据中心资源类型
DataTable dt29 = BaseDT.T_SYS_DICT.getDT(new T_SYS_DICTSW {
DICTTYPEID = "29"
}); //数据中心资源起源类型
DataTable dt30 = BaseDT.T_SYS_DICT.getDT(new T_SYS_DICTSW {
DICTTYPEID = "30"
}); //数据中心资源可燃类型
DataTable dt31 = BaseDT.T_SYS_DICT.getDT(new T_SYS_DICTSW {
DICTTYPEID = "31"
}); //数据中心资源林木类型
DC_RESOURCE_NEW_Model m = new DC_RESOURCE_NEW_Model();
if (dt.Rows.Count > 0)
{
int i = 0;
m.DC_RESOURCE_NEW_ID = dt.Rows[i]["DC_RESOURCE_NEW_ID"].ToString();
m.RESOURCETYPE = dt.Rows[i]["RESOURCETYPE"].ToString();
m.RESOURCETYPEName = BaseDT.T_SYS_DICT.getName(dt28, m.RESOURCETYPE);
m.NUMBER = dt.Rows[i]["NUMBER"].ToString();
m.NAME = dt.Rows[i]["NAME"].ToString();
m.ORGNOS = dt.Rows[i]["ORGNOS"].ToString();
m.ORGNOSName = BaseDT.T_SYS_ORG.getNames(dtORG, m.ORGNOS);
m.KINDTYPE = dt.Rows[i]["KINDTYPE"].ToString();
m.AGETYPE = dt.Rows[i]["AGETYPE"].ToString();
m.AGETYPEName = BaseDT.T_SYS_DICT.getName(dt27, m.AGETYPE);
m.ORIGINTYPE = dt.Rows[i]["ORIGINTYPE"].ToString();
m.ORIGINTYPEName = BaseDT.T_SYS_DICT.getName(dt29, m.AGETYPE);
m.AREA = dt.Rows[i]["AREA"].ToString();
m.BURNTYPE = dt.Rows[i]["BURNTYPE"].ToString();
m.BURNTYPEName = BaseDT.T_SYS_DICT.getName(dt30, m.BURNTYPE);
m.TREETYPE = dt.Rows[i]["TREETYPE"].ToString();
m.TREETYPEName = BaseDT.T_SYS_DICT.getName(dt31, m.TREETYPE);
m.ASPECT = dt.Rows[i]["ASPECT"].ToString();
m.ANGLE = dt.Rows[i]["ANGLE"].ToString();
m.MARK = dt.Rows[i]["MARK"].ToString();
m.JD = dt.Rows[i]["JD"].ToString();
m.WD = dt.Rows[i]["WD"].ToString();
m.POTHOOKLEADER = dt.Rows[i]["POTHOOKLEADER"].ToString();
m.POTHOOKLEADERJOB = dt.Rows[i]["POTHOOKLEADERJOB"].ToString();
m.POTHOOKLEADERTLEE = dt.Rows[i]["POTHOOKLEADERTLEE"].ToString();
m.DUTYPERSON = dt.Rows[i]["DUTYPERSON"].ToString();
m.DUTYPERSONTELL = dt.Rows[i]["DUTYPERSONTELL"].ToString();
m.JWDLIST = dt.Rows[i]["JWDLIST"].ToString();
}
dt.Clear();
dt.Dispose();
dt27.Clear();
dt27.Dispose();
dt28.Clear();
dt28.Dispose();
dt29.Clear();
dt29.Dispose();
dt30.Clear();
dt30.Dispose();
dt31.Clear();
dt31.Dispose();
dtORG.Clear();
dtORG.Dispose();
return(m);
}
