/// <summary>
/// 得到一个对象实体
/// </summary>
public Model.EX_FOREIGNCASE GetModel(string OURNO)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select OURNO,TITLE,NATIVE_NO,CLIENT,CLIENT_NAME,CLIENT_ADDR,CLIENT_FAX,CLIENT_REF,YOUR_AGENCY_NO,YOUR_AGENCY_NAME,YOUR_AGENCY_ADDR,YOUR_AGENCY_FAX,YOUR_AGENCY_REF,APPL_CODE,APPLICANT,APPDATE,APPLICATION_NO,PRI_NUMBER1,PRI_DATE1,PRI_NUMBER2,PRI_DATE2,PRI_NUMBER3,PRI_DATE3,PRI_NUMBER4,PRI_DATE4,PRI_NUMBER5,PRI_DATE5,PRI_NUMBER6,PRI_DATE6,PRI_NUMBER7,PRI_DATE7,PRI_NUMBER8,PRI_DATE8,PRI_NUMBER9,PRI_DATE9,COMMENTS,DEADLINE1,DL_DATE1,DL_RESP_DATE1,COMMENTS1,DEADLINE2,DL_DATE2,DL_RESP_DATE2,COMMENTS2,DEADLINE3,DL_DATE3,DL_RESP_DATE3,COMMENTS3,DEADLINE4,DL_DATE4,DL_RESP_DATE4,COMMENTS4,DEADLINE5,DL_DATE5,DL_RESP_DATE5,COMMENTS5,DEADLINE6,DL_DATE6,DL_RESP_DATE6,COMMENTS6,FILE1,FILE2,FILE3,FILE4,FILE5,FILE6,FILE7,FILE8,FILE9,FILE10,FILE11,FILE12,FILE13,FILE14,FILE15 from EX_FOREIGNCASE ");
strSql.Append(" where OURNO=:OURNO ");
OracleParameter[] parameters =
{
new OracleParameter(":OURNO", OracleType.VarChar, 24)
};
parameters[0].Value = OURNO;
Model.EX_FOREIGNCASE model = new Model.EX_FOREIGNCASE();
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_FOREIGNCASE model)
{
return(dal.Update(model));
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(Model.EX_FOREIGNCASE model)
{
return(dal.Add(model));
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Model.EX_FOREIGNCASE DataRowToModel(DataRow row)
{
Model.EX_FOREIGNCASE model = new Model.EX_FOREIGNCASE();
if (row != null)
{
if (row["OURNO"] != null)
{
model.OURNO = row["OURNO"].ToString();
}
if (row["TITLE"] != null)
{
model.TITLE = row["TITLE"].ToString();
}
if (row["NATIVE_NO"] != null)
{
model.NATIVE_NO = row["NATIVE_NO"].ToString();
}
if (row["CLIENT"] != null)
{
model.CLIENT = row["CLIENT"].ToString();
}
if (row["CLIENT_NAME"] != null)
{
model.CLIENT_NAME = row["CLIENT_NAME"].ToString();
}
if (row["CLIENT_ADDR"] != null)
{
model.CLIENT_ADDR = row["CLIENT_ADDR"].ToString();
}
if (row["CLIENT_FAX"] != null)
{
model.CLIENT_FAX = row["CLIENT_FAX"].ToString();
}
if (row["CLIENT_REF"] != null)
{
model.CLIENT_REF = row["CLIENT_REF"].ToString();
}
if (row["YOUR_AGENCY_NO"] != null)
{
model.YOUR_AGENCY_NO = row["YOUR_AGENCY_NO"].ToString();
}
if (row["YOUR_AGENCY_NAME"] != null)
{
model.YOUR_AGENCY_NAME = row["YOUR_AGENCY_NAME"].ToString();
}
if (row["YOUR_AGENCY_ADDR"] != null)
{
model.YOUR_AGENCY_ADDR = row["YOUR_AGENCY_ADDR"].ToString();
}
if (row["YOUR_AGENCY_FAX"] != null)
{
model.YOUR_AGENCY_FAX = row["YOUR_AGENCY_FAX"].ToString();
}
if (row["YOUR_AGENCY_REF"] != null)
{
model.YOUR_AGENCY_REF = row["YOUR_AGENCY_REF"].ToString();
}
if (row["APPL_CODE"] != null)
{
model.APPL_CODE = row["APPL_CODE"].ToString();
}
if (row["APPLICANT"] != null)
{
model.APPLICANT = row["APPLICANT"].ToString();
}
if (row["APPDATE"] != null && row["APPDATE"].ToString() != "")
{
model.APPDATE = DateTime.Parse(row["APPDATE"].ToString());
}
if (row["APPLICATION_NO"] != null)
{
model.APPLICATION_NO = row["APPLICATION_NO"].ToString();
}
if (row["PRI_NUMBER1"] != null)
{
model.PRI_NUMBER1 = row["PRI_NUMBER1"].ToString();
}
if (row["PRI_DATE1"] != null && row["PRI_DATE1"].ToString() != "")
{
model.PRI_DATE1 = DateTime.Parse(row["PRI_DATE1"].ToString());
}
if (row["PRI_NUMBER2"] != null)
{
model.PRI_NUMBER2 = row["PRI_NUMBER2"].ToString();
}
if (row["PRI_DATE2"] != null && row["PRI_DATE2"].ToString() != "")
{
model.PRI_DATE2 = DateTime.Parse(row["PRI_DATE2"].ToString());
}
if (row["PRI_NUMBER3"] != null)
{
model.PRI_NUMBER3 = row["PRI_NUMBER3"].ToString();
}
if (row["PRI_DATE3"] != null && row["PRI_DATE3"].ToString() != "")
{
model.PRI_DATE3 = DateTime.Parse(row["PRI_DATE3"].ToString());
}
if (row["PRI_NUMBER4"] != null)
{
model.PRI_NUMBER4 = row["PRI_NUMBER4"].ToString();
}
if (row["PRI_DATE4"] != null && row["PRI_DATE4"].ToString() != "")
{
model.PRI_DATE4 = DateTime.Parse(row["PRI_DATE4"].ToString());
}
if (row["PRI_NUMBER5"] != null)
{
model.PRI_NUMBER5 = row["PRI_NUMBER5"].ToString();
}
if (row["PRI_DATE5"] != null && row["PRI_DATE5"].ToString() != "")
{
model.PRI_DATE5 = DateTime.Parse(row["PRI_DATE5"].ToString());
}
if (row["PRI_NUMBER6"] != null)
{
model.PRI_NUMBER6 = row["PRI_NUMBER6"].ToString();
}
if (row["PRI_DATE6"] != null && row["PRI_DATE6"].ToString() != "")
{
model.PRI_DATE6 = DateTime.Parse(row["PRI_DATE6"].ToString());
}
if (row["PRI_NUMBER7"] != null)
{
model.PRI_NUMBER7 = row["PRI_NUMBER7"].ToString();
}
if (row["PRI_DATE7"] != null && row["PRI_DATE7"].ToString() != "")
{
model.PRI_DATE7 = DateTime.Parse(row["PRI_DATE7"].ToString());
}
if (row["PRI_NUMBER8"] != null)
{
model.PRI_NUMBER8 = row["PRI_NUMBER8"].ToString();
}
if (row["PRI_DATE8"] != null && row["PRI_DATE8"].ToString() != "")
{
model.PRI_DATE8 = DateTime.Parse(row["PRI_DATE8"].ToString());
}
if (row["PRI_NUMBER9"] != null)
{
model.PRI_NUMBER9 = row["PRI_NUMBER9"].ToString();
}
if (row["PRI_DATE9"] != null && row["PRI_DATE9"].ToString() != "")
{
model.PRI_DATE9 = DateTime.Parse(row["PRI_DATE9"].ToString());
}
if (row["COMMENTS"] != null)
{
model.COMMENTS = row["COMMENTS"].ToString();
}
if (row["DEADLINE1"] != null)
{
model.DEADLINE1 = row["DEADLINE1"].ToString();
}
if (row["DL_DATE1"] != null && row["DL_DATE1"].ToString() != "")
{
model.DL_DATE1 = DateTime.Parse(row["DL_DATE1"].ToString());
}
if (row["DL_RESP_DATE1"] != null && row["DL_RESP_DATE1"].ToString() != "")
{
model.DL_RESP_DATE1 = DateTime.Parse(row["DL_RESP_DATE1"].ToString());
}
if (row["COMMENTS1"] != null)
{
model.COMMENTS1 = row["COMMENTS1"].ToString();
}
if (row["DEADLINE2"] != null)
{
model.DEADLINE2 = row["DEADLINE2"].ToString();
}
if (row["DL_DATE2"] != null && row["DL_DATE2"].ToString() != "")
{
model.DL_DATE2 = DateTime.Parse(row["DL_DATE2"].ToString());
}
if (row["DL_RESP_DATE2"] != null && row["DL_RESP_DATE2"].ToString() != "")
{
model.DL_RESP_DATE2 = DateTime.Parse(row["DL_RESP_DATE2"].ToString());
}
if (row["COMMENTS2"] != null)
{
model.COMMENTS2 = row["COMMENTS2"].ToString();
}
if (row["DEADLINE3"] != null)
{
model.DEADLINE3 = row["DEADLINE3"].ToString();
}
if (row["DL_DATE3"] != null && row["DL_DATE3"].ToString() != "")
{
model.DL_DATE3 = DateTime.Parse(row["DL_DATE3"].ToString());
}
if (row["DL_RESP_DATE3"] != null && row["DL_RESP_DATE3"].ToString() != "")
{
model.DL_RESP_DATE3 = DateTime.Parse(row["DL_RESP_DATE3"].ToString());
}
if (row["COMMENTS3"] != null)
{
model.COMMENTS3 = row["COMMENTS3"].ToString();
}
if (row["DEADLINE4"] != null)
{
model.DEADLINE4 = row["DEADLINE4"].ToString();
}
if (row["DL_DATE4"] != null && row["DL_DATE4"].ToString() != "")
{
model.DL_DATE4 = DateTime.Parse(row["DL_DATE4"].ToString());
}
if (row["DL_RESP_DATE4"] != null && row["DL_RESP_DATE4"].ToString() != "")
{
model.DL_RESP_DATE4 = DateTime.Parse(row["DL_RESP_DATE4"].ToString());
}
if (row["COMMENTS4"] != null)
{
model.COMMENTS4 = row["COMMENTS4"].ToString();
}
if (row["DEADLINE5"] != null)
{
model.DEADLINE5 = row["DEADLINE5"].ToString();
}
if (row["DL_DATE5"] != null && row["DL_DATE5"].ToString() != "")
{
model.DL_DATE5 = DateTime.Parse(row["DL_DATE5"].ToString());
}
if (row["DL_RESP_DATE5"] != null && row["DL_RESP_DATE5"].ToString() != "")
{
model.DL_RESP_DATE5 = DateTime.Parse(row["DL_RESP_DATE5"].ToString());
}
if (row["COMMENTS5"] != null)
{
model.COMMENTS5 = row["COMMENTS5"].ToString();
}
if (row["DEADLINE6"] != null)
{
model.DEADLINE6 = row["DEADLINE6"].ToString();
}
if (row["DL_DATE6"] != null && row["DL_DATE6"].ToString() != "")
{
model.DL_DATE6 = DateTime.Parse(row["DL_DATE6"].ToString());
}
if (row["DL_RESP_DATE6"] != null && row["DL_RESP_DATE6"].ToString() != "")
{
model.DL_RESP_DATE6 = DateTime.Parse(row["DL_RESP_DATE6"].ToString());
}
if (row["COMMENTS6"] != null)
{
model.COMMENTS6 = row["COMMENTS6"].ToString();
}
if (row["FILE1"] != null)
{
model.FILE1 = row["FILE1"].ToString();
}
if (row["FILE2"] != null)
{
model.FILE2 = row["FILE2"].ToString();
}
if (row["FILE3"] != null)
{
model.FILE3 = row["FILE3"].ToString();
}
if (row["FILE4"] != null)
{
model.FILE4 = row["FILE4"].ToString();
}
if (row["FILE5"] != null)
{
model.FILE5 = row["FILE5"].ToString();
}
if (row["FILE6"] != null)
{
model.FILE6 = row["FILE6"].ToString();
}
if (row["FILE7"] != null)
{
model.FILE7 = row["FILE7"].ToString();
}
if (row["FILE8"] != null)
{
model.FILE8 = row["FILE8"].ToString();
}
if (row["FILE9"] != null)
{
model.FILE9 = row["FILE9"].ToString();
}
if (row["FILE10"] != null)
{
model.FILE10 = row["FILE10"].ToString();
}
if (row["FILE11"] != null)
{
model.FILE11 = row["FILE11"].ToString();
}
if (row["FILE12"] != null)
{
model.FILE12 = row["FILE12"].ToString();
}
if (row["FILE13"] != null)
{
model.FILE13 = row["FILE13"].ToString();
}
if (row["FILE14"] != null)
{
model.FILE14 = row["FILE14"].ToString();
}
if (row["FILE15"] != null)
{
model.FILE15 = row["FILE15"].ToString();
}
}
return(model);
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(Model.EX_FOREIGNCASE model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into EX_FOREIGNCASE(");
strSql.Append("OURNO,TITLE,NATIVE_NO,CLIENT,CLIENT_NAME,CLIENT_ADDR,CLIENT_FAX,CLIENT_REF,YOUR_AGENCY_NO,YOUR_AGENCY_NAME,YOUR_AGENCY_ADDR,YOUR_AGENCY_FAX,YOUR_AGENCY_REF,APPL_CODE,APPLICANT,APPDATE,APPLICATION_NO,PRI_NUMBER1,PRI_DATE1,PRI_NUMBER2,PRI_DATE2,PRI_NUMBER3,PRI_DATE3,PRI_NUMBER4,PRI_DATE4,PRI_NUMBER5,PRI_DATE5,PRI_NUMBER6,PRI_DATE6,PRI_NUMBER7,PRI_DATE7,PRI_NUMBER8,PRI_DATE8,PRI_NUMBER9,PRI_DATE9,COMMENTS,DEADLINE1,DL_DATE1,DL_RESP_DATE1,COMMENTS1,DEADLINE2,DL_DATE2,DL_RESP_DATE2,COMMENTS2,DEADLINE3,DL_DATE3,DL_RESP_DATE3,COMMENTS3,DEADLINE4,DL_DATE4,DL_RESP_DATE4,COMMENTS4,DEADLINE5,DL_DATE5,DL_RESP_DATE5,COMMENTS5,DEADLINE6,DL_DATE6,DL_RESP_DATE6,COMMENTS6,FILE1,FILE2,FILE3,FILE4,FILE5,FILE6,FILE7,FILE8,FILE9,FILE10,FILE11,FILE12,FILE13,FILE14,FILE15)");
strSql.Append(" values (");
strSql.Append(":OURNO,:TITLE,:NATIVE_NO,:CLIENT,:CLIENT_NAME,:CLIENT_ADDR,:CLIENT_FAX,:CLIENT_REF,:YOUR_AGENCY_NO,:YOUR_AGENCY_NAME,:YOUR_AGENCY_ADDR,:YOUR_AGENCY_FAX,:YOUR_AGENCY_REF,:APPL_CODE,:APPLICANT,:APPDATE,:APPLICATION_NO,:PRI_NUMBER1,:PRI_DATE1,:PRI_NUMBER2,:PRI_DATE2,:PRI_NUMBER3,:PRI_DATE3,:PRI_NUMBER4,:PRI_DATE4,:PRI_NUMBER5,:PRI_DATE5,:PRI_NUMBER6,:PRI_DATE6,:PRI_NUMBER7,:PRI_DATE7,:PRI_NUMBER8,:PRI_DATE8,:PRI_NUMBER9,:PRI_DATE9,:COMMENTS,:DEADLINE1,:DL_DATE1,:DL_RESP_DATE1,:COMMENTS1,:DEADLINE2,:DL_DATE2,:DL_RESP_DATE2,:COMMENTS2,:DEADLINE3,:DL_DATE3,:DL_RESP_DATE3,:COMMENTS3,:DEADLINE4,:DL_DATE4,:DL_RESP_DATE4,:COMMENTS4,:DEADLINE5,:DL_DATE5,:DL_RESP_DATE5,:COMMENTS5,:DEADLINE6,:DL_DATE6,:DL_RESP_DATE6,:COMMENTS6,:FILE1,:FILE2,:FILE3,:FILE4,:FILE5,:FILE6,:FILE7,:FILE8,:FILE9,:FILE10,:FILE11,:FILE12,:FILE13,:FILE14,:FILE15)");
OracleParameter[] parameters =
{
new OracleParameter(":OURNO", OracleType.VarChar, 24),
new OracleParameter(":TITLE", OracleType.VarChar, 800),
new OracleParameter(":NATIVE_NO", OracleType.VarChar, 24),
new OracleParameter(":CLIENT", OracleType.VarChar, 20),
new OracleParameter(":CLIENT_NAME", OracleType.VarChar, 400),
new OracleParameter(":CLIENT_ADDR", OracleType.VarChar, 800),
new OracleParameter(":CLIENT_FAX", OracleType.VarChar, 50),
new OracleParameter(":CLIENT_REF", OracleType.VarChar, 60),
new OracleParameter(":YOUR_AGENCY_NO", OracleType.VarChar, 60),
new OracleParameter(":YOUR_AGENCY_NAME", OracleType.VarChar, 200),
new OracleParameter(":YOUR_AGENCY_ADDR", OracleType.VarChar, 800),
new OracleParameter(":YOUR_AGENCY_FAX", OracleType.VarChar, 60),
new OracleParameter(":YOUR_AGENCY_REF", OracleType.VarChar, 80),
new OracleParameter(":APPL_CODE", OracleType.VarChar, 30),
new OracleParameter(":APPLICANT", OracleType.VarChar, 400),
new OracleParameter(":APPDATE", OracleType.DateTime),
new OracleParameter(":APPLICATION_NO", OracleType.VarChar, 50),
new OracleParameter(":PRI_NUMBER1", OracleType.VarChar, 50),
new OracleParameter(":PRI_DATE1", OracleType.DateTime),
new OracleParameter(":PRI_NUMBER2", OracleType.VarChar, 50),
new OracleParameter(":PRI_DATE2", OracleType.DateTime),
new OracleParameter(":PRI_NUMBER3", OracleType.VarChar, 50),
new OracleParameter(":PRI_DATE3", OracleType.DateTime),
new OracleParameter(":PRI_NUMBER4", OracleType.VarChar, 50),
new OracleParameter(":PRI_DATE4", OracleType.DateTime),
new OracleParameter(":PRI_NUMBER5", OracleType.VarChar, 50),
new OracleParameter(":PRI_DATE5", OracleType.DateTime),
new OracleParameter(":PRI_NUMBER6", OracleType.VarChar, 50),
new OracleParameter(":PRI_DATE6", OracleType.DateTime),
new OracleParameter(":PRI_NUMBER7", OracleType.VarChar, 50),
new OracleParameter(":PRI_DATE7", OracleType.DateTime),
new OracleParameter(":PRI_NUMBER8", OracleType.VarChar, 50),
new OracleParameter(":PRI_DATE8", OracleType.DateTime),
new OracleParameter(":PRI_NUMBER9", OracleType.VarChar, 50),
new OracleParameter(":PRI_DATE9", OracleType.DateTime),
new OracleParameter(":COMMENTS", OracleType.VarChar, 800),
new OracleParameter(":DEADLINE1", OracleType.VarChar, 60),
new OracleParameter(":DL_DATE1", OracleType.DateTime),
new OracleParameter(":DL_RESP_DATE1", OracleType.DateTime),
new OracleParameter(":COMMENTS1", OracleType.VarChar, 300),
new OracleParameter(":DEADLINE2", OracleType.VarChar, 60),
new OracleParameter(":DL_DATE2", OracleType.DateTime),
new OracleParameter(":DL_RESP_DATE2", OracleType.DateTime),
new OracleParameter(":COMMENTS2", OracleType.VarChar, 300),
new OracleParameter(":DEADLINE3", OracleType.VarChar, 60),
new OracleParameter(":DL_DATE3", OracleType.DateTime),
new OracleParameter(":DL_RESP_DATE3", OracleType.DateTime),
new OracleParameter(":COMMENTS3", OracleType.VarChar, 300),
new OracleParameter(":DEADLINE4", OracleType.VarChar, 60),
new OracleParameter(":DL_DATE4", OracleType.DateTime),
new OracleParameter(":DL_RESP_DATE4", OracleType.DateTime),
new OracleParameter(":COMMENTS4", OracleType.VarChar, 300),
new OracleParameter(":DEADLINE5", OracleType.VarChar, 60),
new OracleParameter(":DL_DATE5", OracleType.DateTime),
new OracleParameter(":DL_RESP_DATE5", OracleType.DateTime),
new OracleParameter(":COMMENTS5", OracleType.VarChar, 300),
new OracleParameter(":DEADLINE6", OracleType.VarChar, 60),
new OracleParameter(":DL_DATE6", OracleType.DateTime),
new OracleParameter(":DL_RESP_DATE6", OracleType.DateTime),
new OracleParameter(":COMMENTS6", OracleType.VarChar, 300),
new OracleParameter(":FILE1", OracleType.VarChar, 400),
new OracleParameter(":FILE2", OracleType.VarChar, 400),
new OracleParameter(":FILE3", OracleType.VarChar, 400),
new OracleParameter(":FILE4", OracleType.VarChar, 400),
new OracleParameter(":FILE5", OracleType.VarChar, 400),
new OracleParameter(":FILE6", OracleType.VarChar, 400),
new OracleParameter(":FILE7", OracleType.VarChar, 400),
new OracleParameter(":FILE8", OracleType.VarChar, 400),
new OracleParameter(":FILE9", OracleType.VarChar, 400),
new OracleParameter(":FILE10", OracleType.VarChar, 400),
new OracleParameter(":FILE11", OracleType.VarChar, 400),
new OracleParameter(":FILE12", OracleType.VarChar, 400),
new OracleParameter(":FILE13", OracleType.VarChar, 400),
new OracleParameter(":FILE14", OracleType.VarChar, 400),
new OracleParameter(":FILE15", OracleType.VarChar, 400)
};
parameters[0].Value = model.OURNO;
parameters[1].Value = model.TITLE;
parameters[2].Value = model.NATIVE_NO;
parameters[3].Value = model.CLIENT;
parameters[4].Value = model.CLIENT_NAME;
parameters[5].Value = model.CLIENT_ADDR;
parameters[6].Value = model.CLIENT_FAX;
parameters[7].Value = model.CLIENT_REF;
parameters[8].Value = model.YOUR_AGENCY_NO;
parameters[9].Value = model.YOUR_AGENCY_NAME;
parameters[10].Value = model.YOUR_AGENCY_ADDR;
parameters[11].Value = model.YOUR_AGENCY_FAX;
parameters[12].Value = model.YOUR_AGENCY_REF;
parameters[13].Value = model.APPL_CODE;
parameters[14].Value = model.APPLICANT;
parameters[15].Value = model.APPDATE;
parameters[16].Value = model.APPLICATION_NO;
parameters[17].Value = model.PRI_NUMBER1;
parameters[18].Value = model.PRI_DATE1;
parameters[19].Value = model.PRI_NUMBER2;
parameters[20].Value = model.PRI_DATE2;
parameters[21].Value = model.PRI_NUMBER3;
parameters[22].Value = model.PRI_DATE3;
parameters[23].Value = model.PRI_NUMBER4;
parameters[24].Value = model.PRI_DATE4;
parameters[25].Value = model.PRI_NUMBER5;
parameters[26].Value = model.PRI_DATE5;
parameters[27].Value = model.PRI_NUMBER6;
parameters[28].Value = model.PRI_DATE6;
parameters[29].Value = model.PRI_NUMBER7;
parameters[30].Value = model.PRI_DATE7;
parameters[31].Value = model.PRI_NUMBER8;
parameters[32].Value = model.PRI_DATE8;
parameters[33].Value = model.PRI_NUMBER9;
parameters[34].Value = model.PRI_DATE9;
parameters[35].Value = model.COMMENTS;
parameters[36].Value = model.DEADLINE1;
parameters[37].Value = model.DL_DATE1;
parameters[38].Value = model.DL_RESP_DATE1;
parameters[39].Value = model.COMMENTS1;
parameters[40].Value = model.DEADLINE2;
parameters[41].Value = model.DL_DATE2;
parameters[42].Value = model.DL_RESP_DATE2;
parameters[43].Value = model.COMMENTS2;
parameters[44].Value = model.DEADLINE3;
parameters[45].Value = model.DL_DATE3;
parameters[46].Value = model.DL_RESP_DATE3;
parameters[47].Value = model.COMMENTS3;
parameters[48].Value = model.DEADLINE4;
parameters[49].Value = model.DL_DATE4;
parameters[50].Value = model.DL_RESP_DATE4;
parameters[51].Value = model.COMMENTS4;
parameters[52].Value = model.DEADLINE5;
parameters[53].Value = model.DL_DATE5;
parameters[54].Value = model.DL_RESP_DATE5;
parameters[55].Value = model.COMMENTS5;
parameters[56].Value = model.DEADLINE6;
parameters[57].Value = model.DL_DATE6;
parameters[58].Value = model.DL_RESP_DATE6;
parameters[59].Value = model.COMMENTS6;
parameters[60].Value = model.FILE1;
parameters[61].Value = model.FILE2;
parameters[62].Value = model.FILE3;
parameters[63].Value = model.FILE4;
parameters[64].Value = model.FILE5;
parameters[65].Value = model.FILE6;
parameters[66].Value = model.FILE7;
parameters[67].Value = model.FILE8;
parameters[68].Value = model.FILE9;
parameters[69].Value = model.FILE10;
parameters[70].Value = model.FILE11;
parameters[71].Value = model.FILE12;
parameters[72].Value = model.FILE13;
parameters[73].Value = model.FILE14;
parameters[74].Value = model.FILE15;
int rows = DbHelperOra.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(Model.EX_FOREIGNCASE model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update EX_FOREIGNCASE set ");
strSql.Append("OURNO=:OURNO,");
strSql.Append("TITLE=:TITLE,");
strSql.Append("NATIVE_NO=:NATIVE_NO,");
strSql.Append("CLIENT=:CLIENT,");
strSql.Append("CLIENT_NAME=:CLIENT_NAME,");
strSql.Append("CLIENT_ADDR=:CLIENT_ADDR,");
strSql.Append("CLIENT_FAX=:CLIENT_FAX,");
strSql.Append("CLIENT_REF=:CLIENT_REF,");
strSql.Append("YOUR_AGENCY_NO=:YOUR_AGENCY_NO,");
strSql.Append("YOUR_AGENCY_NAME=:YOUR_AGENCY_NAME,");
strSql.Append("YOUR_AGENCY_ADDR=:YOUR_AGENCY_ADDR,");
strSql.Append("YOUR_AGENCY_FAX=:YOUR_AGENCY_FAX,");
strSql.Append("YOUR_AGENCY_REF=:YOUR_AGENCY_REF,");
strSql.Append("APPL_CODE=:APPL_CODE,");
strSql.Append("APPLICANT=:APPLICANT,");
strSql.Append("APPDATE=:APPDATE,");
strSql.Append("APPLICATION_NO=:APPLICATION_NO,");
strSql.Append("PRI_NUMBER1=:PRI_NUMBER1,");
strSql.Append("PRI_DATE1=:PRI_DATE1,");
strSql.Append("PRI_NUMBER2=:PRI_NUMBER2,");
strSql.Append("PRI_DATE2=:PRI_DATE2,");
strSql.Append("PRI_NUMBER3=:PRI_NUMBER3,");
strSql.Append("PRI_DATE3=:PRI_DATE3,");
strSql.Append("PRI_NUMBER4=:PRI_NUMBER4,");
strSql.Append("PRI_DATE4=:PRI_DATE4,");
strSql.Append("PRI_NUMBER5=:PRI_NUMBER5,");
strSql.Append("PRI_DATE5=:PRI_DATE5,");
strSql.Append("PRI_NUMBER6=:PRI_NUMBER6,");
strSql.Append("PRI_DATE6=:PRI_DATE6,");
strSql.Append("PRI_NUMBER7=:PRI_NUMBER7,");
strSql.Append("PRI_DATE7=:PRI_DATE7,");
strSql.Append("PRI_NUMBER8=:PRI_NUMBER8,");
strSql.Append("PRI_DATE8=:PRI_DATE8,");
strSql.Append("PRI_NUMBER9=:PRI_NUMBER9,");
strSql.Append("PRI_DATE9=:PRI_DATE9,");
strSql.Append("COMMENTS=:COMMENTS,");
strSql.Append("DEADLINE1=:DEADLINE1,");
strSql.Append("DL_DATE1=:DL_DATE1,");
strSql.Append("DL_RESP_DATE1=:DL_RESP_DATE1,");
strSql.Append("COMMENTS1=:COMMENTS1,");
strSql.Append("DEADLINE2=:DEADLINE2,");
strSql.Append("DL_DATE2=:DL_DATE2,");
strSql.Append("DL_RESP_DATE2=:DL_RESP_DATE2,");
strSql.Append("COMMENTS2=:COMMENTS2,");
strSql.Append("DEADLINE3=:DEADLINE3,");
strSql.Append("DL_DATE3=:DL_DATE3,");
strSql.Append("DL_RESP_DATE3=:DL_RESP_DATE3,");
strSql.Append("COMMENTS3=:COMMENTS3,");
strSql.Append("DEADLINE4=:DEADLINE4,");
strSql.Append("DL_DATE4=:DL_DATE4,");
strSql.Append("DL_RESP_DATE4=:DL_RESP_DATE4,");
strSql.Append("COMMENTS4=:COMMENTS4,");
strSql.Append("DEADLINE5=:DEADLINE5,");
strSql.Append("DL_DATE5=:DL_DATE5,");
strSql.Append("DL_RESP_DATE5=:DL_RESP_DATE5,");
strSql.Append("COMMENTS5=:COMMENTS5,");
strSql.Append("DEADLINE6=:DEADLINE6,");
strSql.Append("DL_DATE6=:DL_DATE6,");
strSql.Append("DL_RESP_DATE6=:DL_RESP_DATE6,");
strSql.Append("COMMENTS6=:COMMENTS6,");
strSql.Append("FILE1=:FILE1,");
strSql.Append("FILE2=:FILE2,");
strSql.Append("FILE3=:FILE3,");
strSql.Append("FILE4=:FILE4,");
strSql.Append("FILE5=:FILE5,");
strSql.Append("FILE6=:FILE6,");
strSql.Append("FILE7=:FILE7,");
strSql.Append("FILE8=:FILE8,");
strSql.Append("FILE9=:FILE9,");
strSql.Append("FILE10=:FILE10,");
strSql.Append("FILE11=:FILE11,");
strSql.Append("FILE12=:FILE12,");
strSql.Append("FILE13=:FILE13,");
strSql.Append("FILE14=:FILE14,");
strSql.Append("FILE15=:FILE15");
strSql.Append(" where OURNO=:OURNO ");
OracleParameter[] parameters =
{
new OracleParameter(":OURNO", OracleType.VarChar, 24),
new OracleParameter(":TITLE", OracleType.VarChar, 800),
new OracleParameter(":NATIVE_NO", OracleType.VarChar, 24),
new OracleParameter(":CLIENT", OracleType.VarChar, 20),
new OracleParameter(":CLIENT_NAME", OracleType.VarChar, 400),
new OracleParameter(":CLIENT_ADDR", OracleType.VarChar, 800),
new OracleParameter(":CLIENT_FAX", OracleType.VarChar, 50),
new OracleParameter(":CLIENT_REF", OracleType.VarChar, 60),
new OracleParameter(":YOUR_AGENCY_NO", OracleType.VarChar, 60),
new OracleParameter(":YOUR_AGENCY_NAME", OracleType.VarChar, 200),
new OracleParameter(":YOUR_AGENCY_ADDR", OracleType.VarChar, 800),
new OracleParameter(":YOUR_AGENCY_FAX", OracleType.VarChar, 60),
new OracleParameter(":YOUR_AGENCY_REF", OracleType.VarChar, 80),
new OracleParameter(":APPL_CODE", OracleType.VarChar, 30),
new OracleParameter(":APPLICANT", OracleType.VarChar, 400),
new OracleParameter(":APPDATE", OracleType.DateTime),
new OracleParameter(":APPLICATION_NO", OracleType.VarChar, 50),
new OracleParameter(":PRI_NUMBER1", OracleType.VarChar, 50),
new OracleParameter(":PRI_DATE1", OracleType.DateTime),
new OracleParameter(":PRI_NUMBER2", OracleType.VarChar, 50),
new OracleParameter(":PRI_DATE2", OracleType.DateTime),
new OracleParameter(":PRI_NUMBER3", OracleType.VarChar, 50),
new OracleParameter(":PRI_DATE3", OracleType.DateTime),
new OracleParameter(":PRI_NUMBER4", OracleType.VarChar, 50),
new OracleParameter(":PRI_DATE4", OracleType.DateTime),
new OracleParameter(":PRI_NUMBER5", OracleType.VarChar, 50),
new OracleParameter(":PRI_DATE5", OracleType.DateTime),
new OracleParameter(":PRI_NUMBER6", OracleType.VarChar, 50),
new OracleParameter(":PRI_DATE6", OracleType.DateTime),
new OracleParameter(":PRI_NUMBER7", OracleType.VarChar, 50),
new OracleParameter(":PRI_DATE7", OracleType.DateTime),
new OracleParameter(":PRI_NUMBER8", OracleType.VarChar, 50),
new OracleParameter(":PRI_DATE8", OracleType.DateTime),
new OracleParameter(":PRI_NUMBER9", OracleType.VarChar, 50),
new OracleParameter(":PRI_DATE9", OracleType.DateTime),
new OracleParameter(":COMMENTS", OracleType.VarChar, 800),
new OracleParameter(":DEADLINE1", OracleType.VarChar, 60),
new OracleParameter(":DL_DATE1", OracleType.DateTime),
new OracleParameter(":DL_RESP_DATE1", OracleType.DateTime),
new OracleParameter(":COMMENTS1", OracleType.VarChar, 300),
new OracleParameter(":DEADLINE2", OracleType.VarChar, 60),
new OracleParameter(":DL_DATE2", OracleType.DateTime),
new OracleParameter(":DL_RESP_DATE2", OracleType.DateTime),
new OracleParameter(":COMMENTS2", OracleType.VarChar, 300),
new OracleParameter(":DEADLINE3", OracleType.VarChar, 60),
new OracleParameter(":DL_DATE3", OracleType.DateTime),
new OracleParameter(":DL_RESP_DATE3", OracleType.DateTime),
new OracleParameter(":COMMENTS3", OracleType.VarChar, 300),
new OracleParameter(":DEADLINE4", OracleType.VarChar, 60),
new OracleParameter(":DL_DATE4", OracleType.DateTime),
new OracleParameter(":DL_RESP_DATE4", OracleType.DateTime),
new OracleParameter(":COMMENTS4", OracleType.VarChar, 300),
new OracleParameter(":DEADLINE5", OracleType.VarChar, 60),
new OracleParameter(":DL_DATE5", OracleType.DateTime),
new OracleParameter(":DL_RESP_DATE5", OracleType.DateTime),
new OracleParameter(":COMMENTS5", OracleType.VarChar, 300),
new OracleParameter(":DEADLINE6", OracleType.VarChar, 60),
new OracleParameter(":DL_DATE6", OracleType.DateTime),
new OracleParameter(":DL_RESP_DATE6", OracleType.DateTime),
new OracleParameter(":COMMENTS6", OracleType.VarChar, 300),
new OracleParameter(":FILE1", OracleType.VarChar, 400),
new OracleParameter(":FILE2", OracleType.VarChar, 400),
new OracleParameter(":FILE3", OracleType.VarChar, 400),
new OracleParameter(":FILE4", OracleType.VarChar, 400),
new OracleParameter(":FILE5", OracleType.VarChar, 400),
new OracleParameter(":FILE6", OracleType.VarChar, 400),
new OracleParameter(":FILE7", OracleType.VarChar, 400),
new OracleParameter(":FILE8", OracleType.VarChar, 400),
new OracleParameter(":FILE9", OracleType.VarChar, 400),
new OracleParameter(":FILE10", OracleType.VarChar, 400),
new OracleParameter(":FILE11", OracleType.VarChar, 400),
new OracleParameter(":FILE12", OracleType.VarChar, 400),
new OracleParameter(":FILE13", OracleType.VarChar, 400),
new OracleParameter(":FILE14", OracleType.VarChar, 400),
new OracleParameter(":FILE15", OracleType.VarChar, 400)
};
parameters[0].Value = model.OURNO;
parameters[1].Value = model.TITLE;
parameters[2].Value = model.NATIVE_NO;
parameters[3].Value = model.CLIENT;
parameters[4].Value = model.CLIENT_NAME;
parameters[5].Value = model.CLIENT_ADDR;
parameters[6].Value = model.CLIENT_FAX;
parameters[7].Value = model.CLIENT_REF;
parameters[8].Value = model.YOUR_AGENCY_NO;
parameters[9].Value = model.YOUR_AGENCY_NAME;
parameters[10].Value = model.YOUR_AGENCY_ADDR;
parameters[11].Value = model.YOUR_AGENCY_FAX;
parameters[12].Value = model.YOUR_AGENCY_REF;
parameters[13].Value = model.APPL_CODE;
parameters[14].Value = model.APPLICANT;
parameters[15].Value = model.APPDATE;
parameters[16].Value = model.APPLICATION_NO;
parameters[17].Value = model.PRI_NUMBER1;
parameters[18].Value = model.PRI_DATE1;
parameters[19].Value = model.PRI_NUMBER2;
parameters[20].Value = model.PRI_DATE2;
parameters[21].Value = model.PRI_NUMBER3;
parameters[22].Value = model.PRI_DATE3;
parameters[23].Value = model.PRI_NUMBER4;
parameters[24].Value = model.PRI_DATE4;
parameters[25].Value = model.PRI_NUMBER5;
parameters[26].Value = model.PRI_DATE5;
parameters[27].Value = model.PRI_NUMBER6;
parameters[28].Value = model.PRI_DATE6;
parameters[29].Value = model.PRI_NUMBER7;
parameters[30].Value = model.PRI_DATE7;
parameters[31].Value = model.PRI_NUMBER8;
parameters[32].Value = model.PRI_DATE8;
parameters[33].Value = model.PRI_NUMBER9;
parameters[34].Value = model.PRI_DATE9;
parameters[35].Value = model.COMMENTS;
parameters[36].Value = model.DEADLINE1;
parameters[37].Value = model.DL_DATE1;
parameters[38].Value = model.DL_RESP_DATE1;
parameters[39].Value = model.COMMENTS1;
parameters[40].Value = model.DEADLINE2;
parameters[41].Value = model.DL_DATE2;
parameters[42].Value = model.DL_RESP_DATE2;
parameters[43].Value = model.COMMENTS2;
parameters[44].Value = model.DEADLINE3;
parameters[45].Value = model.DL_DATE3;
parameters[46].Value = model.DL_RESP_DATE3;
parameters[47].Value = model.COMMENTS3;
parameters[48].Value = model.DEADLINE4;
parameters[49].Value = model.DL_DATE4;
parameters[50].Value = model.DL_RESP_DATE4;
parameters[51].Value = model.COMMENTS4;
parameters[52].Value = model.DEADLINE5;
parameters[53].Value = model.DL_DATE5;
parameters[54].Value = model.DL_RESP_DATE5;
parameters[55].Value = model.COMMENTS5;
parameters[56].Value = model.DEADLINE6;
parameters[57].Value = model.DL_DATE6;
parameters[58].Value = model.DL_RESP_DATE6;
parameters[59].Value = model.COMMENTS6;
parameters[60].Value = model.FILE1;
parameters[61].Value = model.FILE2;
parameters[62].Value = model.FILE3;
parameters[63].Value = model.FILE4;
parameters[64].Value = model.FILE5;
parameters[65].Value = model.FILE6;
parameters[66].Value = model.FILE7;
parameters[67].Value = model.FILE8;
parameters[68].Value = model.FILE9;
parameters[69].Value = model.FILE10;
parameters[70].Value = model.FILE11;
parameters[71].Value = model.FILE12;
parameters[72].Value = model.FILE13;
parameters[73].Value = model.FILE14;
parameters[74].Value = model.FILE15;
int rows = DbHelperOra.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
