/// <summary> /// 获取已经通过审核的初步设计中的项目名称和Guid,用于填充施工图设计的下拉框 Type=“0” /// 获取已经通过施工图中的项目名称和Guid,用于填充开工申请中的下拉框 Type=“1” /// </summary> /// <param name="CORGUID"></param> /// <returns></returns> public List<Detail_CAW_BANK_PREDESIGN> GetProject(string CORGUID,string Type) { Database db = DatabaseFactory.CreateDatabase(CawConnStr); string strSql = "SELECT PROJECTNAME,DESIGNGUID FROM CAW_BANK_PREDESIGN A,CAW_DATESTATUS B WHERE A.DTYPE='" + Type.ToString() + "' AND A.DESIGNGUID=B.KEYGUID AND B.DATASTATUS='2' AND A.CORGUID='" + CORGUID + "'"; DbCommand cmd = db.GetSqlStringCommand(strSql); DataView dv = db.ExecuteDataView(cmd); List<Detail_CAW_BANK_PREDESIGN> ProjectList = new List<Detail_CAW_BANK_PREDESIGN>(); for (int i = 0; i < dv.Count; i++) { Detail_CAW_BANK_PREDESIGN Project = new Detail_CAW_BANK_PREDESIGN(); Project.PROJECTNAME = dv[i]["PROJECTNAME"].ToString(); Project.DESIGNGUID = dv[i]["DESIGNGUID"].ToString(); ProjectList.Add(Project); } return ProjectList; }
/// <summary> /// 根据岸线申请主键,获取该项目的基本信息(地点、主要设计单位、设计单位资质等级),用于填充相应的控件 /// </summary> /// <param name="ApplyGuid"></param> /// <returns></returns> public Detail_CAW_BANK_PREDESIGN GetProjectInfo(string DESIGNGUID) { Database db = DatabaseFactory.CreateDatabase(CawConnStr); string strSql = "SELECT PROJECTNAME,DESIGNADDRESS,DESIGNAGENT,AGENTGRADE FROM CAW_BANK_PREDESIGN WHERE DESIGNGUID='" + DESIGNGUID + "'"; DbCommand cmd = db.GetSqlStringCommand(strSql); DataView dv = db.ExecuteDataView(cmd); Detail_CAW_BANK_PREDESIGN CBP = new Detail_CAW_BANK_PREDESIGN(); if (dv.Count > 0) { CBP.AGENTGRADE = dv[0]["AGENTGRADE"].ToString(); CBP.DESIGNADDRESS = dv[0]["DESIGNADDRESS"].ToString(); CBP.PROJECTNAME = dv[0]["PROJECTNAME"].ToString(); CBP.DESIGNAGENT = dv[0]["DESIGNAGENT"].ToString(); } return CBP; }
/// <summary> /// /// 编写日期:2010-3-19 /// 编写人:GWF /// </summary> /// <param name="DESIGNGUID"></param> public Detail_CAW_BANK_PREDESIGN Select(string DESIGNGUID) { Database db = DatabaseFactory.CreateDatabase(CawConnStr); string strSql = "SELECT A.*, B.DATASTATUS,B.DATASTATUS_NAME,B.CHECKOPION FROM CAW_BANK_PREDESIGN A,CAW_DATESTATUS B WHERE A.DESIGNGUID=B.KEYGUID AND A.DESIGNGUID='" + DESIGNGUID + "'"; DbCommand cmd = db.GetSqlStringCommand(strSql); DataView dv = db.ExecuteDataView(cmd); Detail_CAW_BANK_PREDESIGN CBP = new Detail_CAW_BANK_PREDESIGN(); if (dv.Count > 0) { CBP.AGENTGRADE = dv[0]["AGENTGRADE"].ToString(); CBP.CORGUID = dv[0]["CORGUID"].ToString(); CBP.CORPADDRESS = dv[0]["CORPADDRESS"].ToString(); CBP.CORPNAME = dv[0]["CORPNAME"].ToString(); CBP.DECDATE = DateTime.MinValue; try { CBP.DECDATE = Convert.ToDateTime(dv[0]["DECDATE"]); } catch { } CBP.DECPERNAME = dv[0]["DECPERNAME"].ToString(); CBP.DESIGNADDRESS = dv[0]["DESIGNADDRESS"].ToString(); CBP.DESIGNAGENT = dv[0]["DESIGNAGENT"].ToString(); CBP.DESIGNGUID = dv[0]["DESIGNGUID"].ToString(); CBP.DESIGNREMARK = dv[0]["DESIGNREMARK"].ToString(); CBP.ITEMNAME = dv[0]["ITEMNAME"].ToString(); CBP.LAWMAN = dv[0]["LAWMAN"].ToString(); CBP.LAWMANTEL = dv[0]["LAWMANTEL"].ToString(); CBP.LINKNAME = dv[0]["LINKNAME"].ToString(); CBP.LINKPOSTCODE = dv[0]["LINKPOSTCODE"].ToString(); CBP.LINKTEL = dv[0]["LINKTEL"].ToString(); CBP.LMPOSTCODE = dv[0]["LMPOSTCODE"].ToString(); CBP.PROJECTNAME = dv[0]["PROJECTNAME"].ToString(); CBP.ApplyGuid = dv[0]["ApplyGuid"].ToString(); CBP.DATASTATUS = dv[0]["DATASTATUS"].ToString(); CBP.DATASTATUS_NAME = dv[0]["DATASTATUS_NAME"].ToString(); CBP.CHECKOPION = dv[0]["CHECKOPION"].ToString(); } return CBP; }