// <summary>
///
/// 编写日期：2010-3-25
/// 编写人：GWF
/// </summary>
/// <param name="GUID"></param>
public Detail_CAW_ACCIDENT GetDetail(string GUID)
{
Database db = DatabaseFactory.CreateDatabase(CawConnStr);
string strSql = (db.DbProviderFactory.ToString() != "System.Data.OracleClient.OracleClientFactory") ?
"SELECT * FROM CAW_ACCIDENT WHERE GUID=@GUID " :
"SELECT * FROM CAW_ACCIDENT WHERE GUID=:GUID ";
DbCommand cmd = db.GetSqlStringCommand(strSql);
db.AddInParameter(cmd, "GUID", DbType.String, GUID);
Detail_CAW_ACCIDENT myDetail = new Detail_CAW_ACCIDENT();
using (IDataReader myReader = db.ExecuteReader(cmd))
{
if (myReader.Read())
{
if (!Convert.IsDBNull(myReader["GUID"]))
{
myDetail.GUID = Convert.ToString(myReader["GUID"]);
}
if (!Convert.IsDBNull(myReader["PORTGUID"]))
{
myDetail.PORTGUID = Convert.ToString(myReader["PORTGUID"]);
}
if (!Convert.IsDBNull(myReader["BASICINFO"]))
{
myDetail.BASICINFO = Convert.ToString(myReader["BASICINFO"]);
}
if (!Convert.IsDBNull(myReader["OCCURRENCETIME"]))
{
myDetail.OCCURRENCETIME = Convert.ToDateTime(myReader["OCCURRENCETIME"]);
}
if (!Convert.IsDBNull(myReader["OCCURRENCEADDR"]))
{
myDetail.OCCURRENCEADDR = Convert.ToString(myReader["OCCURRENCEADDR"]);
}
if (!Convert.IsDBNull(myReader["BERTHNAME"]))
{
myDetail.BERTHNAME = Convert.ToString(myReader["BERTHNAME"]);
}
if (!Convert.IsDBNull(myReader["UNITNAME"]))
{
myDetail.UNITNAME = Convert.ToString(myReader["UNITNAME"]);
}
if (!Convert.IsDBNull(myReader["ESTIMATELOSS"]))
{
myDetail.ESTIMATELOSS = Convert.ToDecimal(myReader["ESTIMATELOSS"]);
}
if (!Convert.IsDBNull(myReader["DEATHTOLL"]))
{
myDetail.DEATHTOLL = Convert.ToInt32(myReader["DEATHTOLL"]);
}
if (!Convert.IsDBNull(myReader["DEEPWOUNDTOLL"]))
{
myDetail.DEEPWOUNDTOLL = Convert.ToInt32(myReader["DEEPWOUNDTOLL"]);
}
if (!Convert.IsDBNull(myReader["PROCESS"]))
{
myDetail.PROCESS = Convert.ToString(myReader["PROCESS"]);
}
if (!Convert.IsDBNull(myReader["ANALYSE"]))
{
myDetail.ANALYSE = Convert.ToString(myReader["ANALYSE"]);
}
if (!Convert.IsDBNull(myReader["RESCUEINFO"]))
{
myDetail.RESCUEINFO = Convert.ToString(myReader["RESCUEINFO"]);
}
if (!Convert.IsDBNull(myReader["BERTHUSUAGE"]))
{
myDetail.BERTHUSUAGE = Convert.ToInt32(myReader["BERTHUSUAGE"]);
}
if (!Convert.IsDBNull(myReader["LEGALPERSON"]))
{
myDetail.LEGALPERSON = Convert.ToString(myReader["LEGALPERSON"]);
}
if (!Convert.IsDBNull(myReader["EMPLOYEECOUNT"]))
{
myDetail.EMPLOYEECOUNT = Convert.ToDecimal(myReader["EMPLOYEECOUNT"]);
}
if (!Convert.IsDBNull(myReader["LEGALAREA"]))
{
myDetail.LEGALAREA = Convert.ToString(myReader["LEGALAREA"]);
}
if (!Convert.IsDBNull(myReader["LINKMAN"]))
{
myDetail.LINKMAN = Convert.ToString(myReader["LINKMAN"]);
}
if (!Convert.IsDBNull(myReader["MOBILE"]))
{
myDetail.MOBILE = Convert.ToString(myReader["MOBILE"]);
}
if (!Convert.IsDBNull(myReader["TYPE"]))
{
myDetail.TYPE = Convert.ToInt32(myReader["TYPE"]);
}
if (!Convert.IsDBNull(myReader["REASONTYPE"]))
{
myDetail.REASONTYPE = Convert.ToInt32(myReader["REASONTYPE"]);
}
if (!Convert.IsDBNull(myReader["REMARK"]))
{
myDetail.REMARK = Convert.ToString(myReader["REMARK"]);
}
if (!Convert.IsDBNull(myReader["COMPANYGUID"]))
{
myDetail.COMPANYGUID = Convert.ToString(myReader["COMPANYGUID"]);
}
}
}
return myDetail;
}
/// <summary>
///
/// 编写日期：2010-3-19
/// 编写人：GWF
/// </summary>
/// <param name="DESIGNGUID"></param>
public Detail_CAW_ACCIDENT Select(string pGUID)
{
Database db = DatabaseFactory.CreateDatabase(CawConnStr);
string strSql = "SELECT A.*, B.DATASTATUS,B.DATASTATUS_NAME FROM CAW_ACCIDENT A,CAW_DATESTATUS B WHERE A.GUID=B.KEYGUID AND A.GUID='" + pGUID + "'";
DbCommand cmd = db.GetSqlStringCommand(strSql);
DataView dv = db.ExecuteDataView(cmd);
Detail_CAW_ACCIDENT CA = new Detail_CAW_ACCIDENT();
if (dv.Count > 0)
{
CA.GUID = dv[0]["GUID"].ToString();
CA.PORTGUID = dv[0]["PORTGUID"].ToString();
CA.BASICINFO = dv[0]["BASICINFO"].ToString();
try
{
CA.OCCURRENCETIME = Convert.ToDateTime(dv[0]["OCCURRENCETIME"]);
CA.ESTIMATELOSS = Convert.ToDecimal(dv[0]["ESTIMATELOSS"].ToString());
CA.DEATHTOLL = Convert.ToDecimal(dv[0]["DEATHTOLL"].ToString());
CA.DEEPWOUNDTOLL = Convert.ToDecimal(dv[0]["DEEPWOUNDTOLL"].ToString());
CA.EMPLOYEECOUNT = Convert.ToDecimal(dv[0]["EMPLOYEECOUNT"].ToString());
CA.BERTHUSUAGE = Convert.ToDecimal(dv[0]["BERTHUSUAGE"].ToString());
CA.TYPE = Convert.ToDecimal(dv[0]["TYPE"].ToString());
CA.REASONTYPE = Convert.ToDecimal(dv[0]["REASONTYPE"].ToString());
}
catch { }
CA.OCCURRENCEADDR = dv[0]["OCCURRENCEADDR"].ToString();
CA.BERTHNAME = dv[0]["BERTHNAME"].ToString();
CA.UNITNAME = dv[0]["UNITNAME"].ToString();
CA.PROCESS = dv[0]["PROCESS"].ToString();
CA.ANALYSE = dv[0]["ANALYSE"].ToString();
CA.RESCUEINFO = dv[0]["RESCUEINFO"].ToString();
CA.LEGALPERSON = dv[0]["LEGALPERSON"].ToString();
CA.LEGALAREA = dv[0]["LEGALAREA"].ToString();
CA.LINKMAN = dv[0]["LINKMAN"].ToString();
CA.MOBILE = dv[0]["MOBILE"].ToString();
CA.REMARK = dv[0]["REMARK"].ToString();
CA.COMPANYGUID = dv[0]["COMPANYGUID"].ToString();
CA.PORTNAME = dv[0]["PORTNAME"].ToString();
CA.STEPIDEA = dv[0]["STEPIDEA"].ToString();
CA.DATASTATUS = dv[0]["DATASTATUS"].ToString();
CA.DATASTATUS_NAME = dv[0]["DATASTATUS_NAME"].ToString();
}
return CA;
}
