public int Add(HideColumn_Model model) { StringBuilder builder = new StringBuilder(); builder.Append("insert into HIDECOLUMN("); builder.Append("ID,REPORTPARAMPK,COLUMNNAME)"); builder.Append(" values ("); builder.Append(":REPORTPARAMPK,:COLUMNNAME)"); OracleParameter[] cmdParms = { new OracleParameter(":REPORTPARAMPK", OracleType.Number,4), new OracleParameter(":COLUMNNAME", OracleType.VarChar,50)}; cmdParms[0].Value = model.reportParamPK; cmdParms[1].Value = model.ColumnName; return DbHelperOra.ExecuteSql(builder.ToString(), cmdParms); }
public HideColumn_Model DataRowToModel(DataRow row) { HideColumn_Model model = new HideColumn_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(); } } return model; }
public bool Update(HideColumn_Model model) { StringBuilder builder = new StringBuilder(); builder.Append("update HideColumn set "); builder.Append("reportParamPK=:reportParamPK,"); builder.Append("ColumnName=:ColumnName"); builder.Append(" where id=:id"); OracleParameter[] cmdParms = new OracleParameter[] { new OracleParameter(":reportParamPK", OracleType.Number, 4), new OracleParameter(":ColumnName", OracleType.VarChar, 50), new OracleParameter(":id", OracleType.Number, 4) }; cmdParms[0].Value = model.reportParamPK; cmdParms[1].Value = model.ColumnName; cmdParms[2].Value = model.id; return (DbHelperOra.ExecuteSql(builder.ToString(), cmdParms) > 0); }
public bool Update(HideColumn_Model model) { return this.dal.Update(model); }
public int Add(HideColumn_Model model) { return this.dal.Add(model); }