/// <summary> /// /// 编写日期:2010-3-29 /// 编写人:GWF /// </summary> /// <param name="GUID"></param> /// <param name="APPLYGUID"></param> /// <param name="PROJECTNAME"></param> /// <param name="PROJECTADDRESS"></param> /// <param name="CORGUID"></param> /// <param name="CORNAME"></param> /// <param name="CORMANAGER"></param> /// <summary> /// /// 编写日期:2010-3-29 /// 编写人:GWF /// </summary> /// <param name="GUID"></param> public Detail_CAW_BANK_TRYRUN GetDetail(string Guid) { Database db = DatabaseFactory.CreateDatabase(CawConnStr); string strSql = "SELECT A.*,B.DATASTATUS,B.DATASTATUS_NAME,B.CHECKOPION FROM CAW_BANK_TRYRUN A,CAW_DATESTATUS B WHERE A.GUID=B.KEYGUID AND A.GUID='" + Guid + "' "; DbCommand cmd = db.GetSqlStringCommand(strSql); Detail_CAW_BANK_TRYRUN myDetail = new Detail_CAW_BANK_TRYRUN(); using (IDataReader myReader = db.ExecuteReader(cmd)) { if (myReader.Read()) { if (!Convert.IsDBNull(myReader["GUID"])) { myDetail.GUID = Convert.ToString(myReader["GUID"]); } if (!Convert.IsDBNull(myReader["APPLYGUID"])) { myDetail.APPLYGUID = Convert.ToString(myReader["APPLYGUID"]); } 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["HB_OPION"])) { myDetail.HB_OPION = Convert.ToString(myReader["HB_OPION"]); } if (!Convert.IsDBNull(myReader["LDAQ_OPION"])) { myDetail.LDAQ_OPION = Convert.ToString(myReader["LDAQ_OPION"]); } if (!Convert.IsDBNull(myReader["XF_OPION"])) { myDetail.XF_OPION = Convert.ToString(myReader["XF_OPION"]); } if (!Convert.IsDBNull(myReader["JGYS_OPION"])) { myDetail.JGYS_OPION = Convert.ToString(myReader["JGYS_OPION"]); } if (!Convert.IsDBNull(myReader["LAWMAN_SIGN"])) { myDetail.LAWMAN_SIGN = Convert.ToString(myReader["LAWMAN_SIGN"]); } if (!Convert.IsDBNull(myReader["APPLYDATE"])) { myDetail.APPLYDATE = Convert.ToDateTime(myReader["APPLYDATE"]); } 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_TRYRUN> GetProject(string CORGUID) { Database db = DatabaseFactory.CreateDatabase(CawConnStr); string strSql = "SELECT A.PROJECTNAME,A.GUID FROM CAW_BANK_TRYRUN 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_TRYRUN> ProjectList = new List<Detail_CAW_BANK_TRYRUN>(); for (int i = 0; i < dv.Count; i++) { Detail_CAW_BANK_TRYRUN Project = new Detail_CAW_BANK_TRYRUN(); Project.PROJECTNAME = dv[i]["PROJECTNAME"].ToString(); Project.GUID = dv[i]["GUID"].ToString(); ProjectList.Add(Project); } return ProjectList; }