/// <summary> /// 更新一条数据 /// </summary> public bool Update(Model.HEADERMAPPINGTB model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update HEADERMAPPINGTB set "); strSql.Append("ID=:ID,"); strSql.Append("EXPRESSION=:EXPRESSION,"); strSql.Append("TABLENAME=:TABLENAME,"); strSql.Append("TYPE=:TYPE,"); strSql.Append("DATA_TYPE=:DATA_TYPE,"); strSql.Append("NULLABLE=:NULLABLE,"); strSql.Append("HEADING=:HEADING,"); strSql.Append("REPORTCOL=:REPORTCOL,"); strSql.Append("FORMATTER=:FORMATTER"); strSql.Append(" where ID=:ID "); OracleParameter[] parameters = { new OracleParameter(":ID", OracleType.VarChar, 40), new OracleParameter(":EXPRESSION", OracleType.VarChar, 800), new OracleParameter(":TABLENAME", OracleType.VarChar, 40), new OracleParameter(":TYPE", OracleType.Char, 1), new OracleParameter(":DATA_TYPE", OracleType.VarChar, 40), new OracleParameter(":NULLABLE", OracleType.VarChar, 1), new OracleParameter(":HEADING", OracleType.VarChar, 60), new OracleParameter(":REPORTCOL", OracleType.VarChar, 10), new OracleParameter(":FORMATTER", OracleType.VarChar, 40) }; parameters[0].Value = model.ID; parameters[1].Value = model.EXPRESSION; parameters[2].Value = model.TABLENAME; parameters[3].Value = model.TYPE; parameters[4].Value = model.DATA_TYPE; parameters[5].Value = model.NULLABLE; parameters[6].Value = model.HEADING; parameters[7].Value = model.REPORTCOL; parameters[8].Value = model.FORMATTER; int rows = DbHelperOra.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 得到一个对象实体 /// </summary> public Model.HEADERMAPPINGTB DataRowToModel(DataRow row) { Model.HEADERMAPPINGTB model = new Model.HEADERMAPPINGTB(); if (row != null) { if (row["ID"] != null) { model.ID = row["ID"].ToString(); } if (row["EXPRESSION"] != null) { model.EXPRESSION = row["EXPRESSION"].ToString(); } if (row["TABLENAME"] != null) { model.TABLENAME = row["TABLENAME"].ToString(); } if (row["TYPE"] != null) { model.TYPE = row["TYPE"].ToString(); } if (row["DATA_TYPE"] != null) { model.DATA_TYPE = row["DATA_TYPE"].ToString(); } if (row["NULLABLE"] != null) { model.NULLABLE = row["NULLABLE"].ToString(); } if (row["HEADING"] != null) { model.HEADING = row["HEADING"].ToString(); } if (row["REPORTCOL"] != null) { model.REPORTCOL = row["REPORTCOL"].ToString(); } if (row["FORMATTER"] != null) { model.FORMATTER = row["FORMATTER"].ToString(); } } return(model); }
/// <summary> /// 增加一条数据 /// </summary> public bool Add(Model.HEADERMAPPINGTB model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into HEADERMAPPINGTB("); strSql.Append("ID,EXPRESSION,TABLENAME,TYPE,DATA_TYPE,NULLABLE,HEADING,REPORTCOL,FORMATTER)"); strSql.Append(" values ("); strSql.Append(":ID,:EXPRESSION,:TABLENAME,:TYPE,:DATA_TYPE,:NULLABLE,:HEADING,:REPORTCOL,:FORMATTER)"); OracleParameter[] parameters = { new OracleParameter(":ID", OracleType.VarChar, 40), new OracleParameter(":EXPRESSION", OracleType.VarChar, 800), new OracleParameter(":TABLENAME", OracleType.VarChar, 40), new OracleParameter(":TYPE", OracleType.Char, 1), new OracleParameter(":DATA_TYPE", OracleType.VarChar, 40), new OracleParameter(":NULLABLE", OracleType.VarChar, 1), new OracleParameter(":HEADING", OracleType.VarChar, 60), new OracleParameter(":REPORTCOL", OracleType.VarChar, 10), new OracleParameter(":FORMATTER", OracleType.VarChar, 40) }; parameters[0].Value = model.ID; parameters[1].Value = model.EXPRESSION; parameters[2].Value = model.TABLENAME; parameters[3].Value = model.TYPE; parameters[4].Value = model.DATA_TYPE; parameters[5].Value = model.NULLABLE; parameters[6].Value = model.HEADING; parameters[7].Value = model.REPORTCOL; parameters[8].Value = model.FORMATTER; int rows = DbHelperOra.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 得到一个对象实体 /// </summary> public Model.HEADERMAPPINGTB GetModel(string ID) { StringBuilder strSql = new StringBuilder(); strSql.Append("select ID,EXPRESSION,TABLENAME,TYPE,DATA_TYPE,NULLABLE,HEADING,REPORTCOL,FORMATTER from HEADERMAPPINGTB "); strSql.Append(" where ID=:ID "); OracleParameter[] parameters = { new OracleParameter(":ID", OracleType.VarChar, 40) }; parameters[0].Value = ID; Model.HEADERMAPPINGTB model = new Model.HEADERMAPPINGTB(); DataSet ds = DbHelperOra.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { return(DataRowToModel(ds.Tables[0].Rows[0])); } else { return(null); } }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(Model.HEADERMAPPINGTB model) { return(dal.Update(model)); }
/// <summary> /// 增加一条数据 /// </summary> public bool Add(Model.HEADERMAPPINGTB model) { return(dal.Add(model)); }