/// <summary>
/// ID 和创建人
/// </summary>
/// <param name="ID"></param>
/// <param name="wid"></param>
/// <returns></returns>
public SHUniversity.KPI.Model.KPIItems GetModel(int ID, string wid)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 * from KPIItems ");
strSql.Append(" where ID=@ID and ItemCreator=@wid");
SqlParameter[] parameters =
{
new SqlParameter("@ID", SqlDbType.Int, 4),
new SqlParameter("@wid", SqlDbType.NVarChar, 50)
};
parameters[0].Value = ID;
parameters[1].Value = wid;
SHUniversity.KPI.Model.KPIItems model = new SHUniversity.KPI.Model.KPIItems();
DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
public SHUniversity.KPI.Model.KPIItems GetModel(string strWhere)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 * from KPIItems ");
strSql.Append(" where " + strWhere);
SHUniversity.KPI.Model.KPIItems model = new SHUniversity.KPI.Model.KPIItems();
DataSet ds = DbHelperSQL.Query(strSql.ToString());
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
/// <summary>
/// 获得数据列表
/// </summary>
public List <SHUniversity.KPI.Model.KPIItems> GetListModel(string strWhere)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select * ");
strSql.Append(" FROM KPIItems ");
if (strWhere.Trim() != "")
{
strSql.Append(" where " + strWhere);
}
DataTable ds = DbHelperSQL.Query(strSql.ToString()).Tables[0];
List <SHUniversity.KPI.Model.KPIItems> list = new List <Model.KPIItems>();
if (ds.Rows.Count > 0)
{
foreach (DataRow item in ds.Rows)
{
SHUniversity.KPI.Model.KPIItems m = DataRowToModel(item);
list.Add(m);
}
}
return(list);
}
