/// <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); }