/// <summary>
/// 根据条件，返回IList
/// </summary>
/// <param name="sqlWhere">sql语句</param>
/// <param name="parameters">参数</param>
/// <returns></returns>
public IList<Owen.Model.Model_UserInfo> GetEntities(string sql, params SqlParameter[] parameters)
{
SqlServerHelper.PopulateDelegate<Owen.Model.Model_UserInfo> entities =
new SqlServerHelper.PopulateDelegate<Owen.Model.Model_UserInfo>(this.Populate_UserInfo);
return SqlServerHelper.GetEntities<Owen.Model.Model_UserInfo>(entities, sql, parameters);
}
/// <summary>
/// 根据条件，返回IList
/// </summary>
/// <param name="sqlWhere">sql语句</param>
/// <param name="parameters">参数</param>
/// <returns></returns>
public IList<Owen.Model.Model_MedicalRelation> GetEntities(string sql, params SqlParameter[] parameters)
{
SqlServerHelper.PopulateDelegate<Owen.Model.Model_MedicalRelation> entities =
new SqlServerHelper.PopulateDelegate<Owen.Model.Model_MedicalRelation>(this.Populate_MedicalRelation);
return SqlServerHelper.GetEntities<Owen.Model.Model_MedicalRelation>(entities, sql, parameters);
}
/// <summary>
/// 根据条件，返回IList
/// </summary>
/// <param name="sqlWhere">sql语句</param>
/// <param name="parameters">参数</param>
/// <returns></returns>
public IList <QuartzInAction.Model.DBConfigModel> GetEntities(string sql, string _conStr,
params SqlParameter[] parameters)
{
SqlServerHelper.PopulateDelegate <QuartzInAction.Model.DBConfigModel> entities =
new SqlServerHelper.PopulateDelegate <QuartzInAction.Model.DBConfigModel>(this.Populate_BankList);
return(SqlServerHelper.GetEntities <QuartzInAction.Model.DBConfigModel>(entities, sql, _conStr, parameters));
}
/// <summary>
/// 根据条件，返回IList
/// </summary>
/// <param name="sqlWhere">sql条件</param>
/// <returns></returns>
public IList<Owen.Model.Model_Attentive> GetEntities(string sqlWhere)
{
string sql = string.Format("select * from [Attentive] ");
if (sqlWhere.Trim() != "")
sql += string.Format(" where {0} ", sqlWhere);
SqlServerHelper.PopulateDelegate<Owen.Model.Model_Attentive> entities =
new SqlServerHelper.PopulateDelegate<Owen.Model.Model_Attentive>(this.Populate_Attentive);
return SqlServerHelper.GetEntities<Owen.Model.Model_Attentive>(entities, sql);
}
/// <summary>
/// 根据条件，返回IList
/// </summary>
/// <param name="sqlWhere">sql条件</param>
/// <returns>IList</returns>
public IList <DBConfigModel> GetEntities(string sqlWhere, string _conStr)
{
SqlServerHelper.PopulateDelegate <QuartzInAction.Model.DBConfigModel> entities =
new SqlServerHelper.PopulateDelegate <QuartzInAction.Model.DBConfigModel>(this.Populate_BankList);
string sql = string.Format("select * from DBConfig ");
if (sqlWhere.Trim() != "")
{
sql += string.Format(" where {0} ", sqlWhere);
}
return(SqlServerHelper.GetEntities <QuartzInAction.Model.DBConfigModel>(entities, sql, _conStr));
}
public IList <OrderModel> GetEntities(string sqlwhere, string _conStr)
{
SqlServerHelper.PopulateDelegate <OrderModel> entities =
new SqlServerHelper.PopulateDelegate <OrderModel>(this.Populate_Orders);
string sql = string.Format("select * from Orders");
if (sqlwhere.Trim() != "")
{
sql += string.Format(" where {0} ", sqlwhere);
}
return(SqlServerHelper.GetEntities <OrderModel>(entities, sql, _conStr));
}
/// <summary>
/// 根据条件，返回IList
/// </summary>
/// <param name="sqlWhere">sql条件</param>
/// <returns></returns>
public IList<Owen.Model.Model_Partners> GetEntities(Owen.Common.QueryParam queryParam, out int count)
{
IList<Model.Model_Partners> list = new List<Owen.Model.Model_Partners>();
queryParam.TableName = "Partners";
queryParam.ReturnFields = "*";
if (queryParam.Orderfld == null)
{
queryParam.Orderfld = "PartnersID";
}
else if (queryParam.Orderfld != "PartnersID")
{
queryParam.Orderfld += ",PartnersID";
}
SqlServerHelper.PopulateDelegate<Owen.Model.Model_Partners> mypd =
new SqlServerHelper.PopulateDelegate<Owen.Model.Model_Partners>(this.Populate_Partners);
return SqlServerHelper.GetEntities(mypd, queryParam, out count);
}
/// <summary>
/// 根据条件，返回IList
/// </summary>
/// <param name="sqlWhere">sql条件</param>
/// <returns></returns>
public IList<Owen.Model.Model_MedicalRelation> GetEntities(Owen.Common.QueryParam queryParam, out int count)
{
IList<Model.Model_MedicalRelation> list = new List<Owen.Model.Model_MedicalRelation>();
queryParam.TableName = "MedicalRelation";
queryParam.ReturnFields = "*";
if (queryParam.Orderfld == null)
{
queryParam.Orderfld = "Id";
}
else if (queryParam.Orderfld != "Id")
{
queryParam.Orderfld += ",Id";
}
SqlServerHelper.PopulateDelegate<Owen.Model.Model_MedicalRelation> mypd =
new SqlServerHelper.PopulateDelegate<Owen.Model.Model_MedicalRelation>(this.Populate_MedicalRelation);
return SqlServerHelper.GetEntities(mypd, queryParam, out count);
}
/// <summary>
/// 返回IList
/// </summary>
/// <param name="strWhere">查询条件</param>
/// <param name="pageSize">每页数据大小</param>
/// <param name="pageIndex">第几页</param>
/// <param name="orderField">排序字段</param>
/// <param name="count">返回记录总数</param>
/// <returns>返回记录集List</returns>
public System.Collections.Generic.IList<Owen.Model.Model_UserInfo> GetEntities(string strWhere,
int pageSize, int pageIndex, string orderField, out int count)
{
StringBuilder strSql = new StringBuilder(50);
strSql.Append(" select * from [UserInfo] ");
if (strWhere.Trim() != "")
{
strSql.Append(" where " + strWhere);
}
//得到记录总数
count = Convert.ToInt32(SqlServerHelper.GetSingle(Owen.Common.PagingHelper.CreateCountingSql(strSql.ToString())));
SqlServerHelper.PopulateDelegate<Owen.Model.Model_UserInfo> mypd =
new SqlServerHelper.PopulateDelegate<Owen.Model.Model_UserInfo>(this.Populate_UserInfo);
return SqlServerHelper.GetEntities(mypd, count, pageSize, pageIndex, strSql.ToString(), orderField);
}
/// <summary>
/// 根据条件，返回IList
/// </summary>
/// <param name="sqlWhere">sql条件</param>
/// <returns></returns>
public IList<Owen.Model.Model_Hospital> GetEntities(Owen.Common.QueryParam queryParam, out int count)
{
IList<Model.Model_Hospital> list = new List<Owen.Model.Model_Hospital>();
queryParam.TableName = "Hospital";
queryParam.ReturnFields = "*";
if (queryParam.Orderfld == null)
{
queryParam.Orderfld = "DistributorID";
}
else if (queryParam.Orderfld != "DistributorID")
{
queryParam.Orderfld += ",DistributorID";
}
SqlServerHelper.PopulateDelegate<Owen.Model.Model_Hospital> mypd =
new SqlServerHelper.PopulateDelegate<Owen.Model.Model_Hospital>(this.Populate_Hospital);
return SqlServerHelper.GetEntities(mypd, queryParam, out count);
}
/// <summary>
/// 返回IList
/// </summary>
/// <param name="strWhere">查询条件</param>
/// <param name="pageSize">每页数据大小</param>
/// <param name="pageIndex">第几页</param>
/// <param name="orderField">排序字段</param>
/// <param name="count">返回记录总数</param>
/// <returns>返回记录集List</returns>
public IList<Owen.Model.Model_SysLog> GetEntities(string strWhere,
int pageSize, int pageIndex, string orderField, out int count)
{
string strSql = " select * from [SysLog] ";
if (strWhere.Trim() != "")
strSql += string.Format(" where {0} ", strWhere);
//得到记录总数
count = Convert.ToInt32(SqlServerHelper.GetSingle(Owen.Common.PagingHelper.CreateCountingSql(strSql.ToString())));
SqlServerHelper.PopulateDelegate<Owen.Model.Model_SysLog> mypd =
new SqlServerHelper.PopulateDelegate<Owen.Model.Model_SysLog>(this.Populate_SysLog);
return SqlServerHelper.GetEntities(mypd, count, pageSize, pageIndex, strSql.ToString(), orderField);
}
