/// <summary> /// 更新一条数据 /// </summary> public bool Update(AOC.Perf.Model.SIDCONSTRAINTS model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update SIDCONSTRAINTS set "); strSql.Append("TARGETALTITUDE=@TARGETALTITUDE,"); strSql.Append("GRADIENT=@GRADIENT,"); strSql.Append("COMMENTS=@COMMENTS,"); strSql.Append("LASTUPDATE=@LASTUPDATE,"); strSql.Append("QFUCODE=@QFUCODE,"); strSql.Append("CREATIONDATE=@CREATIONDATE,"); strSql.Append("UPDATEDATE=@UPDATEDATE,"); strSql.Append("UPDATETIME=@UPDATETIME"); strSql.Append(" where "); OleDbParameter[] parameters = { new OleDbParameter("@TARGETALTITUDE", OleDbType.VarChar, 20), new OleDbParameter("@GRADIENT", OleDbType.Double), new OleDbParameter("@COMMENTS", OleDbType.VarChar, 0), new OleDbParameter("@LASTUPDATE", OleDbType.Integer, 4), new OleDbParameter("@QFUCODE", OleDbType.Integer, 4), new OleDbParameter("@CREATIONDATE", OleDbType.Integer, 4), new OleDbParameter("@UPDATEDATE", OleDbType.Integer, 4), new OleDbParameter("@UPDATETIME", OleDbType.Integer, 4), new OleDbParameter("@SIDCONSTRAINTSCODE", OleDbType.Integer, 4) }; parameters[0].Value = model.TARGETALTITUDE; parameters[1].Value = model.GRADIENT; parameters[2].Value = model.COMMENTS; parameters[3].Value = model.LASTUPDATE; parameters[4].Value = model.QFUCODE; parameters[5].Value = model.CREATIONDATE; parameters[6].Value = model.UPDATEDATE; parameters[7].Value = model.UPDATETIME; parameters[8].Value = model.SIDCONSTRAINTSCODE; int rows = DbHelperOleDb.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 得到一个对象实体 /// </summary> public AOC.Perf.Model.SIDCONSTRAINTS DataRowToModel(DataRow row) { AOC.Perf.Model.SIDCONSTRAINTS model = new AOC.Perf.Model.SIDCONSTRAINTS(); if (row != null) { if (row["SIDCONSTRAINTSCODE"] != null && row["SIDCONSTRAINTSCODE"].ToString() != "") { model.SIDCONSTRAINTSCODE = int.Parse(row["SIDCONSTRAINTSCODE"].ToString()); } if (row["TARGETALTITUDE"] != null) { model.TARGETALTITUDE = row["TARGETALTITUDE"].ToString(); } //model.GRADIENT=row["GRADIENT"].ToString(); if (row["COMMENTS"] != null) { model.COMMENTS = row["COMMENTS"].ToString(); } if (row["LASTUPDATE"] != null && row["LASTUPDATE"].ToString() != "") { model.LASTUPDATE = int.Parse(row["LASTUPDATE"].ToString()); } if (row["QFUCODE"] != null && row["QFUCODE"].ToString() != "") { model.QFUCODE = int.Parse(row["QFUCODE"].ToString()); } if (row["CREATIONDATE"] != null && row["CREATIONDATE"].ToString() != "") { model.CREATIONDATE = int.Parse(row["CREATIONDATE"].ToString()); } if (row["UPDATEDATE"] != null && row["UPDATEDATE"].ToString() != "") { model.UPDATEDATE = int.Parse(row["UPDATEDATE"].ToString()); } if (row["UPDATETIME"] != null && row["UPDATETIME"].ToString() != "") { model.UPDATETIME = int.Parse(row["UPDATETIME"].ToString()); } } return(model); }
/// <summary> /// 增加一条数据 /// </summary> public bool Add(AOC.Perf.Model.SIDCONSTRAINTS model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into SIDCONSTRAINTS("); strSql.Append("TARGETALTITUDE,GRADIENT,COMMENTS,LASTUPDATE,QFUCODE,CREATIONDATE,UPDATEDATE,UPDATETIME)"); strSql.Append(" values ("); strSql.Append("@TARGETALTITUDE,@GRADIENT,@COMMENTS,@LASTUPDATE,@QFUCODE,@CREATIONDATE,@UPDATEDATE,@UPDATETIME)"); OleDbParameter[] parameters = { new OleDbParameter("@TARGETALTITUDE", OleDbType.VarChar, 20), new OleDbParameter("@GRADIENT", OleDbType.Double), new OleDbParameter("@COMMENTS", OleDbType.VarChar, 0), new OleDbParameter("@LASTUPDATE", OleDbType.Integer, 4), new OleDbParameter("@QFUCODE", OleDbType.Integer, 4), new OleDbParameter("@CREATIONDATE", OleDbType.Integer, 4), new OleDbParameter("@UPDATEDATE", OleDbType.Integer, 4), new OleDbParameter("@UPDATETIME", OleDbType.Integer, 4) }; parameters[0].Value = model.TARGETALTITUDE; parameters[1].Value = model.GRADIENT; parameters[2].Value = model.COMMENTS; parameters[3].Value = model.LASTUPDATE; parameters[4].Value = model.QFUCODE; parameters[5].Value = model.CREATIONDATE; parameters[6].Value = model.UPDATEDATE; parameters[7].Value = model.UPDATETIME; int rows = DbHelperOleDb.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 得到一个对象实体 /// </summary> public AOC.Perf.Model.SIDCONSTRAINTS GetModel() { //该表无主键信息,请自定义主键/条件字段 StringBuilder strSql = new StringBuilder(); strSql.Append("select SIDCONSTRAINTSCODE,TARGETALTITUDE,GRADIENT,COMMENTS,LASTUPDATE,QFUCODE,CREATIONDATE,UPDATEDATE,UPDATETIME from SIDCONSTRAINTS "); strSql.Append(" where "); OleDbParameter[] parameters = { }; AOC.Perf.Model.SIDCONSTRAINTS model = new AOC.Perf.Model.SIDCONSTRAINTS(); DataSet ds = DbHelperOleDb.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { return(DataRowToModel(ds.Tables[0].Rows[0])); } else { return(null); } }