Ejemplo n.º 1
0
 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);
 }
Ejemplo n.º 2
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;
 }
Ejemplo n.º 3
0
 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);
 }