/// <summary> /// Method to get one recoder by primary key /// </summary> public MDLLog GetModel(int ) { //Set up a return value MDLLog model = null; StringBuilder strSql = new StringBuilder(); strSql.Append("SELECT [Id], [Date], [Thread], [Level], [Logger], [Message], [Exception] "); strSql.Append(" FROM [Log] "); strSql.Append(" WHERE []=" + .ToString()); using (SqlDataReader sdr = DbHelperSQL.ExecuteReader(strSql.ToString())) { if (sdr.Read()) model = new MDLLog(sdr.(0), sdr.(1), sdr.(2), sdr.(3), sdr.(4), sdr.(5), sdr.(6));
/// <summary> /// Update one record /// </summary> public void Update(MDLLog model) { dal.Update(model); }
/// <summary> /// Add one record /// </summary> public int Add(MDLLog model) { return(dal.Add(model)); }