/// <summary> /// 选择申请项的信息,用于填充dropdown /// </summary> /// <param name="ID"></param> /// <returns></returns> public List<Detail_CAW_APPLYNOTE> GetApplyInfo() { Database db = DatabaseFactory.CreateDatabase(CawConnStr); string SqlStr = "SELECT TABLEFLAG,TABLENAME,PAGEURL2 FROM CAW_APPLYNOTE "; DbCommand cmd = db.GetSqlStringCommand(SqlStr); DataView dv = db.ExecuteDataView(cmd); List<Detail_CAW_APPLYNOTE> DocList = new List<Detail_CAW_APPLYNOTE>(); for (int i = 0; i < dv.Count; i++) { Detail_CAW_APPLYNOTE DCA = new Detail_CAW_APPLYNOTE(); DCA.TABLEFLAG = dv[i]["TABLEFLAG"].ToString().Trim(); DCA.TABLENAME = dv[i]["TABLENAME"].ToString().Trim(); DCA.PAGEURL2 = dv[i]["PAGEURL2"].ToString().Trim(); DocList.Add(DCA); } return DocList; }
/// <summary> /// /// 编写日期:2010-3-10 /// 编写人:GWF /// </summary> /// <param name="ID"></param> public List<Detail_CAW_APPLYNOTE> GetApplyNoteRecord(string ID) { Database db = DatabaseFactory.CreateDatabase(CawConnStr); string SqlStr = "SELECT TABLEFLAG,TABLENAME,TABLENOTE,FREQUENCE,PAGEURL,PAGEURL2 FROM CAW_APPLYNOTE WHERE GUID='" + ID + "'"; DbCommand cmd = db.GetSqlStringCommand(SqlStr); DataView dv = db.ExecuteDataView(cmd); List<Detail_CAW_APPLYNOTE> DocList = new List<Detail_CAW_APPLYNOTE>(); for (int i = 0; i < dv.Count; i++) { Detail_CAW_APPLYNOTE DCA = new Detail_CAW_APPLYNOTE(); DCA.GUID = ID; DCA.TABLEFLAG = dv[i]["TABLEFLAG"].ToString().Trim(); DCA.TABLENAME = dv[i]["TABLENAME"].ToString().Trim(); DCA.TABLENOTE = dv[i]["TABLENOTE"].ToString().Trim(); DCA.FREQUENCE = dv[i]["FREQUENCE"].ToString().Trim(); DCA.PAGEURL = dv[i]["PAGEURL"].ToString().Trim(); DCA.PAGEURL2 = dv[i]["PAGEURL2"].ToString().Trim(); DocList.Add(DCA); } return DocList; }