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);
}
