/// <summary>
/// 得到一个对象实体
/// </summary>
public static T_YH GetModel(int F_ID)
{
dbbase.odbcdb aa = new odbcdb("DSN=pathnet;UID=pathnet;PWD=4s3c2a1p", "", "");
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 F_ID,F_YHM,F_YHMC,F_YHBH,F_YHQX,F_YHMM,F_DLSJ,F_SFZX,F_ZXWZ,F_ZXSC,F_DXYS,F_SFZH,F_DHHM,F_FJH,F_CXTS,F_DXFPYS,F_YH_BY1,F_YH_BY2 from T_YH ");
strSql.Append($" where F_ID='{F_ID}'");
DataTable dt = aa.GetDataTable(strSql.ToString(), "dt1");
if (dt.Rows.Count > 0)
{
return(T_YH.DataRowToModel(dt.Rows[0]));
}
return(null);
}
/// <summary>
/// 获得前几行数据
/// </summary>
public static List <T_YH> GetList(string strWhere)
{
dbbase.odbcdb aa = new odbcdb("DSN=pathnet;UID=pathnet;PWD=4s3c2a1p", "", "");
StringBuilder strSql = new StringBuilder();
strSql.Append("select ");
strSql.Append(" F_ID,F_YHM,F_YHMC,F_YHBH,F_YHQX,F_YHMM,F_DLSJ,F_SFZX,F_ZXWZ,F_ZXSC,F_DXYS,F_SFZH,F_DHHM,F_FJH,F_CXTS,F_DXFPYS,F_YH_BY1,F_YH_BY2 ");
strSql.Append(" FROM T_YH ");
if (strWhere.Trim() != "")
{
strSql.Append(" where " + strWhere);
}
var dt = aa.GetDataTable(strSql.ToString(), "dt");
var listYh = new List <T_YH>();
foreach (DataRow dtRow in dt.Rows)
{
listYh.Add(T_YH.DataRowToModel(dtRow));
}
return(listYh);
}