/// <summary>
/// 获取单条瞭望塔
/// </summary>
/// <param name="sw"></param>
/// <returns></returns>
public static DC_WATCHTOWER_Model getModel(DC_WATCHTOWER_SW sw)
{
DataTable dt = BaseDT.DC_WATCHTOWER.getDT(sw);
DC_WATCHTOWER_Model m = new DC_WATCHTOWER_Model();
if (dt.Rows.Count > 0)
{
int i = 0;
m.DC_WATCHTOWERID = dt.Rows[i]["DC_WATCHTOWERID"].ToString();
m.BYORGNO = dt.Rows[i]["BYORGNO"].ToString();
m.WATCHNAME = dt.Rows[i]["WATCHNAME"].ToString();
m.BASICS = dt.Rows[i]["BASICS"].ToString();
m.BUILDTIME = dt.Rows[i]["BUILDTIME"].ToString();
m.BULIDAREA = dt.Rows[i]["BULIDAREA"].ToString();
m.USAGE = dt.Rows[i]["USAGE"].ToString();
m.LINKWAY = dt.Rows[i]["LINKWAY"].ToString();
m.PHOTO = dt.Rows[i]["PHOTO"].ToString();
m.JD = dt.Rows[i]["JD"].ToString();
m.WD = dt.Rows[i]["WD"].ToString();
m.ORDERBY = dt.Rows[i]["ORDERBY"].ToString();
}
dt.Dispose();
dt.Clear();
return(m);
}
/// <summary>
/// 获取列表
/// </summary>
/// <param name="sw"></param>
/// <returns></returns>
public static IEnumerable <DC_WATCHTOWER_Model> getListModel(DC_WATCHTOWER_SW sw)
{
DataTable dt = BaseDT.DC_WATCHTOWER.getDT(sw);
var result = new List <DC_WATCHTOWER_Model>();
for (int i = 0; i < dt.Rows.Count; i++)
{
DC_WATCHTOWER_Model m = new DC_WATCHTOWER_Model();
m.DC_WATCHTOWERID = dt.Rows[i]["DC_WATCHTOWERID"].ToString();
m.BYORGNO = dt.Rows[i]["BYORGNO"].ToString();
m.WATCHNAME = dt.Rows[i]["WATCHNAME"].ToString();
m.BASICS = dt.Rows[i]["BASICS"].ToString();
m.PHOTO = dt.Rows[i]["PHOTO"].ToString();
m.BUILDTIME = dt.Rows[i]["BUILDTIME"].ToString();
m.BULIDAREA = dt.Rows[i]["BULIDAREA"].ToString();
m.USAGE = dt.Rows[i]["USAGE"].ToString();
m.JD = dt.Rows[i]["JD"].ToString();
m.WD = dt.Rows[i]["WD"].ToString();
m.LINKWAY = dt.Rows[i]["LINKWAY"].ToString();
m.ORDERBY = dt.Rows[i]["ORDERBY"].ToString();
result.Add(m);
}
dt.Clear();
dt.Dispose();
return(result);
}
/// <summary>
/// 获取数据
/// </summary>
/// <param name="sw"></param>
/// <returns></returns>
public static DataTable getDT(DC_WATCHTOWER_SW sw)
{
StringBuilder sb = new StringBuilder();
sb.AppendFormat(" from DC_WATCHTOWER a ");
sb.AppendFormat("where 1=1");
if (string.IsNullOrEmpty(sw.DC_WATCHTOWERID) == false)
{
sb.AppendFormat("and DC_WATCHTOWERID = '{0}'", ClsSql.EncodeSql(sw.DC_WATCHTOWERID));
}
if (string.IsNullOrEmpty(sw.BYORGNO) == false)
{
sb.AppendFormat("and BYORGNO = '{0}'", ClsSql.EncodeSql(sw.BYORGNO));
}
if (string.IsNullOrEmpty(sw.WATCHNAME) == false)
{
sb.AppendFormat("and WATCHNAME = '{0}'", ClsSql.EncodeSql(sw.WATCHNAME));
}
if (string.IsNullOrEmpty(sw.BASICS) == false)
{
sb.AppendFormat("and BASICS = '{0}'", ClsSql.EncodeSql(sw.BASICS));
}
if (string.IsNullOrEmpty(sw.PHOTO) == false)
{
sb.AppendFormat("and PHOTO = '{0}'", ClsSql.EncodeSql(sw.PHOTO));
}
if (string.IsNullOrEmpty(sw.LINKWAY) == false)
{
sb.AppendFormat("and LINKWAY = '{0}'", ClsSql.EncodeSql(sw.LINKWAY));
}
if (string.IsNullOrEmpty(sw.BUILDTIME) == false)
{
sb.AppendFormat("and BUILDTIME= '{0}'", ClsSql.EncodeSql(sw.BUILDTIME));
}
if (string.IsNullOrEmpty(sw.WD) == false)
{
sb.AppendFormat("and WD = '{0}'", ClsSql.EncodeSql(sw.WD));
}
if (string.IsNullOrEmpty(sw.JD) == false)
{
sb.AppendFormat("and JD = '{0}'", ClsSql.EncodeSql(sw.JD));
}
if (string.IsNullOrEmpty(sw.ORDERBY) == false)
{
sb.AppendFormat("and ORDERBY = '{0}'", ClsSql.EncodeSql(sw.ORDERBY));
}
if (string.IsNullOrEmpty(sw.BULIDAREA) == false)
{
sb.AppendFormat("and BULIDAREA = '{0}'", ClsSql.EncodeSql(sw.BULIDAREA));
}
string sql = ("select DC_WATCHTOWERID,BYORGNO,WATCHNAME,BASICS,LINKWAY,PHOTO,BUILDTIME,BULIDAREA,WD,JD,USAGE,ORDERBY") + sb.ToString() + ("order by DC_WATCHTOWERID ");
DataSet ds = DataBaseClass.FullDataSet(sql);
return(ds.Tables[0]);
}
