/// <summary>
/// 获取数据列表
/// </summary>
/// <param name="sw"></param>
/// <param name="total"></param>
/// <returns></returns>
public static IEnumerable <PEST_REMOTEDIAGN_Model> getListModel(PEST_REMOTEDIAGN_SW sw, out int total)
{
var result = new List <PEST_REMOTEDIAGN_Model>();
DataTable dt = BaseDT.PEST_REMOTEDIAGN.getDT(sw, out total);//列表
DataTable dt122 = BaseDT.T_SYS_DICT.getDT(new T_SYS_DICTSW {
DICTTYPEID = "122"
}); //诊断状态
for (int i = 0; i < dt.Rows.Count; i++)
{
PEST_REMOTEDIAGN_Model m = new PEST_REMOTEDIAGN_Model();
m.PEST_REMOTEDIAGNID = dt.Rows[i]["PEST_REMOTEDIAGNID"].ToString();
m.DIAGNTITLE = dt.Rows[i]["DIAGNTITLE"].ToString();
m.DIAGNCONTENT = dt.Rows[i]["DIAGNCONTENT"].ToString();
m.DIAGNTIME = ClsSwitch.SwitMN(dt.Rows[i]["DIAGNTIME"].ToString());
m.DIAGNEXPERTS = dt.Rows[i]["DIAGNEXPERTS"].ToString();
m.DIAGNSTATUS = dt.Rows[i]["DIAGNSTATUS"].ToString();
m.DIAGNSTATUSName = BaseDT.T_SYS_DICT.getName(dt122, m.DIAGNSTATUS);
m.DIAGNRESULT = dt.Rows[i]["DIAGNRESULT"].ToString();
m.DIAGNSPONSERUID = dt.Rows[i]["DIAGNSPONSERUID"].ToString();
if (!string.IsNullOrEmpty(m.DIAGNSPONSERUID))
{
m.DIAGNSPONSERNAME = T_SYSSEC_IPSUSERCls.getname(m.DIAGNSPONSERUID);
}
m.DIAGNSPONSERTIME = ClsSwitch.SwitMN(dt.Rows[i]["DIAGNSPONSERTIME"].ToString());
result.Add(m);
}
dt.Clear();
dt.Dispose();
dt122.Clear();
dt122.Dispose();
return(result);
}
/// <summary>
/// 获取单条数据
/// </summary>
/// <param name="sw">参见模型</param>
/// <returns>参见模型</returns>
public static PEST_REMOTEDIAGN_Model getModel(PEST_REMOTEDIAGN_SW sw)
{
DataTable dt = BaseDT.PEST_REMOTEDIAGN.getDT(sw);//列表
DataTable dt122 = BaseDT.T_SYS_DICT.getDT(new T_SYS_DICTSW {
DICTTYPEID = "122"
}); //诊断状态
PEST_REMOTEDIAGN_Model m = new PEST_REMOTEDIAGN_Model();
if (dt.Rows.Count > 0)
{
int i = 0;
m.PEST_REMOTEDIAGNID = dt.Rows[i]["PEST_REMOTEDIAGNID"].ToString();
m.DIAGNTITLE = dt.Rows[i]["DIAGNTITLE"].ToString();
m.DIAGNCONTENT = dt.Rows[i]["DIAGNCONTENT"].ToString();
m.DIAGNTIME = ClsSwitch.SwitMN(dt.Rows[i]["DIAGNTIME"].ToString());
m.DIAGNEXPERTS = dt.Rows[i]["DIAGNEXPERTS"].ToString();
m.DIAGNSTATUS = dt.Rows[i]["DIAGNSTATUS"].ToString();
m.DIAGNSTATUSName = BaseDT.T_SYS_DICT.getName(dt122, m.DIAGNSTATUS);
m.DIAGNRESULT = dt.Rows[i]["DIAGNRESULT"].ToString();
m.DIAGNSPONSERUID = dt.Rows[i]["DIAGNSPONSERUID"].ToString();
if (!string.IsNullOrEmpty(m.DIAGNSPONSERUID))
{
m.DIAGNSPONSERNAME = T_SYSSEC_IPSUSERCls.getname(m.DIAGNSPONSERUID);
}
m.DIAGNSPONSERTIME = ClsSwitch.SwitMN(dt.Rows[i]["DIAGNSPONSERTIME"].ToString());
}
dt.Clear();
dt.Dispose();
dt122.Clear();
dt122.Dispose();
return(m);
}
/// <summary>
/// 获取记录
/// </summary>
/// <param name="sw"></param>
/// <returns></returns>
public static DataTable getDT(PEST_REMOTEDIAGN_SW sw)
{
StringBuilder sb = new StringBuilder();
sb.AppendFormat(" FROM PEST_REMOTEDIAGN WHERE 1=1");
if (string.IsNullOrEmpty(sw.PEST_REMOTEDIAGNID) == false)
{
sb.AppendFormat(" AND PEST_REMOTEDIAGNID = '{0}'", ClsSql.EncodeSql(sw.PEST_REMOTEDIAGNID));
}
if (string.IsNullOrEmpty(sw.DIAGNTITLE) == false)
{
sb.AppendFormat(" AND DIAGNTITLE like '%{0}%'", ClsSql.EncodeSql(sw.DIAGNTITLE));
}
if (string.IsNullOrEmpty(sw.DIAGNSTARTTIME) == false)
{
sb.AppendFormat(" AND DIAGNTIME >= '{0}'", ClsSql.EncodeSql(DateTime.Parse(sw.DIAGNSTARTTIME).ToString()));
}
if (string.IsNullOrEmpty(sw.DIAGNENDTIME) == false)
{
sb.AppendFormat(" AND DIAGNTIME <= '{0}'", ClsSql.EncodeSql(DateTime.Parse(sw.DIAGNENDTIME).AddDays(1).AddSeconds(-1).ToString()));
}
if (string.IsNullOrEmpty(sw.DIAGNSTATUS) == false)
{
sb.AppendFormat(" AND DIAGNSTATUS = '{0}'", ClsSql.EncodeSql(sw.DIAGNSTATUS));
}
if (string.IsNullOrEmpty(sw.DIAGNSPONSERUID) == false)
{
sb.AppendFormat(" AND DIAGNSPONSERUID = '{0}'", ClsSql.EncodeSql(sw.DIAGNSPONSERUID));
}
string sql = "SELECT PEST_REMOTEDIAGNID, DIAGNTITLE, DIAGNCONTENT, DIAGNTIME, DIAGNEXPERTS, DIAGNSTATUS, DIAGNRESULT, DIAGNSPONSERUID, DIAGNSPONSERTIME"
+ sb.ToString() + " ORDER BY DIAGNTIME DESC ";
DataSet ds = DataBaseClass.FullDataSet(sql);
return(ds.Tables[0]);
}
/// <summary>
/// 判断记录是否存在
/// </summary>
/// <param name="sw">参见模型</param>
/// <returns>true存在 false不存在</returns>
public static bool isExists(PEST_REMOTEDIAGN_SW sw)
{
StringBuilder sb = new StringBuilder();
sb.AppendFormat("select 1 from PEST_REMOTEDIAGN where 1=1");
if (string.IsNullOrEmpty(sw.PEST_REMOTEDIAGNID) == false)
{
sb.AppendFormat(" and PEST_REMOTEDIAGNID= '{0}'", ClsSql.EncodeSql(sw.PEST_REMOTEDIAGNID));
}
return(DataBaseClass.JudgeRecordExists(sb.ToString()));
}
/// <summary>
/// 获取分页列表
/// </summary>
/// <param name="sw"></param>
/// <param name="total"></param>
/// <returns></returns>
public static DataTable getDT(PEST_REMOTEDIAGN_SW sw, out int total)
{
StringBuilder sb = new StringBuilder();
sb.AppendFormat(" FROM PEST_REMOTEDIAGN WHERE 1=1");
if (string.IsNullOrEmpty(sw.PEST_REMOTEDIAGNID) == false)
{
sb.AppendFormat(" AND PEST_REMOTEDIAGNID = '{0}'", ClsSql.EncodeSql(sw.PEST_REMOTEDIAGNID));
}
if (string.IsNullOrEmpty(sw.DIAGNTITLE) == false)
{
sb.AppendFormat(" AND DIAGNTITLE like '%{0}%'", ClsSql.EncodeSql(sw.DIAGNTITLE));
}
if (string.IsNullOrEmpty(sw.DIAGNSTARTTIME) == false)
{
sb.AppendFormat(" AND DIAGNTIME >= '{0}'", ClsSql.EncodeSql(DateTime.Parse(sw.DIAGNSTARTTIME).ToString()));
}
if (string.IsNullOrEmpty(sw.DIAGNENDTIME) == false)
{
sb.AppendFormat(" AND DIAGNTIME <= '{0}'", ClsSql.EncodeSql(DateTime.Parse(sw.DIAGNENDTIME).AddDays(1).AddSeconds(-1).ToString()));
}
if (string.IsNullOrEmpty(sw.DIAGNSTATUS) == false)
{
sb.AppendFormat(" AND DIAGNSTATUS = '{0}'", ClsSql.EncodeSql(sw.DIAGNSTATUS));
}
if (string.IsNullOrEmpty(sw.DIAGNSPONSERUID) == false)
{
sb.AppendFormat(" AND DIAGNSPONSERUID = '{0}'", ClsSql.EncodeSql(sw.DIAGNSPONSERUID));
}
string sql = "SELECT PEST_REMOTEDIAGNID, DIAGNTITLE, DIAGNCONTENT, DIAGNTIME, DIAGNEXPERTS, DIAGNSTATUS, DIAGNRESULT, DIAGNSPONSERUID, DIAGNSPONSERTIME"
+ sb.ToString() + " ORDER BY DIAGNTIME DESC ";
string sqlC = "select count(1) " + sb.ToString();
total = int.Parse(DataBaseClass.ReturnSqlField(sqlC));
sw.CurPage = PagerCls.getCurPage(new PagerSW {
curPage = sw.CurPage, pageSize = sw.PageSize, rowCount = total
});
DataSet ds = DataBaseClass.FullDataSet(sql, (sw.CurPage - 1) * sw.PageSize, sw.PageSize, "a");
return(ds.Tables[0]);
}
