/// <summary>
/// 根据类别获取新闻通知
/// </summary>
/// <returns></returns>
public List <HCQ2_Model.AppModel.Message> GetNoticeByType(HCQ2_Model.AppModel.NoticeModel notice, string appUrl)
{
HCQ2_Model.AppModel.Message mes = new HCQ2_Model.AppModel.Message();
List <HCQ2_Model.AppModel.Message> rlist = new List <HCQ2_Model.AppModel.Message>();
List <T_MessageNotice> list = new List <T_MessageNotice>();
T_ItemCodeBLL codeList = new T_ItemCodeBLL();
T_ItemCodeMenumBLL codeMenuList = new T_ItemCodeMenumBLL();
string news_type = codeMenuList.GetByItemId(codeList.GetByItemCode("NewsType").item_id).
Where(o => o.code_value == notice.type).FirstOrDefault()?.code_name;
var data = GetAllMess().Where(o => o.m_type == news_type).Skip((notice.rows * notice.page) - notice.rows).Take(notice.rows);
if (data.Count() > 0)
{
list = data.ToList();
foreach (var item in list)
{
mes = new HCQ2_Model.AppModel.Message();
mes.notice_title = item.m_title;
mes.notice_content = "";
mes.notice_type = item.m_type;
mes.notice_image = null;
mes.notice_image_src = "";
mes.release_name = item.create_user_name;
if (!string.IsNullOrEmpty(item.create_date.ToString()))
{
mes.release_date = Convert.ToDateTime(item.create_date).ToString("yyyy-MM-dd");
}
rlist.Add(mes);
}
}
return(rlist);
}
private string GetItemCodeMenuTreeJson(List <T_ItemCodeMenum> list)
{
T_ItemCodeMenumBLL codeMenuBll = new T_ItemCodeMenumBLL();
List <T_ItemCodeMenum> listMenu = codeMenuBll.GetItemCodeMenu();
sbChild.Append("[");
T_ItemCodeMenum itemCodeMenum = new T_ItemCodeMenum();
for (int i = 0; i < list.Count; i++)
{
if (i != 0)
{
sbChild.Append(" , ");
}
itemCodeMenum = list[i];
sbChild.Append(AddModleItemMenu(itemCodeMenum));
var data = listMenu.Where(o => o.code_pid == itemCodeMenum.code_id);
if (data.Count() > 0)
{
sbChild.Append(" ,nodes: ");
GetItemCodeMenuTreeJson(data.ToList());
sbChild.Append(" } ");
}
else
{
sbChild.Append(" } ");
}
}
sbChild.Append("]");
return(sbChild.ToString());
}
/// <summary>
/// 获取所有的字典目录树t_itemcode第一级目录
/// </summary>
/// <returns></returns>
public string GetItemTreeJson(List <T_ItemCode> listItemCode)
{
T_ItemCodeMenumBLL codeMenuBll = new T_ItemCodeMenumBLL();
List <T_ItemCodeMenum> listMenu = codeMenuBll.GetItemCodeMenu();
sbJson.Append("[");
T_ItemCode itemCode = new T_ItemCode();
for (int i = 0; i < listItemCode.Count; i++)
{
if (i != 0)
{
sbJson.Append(" , ");
}
itemCode = listItemCode[i];
sbJson.Append(AddModleItem(itemCode));
var data = listMenu.Where(o => o.item_id == itemCode.item_id && o.code_pid == 0);
if (data.Count() > 0)
{
sbJson.Append(" ,nodes: ");
sbJson.Append(GetItemCodeMenuTreeJson(data.ToList()));
sbChild = new StringBuilder();
sbJson.Append(" } ");
}
else
{
sbJson.Append(" } ");
}
}
sbJson.Append("]");
return(sbJson.ToString());
}
/// <summary>
/// 编辑数据字典
/// </summary>
/// <param name="obj"></param>
/// <returns></returns>
public bool EditItemCode(object obj)
{
bool isAccess = false;
FormCollection param = (FormCollection)obj;
int code_id = int.Parse(param["code_id"]);
int item_id = int.Parse(param["item_id"]);
string item_type = param["item_type"];
string input_item_name = param["input_name"];
string input_item_code = param["input_code"];
string input_item_note = param["input_note"];
string code_type = param["code_type"];
if (item_type == "M")
{
T_ItemCode itemcode = new T_ItemCode();
itemcode.item_name = input_item_name;
itemcode.item_code = input_item_code;
itemcode.item_note = input_item_note;
isAccess = base.Modify(itemcode, o => o.item_id == item_id, "item_name", "item_code", "item_note") > 0;
}
else if (item_type == "N")
{
T_ItemCodeMenumBLL menu_bll = new T_ItemCodeMenumBLL();
T_ItemCodeMenum menu = new T_ItemCodeMenum();
menu.code_name = input_item_name;
menu.code_value = input_item_code;
menu.code_note = input_item_note;
menu.code_type = code_type;
isAccess = menu_bll.Modify(menu, o => o.code_id == code_id, "code_name", "code_value", "code_note", "code_type") > 0;
}
return(isAccess);
}
/// <summary>
/// 删除数据字典
/// </summary>
/// <param name="obj"></param>
/// <returns></returns>
public bool DeleteItemCode(object obj)
{
bool isAccess = false;
FormCollection param = (FormCollection)obj;
string code_type = param["item_type"];
if (code_type == "M")
{
int item_id = int.Parse(param["item_id"]);
isAccess = base.Delete(o => o.item_id == item_id) > 0;
T_ItemCodeMenumBLL menuBll = new T_ItemCodeMenumBLL();
menuBll.Delete(o => o.item_id == item_id);
}
else if (code_type == "N")
{
int code_id = int.Parse(param["code_id"]);
T_ItemCodeMenumBLL menuBll = new T_ItemCodeMenumBLL();
isAccess = menuBll.Delete(o => o.code_id == code_id) > 0;
menuBll.Delete(o => o.code_pid == code_id);
}
return(isAccess);
}
/// <summary>
/// 根据企业类别统计人数
/// </summary>
/// <returns></returns>
public List <Dictionary <string, object> > GetCompayQXLB()
{
List <Dictionary <string, object> > rList = new List <Dictionary <string, object> >();
Dictionary <string, object> rDic = new Dictionary <string, object>();
StringBuilder sbSql = new StringBuilder();
sbSql.AppendFormat("select a.QXLB,PersonCount=(select COUNT(*) from A01 where UnitID=b.UnitID) from B01 b");
sbSql.AppendFormat(" inner join T_CompProInfo a on b.in_compay=a.com_id");
sbSql.AppendFormat(" where in_compay>0 order by in_compay");
DataTable dt = HCQ2_Common.SQL.SqlHelper.ExecuteDataTable(sbSql.ToString());
double totlePerson = Convert.ToDouble(dt.Compute("sum(PersonCount)", "true"));
T_ItemCode itemCode = new T_ItemCodeBLL().GetByItemCode("QYLSZBFB");
List <T_ItemCodeMenum> menuList = new T_ItemCodeMenumBLL().GetByItemId(itemCode.item_id);
double percent01 = 0;
double percent02 = 0;
foreach (var item in menuList)
{
rDic = new Dictionary <string, object>();
rDic.Add("name", item.code_name);
var data = dt.Select("QXLB='" + item.code_value + "'");
if (data.Count() > 0)
{
double count = Convert.ToDouble(data.CopyToDataTable().Compute("sum(PersonCount)", "true"));
rDic.Add("value", count / totlePerson);
if (item.code_value == "01")
{
percent01 = count / totlePerson;
}
if (item.code_value == "02")
{
percent02 = count / totlePerson;
}
}
else
{
rDic.Add("value", 0);
if (item.code_value == "01")
{
percent01 = 0;
}
if (item.code_value == "02")
{
percent02 = 0;
}
}
if (item.code_value != "01" && item.code_value != "02")
{
rList.Add(rDic);
}
}
//合并工程类总包和工程类分包
rDic = new Dictionary <string, object>();
rDic.Add("name", "建筑");
rDic.Add("value", (percent01 + percent02));
rList.Add(rDic);
return(rList);
}
/// <summary>
/// 新增数据字典
/// </summary>
/// <param name="obj"></param>
/// <returns></returns>
public bool AddItemCode(object obj)
{
bool isAccess = false;
FormCollection param = (FormCollection)obj;
string code_id = param["code_id"];
string item_id = param["item_id"];
string input_item_name = param["input_name"];
string input_item_code = param["input_code"];
string input_item_note = param["input_note"];
string input_code_type = param["input_code_type"];
if (string.IsNullOrEmpty(item_id) && string.IsNullOrEmpty(code_id))
{
//如果有相同的code，则不能添加。
if (base.Select(o => o.item_code == input_item_code).Count() > 0)
{
return(isAccess);
}
//添加字典说明表
T_ItemCode itemCode = new T_ItemCode();
itemCode.item_name = input_item_name;
itemCode.item_code = input_item_code;
itemCode.item_note = input_item_note;
itemCode.creator_date = DateTime.Now;
itemCode.creator_id = HCQ2UI_Helper.OperateContext.Current.Usr.user_id;
itemCode.creator_name = HCQ2UI_Helper.OperateContext.Current.Usr.user_name;
isAccess = base.Add(itemCode) > 0;
}
else if (!string.IsNullOrEmpty(item_id) && string.IsNullOrEmpty(code_id))
{
//添加第一层字典表
T_ItemCodeMenumBLL codeBll = new T_ItemCodeMenumBLL();
//如果有相同的code，则不能添加。
if (codeBll.GetByItemId(int.Parse(item_id)).Where(o => o.code_value == input_item_code).Count() > 0)
{
return(isAccess);
}
T_ItemCodeMenum codeMenu = codeBll.GetByItemId(int.Parse(item_id)).Where(o => o.code_pid == 0).LastOrDefault();
int? maxOrder = codeMenu != null ? codeMenu.code_order + 1 : 1;
codeMenu = new T_ItemCodeMenum();
codeMenu.item_id = int.Parse(item_id);
codeMenu.code_name = input_item_name;
codeMenu.code_value = input_item_code;
codeMenu.code_note = input_item_note;
codeMenu.if_system = 0;
codeMenu.if_child = 0;
codeMenu.code_pid = 0;
codeMenu.code_order = maxOrder;
if (!string.IsNullOrEmpty(input_code_type))
{
codeMenu.code_type = input_code_type;
}
isAccess = codeBll.Add(codeMenu) > 0;
}
else if (!string.IsNullOrEmpty(item_id) && !string.IsNullOrEmpty(code_id))
{
//添加字典表字典的子节点
T_ItemCodeMenumBLL codeBll = new T_ItemCodeMenumBLL();
//如果有相同的code，则不能添加。
if (codeBll.GetByItemId(int.Parse(item_id)).Where(o => o.code_value == input_item_code).Count() > 0)
{
return(isAccess);
}
T_ItemCodeMenum codeMenu = codeBll.GetByItemId(int.Parse(item_id)).Where(o => o.code_pid == int.Parse(code_id)).Max();
int? maxOrder = codeMenu != null ? codeMenu.code_order + 1 : 1;
codeMenu = new T_ItemCodeMenum();
codeMenu.item_id = int.Parse(item_id);
codeMenu.code_name = input_item_name;
codeMenu.code_value = input_item_code;
codeMenu.code_note = input_item_note;
codeMenu.if_system = 0;
codeMenu.if_child = 0;
codeMenu.code_pid = int.Parse(code_id);
codeMenu.code_order = maxOrder;
if (!string.IsNullOrEmpty(input_code_type))
{
codeMenu.code_type = input_code_type;
}
isAccess = codeBll.Add(codeMenu) > 0;
}
return(isAccess);
}
/// <summary>
/// 返回页面的json
/// </summary>
/// <returns></returns>
public string ReturnPageJson(object obj)
{
FormCollection param = (FormCollection)obj;
T_ItemCodeMenumBLL _bll_codeitemmenu = new T_ItemCodeMenumBLL();
List <T_ItemCodeMenum> list = _bll_codeitemmenu.GetItemCodeMenu();
int page = int.Parse(param["page"]);
int rows = int.Parse(param["rows"]);
if (!string.IsNullOrEmpty(param["item_id"]))
{
list = list.Where(o => o.item_id == int.Parse(param["item_id"])).ToList();
}
if (!string.IsNullOrEmpty(param["code_id"]))
{
list = list.Where(o => o.code_id == int.Parse(param["code_id"])).ToList();
}
if (!string.IsNullOrEmpty(param["txtSearchName"]))
{
list = list.Where(o => o.code_name.Contains(param["txtSearchName"])).ToList();
}
List <T_ItemCode> listItemCode = GetItemCode();
if (!string.IsNullOrEmpty(param["item_id"]))
{
listItemCode = listItemCode.Where(o => o.item_id == int.Parse(param["item_id"])).ToList();
}
if (!string.IsNullOrEmpty(param["code_id"]))
{
listItemCode = listItemCode.Where(o => o.item_id == -1).ToList();
}
if (!string.IsNullOrEmpty(param["txtSearchName"]))
{
listItemCode = listItemCode.Where(o => o.item_name.Contains(param["txtSearchName"])).ToList();
}
DisplayCode dis = new DisplayCode();
List <DisplayCode> displayList = new List <DisplayCode>();
if (listItemCode.Count() > 0)
{
for (int i = 0; i < listItemCode.Count(); i++)
{
dis = new DisplayCode();
dis.code_id = 0;
dis.code_name = listItemCode[i].item_name;
dis.code_value = listItemCode[i].item_code;
dis.code_note = listItemCode[i].item_note;
dis.item_id = listItemCode[i].item_id;
dis.item_type = "M";
displayList.Add(dis);
}
}
if (list.Count() > 0)
{
for (int i = 0; i < list.Count(); i++)
{
dis = new DisplayCode();
dis.code_id = list[i].code_id;
dis.code_name = list[i].code_name;
dis.code_value = list[i].code_value;
dis.code_note = list[i].code_note;
dis.item_id = list[i].item_id;
dis.code_type = list[i].code_type;
dis.item_type = "N";
displayList.Add(dis);
}
}
return(HCQ2_Common.ReturnJson.GetReturnJson <DisplayCode>(displayList, page, rows));
}