public int Add(news model)
{
StringBuilder builder = new StringBuilder();
builder.Append("insert into pd_project_regulate(");
builder.Append("PD_PROJECT_CODE,PD_PROJECT_SUBJECTS,PD_PROJECT_CONTENTS,PD_PROJECT_SYSDATE,PD_PROJECT_TYPE)");
builder.Append(" values (");
builder.Append(":PD_PROJECT_CODE,:PD_PROJECT_SUBJECTS,:PD_PROJECT_CONTENTS,:PD_PROJECT_SYSDATE,:PD_PROJECT_TYPE)");
OracleParameter[] cmdParms = new OracleParameter[] { new OracleParameter(":PD_PROJECT_CODE", OracleType.Char, 0x24), new OracleParameter(":PD_PROJECT_SUBJECTS", OracleType.VarChar, 220), new OracleParameter(":PD_PROJECT_CONTENTS", OracleType.LongVarChar), new OracleParameter(":PD_PROJECT_SYSDATE", OracleType.DateTime), new OracleParameter(":PD_PROJECT_TYPE", OracleType.Number, 4) };
cmdParms[0].Value = model.newid;
cmdParms[1].Value = model.subjects;
cmdParms[2].Value = model.contents;
cmdParms[3].Value = model.sysdate_;
cmdParms[4].Value = model.type;
return DbHelperOra.ExecuteSql(builder.ToString(), cmdParms);
}
public int Update(news model)
{
StringBuilder builder = new StringBuilder();
builder.Append("update PD_PROJECT_REGULATE set ");
builder.Append("PD_PROJECT_SUBJECTS=:PD_PROJECT_SUBJECTS,");
builder.Append("PD_PROJECT_CONTENTS=:PD_PROJECT_CONTENTS,");
builder.Append("PD_PROJECT_SYSDATE=:PD_PROJECT_SYSDATE,");
builder.Append("PD_PROJECT_TYPE=:PD_PROJECT_TYPE");
builder.Append(" where PD_PROJECT_CODE=:PD_PROJECT_CODE ");
OracleParameter[] cmdParms = new OracleParameter[] { new OracleParameter(":PD_PROJECT_SUBJECTS", OracleType.VarChar, 220), new OracleParameter(":PD_PROJECT_CONTENTS", OracleType.LongVarChar), new OracleParameter(":PD_PROJECT_SYSDATE", OracleType.DateTime), new OracleParameter(":PD_PROJECT_TYPE", OracleType.Number, 4), new OracleParameter(":PD_PROJECT_CODE", OracleType.Char, 100) };
cmdParms[0].Value = model.subjects;
cmdParms[1].Value = model.contents;
cmdParms[2].Value = model.sysdate_;
cmdParms[3].Value = model.type;
cmdParms[4].Value = model.newid;
return DbHelperOra.ExecuteSql(builder.ToString(), cmdParms);
}
public int Update(news model)
{
return this.dal.Update(model);
}
public int Add(news model)
{
return this.dal.Add(model);
}