/// <summary>
/// 获取数据列表
/// </summary>
/// <param name="sw">参见条件模型CollectDataSW</param>
/// <returns>参见模型CollectDataListModel</returns>
public static IEnumerable <CollectDataListModel> get_CollectDataModelList(CollectDataSW sw)
{
var result = new List <CollectDataListModel>();
DataTable dt = T_IPSCOL_COLLECTDATA.getUnionDT(sw);
for (int i = 0; i < dt.Rows.Count; i++)
{
CollectDataListModel m = new CollectDataListModel();
m.COLLECTID = long.Parse(dt.Rows[i]["COLLECTID"].ToString());
m.HID = int.Parse(dt.Rows[i]["HID"].ToString());
m.LONGITUDE = (dt.Rows[i]["LONGITUDE"] == null) ? 0 : decimal.Parse(dt.Rows[i]["LONGITUDE"].ToString());
m.LATITUDE = (dt.Rows[i]["LATITUDE"] == null) ? 0 : decimal.Parse(dt.Rows[i]["LATITUDE"].ToString());
//******************计算坐标偏移量
string[] arr = PublicCls.switJWD(m.LATITUDE.ToString(), m.LONGITUDE.ToString());
m.LATITUDE = Convert.ToDecimal(arr[0]);
m.LONGITUDE = Convert.ToDecimal(arr[1]);
//******************计算坐标偏移量 End
m.SYSTYPEVALUE = dt.Rows[i]["SYSTYPEVALUE"].ToString();
m.COLLECTNAME = dt.Rows[i]["COLLECTNAME"].ToString();
m.ADDRESS = dt.Rows[i]["ADDRESS"].ToString();
//if (string.IsNullOrEmpty(Convert.ToString(dt.Rows[i]["HEIGHT"])))//判断是否是空值
//{
// dt.Rows[i]["HEIGHT"] = 0;
//}
m.COLLECTTIME = Convert.ToDateTime(dt.Rows[i]["COLLECTTIME"].ToString());
result.Add(m);
}
return(result);
}
/// <summary>
/// 根据ID获取明细
/// </summary>
/// <param name="sw">sw.REPORTID</param>
/// <returns>参见模型</returns>
public static IEnumerable <T_IPSRPT_REPORT_Model> getDetailModelList(T_IPSRPT_REPORT_SW sw)
{
var result = new List <T_IPSRPT_REPORT_Model>();
DataTable dt = BaseDT.T_IPSRPT_REPORT.getDetailDT(new T_IPSRPT_REPORT_SW {
REPORTID = sw.REPORTID
});
for (int i = 0; i < dt.Rows.Count; i++)
{
T_IPSRPT_REPORT_Model m = new T_IPSRPT_REPORT_Model();
m.REPORTDETAILID = dt.Rows[i]["REPORTDETAILID"].ToString();
m.REPORTID = dt.Rows[i]["REPORTID"].ToString();
m.LONGITUDE = dt.Rows[i]["LONGITUDE"].ToString();
m.LATITUDE = dt.Rows[i]["LATITUDE"].ToString();
//******************计算坐标偏移量
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.DIRECTION = dt.Rows[i]["DIRECTION"].ToString();
m.SBTIME = ClsSwitch.SwitTM(dt.Rows[i]["SBTIME"].ToString());
result.Add(m);
}
dt.Clear();
dt.Dispose();
return(result);
}
/// <summary>
/// 护林员周边
/// </summary>
/// <param name="sw">周边模型</param>
/// <returns></returns>
public static IEnumerable <T_IPS_REALDATATEMPORARYModel> getModelList(HlyAreaDataSW sw)
{
var result = new List <T_IPS_REALDATATEMPORARYModel>();
DataTable dt = BaseDT.T_IPS_REALDATATEMPORARY.getDTByArea(sw);
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();
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();
result.Add(m);
}
return(result);
}
/// <summary>
/// 根据电话号码获取实时传输数据
/// </summary>
/// <example>
/// sw.SearchTime 查询日期，查询某日的电量信息
/// sw.USERID 护林员序号（多序号以逗号分隔）
/// sw.DateBegin 开始日期
/// sw.DateEnd 结束日期
/// </example>
/// <param name="sw">参见条件模型T_IPS_REALDATASW</param>
/// <returns>参见模型T_IPS_REALDATAModel</returns>
public static IEnumerable <T_IPS_REALDATAModel> getModelList(T_IPS_REALDATASW sw)
{
var result = new List <T_IPS_REALDATAModel>();
DataTable dt = BaseDT.T_IPS_REALDATA.getDT(sw);
for (int i = 0; i < dt.Rows.Count; i++)
{
T_IPS_REALDATAModel m = new T_IPS_REALDATAModel();
m.REALDATAID = dt.Rows[i]["REALDATAID"].ToString();
m.PHONE = dt.Rows[i]["PHONE"].ToString();
m.LONGITUDE = dt.Rows[i]["LONGITUDE"].ToString(); //经度
m.LATITUDE = 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();
result.Add(m);
}
//dtHUser.Clear();
//dtHUser.Dispose();
dt.Clear();
dt.Dispose();
return(result);
}
/// <summary>
/// 根据ID获取明细
/// </summary>
/// <param name="sw">sw.COLLECTID</param>
/// <returns>参见模型T_IPSCOL_COLLECT_Model</returns>
public static IEnumerable <T_IPSCOL_COLLECT_Model> getDetailModelList(T_IPSCOL_COLLECT_SW sw)
{
var result = new List <T_IPSCOL_COLLECT_Model>();
DataTable dt = BaseDT.T_IPSCOL_COLLECT.getDetailDT(new T_IPSCOL_COLLECT_SW {
COLLECTID = sw.COLLECTID
});
for (int i = 0; i < dt.Rows.Count; i++)
{
T_IPSCOL_COLLECT_Model m = new T_IPSCOL_COLLECT_Model();
m.COLLECTDETAILID = dt.Rows[i]["COLLECTDETAILID"].ToString();
m.COLLECTID = dt.Rows[i]["COLLECTID"].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.DIRECTION = dt.Rows[i]["DIRECTION"].ToString();
m.COLLECTTIME = PublicClassLibrary.ClsSwitch.SwitTM(dt.Rows[i]["COLLECTTIME"].ToString());
result.Add(m);
}
dt.Clear();
dt.Dispose();
return(result);
}
/// <summary>
/// 获取一条数据
/// </summary>
/// <example>
/// sw.ALARMID 报警ID
/// </example>
/// <param name="sw">参见条件模型T_IPS_ALARM_SW</param>
/// <returns>参见模型T_IPS_ALARM_Model</returns>
public static T_IPS_ALARM_Model getModel(T_IPS_ALARM_SW sw)
{
DataTable dt = BaseDT.T_IPS_ALARM.getDT(sw);
T_IPS_ALARM_Model m = new T_IPS_ALARM_Model();
if (dt.Rows.Count > 0)
{
int i = 0;
m.ALARMID = dt.Rows[i]["ALARMID"].ToString();
m.LONGITUDE = dt.Rows[i]["LONGITUDE"].ToString();
m.LATITUDE = dt.Rows[i]["LATITUDE"].ToString();
//******************计算坐标偏移量
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.PHONE = dt.Rows[i]["PHONE"].ToString();
m.ADDRESS = dt.Rows[i]["ADDRESS"].ToString();
m.ALARMTIME = dt.Rows[i]["ALARMTIME"].ToString();
if (string.IsNullOrEmpty(m.ALARMTIME) == false)
{
m.ALARMTIME = PublicClassLibrary.ClsSwitch.SwitTM(m.ALARMTIME);
}
m.ALARMCONTENT = dt.Rows[i]["ALARMCONTENT"].ToString();
m.MANSTATE = dt.Rows[i]["MANSTATE"].ToString();
m.MANRESULT = dt.Rows[i]["MANRESULT"].ToString();
m.MANTIME = dt.Rows[i]["MANTIME"].ToString();
if (string.IsNullOrEmpty(m.MANTIME) == false)
{
m.MANTIME = PublicClassLibrary.ClsSwitch.SwitTM(m.MANTIME);
}
m.MANUSERID = dt.Rows[i]["MANUSERID"].ToString();
DataTable dtHRUser = BaseDT.T_IPSFR_USER.getDT(new T_IPSFR_USER_SW {
PHONE = m.PHONE
});
DataTable dtUser = BaseDT.T_SYSSEC_USER.getDT(new T_SYSSEC_IPSUSER_SW {
USERID = m.MANUSERID
});
DataRow[] drHRUser = dtHRUser.Select("PHONE='" + m.PHONE + "'");
if (drHRUser.Length > 0)
{
m.OrgNoName = drHRUser[0]["ORGNAME"].ToString();
m.HName = drHRUser[0]["HNAME"].ToString();
m.HID = drHRUser[0]["HID"].ToString();
m.OrgNo = drHRUser[0]["BYORGNO"].ToString();
}
if (!string.IsNullOrEmpty(m.MANUSERID))
{
DataRow[] drUser = dtUser.Select("USERID='" + m.MANUSERID + "'");
if (drUser.Length > 0)
{
m.ManUserName = drUser[0]["USERNAME"].ToString();
}
}
dtUser.Clear();
dtUser.Dispose();
dtHRUser.Clear();
dtHRUser.Dispose();
////权限获取
//var userid = SystemCls.getUserID();
//var rightsw = new T_SYSSEC_IPSUSER_SW();
//rightsw.USERID = userid;
//m.Rights = T_SYSSEC_RIGHTCls.getRightStrByUID(rightsw);
}
dt.Clear();
dt.Dispose();
return(m);
}
/// <summary>
/// 获取多条数据
/// </summary>
/// <example>
/// sw.orgNo 机构编码，用于获取该机构编码下所有的采集信息
/// sw.MANSTATE 处理状态 0未处理1已处理
/// sw.DateBegin 开始日期
/// sw.DateEnd 结束日期
/// </example>
/// <param name="sw">参见条件模型T_IPSCOL_COLLECT_SW</param>
/// <returns>参见模型T_IPSCOL_COLLECT_Model</returns>
public static IEnumerable <T_IPSCOL_COLLECT_Model> getModelList(T_IPSCOL_COLLECT_SW sw)
{
DataTable dtHRUser = BaseDT.T_IPSFR_USER.getDT(new T_IPSFR_USER_SW {
BYORGNO = sw.orgNo
});
DataTable dtUser = BaseDT.T_SYSSEC_USER.getDT(new T_SYSSEC_IPSUSER_SW {
});
DataTable dtCollectType = BaseDT.T_SYS_DICT.getDT(new T_SYS_DICTSW {
DICTFLAG = "数据采集"
});
var result = new List <T_IPSCOL_COLLECT_Model>();
DataTable dt = null;
if (sw.UnionHUser)
{
dt = BaseDT.T_IPSCOL_COLLECT.getDtUnionHUser(sw); //关联护林员表
}
else
{
dt = BaseDT.T_IPSCOL_COLLECT.getDT(sw);
}
string IDList = "";
for (int i = 0; i < dt.Rows.Count; i++)
{
if (i > 0)
{
IDList += ",";
}
IDList += dt.Rows[i]["COLLECTID"].ToString();
}
DataTable dtDetail = BaseDT.T_IPSCOL_COLLECT.getDetailDT(new T_IPSCOL_COLLECT_SW {
COLLECTID = IDList
});
DataTable dtUpload = BaseDT.T_IPSCOL_COLLECT.getUploadDT(new T_IPSCOL_COLLECT_SW {
COLLECTID = IDList
});
//var userid = SystemCls.getUserID();
//var rightsw = new T_SYSSEC_IPSUSER_SW();
//rightsw.USERID = userid;
for (int i = 0; i < dt.Rows.Count; i++)
{
T_IPSCOL_COLLECT_Model m = new T_IPSCOL_COLLECT_Model();
m.HID = dt.Rows[i]["HID"].ToString();
m.COLLECTID = dt.Rows[i]["COLLECTID"].ToString();
m.SYSTYPEVALUE = dt.Rows[i]["SYSTYPEVALUE"].ToString();
m.SYSTYPEName = BaseDT.T_SYS_DICT.getName(dtCollectType, m.SYSTYPEVALUE);
m.ADDRESS = dt.Rows[i]["ADDRESS"].ToString();
m.COLLECTTIME = ClsSwitch.SwitTM(dt.Rows[i]["COLLECTTIME"].ToString());
m.COLLECTNAME = dt.Rows[i]["COLLECTNAME"].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();
DataRow[] drDetail = dtDetail.Select("COLLECTID='" + m.COLLECTID + "'", "COLLECTTIME");
if (drDetail.Length > 0)
{
m.COLLECTDETAILID = drDetail[0]["COLLECTDETAILID"].ToString();
m.LONGITUDE = drDetail[0]["LONGITUDE"].ToString();
m.LATITUDE = drDetail[0]["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 = drDetail[0]["HEIGHT"].ToString();
m.DIRECTION = drDetail[0]["DIRECTION"].ToString();
// m.COLLECTTIME = ClsSwitch.SwitTM(drDetail[0]["COLLECTTIME"].ToString());
}
DataRow[] drUpload = dtUpload.Select("COLLECTID='" + m.COLLECTID + "'", "COLLECTUPLOADID");
if (drUpload.Length > 0)
{
m.COLLECTUPLOADID = drUpload[0]["COLLECTUPLOADID"].ToString();
m.UPLOADURL = drUpload[0]["UPLOADURL"].ToString();
m.UPLOADNAME = drUpload[0]["UPLOADNAME"].ToString();
m.UPLOADDESCRIBE = drUpload[0]["UPLOADDESCRIBE"].ToString();
}
DataRow[] drHRUser = dtHRUser.Select("HID='" + m.HID + "'");
if (drHRUser.Length > 0)
{
m.OrgNoName = drHRUser[0]["ORGNAME"].ToString();
m.HName = drHRUser[0]["HNAME"].ToString();
m.Phone = drHRUser[0]["PHONE"].ToString();
m.OrgNo = drHRUser[0]["BYORGNO"].ToString();
m.Phone = drHRUser[0]["PHONE"].ToString();
}
if (!string.IsNullOrEmpty(m.MANUSERID))
{
DataRow[] drUser = dtUser.Select("USERID='" + m.MANUSERID + "'");
if (drUser.Length > 0)
{
m.ManUserName = drUser[0]["USERNAME"].ToString();
}
}
//权限获取
//m.Rights = T_SYSSEC_RIGHTCls.getRightStrByUID(rightsw);
result.Add(m);
}
dtUser.Clear();
dtUser.Dispose();
dtHRUser.Clear();
dtHRUser.Dispose();
dtDetail.Clear();
dtDetail.Dispose();
dtUpload.Clear();
dtUpload.Dispose();
dtCollectType.Clear();
dtCollectType.Dispose();
dt.Clear();
dt.Dispose();
return(result);
}
/// <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>
/// 获取一条数据
/// </summary>
/// <example>
/// sw.ALARMID 热点ID
/// </example>
/// <param name="sw">参见条件模型T_IPS_HOTS_SW</param>
/// <returns>参见模型T_IPS_HOTS_Model</returns>
public static T_IPS_HOTS_Model getModel(T_IPS_HOTS_SW sw)
{
DataTable dt = BaseDT.T_IPS_HOTS.getDT(sw);
T_IPS_HOTS_Model m = new T_IPS_HOTS_Model();
if (dt.Rows.Count > 0)
{
int i = 0;
m.HOTSID = dt.Rows[i]["HOTSID"].ToString();
m.BH = dt.Rows[i]["BH"].ToString();
m.WXBH = dt.Rows[i]["WXBH"].ToString();
m.DQRDBH = dt.Rows[i]["DQRDBH"].ToString();
m.HLY = dt.Rows[i]["HLY"].ToString();
m.ZQWZ = dt.Rows[i]["ZQWZ"].ToString();
m.JD = dt.Rows[i]["JD"].ToString();
m.WD = dt.Rows[i]["WD"].ToString();
//******************计算坐标偏移量
string[] arr = PublicCls.switJWD(m.WD, m.JD);
m.WD = arr[0];
m.JD = arr[1];
//******************计算坐标偏移量 End
m.XS = dt.Rows[i]["XS"].ToString();
m.DL = dt.Rows[i]["DL"].ToString();
m.YY = dt.Rows[i]["YY"].ToString();
m.JXHQSJ = dt.Rows[i]["JXHQSJ"].ToString();
m.FXSJ = dt.Rows[i]["FXSJ"].ToString();
if (string.IsNullOrEmpty(m.FXSJ) == false)
{
m.FXSJ = PublicClassLibrary.ClsSwitch.SwitTM(m.FXSJ);
}
m.SBSJ = dt.Rows[i]["SBSJ"].ToString();
if (string.IsNullOrEmpty(m.SBSJ) == false)
{
m.SBSJ = PublicClassLibrary.ClsSwitch.SwitTM(m.SBSJ);
}
m.BZW = dt.Rows[i]["BZW"].ToString();
m.FJBH = dt.Rows[i]["FJBH"].ToString();
m.WLBH = dt.Rows[i]["WLBH"].ToString();
m.XZQH = dt.Rows[i]["XZQH"].ToString();
m.CZW = dt.Rows[i]["CZW"].ToString();
m.MANSTATE = dt.Rows[i]["MANSTATE"].ToString();
m.MANRESULT = dt.Rows[i]["MANRESULT"].ToString();
m.MANTIME = dt.Rows[i]["MANTIME"].ToString();
m.MANUSERID = dt.Rows[i]["MANUSERID"].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();
}
//权限获取
//var userid = SystemCls.getUserID();
//var rightsw = new T_SYSSEC_IPSUSER_SW();
//rightsw.USERID = userid;
//m.Rights = T_SYSSEC_RIGHTCls.getRightStrByUID(rightsw);
}
dt.Clear();
dt.Dispose();
return(m);
}