public bool Add(whereList_Model model) { StringBuilder builder = new StringBuilder(); builder.Append("insert into whereList("); builder.Append("reportParamPK,columnName,columnType,IsBindDate,DateType,IsQuJian,IsProcParam,IsLike,IsShow,IsGetData,ShowTableName,ShowColumn)"); builder.Append(" values ("); builder.Append(":reportParamPK,:columnName,:columnType,:IsBindDate,:DateType,:IsQuJian,:IsProcParam,:IsLike,:IsShow,:IsGetData,:ShowTableName,:ShowColumn)"); OracleParameter[] cmdParms = new OracleParameter[] { new OracleParameter(":reportParamPK", OracleType.Number, 4), new OracleParameter(":columnName", OracleType.VarChar, 0), new OracleParameter(":columnType", OracleType.VarChar, 50), new OracleParameter(":IsBindDate", OracleType.Number,4), new OracleParameter(":DateType", OracleType.VarChar, 50), new OracleParameter(":IsQuJian", OracleType.Number,4), new OracleParameter(":IsProcParam", OracleType.Number,4), new OracleParameter(":IsLike", OracleType.Number,4), new OracleParameter(":IsShow", OracleType.VarChar, 50), new OracleParameter(":IsGetData", OracleType.Number,4), new OracleParameter(":ShowTableName", OracleType.VarChar, 50), new OracleParameter(":ShowColumn", OracleType.VarChar, 0xff) }; cmdParms[0].Value = model.reportParamPK; cmdParms[1].Value = model.columnName; cmdParms[2].Value = model.columnType; cmdParms[3].Value = model.IsBindDate; cmdParms[4].Value = model.DateType; cmdParms[5].Value = model.IsQuJian; cmdParms[6].Value = model.IsProcParam; cmdParms[7].Value = model.IsLike; cmdParms[8].Value = model.IsShow; cmdParms[9].Value = model.IsGetData; cmdParms[10].Value = model.ShowTableName; cmdParms[11].Value = model.ShowColumn; return (DbHelperOra.ExecuteSql(builder.ToString(), cmdParms) > 0); }
public whereList_Model DataRowToModel(DataRow row) { whereList_Model model = new whereList_Model(); if (row != null) { if ((row["id"] != null) && (row["id"].ToString() != "")) { model.id = int.Parse(row["id"].ToString()); } if ((row["reportParamPK"] != null) && (row["reportParamPK"].ToString() != "")) { model.reportParamPK = new int?(int.Parse(row["reportParamPK"].ToString())); } if (row["columnName"] != null) { model.columnName = row["columnName"].ToString(); } if (row["columnType"] != null) { model.columnType = row["columnType"].ToString(); } if ((row["IsBindDate"] != null) && (row["IsBindDate"].ToString().Trim() != "")) { model.IsBindDate = byte.Parse(row["IsBindDate"].ToString()); } if (row["DateType"] != null) { model.DateType = row["DateType"].ToString(); } if (row["IsQuJian"] != null) { model.IsQuJian = byte.Parse(row["IsQuJian"].ToString()); } if (row["IsProcParam"] != null) { model.IsProcParam = byte.Parse(row["IsProcParam"].ToString()); } if (row["IsLike"] != null) { model.IsLike = byte.Parse(row["IsLike"].ToString()); } if (row["IsShow"] != null) { model.IsShow = row["IsShow"].ToString(); } if ((row["IsGetData"] != null) && (row["IsGetData"].ToString().Trim() != "")) { model.IsGetData = byte.Parse(row["IsGetData"].ToString()); } if (row["ShowTableName"] != null) { model.ShowTableName = row["ShowTableName"].ToString(); } if (row["ShowColumn"] != null) { model.ShowColumn = row["ShowColumn"].ToString(); } if (row["ShowWhere"] != null) { model.ShowWhere = row["ShowWhere"].ToString(); } } return model; }
public bool Update(whereList_Model model) { StringBuilder builder = new StringBuilder(); builder.Append("update whereList set "); builder.Append("reportParamPK=:reportParamPK,"); builder.Append("columnName=:columnName,"); builder.Append("columnType=:columnType,"); builder.Append("IsBindDate=:IsBindDate,"); builder.Append("DateType=:DateType,"); builder.Append("IsQuJian=:IsQuJian,"); builder.Append("IsProcParam=:IsProcParam,"); builder.Append("IsLike=:IsLike,"); builder.Append("IsShow=:IsShow,"); builder.Append("IsGetData=:IsGetData,"); builder.Append("ShowTableName=:ShowTableName,"); builder.Append("ShowColumn=:ShowColumn"); builder.Append(" where id=:id"); OracleParameter[] cmdParms = new OracleParameter[] { new OracleParameter(":reportParamPK", OracleType.Number, 4), new OracleParameter(":columnName", OracleType.VarChar, 0), new OracleParameter(":columnType", OracleType.VarChar, 50), new OracleParameter(":IsBindDate", OracleType.Number,4), new OracleParameter(":DateType", OracleType.VarChar, 50), new OracleParameter(":IsQuJian", OracleType.Number,4), new OracleParameter(":IsProcParam", OracleType.Number,4), new OracleParameter(":IsLike", OracleType.Number,4), new OracleParameter(":IsShow", OracleType.VarChar, 50), new OracleParameter(":IsGetData", OracleType.Number,4), new OracleParameter(":ShowTableName", OracleType.VarChar, 50), new OracleParameter(":ShowColumn", OracleType.VarChar, 0xff), new OracleParameter(":id", OracleType.Number, 4) }; cmdParms[0].Value = model.reportParamPK; cmdParms[1].Value = model.columnName; cmdParms[2].Value = model.columnType; cmdParms[3].Value = model.IsBindDate; cmdParms[4].Value = model.DateType; cmdParms[5].Value = model.IsQuJian; cmdParms[6].Value = model.IsProcParam; cmdParms[7].Value = model.IsLike; cmdParms[8].Value = model.IsShow; cmdParms[9].Value = model.IsGetData; cmdParms[10].Value = model.ShowTableName; cmdParms[11].Value = model.ShowColumn; cmdParms[12].Value = model.id; return (DbHelperOra.ExecuteSql(builder.ToString(), cmdParms) > 0); }