public static T GetModelByHash <T>(Hashtable ht)//多条件查询
{
T model = Activator.CreateInstance <T>();
Type type = model.GetType();
StringBuilder strSql = new StringBuilder();
strSql.Append("SELECT * FROM " + type.Name + " WHERE 1=1");
foreach (string key in ht.Keys)
{
strSql.Append(" AND " + key + " = " + ParamKey + "" + key + "");
}
DataTable dt = ExecuteDataTable(strSql.ToString(), GetParameter(ht));
if (dt.Rows.Count > 0)
{
return(DataConvertHelper.DataRowToModel <T>(dt.Rows[0]));
}
return(model);
}
public static T GetModelByName <T>(string pkName, string pkVal)
{
if (string.IsNullOrEmpty(pkVal))
{
return(default(T));
}
T model = Activator.CreateInstance <T>();
Type type = model.GetType();
StringBuilder sb = new StringBuilder();
sb.Append("SELECT * FROM ").Append(type.Name).Append(" Where ").Append(pkName).Append("=" + ParamKey + "ID");
DataTable dt = ExecuteDataTable(sb.ToString(), new OracleParameter(ParamKey + "ID", pkVal));
if (dt != null && dt.Rows.Count > 0)
{
return(DataConvertHelper.DataRowToModel <T>(dt.Rows[0]));
}
return(model);
}
