ERP员工入职登记（五）

ERP员工入职登记（五）

在数据库中添加链接的地址：

通过iframe中的name属性指定打开页面：

cn.Target = "MainFrame";

页面的布局：

<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="WorkerAdd.aspx.cs" Inherits="BioErpWeb.HRSystem.WorkerAdd" %><%@ Register assembly="AjaxControlToolkit" namespace="AjaxControlToolkit" tagprefix="cc1" %>

员工入职登记
登录名		真实姓名
所属部门		角色
生日		手机号码
Email地址		照片
住址		性别	男 女
显示的顺序		员工状态	在职 离职

在NuGet中执行：

Install-Package AjaxControlToolkit

CSS样式表代码：

body { PADDING-RIGHT: 0px; PADDING-LEFT: 0px; BACKGROUND: #dde4ea; PADDING-BOTTOM: 0px; MARGIN: 0px; PADDING-TOP: 0px; FONT-FAMILY: Tahoma,Arial,Helvetica,Sans-Serif; font-size:12px; } .maintable{ width:800px; border:solid 1px #8fabc1; border-collapse:collapse; margin:0px auto;} .maintable td{ border:solid 1px #8fabc1;} .titlebar{ font-size:14px; font-weight:bold; line-height:30px; background-color:#8fabc1; text-align:center;} input{ width:150px; border:solid 1px #ccc;} input:hover{ border:solid 1px red;} .submitbutton{ width:100px;} .bottomtd{ text-align:right; padding-right:20px;}

日历控件的CSS：

.MyCalendar .ajax__calendar_container { border:1px solid #646464; background-color:#faac38; } .MyCalendar .ajax__calendar_other .ajax__calendar_day, .MyCalendar .ajax__calendar_other .ajax__calendar_year { color:#ffffff; } .MyCalendar .ajax__calendar_hover .ajax__calendar_day { color:red; background-color:#e8e8e8; } .MyCalendar .ajax__calendar_active .ajax__calendar_day { color:blue; font-weight:bolder; background-color:#e8e8e8; }

样式：

绑定部门的存储过程：

-- =============================================-- Author: 孙丽媛-- Create date: 2016/10/07-- Description: 查询部门信息-- =============================================ALTER PROCEDURE [dbo].[getDepartMent] ASBEGIN SELECT * FROM Department ORDER BY Displayorder ascEND

绑定角色存储过程：

-- =============================================-- Author: 孙丽媛-- Create date: 2016年10月07日-- Description: 获取员工所有角色信息-- =============================================ALTER PROCEDURE [dbo].[getUserRoseList]ASBEGIN SELECT RoseID, RoseName FROM tbRoseEND

公用层的封装：

///

/// 查询部门信息 ///

/// public static DataTable getDepartMent() { return DataBaseHelper.SelectSQLReturnTable("getDepartMent", CommandType.StoredProcedure); } ///

/// 获取员工角色列表 ///

/// DataTable public static DataTable getUserRoseList() { return DataBaseHelper.SelectSQLReturnTable("getUserRoseList", CommandType.StoredProcedure); }

后台代码：

protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { DepartMentBand(); UserRoseList(); } } ///

/// 绑定部门信息 ///

private void DepartMentBand() { ddlDepartMent.DataSource= SqlComm.getDepartMent(); //显示的列 ddlDepartMent.DataTextField = "DepartmentName"; //隐藏的列 ddlDepartMent.DataValueField = "DepartmentId"; ddlDepartMent.DataBind(); ddlDepartMent.Items.Add(new ListItem("--请选择部门--", "0")); ddlDepartMent.SelectedValue = "0"; } ///

/// 员工角色列表 ///

private void UserRoseList() { ddlRose.DataSource= SqlComm.getUserRoseList(); ddlRose.DataTextField = "RoseName"; ddlRose.DataValueField = "RoseID"; ddlRose.DataBind(); ddlRose.Items.Add(new ListItem("--请选择角色--", "0")); ddlRose.SelectedValue = "0"; }

员工添加的存储过程：

ALTER PROCEDURE [dbo].[UserManager_ADD]@LoginName nvarchar(50),@UserName nvarchar(50),@Password nvarchar(50),@DepartmentId int,@RoleId int,@Birthday datetime,@Mobile nvarchar(50),@Email nvarchar(50),@Photo nvarchar(20),@Address nvarchar(50),@LastLoginDate datetime,@Sex bit,@DisplayOrder int,@Sate bit AS INSERT INTO [UserManager]( [LoginName],[UserName],[Password],[DepartmentId],[RoleId],[Birthday],[Mobile],[Email],[Photo],[Address],[LastLoginDate],[Sex],[DisplayOrder],[Sate] )VALUES( @LoginName,@UserName,@Password,@DepartmentId,@RoleId,@Birthday,@Mobile,@Email,@Photo,@Address,@LastLoginDate,@Sex,@DisplayOrder,@Sate )

修改的存储过程：

ALTER PROCEDURE [dbo].[UserManager_Update]@UserId int,@LoginName nvarchar(50),@UserName nvarchar(50),@Password nvarchar(50),@DepartmentId int,@RoleId int,@Birthday datetime,@Mobile nvarchar(50),@Email nvarchar(50),@Photo nvarchar(20),@Address nvarchar(50),@LastLoginDate datetime,@Sex bit,@DisplayOrder int,@Sate bit AS UPDATE [UserManager] SET [LoginName] = @LoginName,[UserName] = @UserName,[Password] = @Password,[DepartmentId] = @DepartmentId,[RoleId] = @RoleId,[Birthday] = @Birthday,[Mobile] = @Mobile,[Email] = @Email,[Photo] = @Photo,[Address] = @Address,[LastLoginDate] = @LastLoginDate,[Sex] = @Sex,[DisplayOrder] = @DisplayOrder,[Sate] = @Sate WHERE UserId=@UserId

业务逻辑层：

public class UserManagerBLL { ///

/// 添加员工信息 ///

/// user public int UserMangerAdd(UserManager user) { SqlParameter[] pars = new SqlParameter[]{ new SqlParameter("@LoginName",user.LoginName), new SqlParameter("@UserName",user.UserName), new SqlParameter("@Password",user.Password), new SqlParameter("@DepartmentId",user.DepartmentId), new SqlParameter("@RoleId",user.RoleId), new SqlParameter("@Birthday",user.Birthday), new SqlParameter("@Mobile",user.Mobile), new SqlParameter("@Email",user.Email), new SqlParameter("@Photo",user.Photo), new SqlParameter("@Address",user.Address), new SqlParameter("@LastLoginDate",user.LastLoginDate), new SqlParameter("@Sex",user.Sex), new SqlParameter("@DisplayOrder",user.DisplayOrder), new SqlParameter("@Sate",user.Sate) }; return DataBaseHelper.ExcuteSqlReturnInt("UserManager_ADD", CommandType.StoredProcedure, pars); } ///

/// 员工修改 ///

/// 员工对象 /// int public int UserManagerUpdate(UserManager user) { SqlParameter[] pars = new SqlParameter[]{ new SqlParameter("@UserId",user.UserId), new SqlParameter("@LoginName",user.LoginName), new SqlParameter("@UserName",user.UserName), new SqlParameter("@Password",user.Password), new SqlParameter("@DepartmentId",user.DepartmentId), new SqlParameter("@RoleId",user.RoleId), new SqlParameter("@Birthday",user.Birthday), new SqlParameter("@Mobile",user.Mobile), new SqlParameter("@Email",user.Email), new SqlParameter("@Photo",user.Photo), new SqlParameter("@Address",user.Address), new SqlParameter("@LastLoginDate",user.LastLoginDate), new SqlParameter("@Sex",user.Sex), new SqlParameter("@DisplayOrder",user.DisplayOrder), new SqlParameter("@Sate",user.Sate) }; return DataBaseHelper.ExcuteSqlReturnInt("UserManager_Update", CommandType.StoredProcedure, pars); }

后台代码：

protected void btnSubmit_Click(object sender, EventArgs e) { UserManager user = new UserManager(); user.LoginName = this.txtLoginName.Text; user.UserName = this.txtUserName.Text; if (ddlDepartMent.SelectedValue == "0") { //Response.Write(""); ScriptManager.RegisterStartupScript(this, this.GetType(), "test", "alert('请选择部门');", true); return; } else { user.DepartmentId = int.Parse(ddlDepartMent.SelectedValue.ToString()); } if (ddlRose.SelectedValue == "0") { ScriptManager.RegisterStartupScript(this, this.GetType(), "test", "alert('请选择角色');", true); return; } else { user.RoleId =int.Parse(ddlRose.SelectedValue.ToString()); } user.Mobile = this.txtMobile.Text; user.Birthday = Convert.ToDateTime(this.txtBirthday.Text); user.Email = this.txtEmail.Text; user.Address = this.txtAddress.Text; //0：男，1,女 user.Sex = this.ddlSex.SelectedValue == "0" ? true : false; user.DisplayOrder = Convert.ToInt32(this.txtDisplayOrder.Text); //0：离职，1：在职 user.Sate = this.ddlState.SelectedValue == "0" ? false : true; user.Password =Comm.MD5("123456"); user.Photo = ImgName; user.LastLoginDate =Convert.ToDateTime(DateTime.Now.ToString("yyyy-MM-dd")); UserManagerBLL userbll = new UserManagerBLL(); int count=userbll.UserMangerAdd(user); if (count ==0) { ScriptManager.RegisterStartupScript(this, this.GetType(), "test", "alert('数据提交失败');", true); return; } }

图像上传：（先新建一个文件夹）

思路：

//图片上传（第一种方法） protected void btnPhoto_Click(object sender, EventArgs e) { //获取名字 string filename= this.fp_photo.FileName; //取出文件得后缀名 string filetype = filename.Substring(filename.LastIndexOf(".")+1); //给出提示 if (filetype.ToLower() != "jpg" && filetype.ToLower() != "bmp" && filetype.ToLower() != "gif" && filetype.ToLower() != "png") { ScriptManager.RegisterStartupScript(this, this.GetType(), "test", "alert('请选择有效的图片格式(*.jpg/*.bmp/*.gif/*.png)');", true); return; } //找到保存图片的物理路径 string filepath= Server.MapPath(@"\Files\Usersphoto\") + filename; //另存为上述的路径 this.fp_photo.SaveAs(filepath); //从文件夹中取出图片进行显示 this.Userimg.ImageUrl = @"\Files\Usersphoto\" + filename; }

效果：

上传文件调用公用的方法：

static string ImgName = ""; //图片上传 protected void btnPhoto_Click(object sender, EventArgs e) { string filename= this.fp_photo.FileName; if (!Comm.isImg(filename)) { ScriptManager.RegisterStartupScript(this, this.GetType(), "test", "alert('请选择有效的图片格式(*.jpg/*.bmp/*.gif/*.png)');", true); return; } string filepath = Server.MapPath(@"\Files\Usersphoto\"); //上传指定路径的文件 ImgName= Comm.FileUpLoad(this.fp_photo, filepath); if (ImgName == "false") { ScriptManager.RegisterStartupScript(this, this.GetType(), "test", "alert('上传失败')", true); return; } this.Userimg.ImageUrl = @"\Files\Usersphoto\" + ImgName; }

封装成通用得方法：

引用命名空间：using System.Web.UI.WebControls;

public class Comm { ///

/// 上传文件，文件名要求唯一，上传成功显示文件名，如123.jpg,否则返回 false; ///

/// 上传组件 /// 指定的路径 ，总是以“/”结尾 /// string public static string FileUpLoad(FileUpload fload, string path) { //判断指定路径是否存在此目录，如果没有则创建 if (!System.IO.Directory.Exists(path)) { System.IO.Directory.CreateDirectory(path); } int count=0; //获取文件名称 string fileName = fload.FileName; //获取新的文件名称 string NewFileName = DateTime.Now.ToString("yyyyMMddHHmmss") + fileName; //上传文件之前判断指定路径是否已经存在此文件，如果存在，则删除 if (System.IO.File.Exists(path + NewFileName)) { System.IO.File.Delete(path + NewFileName); } try { fload.SaveAs(path + NewFileName); } catch (Exception ex) { count++; } if (count > 0) { return "false"; } else { return NewFileName; } } ///

/// 通用的删除文件功能 ///

/// public static bool FileDelete(string path) { if (System.IO.File.Exists(path)) { System.IO.File.Delete(path); return true; } return false; } ///

/// 判断指定路径是否存在文件 ///

/// 路径 /// bool public static bool FileExists(string path) { if (System.IO.File.Exists(path)) { return true; } return false; } ///

/// 对指定字符串加密 ///

/// 字符串 /// string public static string MD5(string pwd) { return System.Web.Security.FormsAuthentication.HashPasswordForStoringInConfigFile(pwd, "md5"); } ///

/// 是否是有效的图片格式 ，如jpg,bmp,gif,png ///

/// 文件名带后缀名 /// string public static bool isImg(string FileName) { string filetype = FileName.Substring(FileName.LastIndexOf(".") + 1); if (filetype.ToLower() != "jpg" && filetype.ToLower() != "bmp" && filetype.ToLower() != "gif" && filetype.ToLower() != "png") { return false; } return true; } public static bool isIge(string FileName) { string filetype = FileName.Substring(FileName.LastIndexOf(".") + 1); if (filetype.ToLower() != "jpg" && filetype.ToLower() != "bmp" && filetype.ToLower() != "gif" && filetype.ToLower() != "png") { return false; } return true; } }

版权声明：本文内容由网络用户投稿，版权归原作者所有，本站不拥有其著作权，亦不承担相应法律责任。如果您发现本站中有涉嫌抄袭或描述失实的内容，请联系我们jiasou666@gmail.com 处理，核实后本网站将在24小时内删除侵权内容。