/// <summary> /// 得到一个对象实体 /// </summary> public JMP.MDL.appmonitor GetModel(int a_id) { StringBuilder strSql = new StringBuilder(); strSql.Append("select a_id, a_appid, a_request, a_minute, a_state, a_datetime,a_type,a_time_range "); strSql.Append(" from appmonitor "); strSql.Append(" where a_id=@a_id"); SqlParameter[] parameters = { new SqlParameter("@a_id", SqlDbType.Int, 4) }; parameters[0].Value = a_id; JMP.MDL.appmonitor model = new JMP.MDL.appmonitor(); DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { if (ds.Tables[0].Rows[0]["a_id"].ToString() != "") { model.a_id = int.Parse(ds.Tables[0].Rows[0]["a_id"].ToString()); } if (ds.Tables[0].Rows[0]["a_appid"].ToString() != "") { model.a_appid = int.Parse(ds.Tables[0].Rows[0]["a_appid"].ToString()); } if (ds.Tables[0].Rows[0]["a_request"].ToString() != "") { model.a_request = decimal.Parse(ds.Tables[0].Rows[0]["a_request"].ToString()); } if (ds.Tables[0].Rows[0]["a_minute"].ToString() != "") { model.a_minute = int.Parse(ds.Tables[0].Rows[0]["a_minute"].ToString()); } if (ds.Tables[0].Rows[0]["a_state"].ToString() != "") { model.a_state = int.Parse(ds.Tables[0].Rows[0]["a_state"].ToString()); } if (ds.Tables[0].Rows[0]["a_datetime"].ToString() != "") { model.a_datetime = DateTime.Parse(ds.Tables[0].Rows[0]["a_datetime"].ToString()); } if (ds.Tables[0].Rows[0]["a_type"].ToString() != "") { model.a_type = int.Parse(ds.Tables[0].Rows[0]["a_type"].ToString()); } model.a_time_range = ds.Tables[0].Rows[0]["a_time_range"].ToString(); return(model); } else { return(null); } }
/// <summary> /// 增加一条数据 /// </summary> public int Add(JMP.MDL.appmonitor model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into appmonitor("); strSql.Append("a_appid,a_request,a_minute,a_state,a_datetime,a_time_range,a_type"); strSql.Append(") values ("); strSql.Append("@a_appid,@a_request,@a_minute,@a_state,@a_datetime,@a_time_range,@a_type"); strSql.Append(") "); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@a_appid", SqlDbType.Int, 4), new SqlParameter("@a_request", SqlDbType.Decimal, 9), new SqlParameter("@a_minute", SqlDbType.Int, 4), new SqlParameter("@a_state", SqlDbType.Int, 4), new SqlParameter("@a_datetime", SqlDbType.DateTime), new SqlParameter("@a_time_range", SqlDbType.NVarChar, -1), new SqlParameter("@a_type", SqlDbType.Int, 4) }; parameters[0].Value = model.a_appid; parameters[1].Value = model.a_request; parameters[2].Value = model.a_minute; parameters[3].Value = model.a_state; parameters[4].Value = model.a_datetime; parameters[5].Value = model.a_time_range; parameters[6].Value = model.a_type; object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters); if (obj == null) { return(0); } else { return(Convert.ToInt32(obj)); } }