/// <summary> /// /// 编写日期:2010-4-9 /// 编写人:GWF /// </summary> /// <param name="GUID"></param> public Detail_CAW_BANK_PREFINISH GetDetail(string GUID) { Database db = DatabaseFactory.CreateDatabase(CawConnStr); string strSql = "SELECT A.*,B.DATASTATUS,B.DATASTATUS_NAME,B.CHECKOPION FROM CAW_BANK_PREFINISH A,CAW_DATESTATUS B WHERE A.GUID=B.KEYGUID AND A.GUID='" + GUID + "' "; DbCommand cmd = db.GetSqlStringCommand(strSql); Detail_CAW_BANK_PREFINISH myDetail = new Detail_CAW_BANK_PREFINISH(); using (IDataReader myReader = db.ExecuteReader(cmd)) { if (myReader.Read()) { if (!Convert.IsDBNull(myReader["GUID"])) { myDetail.GUID = Convert.ToString(myReader["GUID"]); } if (!Convert.IsDBNull(myReader["DOCACCGUID"])) { myDetail.DOCACCGUID = Convert.ToString(myReader["DOCACCGUID"]); } if (!Convert.IsDBNull(myReader["APPLICANT"])) { myDetail.APPLICANT = Convert.ToString(myReader["APPLICANT"]); } if (!Convert.IsDBNull(myReader["APPLYDATE"])) { myDetail.APPLYDATE = Convert.ToDateTime(myReader["APPLYDATE"]); } if (!Convert.IsDBNull(myReader["ORGOPION"])) { myDetail.ORGOPION = Convert.ToString(myReader["ORGOPION"]); } if (!Convert.IsDBNull(myReader["NOTE"])) { myDetail.NOTE = Convert.ToString(myReader["NOTE"]); } if (!Convert.IsDBNull(myReader["PROJECTNAME"])) { myDetail.PROJECTNAME = Convert.ToString(myReader["PROJECTNAME"]); } if (!Convert.IsDBNull(myReader["PROJECTADDRESS"])) { myDetail.PROJECTADDRESS = Convert.ToString(myReader["PROJECTADDRESS"]); } if (!Convert.IsDBNull(myReader["CORGUID"])) { myDetail.CORGUID = Convert.ToString(myReader["CORGUID"]); } if (!Convert.IsDBNull(myReader["CORNAME"])) { myDetail.CORNAME = Convert.ToString(myReader["CORNAME"]); } if (!Convert.IsDBNull(myReader["CORMANAGER"])) { myDetail.CORMANAGER = Convert.ToString(myReader["CORMANAGER"]); } if (!Convert.IsDBNull(myReader["CONTACTOR"])) { myDetail.CONTACTOR = Convert.ToString(myReader["CONTACTOR"]); } if (!Convert.IsDBNull(myReader["CONTACTORTEL"])) { myDetail.CONTACTORTEL = Convert.ToString(myReader["CONTACTORTEL"]); } if (!Convert.IsDBNull(myReader["DESIGNERUNIT"])) { myDetail.DESIGNERUNIT = Convert.ToString(myReader["DESIGNERUNIT"]); } if (!Convert.IsDBNull(myReader["DESIGNERGRADE"])) { myDetail.DESIGNERGRADE = Convert.ToString(myReader["DESIGNERGRADE"]); } if (!Convert.IsDBNull(myReader["BUILDERUNIT"])) { myDetail.BUILDERUNIT = Convert.ToString(myReader["BUILDERUNIT"]); } if (!Convert.IsDBNull(myReader["BUILDERGRADE"])) { myDetail.BUILDERGRADE = Convert.ToString(myReader["BUILDERGRADE"]); } if (!Convert.IsDBNull(myReader["SUPUNIT"])) { myDetail.SUPUNIT = Convert.ToString(myReader["SUPUNIT"]); } if (!Convert.IsDBNull(myReader["SUPGRADE"])) { myDetail.SUPGRADE = Convert.ToString(myReader["SUPGRADE"]); } if (!Convert.IsDBNull(myReader["SUPERVISIONORG"])) { myDetail.SUPERVISIONORG = Convert.ToString(myReader["SUPERVISIONORG"]); } if (!Convert.IsDBNull(myReader["DATASTATUS"])) { myDetail.DATASTATUS = Convert.ToString(myReader["DATASTATUS"]); } if (!Convert.IsDBNull(myReader["DATASTATUS_NAME"])) { myDetail.DATASTATUS_NAME = Convert.ToString(myReader["DATASTATUS_NAME"]); } if (!Convert.IsDBNull(myReader["CHECKOPION"])) { myDetail.CHECKOPION = Convert.ToString(myReader["CHECKOPION"]); } } } return myDetail; }
/// <summary> ///从通过初步验收申请中,获取项目名称列表 /// </summary> /// <param name="CORGUID"></param> /// <returns></returns> public List<Detail_CAW_BANK_PREFINISH> GetProject(string CORGUID) { Database db = DatabaseFactory.CreateDatabase(CawConnStr); string strSql = "SELECT A.PROJECTNAME,A.GUID FROM CAW_BANK_PREFINISH A,CAW_DATESTATUS B WHERE A.GUID=B.KEYGUID AND B.DATASTATUS='2' AND A.CORGUID='" + CORGUID + "'"; DbCommand cmd = db.GetSqlStringCommand(strSql); DataView dv = db.ExecuteDataView(cmd); List<Detail_CAW_BANK_PREFINISH> ProjectList = new List<Detail_CAW_BANK_PREFINISH>(); for (int i = 0; i < dv.Count; i++) { Detail_CAW_BANK_PREFINISH Project = new Detail_CAW_BANK_PREFINISH(); Project.PROJECTNAME = dv[i]["PROJECTNAME"].ToString(); Project.GUID = dv[i]["GUID"].ToString(); ProjectList.Add(Project); } return ProjectList; }