// <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; }