/// <summary>
/// 电子监控设备信息
/// </summary>
/// <returns></returns>
public ActionResult GetMonitorInfo()
{
MessageListObject msg = null;
var sw = new JC_MONITOR_BASICINFO_SW();
var list = JC_MONITORCls.getListModel(sw);
if (list.Count() > 0)
{
msg = new MessageListObject(true, list);
}
return(Json(msg));
}
/// <summary>
/// 获取数据
/// </summary>
/// <returns>参见模型</returns>
public static DataTable getDT(JC_MONITOR_BASICINFO_SW sw)
{
StringBuilder sb = new StringBuilder();
sb.AppendFormat(" FROM JC_MONITOR_BASICINFO a");
sb.AppendFormat(" WHERE 1=1");
if (string.IsNullOrEmpty(sw.EMID) == false)
{
sb.AppendFormat(" AND EMID = '{0}'", ClsSql.EncodeSql(sw.EMID));
}
if (string.IsNullOrEmpty(sw.TTBH) == false)
{
sb.AppendFormat(" AND TTBH like '%{0}%'", ClsSql.EncodeSql(sw.TTBH));
}
if (string.IsNullOrEmpty(sw.BYORGNO) == false)
{
if (PublicCls.OrgIsShi(sw.BYORGNO))
{
sb.AppendFormat(" and BYORGNO like '{0}%'", PublicCls.getShiIncOrgNo(sw.BYORGNO));
}
else if (PublicCls.OrgIsXian(sw.BYORGNO))
{
sb.AppendFormat(" and BYORGNO like '{0}%'", PublicCls.getXianIncOrgNo(sw.BYORGNO));
}
else if (PublicCls.OrgIsZhen(sw.BYORGNO))
{
sb.AppendFormat(" and BYORGNO like '{0}%'", PublicCls.getZhenIncOrgNo(sw.BYORGNO));
}
else
{
//sb.AppendFormat(" and BYORGNO = '{0}'", PublicCls.getZhenIncOrgNo(sw.BYORGNO));
}
}
string sql = "SELECT EMID, TTBH, EMNAME, BYORGNO, JD, WD, GC, ADDRESS, IP, LOGINUSERNAME, USERPWD, XH, PP, GD, JCJL,OBJID,TEMPLATEDID,PORT,TYPE"
+ sb.ToString()
+ " order by BYORGNO";
DataSet ds = DataBaseClass.FullDataSet(sql);
return(ds.Tables[0]);
}
/// <summary>
/// 根据查询条件获取某一条信息记录
/// </summary>
/// <param name="sw">参见模型</param>
/// <returns>参见模型</returns>
public static JC_MONITOR_BASICINFO_Model getModel(JC_MONITOR_BASICINFO_SW sw)
{
DataTable dt = BaseDT.JC_MONITOR_BASICINFO.getDT(sw);
JC_MONITOR_BASICINFO_Model m = new JC_MONITOR_BASICINFO_Model();
DataTable dtORG = BaseDT.T_SYS_ORG.getDT(new T_SYS_ORGSW {
SYSFLAG = ConfigCls.getSystemFlag()
}); //获取单位
if (dt.Rows.Count > 0)
{//, XH, PP, GD, JCJL
int i = 0;
m.EMID = dt.Rows[i]["EMID"].ToString();
m.TTBH = dt.Rows[i]["TTBH"].ToString();
m.EMNAME = dt.Rows[i]["EMNAME"].ToString();
m.BYORGNO = dt.Rows[i]["BYORGNO"].ToString();
m.JD = dt.Rows[i]["JD"].ToString();
m.WD = dt.Rows[i]["WD"].ToString();
m.GC = dt.Rows[i]["GC"].ToString();
m.ADDRESS = dt.Rows[i]["ADDRESS"].ToString();
m.IP = dt.Rows[i]["IP"].ToString();
m.LOGINUSERNAME = dt.Rows[i]["LOGINUSERNAME"].ToString();
m.USERPWD = dt.Rows[i]["USERPWD"].ToString();
m.XH = dt.Rows[i]["XH"].ToString();
m.PP = dt.Rows[i]["PP"].ToString();
m.GD = dt.Rows[i]["GD"].ToString();
m.JCJL = dt.Rows[i]["JCJL"].ToString();
m.OBJID = dt.Rows[i]["OBJID"].ToString();
m.TEMPLATEDID = dt.Rows[i]["TEMPLATEDID"].ToString();
m.PORT = dt.Rows[i]["PORT"].ToString();
m.TYPE = dt.Rows[i]["TYPE"].ToString();
m.ORGNAME = BaseDT.T_SYS_ORG.getName(dtORG, dt.Rows[i]["BYORGNO"].ToString());
}
dt.Clear();
dt.Dispose();
dtORG.Clear();
dtORG.Dispose();
return(m);
}
/// <summary>
/// 获取列表
/// </summary>
/// <param name="sw">参见模型</param>
/// <returns>参见模型</returns>
public static IEnumerable <JC_MONITOR_BASICINFO_Model> getListModel(JC_MONITOR_BASICINFO_SW sw)
{
DataTable dtORG = BaseDT.T_SYS_ORG.getDT(new T_SYS_ORGSW {
SYSFLAG = ConfigCls.getSystemFlag()
}); //获取单位
DataTable dt = BaseDT.JC_MONITOR_BASICINFO.getDT(sw); //列表
var result = new List <JC_MONITOR_BASICINFO_Model>();
for (int i = 0; i < dt.Rows.Count; i++)
{
JC_MONITOR_BASICINFO_Model m = new JC_MONITOR_BASICINFO_Model();
m.EMID = dt.Rows[i]["EMID"].ToString();
m.TTBH = dt.Rows[i]["TTBH"].ToString();
m.EMNAME = dt.Rows[i]["EMNAME"].ToString();
m.BYORGNO = dt.Rows[i]["BYORGNO"].ToString();
m.JD = dt.Rows[i]["JD"].ToString();
m.WD = dt.Rows[i]["WD"].ToString();
m.GC = dt.Rows[i]["GC"].ToString();
m.ADDRESS = dt.Rows[i]["ADDRESS"].ToString();
m.IP = dt.Rows[i]["IP"].ToString();
m.LOGINUSERNAME = dt.Rows[i]["LOGINUSERNAME"].ToString();
m.USERPWD = dt.Rows[i]["USERPWD"].ToString();
m.XH = dt.Rows[i]["XH"].ToString();
m.PP = dt.Rows[i]["PP"].ToString();
m.GD = dt.Rows[i]["GD"].ToString();
m.JCJL = dt.Rows[i]["JCJL"].ToString();
m.OBJID = dt.Rows[i]["OBJID"].ToString();
m.TEMPLATEDID = dt.Rows[i]["TEMPLATEDID"].ToString();
m.PORT = dt.Rows[i]["PORT"].ToString();
m.TYPE = dt.Rows[i]["TYPE"].ToString();
m.ORGNAME = BaseDT.T_SYS_ORG.getName(dtORG, dt.Rows[i]["BYORGNO"].ToString());
result.Add(m);
}
dtORG.Clear();
dtORG.Dispose();
dt.Clear();
dt.Dispose();
return(result);
}
