/// <summary> /// 修改 /// </summary> private void updateDictionary() { try { SysDictionary Dictionary = new SysDictionary(); Dictionary.D_Code = D_Code.Text; Dictionary.D_Name = D_Name.Text; Dictionary.D_Type = D_Type.SelectedItem.ToString(); Dictionary.D_Seq = int.Parse(D_Seq.Value.ToString()); Dictionary.D_CreateBy = D_CreateBy.Text; Dictionary.D_CreateDate = D_CreateDate.Value; Dictionary.D_UpdateBy = D_UpdateBy.Text; Dictionary.D_UpdateDate = D_UpdateDate.Value; SysDictionaryBLL Dictionarybll = new SysDictionaryBLL(); if (Dictionarybll.Edit(Dictionary) > 0) { untCommon.InfoMsg("修改成功!"); frmParent.loadData(); } else { untCommon.InfoMsg("修改失败!"); } } catch (Exception ex) { untCommon.ErrorMsg("常规信息管理更新数据异常:" + ex.Message); } }
private void deleteDictionary() { try { if (dataGridView.SelectedRows.Count < 1) { return; } string D_Code = dataGridView.SelectedRows[0].Cells["D_Code"].Value.ToString(); if (untCommon.QuestionMsg("您确定删除[" + D_Code + "]该项吗?")) { SysDictionaryBLL companybll = new SysDictionaryBLL(); if (companybll.Delete(D_Code) > 0) { untCommon.InfoMsg("删除成功!"); loadData(); } else { untCommon.InfoMsg("删除失败!"); } } } catch (Exception ex) { untCommon.ErrorMsg("常规信息管理删除数据异常:" + ex); } }
/// <summary> /// 添加 /// </summary> private void addDictionary() { try { if (checkInput()) { SysDictionary Dictionary = new SysDictionary(); Dictionary.D_Code = D_Code.Text; Dictionary.D_Name = D_Name.Text; Dictionary.D_Type = D_Type.SelectedItem.ToString(); Dictionary.D_Seq = int.Parse(D_Seq.Value.ToString()); Dictionary.D_CreateBy = D_CreateBy.Text; Dictionary.D_CreateDate = D_CreateDate.Value; Dictionary.D_UpdateBy = null; Dictionary.D_UpdateDate = null; SysDictionaryBLL Dictionarybll = new SysDictionaryBLL(); if (Dictionarybll.Exists(Dictionary.D_Code)) { untCommon.InfoMsg("信息编码已存在!"); } else { if (Dictionarybll.Add(Dictionary) > 0) { untCommon.InfoMsg("添加成功!"); frmParent.loadData(); } else { untCommon.InfoMsg("添加失败!"); } } } } catch (Exception ex) { untCommon.ErrorMsg("常规信息管理添加数据异常:" + ex.Message); } }
public void loadData(string type = "", string key = "") { try { SysDictionaryBLL companybll = new SysDictionaryBLL(); var rows = companybll.loadData(type, key); if (rows == null || rows.Count < 1) { untCommon.InfoMsg("没有任何数据!"); return; } dataGridView.DataSource = rows; } catch (Exception ex) { untCommon.ErrorMsg("常规信息管理加载数据异常:" + ex.Message); } }
private string FormatTextBySysDic(string strColValue, string strSysCategory) { string strTemp = string.Empty; decimal dValue = 0; decimal.TryParse(strColValue, out dValue); List <T_SYS_DICTIONARY> entDics = new List <T_SYS_DICTIONARY>();// permClient.GetSysDictionaryByCategory(strSysCategory); using (SysDictionaryBLL bll = new SysDictionaryBLL()) { //GetSysLeftMenuFilterPermissionToNewFrame("85b414ab-87b3-4740-aef4-1d89f3f380cc"); entDics = bll.GetSysDictionaryByCategory(strSysCategory).ToList(); } strTemp = entDics.Where(c => c.DICTIONARYVALUE == dValue).First().DICTIONARYNAME; strTemp = string.IsNullOrEmpty(strTemp) == true ? "-" : strTemp; return(strTemp); }
private void getDetail() { try { SysDictionaryBLL Dictionarybll = new SysDictionaryBLL(); SysDictionary Dictionary = Dictionarybll.getDetail(PrimaryKey); D_Code.Text = Dictionary.D_Code; D_Name.Text = Dictionary.D_Name; D_Type.SelectedItem = Dictionary.D_Type; D_Seq.Value = Dictionary.D_Seq; D_CreateBy.Text = Dictionary.D_CreateBy; D_UpdateBy.Text = Dictionary.D_UpdateBy; if (Dictionary.D_CreateDate.HasValue) { D_CreateDate.Value = Dictionary.D_CreateDate.Value; } else { D_CreateDate.Value = DateTime.Now; } if (Dictionary.D_UpdateDate.HasValue) { D_UpdateDate.Value = Dictionary.D_UpdateDate.Value; } else { D_UpdateDate.Value = DateTime.Now; ; } } catch (Exception ex) { untCommon.ErrorMsg("信息管理加载数据异常:" + ex.Message); } }
public void SysDictionaryDelete(string[] IDs) { using (SysDictionaryBLL bll = new SysDictionaryBLL()) { bll.SysDictionaryDelete(IDs); } }
public void SysDictionaryUpdate(T_SYS_DICTIONARY dict, ref string strMsg) { using (SysDictionaryBLL bll = new SysDictionaryBLL()) { bll.SysDictionaryUpdate(dict, ref strMsg); } }
public List<T_SYS_DICTIONARY> GetSysDictionaryByCategoryList(List<string> category) { using (SysDictionaryBLL bll = new SysDictionaryBLL()) { List<T_SYS_DICTIONARY> dictlist = bll.GetSysDictionaryByCategory(category); return dictlist; } }
public List<V_Dictionary> GetSysDictionaryByCategoryByUpdateDate(string category, DateTime dt) { using (SysDictionaryBLL bll = new SysDictionaryBLL()) { IQueryable<V_Dictionary> dictlist = bll.GetSysDictionaryByCategoryByUpdateDate(category, dt); if (dictlist != null) { return dictlist.Count() > 0 ? dictlist.ToList() : null; } else { return null; } } }
public List<T_SYS_DICTIONARY> GetSysDictionaryByFilterPaging(int pageIndex, int pageSize, string sort, string filterString, IList<object> paras, ref int pageCount, string userID) { using (SysDictionaryBLL bll = new SysDictionaryBLL()) { IQueryable<T_SYS_DICTIONARY> menuList = bll.GetSysDictionaryByFilterWithPaging(pageIndex, pageSize, sort, filterString, paras, ref pageCount, userID); if (menuList != null) { return menuList.Count() > 0 ? menuList.ToList() : null; } else { return null; } } }
public T_SYS_DICTIONARY GetSysDictionaryByID(string dictID) { using (SysDictionaryBLL bll = new SysDictionaryBLL()) { return bll.GetSysDictionaryByID(dictID); } }
private StringBuilder GetEmployeeAttendBody(string CompanyName, string Strdate, List <V_LEFTOFFICEVIEW> Collects) { StringBuilder stringBuilder = new StringBuilder(); stringBuilder.Append("<body>\n\r"); stringBuilder.Append("<table ID=\"Table0\" BORDER=1 CELLSPACING=1 CELLPADDING=3 width=100% align=center>\n\r"); stringBuilder.Append("<tr>"); stringBuilder.Append("<table border=1 cellspacing=0 CELLPADDING=3 width=100% align=center>"); stringBuilder.Append("<tr>"); stringBuilder.Append("<td align=center class=\"title\" >员工编号</td>"); stringBuilder.Append("<td align=center class=\"title\" >员工姓名</td>"); stringBuilder.Append("<td align=center class=\"title\" >离职类型</td>"); stringBuilder.Append("<td align=center class=\"title\" >入职时间</td>"); stringBuilder.Append("<td align=center class=\"title\" >离职时间</td>"); stringBuilder.Append("<td align=center class=\"title\" >申请时间</td>"); stringBuilder.Append("<td align=center class=\"title\" >审批状态</td>"); stringBuilder.Append("<td align=center class=\"title\" >是否确认</td>"); stringBuilder.Append("</tr>"); if (Collects.Count <V_LEFTOFFICEVIEW>() > 0) { SysDictionaryBLL bll = new SysDictionaryBLL(); List <TM_SaaS_OA_EFModel.T_SYS_DICTIONARY> sysDictionaryByCategoryList = bll.GetSysDictionaryByCategory(new List <string> { "LEFTOFFICECATEGORY", "CHECKSTATE" }); int i; for (i = 0; i < Collects.Count; i++) { stringBuilder.Append("<tr>"); stringBuilder.Append("<td class=\"x1282\">" + Collects[i].EMPLOYEECODE + "</td>"); stringBuilder.Append("<td class=\"x1282\">" + Collects[i].EMPLOYEECNAME + "</td>"); stringBuilder.Append("<td class=\"x1282\">" + sysDictionaryByCategoryList.Where(t => t.DICTIONARYVALUE == Convert.ToInt32(Collects[i].LEFTOFFICECATEGORY) && t.DICTIONCATEGORY == "LEFTOFFICECATEGORY").FirstOrDefault().DICTIONARYNAME + "</td>"); stringBuilder.Append("<td class=\"x1282\">" + Collects[i].ENTRYDATE.Value.ToString("yyyy-MM-dd") + "</td>"); stringBuilder.Append("<td class=\"x1282\">" + Collects[i].LEFTOFFICEDATE.Value.ToString("yyyy-MM-dd") + "</td>"); stringBuilder.Append("<td class=\"x1282\">" + Collects[i].APPLYDATE.Value.ToString("yyyy-MM-dd") + "</td>"); stringBuilder.Append("<td class=\"x1282\">" + sysDictionaryByCategoryList.Where(t => t.DICTIONARYVALUE == decimal.Parse(Collects[i].CHECKSTATE) && t.DICTIONCATEGORY == "CHECKSTATE").FirstOrDefault().DICTIONARYNAME + "</td>"); int num = Convert.ToInt32(Collects[i].ISCONFIRMED); string str1 = string.Empty; if (num < 0) { str1 = "未确认"; } else { if (num >= 0 && num < 2) { str1 = "确认中"; } else { if (num == 2) { str1 = "已确认"; } else { if (num == 3) { str1 = "确认未通过"; } } } } stringBuilder.Append("<td class=\"x1282\">" + str1 + "</td>"); stringBuilder.Append("</tr>"); } } stringBuilder.Append("</table>"); stringBuilder.Append("</body></html>"); return(stringBuilder); }
/// <summary> /// 数据组装 /// </summary> /// <param name="dt"></param> /// <param name="entSignIn"></param> /// <returns></returns> private DataTable GetDataConversion(DataTable dt, IQueryable <T_HR_EMPLOYEESIGNINDETAIL> entSignIn) { dt.Rows.Clear(); foreach (var item in entSignIn) { try { List <T_SYS_DICTIONARY> dic = new List <T_SYS_DICTIONARY>();//new SaaS.BLLCommonServices.PermissionWS.PermissionServiceClient().GetSysDictionaryByCategoryList(new string[] { "ABNORMCATEGORY", "ATTENDPERIOD", "REASONCATEGORY" });//获取字典值 using (SysDictionaryBLL bll = new SysDictionaryBLL()) { dic = bll.GetSysDictionaryByCategory(new List <string> { "ABNORMCATEGORY", "ATTENDPERIOD", "REASONCATEGORY" }); } // nationDict = tmp.Where(s => s.DICTIONCATEGORY == "NATION" && s.DICTIONARYVALUE == nationValue).FirstOrDefault(); DataRow row = dt.NewRow(); #region 每行数据 for (int i = 0; i < dt.Columns.Count; i++) { switch (i) { case 0: row[i] = item.ABNORMALDATE.Value.ToString("yyyy-MM-dd"); break; //异常日期 case 1: decimal?abCategory = Convert.ToDecimal(item.ABNORMCATEGORY); var dicAbCategory = dic.Where(s => s.DICTIONCATEGORY == "ABNORMCATEGORY" && s.DICTIONARYVALUE == abCategory).FirstOrDefault(); if (dicAbCategory != null) { row[i] = dicAbCategory.DICTIONARYNAME;; //异常类型 } break; case 2: decimal?abOd = Convert.ToDecimal(item.ATTENDPERIOD); var dicAbOd = dic.Where(s => s.DICTIONCATEGORY == "ATTENDPERIOD" && s.DICTIONARYVALUE == abOd).FirstOrDefault(); if (dicAbOd != null) { row[i] = dicAbOd.DICTIONARYNAME; //异常时间段 } break; case 3: row[i] = item.ABNORMALTIME; break; //异常时长(分钟) case 4: decimal?reCategory = Convert.ToDecimal(item.REASONCATEGORY); var dicReCategory = dic.Where(s => s.DICTIONCATEGORY == "REASONCATEGORY" && s.DICTIONARYVALUE == reCategory).FirstOrDefault(); if (dicReCategory != null) { row[i] = dicReCategory.DICTIONARYNAME;; //异常原因类型 } break; case 5: row[i] = item.DETAILREASON; break; //异常原因 } } dt.Rows.Add(row); #endregion } catch (Exception ex) { SMT.Foundation.Log.Tracer.Debug("ExportEmployeeSignIn导出员工签卡信息组装DataTable时出错:" + ex.Message); return(null); } } return(dt); }
public bool ImportCityCSV(UploadFileModel uploadFile, Dictionary<string, string> empInfoDic, ref string strMsg) { string strPath = string.Empty; SaveFile(uploadFile, out strPath);//获取文件路径 string strPhysicalPath = System.Web.HttpContext.Current.Server.MapPath(strPath);//到时测试strPath为空是是否报错 using (SysDictionaryBLL bll = new SysDictionaryBLL()) { return bll.ImportCityCSV(strPhysicalPath, empInfoDic, ref strMsg); } }
public List<T_SYS_DICTIONARY> GetSysDictionarySysType() { using (SysDictionaryBLL bll = new SysDictionaryBLL()) { return bll.GetSysDictionarySysType(); } }
public List<T_SYS_DICTIONARY> GetSysDictionaryByCategory(string category) { using (SysDictionaryBLL bll = new SysDictionaryBLL()) { //GetSysLeftMenuFilterPermissionToNewFrame("85b414ab-87b3-4740-aef4-1d89f3f380cc"); IQueryable<T_SYS_DICTIONARY> dictlist = bll.GetSysDictionaryByCategory(category); return dictlist != null ? dictlist.ToList() : null; } }
public List<T_SYS_DICTIONARY> GetSysDictionaryByFilter(string filter, string sort, string[] paras) { using (SysDictionaryBLL bll = new SysDictionaryBLL()) { return bll.GetSysDictionaryByFilter(filter, sort, paras); } }
public List<T_SYS_DICTIONARY> GetAllSysDictionary() { using (SysDictionaryBLL bll = new SysDictionaryBLL()) { IQueryable<T_SYS_DICTIONARY> dictlist = bll.GetAllSysDictionary(); return dictlist != null ? dictlist.ToList() : null; } }
public string GetSystemDictioanryVersion() { using (SysDictionaryBLL bll = new SysDictionaryBLL()) { return bll.ReadVersion(); } }
public string GetSysDictionaryByCategoryAndValue(string category, string value) { using (SysDictionaryBLL bll = new SysDictionaryBLL()) { return bll.GetSysDictionaryByCategoryAndValue(category, value); } }
public List<V_Dictionary> GetDictionaryByCategoryArray(string[] categorys) { using (SysDictionaryBLL bll = new SysDictionaryBLL()) { IQueryable<V_Dictionary> Listmenus = bll.GetSysDictionaryByCategoryArray(categorys); return Listmenus != null ? Listmenus.ToList() : null; } }
public List<T_SYS_DICTIONARY> GetSysDictionaryByFatherID(string fatherID) { using (SysDictionaryBLL bll = new SysDictionaryBLL()) { IQueryable<T_SYS_DICTIONARY> dictlist = bll.GetSysDictionaryByFatherID(fatherID); return dictlist.Count() > 0 ? dictlist.ToList() : null; } }