/// <summary> /// 得到一个对象实体 /// </summary> public Model.DROPPING_CISCOREPORT GetModel(string OURNO) { StringBuilder strSql = new StringBuilder(); strSql.Append("select YOURNO,OURNO,TITLE,STATUS,COUNTRY,CASE_TYPE,RELATION_TYPE,FILING_TYPE,APPLICANT,APPNO,PCT_APP_DATE,FILING_DATE,PUBLICATION_NO,PUBLICATION,GRANTNOTIC_DATE,ANNO_NO,GAZETTE,CERTIFICATE_NO,EARLIEST_PRIORITY_DATE,EXPIRATION_DATE,HISTORY from DROPPING_CISCOREPORT "); strSql.Append(" where OURNO=:OURNO "); OracleParameter[] parameters = { new OracleParameter(":OURNO", OracleType.VarChar, 30) }; parameters[0].Value = OURNO; Model.DROPPING_CISCOREPORT model = new Model.DROPPING_CISCOREPORT(); DataSet ds = DbHelperOra.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { return(DataRowToModel(ds.Tables[0].Rows[0])); } else { return(null); } }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(Model.DROPPING_CISCOREPORT model) { return(dal.Update(model)); }
/// <summary> /// 增加一条数据 /// </summary> public bool Add(Model.DROPPING_CISCOREPORT model) { return(dal.Add(model)); }
/// <summary> /// 增加一条数据 /// </summary> public bool Add(Model.DROPPING_CISCOREPORT model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into DROPPING_CISCOREPORT("); strSql.Append("YOURNO,OURNO,TITLE,STATUS,COUNTRY,CASE_TYPE,RELATION_TYPE,FILING_TYPE,APPLICANT,APPNO,PCT_APP_DATE,FILING_DATE,PUBLICATION_NO,PUBLICATION,GRANTNOTIC_DATE,ANNO_NO,GAZETTE,CERTIFICATE_NO,EARLIEST_PRIORITY_DATE,EXPIRATION_DATE,HISTORY)"); strSql.Append(" values ("); strSql.Append(":YOURNO,:OURNO,:TITLE,:STATUS,:COUNTRY,:CASE_TYPE,:RELATION_TYPE,:FILING_TYPE,:APPLICANT,:APPNO,:PCT_APP_DATE,:FILING_DATE,:PUBLICATION_NO,:PUBLICATION,:GRANTNOTIC_DATE,:ANNO_NO,:GAZETTE,:CERTIFICATE_NO,:EARLIEST_PRIORITY_DATE,:EXPIRATION_DATE,:HISTORY)"); OracleParameter[] parameters = { new OracleParameter(":YOURNO", OracleType.VarChar, 30), new OracleParameter(":OURNO", OracleType.VarChar, 30), new OracleParameter(":TITLE", OracleType.VarChar, 1000), new OracleParameter(":STATUS", OracleType.VarChar, 40), new OracleParameter(":COUNTRY", OracleType.Char, 4), new OracleParameter(":CASE_TYPE", OracleType.VarChar, 40), new OracleParameter(":RELATION_TYPE", OracleType.VarChar, 40), new OracleParameter(":FILING_TYPE", OracleType.VarChar, 20), new OracleParameter(":APPLICANT", OracleType.VarChar, 200), new OracleParameter(":APPNO", OracleType.VarChar, 40), new OracleParameter(":PCT_APP_DATE", OracleType.DateTime), new OracleParameter(":FILING_DATE", OracleType.DateTime), new OracleParameter(":PUBLICATION_NO", OracleType.VarChar, 40), new OracleParameter(":PUBLICATION", OracleType.DateTime), new OracleParameter(":GRANTNOTIC_DATE", OracleType.DateTime), new OracleParameter(":ANNO_NO", OracleType.VarChar, 40), new OracleParameter(":GAZETTE", OracleType.DateTime), new OracleParameter(":CERTIFICATE_NO", OracleType.VarChar, 40), new OracleParameter(":EARLIEST_PRIORITY_DATE", OracleType.DateTime), new OracleParameter(":EXPIRATION_DATE", OracleType.DateTime), new OracleParameter(":HISTORY", OracleType.VarChar, 2000) }; parameters[0].Value = model.YOURNO; parameters[1].Value = model.OURNO; parameters[2].Value = model.TITLE; parameters[3].Value = model.STATUS; parameters[4].Value = model.COUNTRY; parameters[5].Value = model.CASE_TYPE; parameters[6].Value = model.RELATION_TYPE; parameters[7].Value = model.FILING_TYPE; parameters[8].Value = model.APPLICANT; parameters[9].Value = model.APPNO; parameters[10].Value = model.PCT_APP_DATE; parameters[11].Value = model.FILING_DATE; parameters[12].Value = model.PUBLICATION_NO; parameters[13].Value = model.PUBLICATION; parameters[14].Value = model.GRANTNOTIC_DATE; parameters[15].Value = model.ANNO_NO; parameters[16].Value = model.GAZETTE; parameters[17].Value = model.CERTIFICATE_NO; parameters[18].Value = model.EARLIEST_PRIORITY_DATE; parameters[19].Value = model.EXPIRATION_DATE; parameters[20].Value = model.HISTORY; int rows = DbHelperOra.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 得到一个对象实体 /// </summary> public Model.DROPPING_CISCOREPORT DataRowToModel(DataRow row) { Model.DROPPING_CISCOREPORT model = new Model.DROPPING_CISCOREPORT(); if (row != null) { if (row["YOURNO"] != null) { model.YOURNO = row["YOURNO"].ToString(); } if (row["OURNO"] != null) { model.OURNO = row["OURNO"].ToString(); } if (row["TITLE"] != null) { model.TITLE = row["TITLE"].ToString(); } if (row["STATUS"] != null) { model.STATUS = row["STATUS"].ToString(); } if (row["COUNTRY"] != null) { model.COUNTRY = row["COUNTRY"].ToString(); } if (row["CASE_TYPE"] != null) { model.CASE_TYPE = row["CASE_TYPE"].ToString(); } if (row["RELATION_TYPE"] != null) { model.RELATION_TYPE = row["RELATION_TYPE"].ToString(); } if (row["FILING_TYPE"] != null) { model.FILING_TYPE = row["FILING_TYPE"].ToString(); } if (row["APPLICANT"] != null) { model.APPLICANT = row["APPLICANT"].ToString(); } if (row["APPNO"] != null) { model.APPNO = row["APPNO"].ToString(); } if (row["PCT_APP_DATE"] != null && row["PCT_APP_DATE"].ToString() != "") { model.PCT_APP_DATE = DateTime.Parse(row["PCT_APP_DATE"].ToString()); } if (row["FILING_DATE"] != null && row["FILING_DATE"].ToString() != "") { model.FILING_DATE = DateTime.Parse(row["FILING_DATE"].ToString()); } if (row["PUBLICATION_NO"] != null) { model.PUBLICATION_NO = row["PUBLICATION_NO"].ToString(); } if (row["PUBLICATION"] != null && row["PUBLICATION"].ToString() != "") { model.PUBLICATION = DateTime.Parse(row["PUBLICATION"].ToString()); } if (row["GRANTNOTIC_DATE"] != null && row["GRANTNOTIC_DATE"].ToString() != "") { model.GRANTNOTIC_DATE = DateTime.Parse(row["GRANTNOTIC_DATE"].ToString()); } if (row["ANNO_NO"] != null) { model.ANNO_NO = row["ANNO_NO"].ToString(); } if (row["GAZETTE"] != null && row["GAZETTE"].ToString() != "") { model.GAZETTE = DateTime.Parse(row["GAZETTE"].ToString()); } if (row["CERTIFICATE_NO"] != null) { model.CERTIFICATE_NO = row["CERTIFICATE_NO"].ToString(); } if (row["EARLIEST_PRIORITY_DATE"] != null && row["EARLIEST_PRIORITY_DATE"].ToString() != "") { model.EARLIEST_PRIORITY_DATE = DateTime.Parse(row["EARLIEST_PRIORITY_DATE"].ToString()); } if (row["EXPIRATION_DATE"] != null && row["EXPIRATION_DATE"].ToString() != "") { model.EXPIRATION_DATE = DateTime.Parse(row["EXPIRATION_DATE"].ToString()); } if (row["HISTORY"] != null) { model.HISTORY = row["HISTORY"].ToString(); } } return(model); }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(Model.DROPPING_CISCOREPORT model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update DROPPING_CISCOREPORT set "); strSql.Append("YOURNO=:YOURNO,"); strSql.Append("OURNO=:OURNO,"); strSql.Append("TITLE=:TITLE,"); strSql.Append("STATUS=:STATUS,"); strSql.Append("COUNTRY=:COUNTRY,"); strSql.Append("CASE_TYPE=:CASE_TYPE,"); strSql.Append("RELATION_TYPE=:RELATION_TYPE,"); strSql.Append("FILING_TYPE=:FILING_TYPE,"); strSql.Append("APPLICANT=:APPLICANT,"); strSql.Append("APPNO=:APPNO,"); strSql.Append("PCT_APP_DATE=:PCT_APP_DATE,"); strSql.Append("FILING_DATE=:FILING_DATE,"); strSql.Append("PUBLICATION_NO=:PUBLICATION_NO,"); strSql.Append("PUBLICATION=:PUBLICATION,"); strSql.Append("GRANTNOTIC_DATE=:GRANTNOTIC_DATE,"); strSql.Append("ANNO_NO=:ANNO_NO,"); strSql.Append("GAZETTE=:GAZETTE,"); strSql.Append("CERTIFICATE_NO=:CERTIFICATE_NO,"); strSql.Append("EARLIEST_PRIORITY_DATE=:EARLIEST_PRIORITY_DATE,"); strSql.Append("EXPIRATION_DATE=:EXPIRATION_DATE,"); strSql.Append("HISTORY=:HISTORY"); strSql.Append(" where OURNO=:OURNO "); OracleParameter[] parameters = { new OracleParameter(":YOURNO", OracleType.VarChar, 30), new OracleParameter(":OURNO", OracleType.VarChar, 30), new OracleParameter(":TITLE", OracleType.VarChar, 1000), new OracleParameter(":STATUS", OracleType.VarChar, 40), new OracleParameter(":COUNTRY", OracleType.Char, 4), new OracleParameter(":CASE_TYPE", OracleType.VarChar, 40), new OracleParameter(":RELATION_TYPE", OracleType.VarChar, 40), new OracleParameter(":FILING_TYPE", OracleType.VarChar, 20), new OracleParameter(":APPLICANT", OracleType.VarChar, 200), new OracleParameter(":APPNO", OracleType.VarChar, 40), new OracleParameter(":PCT_APP_DATE", OracleType.DateTime), new OracleParameter(":FILING_DATE", OracleType.DateTime), new OracleParameter(":PUBLICATION_NO", OracleType.VarChar, 40), new OracleParameter(":PUBLICATION", OracleType.DateTime), new OracleParameter(":GRANTNOTIC_DATE", OracleType.DateTime), new OracleParameter(":ANNO_NO", OracleType.VarChar, 40), new OracleParameter(":GAZETTE", OracleType.DateTime), new OracleParameter(":CERTIFICATE_NO", OracleType.VarChar, 40), new OracleParameter(":EARLIEST_PRIORITY_DATE", OracleType.DateTime), new OracleParameter(":EXPIRATION_DATE", OracleType.DateTime), new OracleParameter(":HISTORY", OracleType.VarChar, 2000) }; parameters[0].Value = model.YOURNO; parameters[1].Value = model.OURNO; parameters[2].Value = model.TITLE; parameters[3].Value = model.STATUS; parameters[4].Value = model.COUNTRY; parameters[5].Value = model.CASE_TYPE; parameters[6].Value = model.RELATION_TYPE; parameters[7].Value = model.FILING_TYPE; parameters[8].Value = model.APPLICANT; parameters[9].Value = model.APPNO; parameters[10].Value = model.PCT_APP_DATE; parameters[11].Value = model.FILING_DATE; parameters[12].Value = model.PUBLICATION_NO; parameters[13].Value = model.PUBLICATION; parameters[14].Value = model.GRANTNOTIC_DATE; parameters[15].Value = model.ANNO_NO; parameters[16].Value = model.GAZETTE; parameters[17].Value = model.CERTIFICATE_NO; parameters[18].Value = model.EARLIEST_PRIORITY_DATE; parameters[19].Value = model.EXPIRATION_DATE; parameters[20].Value = model.HISTORY; int rows = DbHelperOra.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }