//数据持久化 internal static void SaveToDb(FileEmployeeInfo pFileEmployeeInfo, FileEmployee pFileEmployee, bool pIsNew) { pFileEmployee.FileEmployeeId = pFileEmployeeInfo.fileEmployeeId; pFileEmployee.FileId = pFileEmployeeInfo.fileId; pFileEmployee.EmployeeId = pFileEmployeeInfo.employeeId; pFileEmployee.IsMsg = pFileEmployeeInfo.isMsg; pFileEmployee.IsDelete = pFileEmployeeInfo.isDelete; pFileEmployee.IsNew = pIsNew; string UserName = SubsonicHelper.GetUserName(); try { pFileEmployee.Save(UserName); } catch (Exception ex) { LogManager.getInstance().getLogger(typeof(FileEmployeeInfo)).Error(ex); if (ex.Message.Contains("插入重复键")) //违反了唯一键 { throw new AppException("此对象已经存在"); //此处等待优化可以从唯一约束中直接取出提示来,如果没有的话,默认为原始的出错提示 } throw new AppException("保存失败"); } pFileEmployeeInfo.fileEmployeeId = pFileEmployee.FileEmployeeId; //如果缓存存在,更新缓存 if (CachedEntityCommander.IsTypeRegistered(typeof(FileEmployeeInfo))) { ResetCache(); } }
/// <summary> /// 获得分页列表,无论是否是缓存实体都从数据库直接拿取数据 /// </summary> /// <param name="pPageIndex">页数</param> /// <param name="pPageSize">每页列表</param> /// <param name="pOrderBy">排序</param> /// <param name="pSortExpression">排序字段</param> /// <param name="pRecordCount">列表行数</param> /// <returns>数据分页</returns> public static List <FileEmployeeInfo> GetPagedList(int pPageIndex, int pPageSize, SortDirection pOrderBy, string pSortExpression, out int pRecordCount) { if (pPageIndex <= 1) { pPageIndex = 1; } List <FileEmployeeInfo> list = new List <FileEmployeeInfo>(); Query q = FileEmployee.CreateQuery(); q.PageIndex = pPageIndex; q.PageSize = pPageSize; q.ORDER_BY(pSortExpression, pOrderBy.ToString()); FileEmployeeCollection collection = new FileEmployeeCollection(); collection.LoadAndCloseReader(q.ExecuteReader()); foreach (FileEmployee fileEmployee in collection) { FileEmployeeInfo fileEmployeeInfo = new FileEmployeeInfo(); LoadFromDAL(fileEmployeeInfo, fileEmployee); list.Add(fileEmployeeInfo); } pRecordCount = q.GetRecordCount(); return(list); }
/// <summary> /// 获得数据列表 /// </summary> /// <returns></returns> public static List <FileEmployeeInfo> GetList() { string cacheKey = GetCacheKey(); //本实体已经注册成缓存实体,并且缓存存在的时候,直接从缓存取 if (CachedEntityCommander.IsTypeRegistered(typeof(FileEmployeeInfo)) && CachedEntityCommander.GetCache(cacheKey) != null) { return(CachedEntityCommander.GetCache(cacheKey) as List <FileEmployeeInfo>); } else { List <FileEmployeeInfo> list = new List <FileEmployeeInfo>(); FileEmployeeCollection collection = new FileEmployeeCollection(); Query qry = new Query(FileEmployee.Schema); collection.LoadAndCloseReader(qry.ExecuteReader()); foreach (FileEmployee fileEmployee in collection) { FileEmployeeInfo fileEmployeeInfo = new FileEmployeeInfo(); LoadFromDAL(fileEmployeeInfo, fileEmployee); list.Add(fileEmployeeInfo); } //生成缓存 if (CachedEntityCommander.IsTypeRegistered(typeof(FileEmployeeInfo))) { CachedEntityCommander.SetCache(cacheKey, list); } return(list); } }
/// <summary> /// 复制一个对象,采用硬编码的方式,避免反射的低效 /// </summary> /// <param name="pIndustryTypeInfoFrom"></param> /// <param name="pIndustryTypeInfoTo"></param> public static void Copy(FileEmployeeInfo pFileEmployeeInfoFrom, FileEmployeeInfo pFileEmployeeInfoTo) { pFileEmployeeInfoTo.FileEmployeeId = pFileEmployeeInfoFrom.fileEmployeeId; pFileEmployeeInfoTo.FileId = pFileEmployeeInfoFrom.fileId; pFileEmployeeInfoTo.EmployeeId = pFileEmployeeInfoFrom.employeeId; pFileEmployeeInfoTo.IsMsg = pFileEmployeeInfoFrom.isMsg; pFileEmployeeInfoTo.IsDelete = pFileEmployeeInfoFrom.isDelete; pFileEmployeeInfoTo.Loaded = pFileEmployeeInfoFrom.Loaded; }
/// <summary> /// 批量装载 /// </summary> internal static void LoadFromDALPatch(List <FileEmployeeInfo> pList, FileEmployeeCollection pCollection) { foreach (FileEmployee fileEmployee in pCollection) { FileEmployeeInfo fileEmployeeInfo = new FileEmployeeInfo(); LoadFromDAL(fileEmployeeInfo, fileEmployee); pList.Add(fileEmployeeInfo); } }
//从后台获取数据 internal static void LoadFromDAL(FileEmployeeInfo pFileEmployeeInfo, FileEmployee pFileEmployee) { pFileEmployeeInfo.fileEmployeeId = pFileEmployee.FileEmployeeId; pFileEmployeeInfo.fileId = pFileEmployee.FileId; pFileEmployeeInfo.employeeId = pFileEmployee.EmployeeId; pFileEmployeeInfo.isMsg = pFileEmployee.IsMsg; pFileEmployeeInfo.isDelete = pFileEmployee.IsDelete; pFileEmployeeInfo.Loaded = true; }
public FileEmployeeInfo GetFileEmployeeInfoById(int FileEmployeeId) { FileEmployeeInfo fileEmployeeInfo = null;// try { fileEmployeeInfo = new FileEmployeeInfo(FileEmployeeId); } catch (AppException) { return null; } return fileEmployeeInfo; }
public FileEmployeeInfo GetFileEmployeeInfoById(int FileEmployeeId) { FileEmployeeInfo fileEmployeeInfo = null; // try { fileEmployeeInfo = new FileEmployeeInfo(FileEmployeeId); } catch (AppException) { return(null); } return(fileEmployeeInfo); }
private void LoadFromId(int fileEmployeeId) { if (CachedEntityCommander.IsTypeRegistered(typeof(FileEmployeeInfo))) { FileEmployeeInfo fileEmployeeInfo = Find(GetList(), fileEmployeeId); if (fileEmployeeInfo == null) { throw new AppException("未能在缓存中找到相应的键值对象"); } Copy(fileEmployeeInfo, this); } else { FileEmployee fileEmployee = new FileEmployee(fileEmployeeId); if (fileEmployee.IsNew) { throw new AppException("尚未初始化"); } LoadFromDAL(this, fileEmployee); } }
//从后台获取数据 internal static void LoadFromDAL(FileEmployeeInfo pFileEmployeeInfo, FileEmployee pFileEmployee) { pFileEmployeeInfo.fileEmployeeId = pFileEmployee.FileEmployeeId; pFileEmployeeInfo.fileId = pFileEmployee.FileId; pFileEmployeeInfo.employeeId = pFileEmployee.EmployeeId; pFileEmployeeInfo.isMsg = pFileEmployee.IsMsg; pFileEmployeeInfo.isDelete = pFileEmployee.IsDelete; pFileEmployeeInfo.Loaded=true; }
protected void btnSendFile_Click(object sender, EventArgs e) { if (IsPageValid()) { try { int emid = Convert.ToInt32(Session["EmployeeId"]); EmployeeInfo em = (EmployeeInfo)Session["Employee"]; //��ȡ�ļ��� string name = this.UpFile.FileName; DateTime sendtime = DateTime.Now; if (!CanYou.OA.BLL.FileInfo.IsDocumentSame(name)) { CanYou.OA.BLL.FileInfo file = new CanYou.OA.BLL.FileInfo(); file.FileName = name; file.FileTypeId = Convert.ToInt32(ddlFileType.SelectedValue.ToString()); file.SendEmployeeId = emid; file.Memo = txtMemo.Text.ToString(); file.SendTime = sendtime; file.IsCommon = 1; file.FilePermissionId=Convert.ToInt32(ddlFilePermit.SelectedValue); file.Save(); if (ddlFilePermit.SelectedItem.Text.ToString() == "����") { DataTable EmTb = MessageInfo.getEmployeeId(emid); string[] strto = new String[EmTb.Rows.Count]; for (int i = 0; i < EmTb.Rows.Count; i++) { MessageInfo.Msgs1(Convert.ToInt32(EmTb.Rows[i]["EmployeeId"]), file.FileId, "~/ShareManage/DownloadDocument.aspx", "���й����ĵ�:"+name, em.EmployeeName,"daiyue",name); EmployeeInfo ems = new EmployeeInfo(Convert.ToInt32(EmTb.Rows[i]["EmployeeId"])); strto[i] = ems.Qq.ToString(); } //MessageInfo.SendMailS(strto, "OA�µ���Ϣ", "���й����ĵ�:"+name); DataTable dt=MessageInfo.getEmployeeId1(); for (int j = 0; j < dt.Rows.Count; j++) { FileEmployeeInfo fileem = new FileEmployeeInfo(); fileem.FileId = file.FileId; fileem.EmployeeId = Convert.ToInt32(dt.Rows[j]["EmployeeId"]); fileem.IsMsg = 0; fileem.IsDelete = 0; fileem.Save(); } } else { DataTable EmTb = MessageInfo.getEmployeeIdOf(emid, ddlFilePermit.SelectedItem.Text.ToString()); string[] strto = new String[EmTb.Rows.Count]; for (int i = 0; i < EmTb.Rows.Count; i++) { MessageInfo.Msgs1(Convert.ToInt32(EmTb.Rows[i]["EmployeeId"]), file.FileId, "~/ShareManage/DownloadDocument.aspx", "���й����ĵ�:" + name, em.EmployeeName, "daiyue", name); EmployeeInfo ems = new EmployeeInfo(Convert.ToInt32(EmTb.Rows[i]["EmployeeId"])); strto[i] = ems.Qq.ToString(); } MessageInfo.SendMailS(strto, "OA�µ���Ϣ", "���й����ĵ�:"+name); DataTable dt = MessageInfo.getEmployeeIdOf1(ddlFilePermit.SelectedItem.Text.ToString()); { for (int j = 0; j < dt.Rows.Count; j++) { FileEmployeeInfo fileem = new FileEmployeeInfo(); fileem.FileId = file.FileId; fileem.EmployeeId = Convert.ToInt32(dt.Rows[j]["EmployeeId"]); fileem.IsMsg = 0; fileem.IsDelete = 0; fileem.Save(); } } } //�ļ��ϴ���ַ��Ŀ¼������ͨ��IIS���豾������ΪFTP������ //string FileSaveUri = @"ftp://192.168.11.70/www/Files/Documents/"; ////FTP�û������룬���DZ������û������� //string ftpUser = "******"; //string ftpPassWord = "******"; //SendFiles(FileSaveUri, ftpUser, ftpPassWord); this.UpFile.PostedFile.SaveAs(Server.MapPath("~/Files/Documents/" + UpFile.FileName)); Page.ClientScript.RegisterStartupScript(this.GetType(), "", "<script language='javascript'>alert('�ϴ��ɹ���');</script>"); } else { Page.ClientScript.RegisterStartupScript(this.GetType(), "", "<script language='javascript'>alert('���ĵ����Ѵ��ڣ�����������');</script>"); } } catch (Exception ex) { ClientScript.RegisterStartupScript(this.GetType(), "Save", "alert('�ϴ�ʧ�ܣ�" + ex.Message + "');", true); } } }
public object SaveFileEmployeeInfo(FileEmployeeInfo fileEmployeeInfo) { fileEmployeeInfo.Save(); return fileEmployeeInfo . FileEmployeeId; }
/// <summary> /// 获得数据列表 /// </summary> /// <returns></returns> public static List<FileEmployeeInfo> GetList() { string cacheKey = GetCacheKey(); //本实体已经注册成缓存实体,并且缓存存在的时候,直接从缓存取 if (CachedEntityCommander.IsTypeRegistered(typeof(FileEmployeeInfo)) && CachedEntityCommander.GetCache(cacheKey) != null) { return CachedEntityCommander.GetCache(cacheKey) as List< FileEmployeeInfo>; } else { List< FileEmployeeInfo> list =new List< FileEmployeeInfo>(); FileEmployeeCollection collection=new FileEmployeeCollection(); Query qry = new Query(FileEmployee.Schema); collection.LoadAndCloseReader(qry.ExecuteReader()); foreach(FileEmployee fileEmployee in collection) { FileEmployeeInfo fileEmployeeInfo= new FileEmployeeInfo(); LoadFromDAL(fileEmployeeInfo,fileEmployee); list.Add(fileEmployeeInfo); } //生成缓存 if (CachedEntityCommander.IsTypeRegistered(typeof(FileEmployeeInfo))) { CachedEntityCommander.SetCache(cacheKey, list); } return list; } }
/// <summary> /// 复制一个对象,采用硬编码的方式,避免反射的低效 /// </summary> /// <param name="pIndustryTypeInfoFrom"></param> /// <param name="pIndustryTypeInfoTo"></param> public static void Copy(FileEmployeeInfo pFileEmployeeInfoFrom, FileEmployeeInfo pFileEmployeeInfoTo) { pFileEmployeeInfoTo.FileEmployeeId = pFileEmployeeInfoFrom.fileEmployeeId; pFileEmployeeInfoTo.FileId = pFileEmployeeInfoFrom.fileId; pFileEmployeeInfoTo.EmployeeId = pFileEmployeeInfoFrom.employeeId; pFileEmployeeInfoTo.IsMsg = pFileEmployeeInfoFrom.isMsg; pFileEmployeeInfoTo.IsDelete = pFileEmployeeInfoFrom.isDelete; pFileEmployeeInfoTo.Loaded=pFileEmployeeInfoFrom.Loaded; }
/// <summary> /// 获得分页列表,无论是否是缓存实体都从数据库直接拿取数据 /// </summary> /// <param name="pPageIndex">页数</param> /// <param name="pPageSize">每页列表</param> /// <param name="pOrderBy">排序</param> /// <param name="pSortExpression">排序字段</param> /// <param name="pRecordCount">列表行数</param> /// <returns>数据分页</returns> public static List<FileEmployeeInfo> GetPagedList(int pPageIndex,int pPageSize,SortDirection pOrderBy,string pSortExpression,out int pRecordCount) { if(pPageIndex<=1) pPageIndex=1; List< FileEmployeeInfo> list = new List< FileEmployeeInfo>(); Query q = FileEmployee .CreateQuery(); q.PageIndex = pPageIndex; q.PageSize = pPageSize; q.ORDER_BY(pSortExpression,pOrderBy.ToString()); FileEmployeeCollection collection=new FileEmployeeCollection(); collection.LoadAndCloseReader(q.ExecuteReader()); foreach (FileEmployee fileEmployee in collection) { FileEmployeeInfo fileEmployeeInfo = new FileEmployeeInfo(); LoadFromDAL(fileEmployeeInfo, fileEmployee); list.Add(fileEmployeeInfo); } pRecordCount=q.GetRecordCount(); return list; }
public void DeleteById(FileEmployeeInfo pFileEmployeeInfo) { FileEmployeeInfo fileEmployeeInfo = new FileEmployeeInfo(pFileEmployeeInfo.FileEmployeeId); fileEmployeeInfo.Delete(); }
public List <FileEmployeeInfo> GetPagedList(int pPageIndex, int pPageSize, SortDirection pOrderBy, string pSortExpression, out int pRecordCount) { return(FileEmployeeInfo.GetPagedList(pPageIndex, pPageSize, pOrderBy, pSortExpression, out pRecordCount)); }
/// <summary> /// 复制为另一个对象 /// </summary> /// <param name="pIndustryTypeInfoTo"></param> public void CopyTo(FileEmployeeInfo pFileEmployeeInfoTo) { Copy(this, pFileEmployeeInfoTo); }
/// <summary> /// 复制为另一个对象 /// </summary> /// <param name="pIndustryTypeInfoTo"></param> public void CopyTo(FileEmployeeInfo pFileEmployeeInfoTo) { Copy(this, pFileEmployeeInfoTo); }
public void DeleteById(FileEmployeeInfo pFileEmployeeInfo) { FileEmployeeInfo fileEmployeeInfo = new FileEmployeeInfo(pFileEmployeeInfo.FileEmployeeId); fileEmployeeInfo.Delete(); }
/// <summary> /// 批量装载 /// </summary> internal static void LoadFromDALPatch(List< FileEmployeeInfo> pList, FileEmployeeCollection pCollection) { foreach (FileEmployee fileEmployee in pCollection) { FileEmployeeInfo fileEmployeeInfo = new FileEmployeeInfo(); LoadFromDAL(fileEmployeeInfo, fileEmployee ); pList.Add(fileEmployeeInfo); } }
public List <FileEmployeeInfo> GetFileEmployeeInfoList() { return(FileEmployeeInfo.GetList()); }
//数据持久化 internal static void SaveToDb(FileEmployeeInfo pFileEmployeeInfo, FileEmployee pFileEmployee,bool pIsNew) { pFileEmployee.FileEmployeeId = pFileEmployeeInfo.fileEmployeeId; pFileEmployee.FileId = pFileEmployeeInfo.fileId; pFileEmployee.EmployeeId = pFileEmployeeInfo.employeeId; pFileEmployee.IsMsg = pFileEmployeeInfo.isMsg; pFileEmployee.IsDelete = pFileEmployeeInfo.isDelete; pFileEmployee.IsNew=pIsNew; string UserName = SubsonicHelper.GetUserName(); try { pFileEmployee.Save(UserName); } catch(Exception ex) { LogManager.getInstance().getLogger(typeof(FileEmployeeInfo)).Error(ex); if(ex.Message.Contains("插入重复键"))//违反了唯一键 { throw new AppException("此对象已经存在");//此处等待优化可以从唯一约束中直接取出提示来,如果没有的话,默认为原始的出错提示 } throw new AppException("保存失败"); } pFileEmployeeInfo.fileEmployeeId = pFileEmployee.FileEmployeeId; //如果缓存存在,更新缓存 if (CachedEntityCommander.IsTypeRegistered(typeof(FileEmployeeInfo))) { ResetCache(); } }
public object SaveFileEmployeeInfo(FileEmployeeInfo fileEmployeeInfo) { fileEmployeeInfo.Save(); return(fileEmployeeInfo.FileEmployeeId); }
protected void FileEmployee() { int Emid = Convert.ToInt32(ddlEmployee.SelectedValue.ToString()); DataTable dt=FileInfo.UserFileEmployee(ddlDepart.SelectedValue.ToString()); for (int i = 0; i < dt.Rows.Count; i++) { FileEmployeeInfo FileEm = new FileEmployeeInfo(); FileEm.EmployeeId = Emid; FileEm.FileId = Convert.ToInt32(dt.Rows[i]["FileId"].ToString()); FileEm.IsDelete = 0; FileEm.IsMsg = 0; FileEm.Save(); } }