public Dictionary <string, object> getNotice(string limit, string page, string id)
{
int lim = int.Parse(limit);
int pa = int.Parse(page);
Dictionary <string, object> r = new Dictionary <string, object>();
try
{
DataTable dt = db.getNotice(id);
if (dt.Rows.Count > 0)
{
DataTable du = db.getNoticeDetail(id);
List <noticeModel> noticelist = new List <noticeModel>();
foreach (DataRow dr in dt.Select())
{
noticeModel nm = new noticeModel();
nm.NOTICE_ID = dr["NOTICE_ID"].ToString();
nm.NOTICE_CODE = dr["NOTICE_CODE"].ToString();
nm.NOTICE_TITLE = dr["NOTICE_TITLE"].ToString();
nm.NOTICE_CONTENT = dr["NOTICE_CONTENT"].ToString();
nm.NOTICE_DATETIME = Convert.ToDateTime(dr["NOTICE_DATETIME"]);
nm.NOTICE_ORGID = dr["NOTICE_ORGID"].ToString();
nm.NOTICE_ORGNAME = dr["NOTICE_ORGNAME"].ToString();
nm.IS_DELETE = int.Parse(dr["IS_DELETE"].ToString());
nm.CREATER = dr["CREATER"].ToString();
nm.CREATE_DATE = Convert.ToDateTime(dr["CREATE_DATE"].ToString());
List <noticeDetailModel> detailList = new List <noticeDetailModel>();
if (du.Rows.Count > 0)
{
foreach (DataRow drr in du.Select("NOTICE_ID='" + nm.NOTICE_ID + "'"))
{
noticeDetailModel ndm = new noticeDetailModel();
ndm.NOTICE_DETAIL_ID = drr["NOTICE_DETAIL_ID"].ToString();
ndm.NOTICE_ID = drr["NOTICE_ID"].ToString();
ndm.FILE_URL = drr["FILE_URL"].ToString();
ndm.FILE_NAME = drr["FILE_NAME"].ToString();
ndm.FILE_SIZE = drr["FILE_SIZE"].ToString();
detailList.Add(ndm);
}
nm.children = detailList;
}
noticelist.Add(nm);
}
int total = 0;
noticelist = (List <noticeModel>)KVTool.PaginationDataSource <noticeModel>(noticelist, pa, lim, out total);
r["message"] = "成功";
r["code"] = 2000;
r["items"] = JsonConvert.DeserializeObject(JsonConvert.SerializeObject(noticelist));
r["total"] = dt.Rows.Count;
}
else
{
r["message"] = "成功";
r["code"] = 2000;
r["total"] = 0;
}
}
catch (Exception e)
{
r["message"] = e.Message;
r["code"] = -1;
}
return(r);
}
/// <summary>
/// 查询公告信息
/// </summary>
/// <param name="d"></param>
/// <returns></returns>
public Dictionary <string, object> fetchNoticeList(Dictionary <string, object> d)
{
Dictionary <string, object> r = new Dictionary <string, object>();
try
{
int limit = d["limit"] == null ? 100 : int.Parse(d["limit"].ToString());
int page = d["page"] == null ? 1 : int.Parse(d["page"].ToString());
DataSet ds = db.fetchNoticeList(d);
List <NoticeMode> list = new List <NoticeMode>();
if (ds != null && ds.Tables.Count > 0)
{
DataTable dt = ds.Tables[0];
DataTable dtDetail = new DataTable();
if (ds.Tables.Count > 1)
{
dtDetail = ds.Tables[1];
}
if (dt != null && dt.Rows.Count > 0)
{
foreach (DataRow dr in dt.Rows)
{
NoticeMode noticeMode = new NoticeMode();
noticeMode.NOTICE_ID = dr["NOTICE_ID"].ToString();
noticeMode.NOTICE_CODE = dr["NOTICE_CODE"] == null ? "" : dr["NOTICE_CODE"].ToString();
noticeMode.NOTICE_TITLE = dr["NOTICE_TITLE"] == null ? "" : dr["NOTICE_TITLE"].ToString();
noticeMode.NOTICE_CONTENT = dr["NOTICE_CONTENT"] == null ? "" : dr["NOTICE_CONTENT"].ToString();
noticeMode.NOTICE_DATETIME = dr["NOTICE_DATETIME"] == null ? DateTime.Now : DateTime.Parse(dr["NOTICE_DATETIME"].ToString());
noticeMode.NOTICE_ORGID = dr["NOTICE_ORGID"].ToString();
noticeMode.NOTICE_ORGNAME = dr["NOTICE_ORGNAME"].ToString();
noticeMode.CREATER = dr["CREATER"].ToString();
noticeMode.CREATE_DATE = dr["CREATE_DATE"] == null ? DateTime.Now : DateTime.Parse(dr["CREATE_DATE"].ToString());
List <NoticeMode> listdetail = new List <NoticeMode>();
if (dtDetail != null && dtDetail.Rows.Count > 0)
{
DataRow[] arry = dtDetail.Select("NOTICE_ID='" + dr["NOTICE_ID"].ToString() + "'");
listdetail.Clear();
if (arry.Length > 0)
{
foreach (var item in arry)
{
NoticeMode noticeModeDetail = new NoticeMode();
noticeModeDetail.NOTICE_DETAIL_ID = item["NOTICE_DETAIL_ID"].ToString();
noticeModeDetail.FILE_URL = item["FILE_URL"].ToString();
noticeModeDetail.FILE_NAME = item["FILE_NAME"].ToString();
noticeModeDetail.FILE_SIZE = item["FILE_SIZE"].ToString();
noticeModeDetail.CREATER = item["CREATER"].ToString();
noticeModeDetail.CREATE_DATE = item["CREATE_DATE"] == null ? DateTime.Now : DateTime.Parse(item["CREATE_DATE"].ToString());
listdetail.Add(noticeModeDetail);
}
}
}
noticeMode.children = listdetail;
list.Add(noticeMode);
}
int totals = 0;
list = (List <NoticeMode>)KVTool.PaginationDataSource <NoticeMode>(list, page, limit, out totals);
r["total"] = dt.Rows.Count;
r["items"] = JsonConvert.DeserializeObject(JsonConvert.SerializeObject(list));// KVTool.TableToListDic(KVTool.GetPagedTable(dt, page, limit));
r["code"] = 2000;
r["message"] = "查询成功";
}
}
else
{
r["total"] = 0;
r["items"] = null;
r["code"] = 2000;
r["message"] = "查询成功";
}
}
catch (Exception e)
{
r["total"] = 0;
r["items"] = null;
r["code"] = -1;
r["message"] = e.Message;
}
return(r);
}
