/// <summary>
/// 得到一个对象实体
/// </summary>
public Model.EX_HKCASE GetModel(string HK_APP_REF)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select HK_APP_REF,HK_APP_NO,HK_PUB_NO,HK_REG1_DATE,HK_PUB1_DATE,MAINTENANCE_DUEDATE,HK_REG2_DATE,NEXT_RENEWAL_DUEDATE,CN_APP_REF,CN_APP_NO,CN_APP_DATE,P4_SENDING_DATE,FIRST_AGENCY_REPORT,TO_PUB,P5_SENDING_DATE,SECOND_AGENCY_REPORT,TO_GRANT,COMMENTS,CLIENT_REF,CLIENT,HK_ANNO_NO,HK_GAZETTE,PARENT_COUNTRY,RECEIVED,ABANDON,PRIORITY,SENDADDRESS,ADDRCHECK,APPLICANT from EX_HKCASE ");
strSql.Append(" where HK_APP_REF=:HK_APP_REF ");
OracleParameter[] parameters =
{
new OracleParameter(":HK_APP_REF", OracleType.VarChar, 30)
};
parameters[0].Value = HK_APP_REF;
Model.EX_HKCASE model = new Model.EX_HKCASE();
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.EX_HKCASE model)
{
return(dal.Update(model));
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(Model.EX_HKCASE model)
{
return(dal.Add(model));
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(Model.EX_HKCASE model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into EX_HKCASE(");
strSql.Append("HK_APP_REF,HK_APP_NO,HK_PUB_NO,HK_REG1_DATE,HK_PUB1_DATE,MAINTENANCE_DUEDATE,HK_REG2_DATE,NEXT_RENEWAL_DUEDATE,CN_APP_REF,CN_APP_NO,CN_APP_DATE,P4_SENDING_DATE,FIRST_AGENCY_REPORT,TO_PUB,P5_SENDING_DATE,SECOND_AGENCY_REPORT,TO_GRANT,COMMENTS,CLIENT_REF,CLIENT,HK_ANNO_NO,HK_GAZETTE,PARENT_COUNTRY,RECEIVED,ABANDON,PRIORITY,SENDADDRESS,ADDRCHECK,APPLICANT)");
strSql.Append(" values (");
strSql.Append(":HK_APP_REF,:HK_APP_NO,:HK_PUB_NO,:HK_REG1_DATE,:HK_PUB1_DATE,:MAINTENANCE_DUEDATE,:HK_REG2_DATE,:NEXT_RENEWAL_DUEDATE,:CN_APP_REF,:CN_APP_NO,:CN_APP_DATE,:P4_SENDING_DATE,:FIRST_AGENCY_REPORT,:TO_PUB,:P5_SENDING_DATE,:SECOND_AGENCY_REPORT,:TO_GRANT,:COMMENTS,:CLIENT_REF,:CLIENT,:HK_ANNO_NO,:HK_GAZETTE,:PARENT_COUNTRY,:RECEIVED,:ABANDON,:PRIORITY,:SENDADDRESS,:ADDRCHECK,:APPLICANT)");
OracleParameter[] parameters =
{
new OracleParameter(":HK_APP_REF", OracleType.VarChar, 30),
new OracleParameter(":HK_APP_NO", OracleType.VarChar, 50),
new OracleParameter(":HK_PUB_NO", OracleType.VarChar, 50),
new OracleParameter(":HK_REG1_DATE", OracleType.DateTime),
new OracleParameter(":HK_PUB1_DATE", OracleType.DateTime),
new OracleParameter(":MAINTENANCE_DUEDATE", OracleType.DateTime),
new OracleParameter(":HK_REG2_DATE", OracleType.DateTime),
new OracleParameter(":NEXT_RENEWAL_DUEDATE", OracleType.DateTime),
new OracleParameter(":CN_APP_REF", OracleType.VarChar, 30),
new OracleParameter(":CN_APP_NO", OracleType.VarChar, 30),
new OracleParameter(":CN_APP_DATE", OracleType.DateTime),
new OracleParameter(":P4_SENDING_DATE", OracleType.DateTime),
new OracleParameter(":FIRST_AGENCY_REPORT", OracleType.DateTime),
new OracleParameter(":TO_PUB", OracleType.DateTime),
new OracleParameter(":P5_SENDING_DATE", OracleType.DateTime),
new OracleParameter(":SECOND_AGENCY_REPORT", OracleType.DateTime),
new OracleParameter(":TO_GRANT", OracleType.DateTime),
new OracleParameter(":COMMENTS", OracleType.VarChar, 1200),
new OracleParameter(":CLIENT_REF", OracleType.VarChar, 80),
new OracleParameter(":CLIENT", OracleType.VarChar, 500),
new OracleParameter(":HK_ANNO_NO", OracleType.VarChar, 50),
new OracleParameter(":HK_GAZETTE", OracleType.DateTime),
new OracleParameter(":PARENT_COUNTRY", OracleType.VarChar, 10),
new OracleParameter(":RECEIVED", OracleType.DateTime),
new OracleParameter(":ABANDON", OracleType.Char, 2),
new OracleParameter(":PRIORITY", OracleType.DateTime),
new OracleParameter(":SENDADDRESS", OracleType.VarChar, 600),
new OracleParameter(":ADDRCHECK", OracleType.Char, 2),
new OracleParameter(":APPLICANT", OracleType.VarChar, 100)
};
parameters[0].Value = model.HK_APP_REF;
parameters[1].Value = model.HK_APP_NO;
parameters[2].Value = model.HK_PUB_NO;
parameters[3].Value = model.HK_REG1_DATE;
parameters[4].Value = model.HK_PUB1_DATE;
parameters[5].Value = model.MAINTENANCE_DUEDATE;
parameters[6].Value = model.HK_REG2_DATE;
parameters[7].Value = model.NEXT_RENEWAL_DUEDATE;
parameters[8].Value = model.CN_APP_REF;
parameters[9].Value = model.CN_APP_NO;
parameters[10].Value = model.CN_APP_DATE;
parameters[11].Value = model.P4_SENDING_DATE;
parameters[12].Value = model.FIRST_AGENCY_REPORT;
parameters[13].Value = model.TO_PUB;
parameters[14].Value = model.P5_SENDING_DATE;
parameters[15].Value = model.SECOND_AGENCY_REPORT;
parameters[16].Value = model.TO_GRANT;
parameters[17].Value = model.COMMENTS;
parameters[18].Value = model.CLIENT_REF;
parameters[19].Value = model.CLIENT;
parameters[20].Value = model.HK_ANNO_NO;
parameters[21].Value = model.HK_GAZETTE;
parameters[22].Value = model.PARENT_COUNTRY;
parameters[23].Value = model.RECEIVED;
parameters[24].Value = model.ABANDON;
parameters[25].Value = model.PRIORITY;
parameters[26].Value = model.SENDADDRESS;
parameters[27].Value = model.ADDRCHECK;
parameters[28].Value = model.APPLICANT;
int rows = DbHelperOra.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Model.EX_HKCASE DataRowToModel(DataRow row)
{
Model.EX_HKCASE model = new Model.EX_HKCASE();
if (row != null)
{
if (row["HK_APP_REF"] != null)
{
model.HK_APP_REF = row["HK_APP_REF"].ToString();
}
if (row["HK_APP_NO"] != null)
{
model.HK_APP_NO = row["HK_APP_NO"].ToString();
}
if (row["HK_PUB_NO"] != null)
{
model.HK_PUB_NO = row["HK_PUB_NO"].ToString();
}
if (row["HK_REG1_DATE"] != null && row["HK_REG1_DATE"].ToString() != "")
{
model.HK_REG1_DATE = DateTime.Parse(row["HK_REG1_DATE"].ToString());
}
if (row["HK_PUB1_DATE"] != null && row["HK_PUB1_DATE"].ToString() != "")
{
model.HK_PUB1_DATE = DateTime.Parse(row["HK_PUB1_DATE"].ToString());
}
if (row["MAINTENANCE_DUEDATE"] != null && row["MAINTENANCE_DUEDATE"].ToString() != "")
{
model.MAINTENANCE_DUEDATE = DateTime.Parse(row["MAINTENANCE_DUEDATE"].ToString());
}
if (row["HK_REG2_DATE"] != null && row["HK_REG2_DATE"].ToString() != "")
{
model.HK_REG2_DATE = DateTime.Parse(row["HK_REG2_DATE"].ToString());
}
if (row["NEXT_RENEWAL_DUEDATE"] != null && row["NEXT_RENEWAL_DUEDATE"].ToString() != "")
{
model.NEXT_RENEWAL_DUEDATE = DateTime.Parse(row["NEXT_RENEWAL_DUEDATE"].ToString());
}
if (row["CN_APP_REF"] != null)
{
model.CN_APP_REF = row["CN_APP_REF"].ToString();
}
if (row["CN_APP_NO"] != null)
{
model.CN_APP_NO = row["CN_APP_NO"].ToString();
}
if (row["CN_APP_DATE"] != null && row["CN_APP_DATE"].ToString() != "")
{
model.CN_APP_DATE = DateTime.Parse(row["CN_APP_DATE"].ToString());
}
if (row["P4_SENDING_DATE"] != null && row["P4_SENDING_DATE"].ToString() != "")
{
model.P4_SENDING_DATE = DateTime.Parse(row["P4_SENDING_DATE"].ToString());
}
if (row["FIRST_AGENCY_REPORT"] != null && row["FIRST_AGENCY_REPORT"].ToString() != "")
{
model.FIRST_AGENCY_REPORT = DateTime.Parse(row["FIRST_AGENCY_REPORT"].ToString());
}
if (row["TO_PUB"] != null && row["TO_PUB"].ToString() != "")
{
model.TO_PUB = DateTime.Parse(row["TO_PUB"].ToString());
}
if (row["P5_SENDING_DATE"] != null && row["P5_SENDING_DATE"].ToString() != "")
{
model.P5_SENDING_DATE = DateTime.Parse(row["P5_SENDING_DATE"].ToString());
}
if (row["SECOND_AGENCY_REPORT"] != null && row["SECOND_AGENCY_REPORT"].ToString() != "")
{
model.SECOND_AGENCY_REPORT = DateTime.Parse(row["SECOND_AGENCY_REPORT"].ToString());
}
if (row["TO_GRANT"] != null && row["TO_GRANT"].ToString() != "")
{
model.TO_GRANT = DateTime.Parse(row["TO_GRANT"].ToString());
}
if (row["COMMENTS"] != null)
{
model.COMMENTS = row["COMMENTS"].ToString();
}
if (row["CLIENT_REF"] != null)
{
model.CLIENT_REF = row["CLIENT_REF"].ToString();
}
if (row["CLIENT"] != null)
{
model.CLIENT = row["CLIENT"].ToString();
}
if (row["HK_ANNO_NO"] != null)
{
model.HK_ANNO_NO = row["HK_ANNO_NO"].ToString();
}
if (row["HK_GAZETTE"] != null && row["HK_GAZETTE"].ToString() != "")
{
model.HK_GAZETTE = DateTime.Parse(row["HK_GAZETTE"].ToString());
}
if (row["PARENT_COUNTRY"] != null)
{
model.PARENT_COUNTRY = row["PARENT_COUNTRY"].ToString();
}
if (row["RECEIVED"] != null && row["RECEIVED"].ToString() != "")
{
model.RECEIVED = DateTime.Parse(row["RECEIVED"].ToString());
}
if (row["ABANDON"] != null)
{
model.ABANDON = row["ABANDON"].ToString();
}
if (row["PRIORITY"] != null && row["PRIORITY"].ToString() != "")
{
model.PRIORITY = DateTime.Parse(row["PRIORITY"].ToString());
}
if (row["SENDADDRESS"] != null)
{
model.SENDADDRESS = row["SENDADDRESS"].ToString();
}
if (row["ADDRCHECK"] != null)
{
model.ADDRCHECK = row["ADDRCHECK"].ToString();
}
if (row["APPLICANT"] != null)
{
model.APPLICANT = row["APPLICANT"].ToString();
}
}
return(model);
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(Model.EX_HKCASE model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update EX_HKCASE set ");
strSql.Append("HK_APP_REF=:HK_APP_REF,");
strSql.Append("HK_APP_NO=:HK_APP_NO,");
strSql.Append("HK_PUB_NO=:HK_PUB_NO,");
strSql.Append("HK_REG1_DATE=:HK_REG1_DATE,");
strSql.Append("HK_PUB1_DATE=:HK_PUB1_DATE,");
strSql.Append("MAINTENANCE_DUEDATE=:MAINTENANCE_DUEDATE,");
strSql.Append("HK_REG2_DATE=:HK_REG2_DATE,");
strSql.Append("NEXT_RENEWAL_DUEDATE=:NEXT_RENEWAL_DUEDATE,");
strSql.Append("CN_APP_REF=:CN_APP_REF,");
strSql.Append("CN_APP_NO=:CN_APP_NO,");
strSql.Append("CN_APP_DATE=:CN_APP_DATE,");
strSql.Append("P4_SENDING_DATE=:P4_SENDING_DATE,");
strSql.Append("FIRST_AGENCY_REPORT=:FIRST_AGENCY_REPORT,");
strSql.Append("TO_PUB=:TO_PUB,");
strSql.Append("P5_SENDING_DATE=:P5_SENDING_DATE,");
strSql.Append("SECOND_AGENCY_REPORT=:SECOND_AGENCY_REPORT,");
strSql.Append("TO_GRANT=:TO_GRANT,");
strSql.Append("COMMENTS=:COMMENTS,");
strSql.Append("CLIENT_REF=:CLIENT_REF,");
strSql.Append("CLIENT=:CLIENT,");
strSql.Append("HK_ANNO_NO=:HK_ANNO_NO,");
strSql.Append("HK_GAZETTE=:HK_GAZETTE,");
strSql.Append("PARENT_COUNTRY=:PARENT_COUNTRY,");
strSql.Append("RECEIVED=:RECEIVED,");
strSql.Append("ABANDON=:ABANDON,");
strSql.Append("PRIORITY=:PRIORITY,");
strSql.Append("SENDADDRESS=:SENDADDRESS,");
strSql.Append("ADDRCHECK=:ADDRCHECK,");
strSql.Append("APPLICANT=:APPLICANT");
strSql.Append(" where HK_APP_REF=:HK_APP_REF ");
OracleParameter[] parameters =
{
new OracleParameter(":HK_APP_REF", OracleType.VarChar, 30),
new OracleParameter(":HK_APP_NO", OracleType.VarChar, 50),
new OracleParameter(":HK_PUB_NO", OracleType.VarChar, 50),
new OracleParameter(":HK_REG1_DATE", OracleType.DateTime),
new OracleParameter(":HK_PUB1_DATE", OracleType.DateTime),
new OracleParameter(":MAINTENANCE_DUEDATE", OracleType.DateTime),
new OracleParameter(":HK_REG2_DATE", OracleType.DateTime),
new OracleParameter(":NEXT_RENEWAL_DUEDATE", OracleType.DateTime),
new OracleParameter(":CN_APP_REF", OracleType.VarChar, 30),
new OracleParameter(":CN_APP_NO", OracleType.VarChar, 30),
new OracleParameter(":CN_APP_DATE", OracleType.DateTime),
new OracleParameter(":P4_SENDING_DATE", OracleType.DateTime),
new OracleParameter(":FIRST_AGENCY_REPORT", OracleType.DateTime),
new OracleParameter(":TO_PUB", OracleType.DateTime),
new OracleParameter(":P5_SENDING_DATE", OracleType.DateTime),
new OracleParameter(":SECOND_AGENCY_REPORT", OracleType.DateTime),
new OracleParameter(":TO_GRANT", OracleType.DateTime),
new OracleParameter(":COMMENTS", OracleType.VarChar, 1200),
new OracleParameter(":CLIENT_REF", OracleType.VarChar, 80),
new OracleParameter(":CLIENT", OracleType.VarChar, 500),
new OracleParameter(":HK_ANNO_NO", OracleType.VarChar, 50),
new OracleParameter(":HK_GAZETTE", OracleType.DateTime),
new OracleParameter(":PARENT_COUNTRY", OracleType.VarChar, 10),
new OracleParameter(":RECEIVED", OracleType.DateTime),
new OracleParameter(":ABANDON", OracleType.Char, 2),
new OracleParameter(":PRIORITY", OracleType.DateTime),
new OracleParameter(":SENDADDRESS", OracleType.VarChar, 600),
new OracleParameter(":ADDRCHECK", OracleType.Char, 2),
new OracleParameter(":APPLICANT", OracleType.VarChar, 100)
};
parameters[0].Value = model.HK_APP_REF;
parameters[1].Value = model.HK_APP_NO;
parameters[2].Value = model.HK_PUB_NO;
parameters[3].Value = model.HK_REG1_DATE;
parameters[4].Value = model.HK_PUB1_DATE;
parameters[5].Value = model.MAINTENANCE_DUEDATE;
parameters[6].Value = model.HK_REG2_DATE;
parameters[7].Value = model.NEXT_RENEWAL_DUEDATE;
parameters[8].Value = model.CN_APP_REF;
parameters[9].Value = model.CN_APP_NO;
parameters[10].Value = model.CN_APP_DATE;
parameters[11].Value = model.P4_SENDING_DATE;
parameters[12].Value = model.FIRST_AGENCY_REPORT;
parameters[13].Value = model.TO_PUB;
parameters[14].Value = model.P5_SENDING_DATE;
parameters[15].Value = model.SECOND_AGENCY_REPORT;
parameters[16].Value = model.TO_GRANT;
parameters[17].Value = model.COMMENTS;
parameters[18].Value = model.CLIENT_REF;
parameters[19].Value = model.CLIENT;
parameters[20].Value = model.HK_ANNO_NO;
parameters[21].Value = model.HK_GAZETTE;
parameters[22].Value = model.PARENT_COUNTRY;
parameters[23].Value = model.RECEIVED;
parameters[24].Value = model.ABANDON;
parameters[25].Value = model.PRIORITY;
parameters[26].Value = model.SENDADDRESS;
parameters[27].Value = model.ADDRCHECK;
parameters[28].Value = model.APPLICANT;
int rows = DbHelperOra.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
