/// <summary>
///
/// 编写日期：2010-3-10
/// 编写人：GWF
/// </summary>
/// <param name="ID"></param>
public List<Detail_OA_SWFTABLEFLAG> GetApplyNoteRecord(string ID)
{
Database db = DatabaseFactory.CreateDatabase(ConnStr);
string SqlStr = "SELECT TABLEFLAG,TABLENAME,TABLENOTE,FREQUENCE,PAGEURL,PAGEURL2 FROM OA_SWFTABLEFLAG WHERE GUID='" + ID + "'";
DbCommand cmd = db.GetSqlStringCommand(SqlStr);
DataView dv = db.ExecuteDataView(cmd);
List<Detail_OA_SWFTABLEFLAG> DocList = new List<Detail_OA_SWFTABLEFLAG>();
for (int i = 0; i < dv.Count; i++)
{
Detail_OA_SWFTABLEFLAG DCA = new Detail_OA_SWFTABLEFLAG();
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;
}
/// <summary>
/// 选择申请项的信息，用于填充dropdown
/// </summary>
/// <param name="ID"></param>
/// <returns></returns>
public List<Detail_OA_SWFTABLEFLAG> GetApplyInfo()
{
Database db = DatabaseFactory.CreateDatabase(ConnStr);
string SqlStr = "SELECT TABLEFLAG,TABLENAME,PAGEURL2 FROM OA_SWFTABLEFLAG ";
DbCommand cmd = db.GetSqlStringCommand(SqlStr);
DataView dv = db.ExecuteDataView(cmd);
List<Detail_OA_SWFTABLEFLAG> DocList = new List<Detail_OA_SWFTABLEFLAG>();
for (int i = 0; i < dv.Count; i++)
{
Detail_OA_SWFTABLEFLAG DCA = new Detail_OA_SWFTABLEFLAG();
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;
}