private void pageinit() { WX.HR.LeaveJob.MODEL LeaveJob = null; string userId = WX.Request.rUserId; WX.Data.Dict.BindListCtrl_DeptList(this.ui_demp, null, null, null); LeaveJob = WX.HR.LeaveJob.GetModel("select top 1 * from HR_LeaveJobs where UserID='" + userId + "' order by Addtime desc"); if (LeaveJob != null) { ui_reason.Text = LeaveJob.reason.ToString(); ui_days.Text = LeaveJob.days.ToString(); ui_lasttime.Text = Convert.ToDateTime(LeaveJob.lasttime.ToString()).ToString("yyyy-MM-dd"); ui_dempop.Text = LeaveJob.dempOpinion.ToString(); ui_dempuser.Value = LeaveJob.dempManager.ToString(); li_dempname.Text = WX.CommonUtils.GetRealNameListByUserIdList(LeaveJob.dempManager.ToString()); ui_adminop.Text = LeaveJob.financialOpinion.ToString(); ui_financialHandleManager.Value = LeaveJob.financialHandleManager.ToString(); li_financialHandleManagername.Text = WX.CommonUtils.GetRealNameListByUserIdList(LeaveJob.financialHandleManager.ToString()); ui_adminuser.Value = LeaveJob.financialManager.ToString(); li_adminname.Text = WX.CommonUtils.GetRealNameListByUserIdList(LeaveJob.financialManager.ToString()); ui_hrop.Text = LeaveJob.hrOpinion.ToString(); ui_hruser.Value = LeaveJob.hrManager.ToString(); li_hrname.Text = WX.CommonUtils.GetRealNameListByUserIdList(LeaveJob.hrManager.ToString()); ui_bossop.Text = LeaveJob.bossOpinion.ToString(); ui_bossuser.Value = LeaveJob.bossManager.ToString(); li_bossname.Text = WX.CommonUtils.GetRealNameListByUserIdList(LeaveJob.bossManager.ToString()); li_addtime.Text = ((DateTime)LeaveJob.Addtime.value).ToString("yyyy-MM-dd"); } else { li_addtime.Text = DateTime.Now.ToString("yyyy-MM-dd"); } Employee.MODEL employee = WX.Request.rEmpolyee; WX.Model.User.MODEL usermodel = WX.Request.rUser; MenuBar1.Param2 = employee.LoadSucceed || true?usermodel.State.ToString() : "0"; if (employee.LoadSucceed || true) { li_name.Text = usermodel.RealName.ToString(); li_sex.Text = ((bool)employee.Sex.value ? "男" : "女"); li_age.Text = ((DateTime)employee.Birthday.value).ToString("yyyy-MM-dd"); li_edu.Text = employee.Edu.ToString(); li_Mobile.Text = employee.Mobile.ToString(); ui_demp.SelectedValue = usermodel.DepartmentID.ToString(); bindjob(); ui_duty.SelectedValue = usermodel.DutyId.ToString(); WX.HR.IntoJob.MODEL intojob = WX.HR.IntoJob.GetModel("select * from HR_Intojobs where UserID='" + userId + "'"); if (intojob == null) { Response.Redirect("HR_AddIntojobs.aspx?UserID=" + WX.Request.rUserId); } li_intotime.Text = ((DateTime)intojob.Addtime.value).ToString("yyyy-MM-dd"); li_sqrname.Text = usermodel.RealName.ToString(); if (usermodel.State.ToString() == "40" && LeaveJob != null) { Button1.Enabled = false; } } }
protected void btnSubmit_Click(object sender, EventArgs e) { //2.取得用户变量 string content = this.ui_content.Value; //3.验证用户变量,包含Request.QueryString及Request.Form //4.业务处理过程 string userId = WX.Request.rUserId; Employee.MODEL employee = Employee.GetModelToID(userId); //Employee.GetModel("SELECT * FROM TU_Employees WHERE UserID='" + userId + "'"); //Employee.MODEL employee = Employee.GetModel("SELECT * FROM TU_Employees WHERE UserID='" + Request.QueryString["UserID"] + "'"); employee.Family.value = content; int iR = employee.Update(); //5.(用户及业务对象)统计与状态 if (iR > 0) { //if (employee.UserID.ToString() == WX.Main.CurUser.UserID.ToString()) //{ // WX.Main.CurUser.LoadEmployeeUser(true); //} } //6.登记日志 if (iR > 0) { WX.Model.User.MODEL usermodel = WX.Model.User.GetCache(userId); WX.Model.Company.AddLogs(Convert.ToInt32(usermodel.CompanyID.ToString()), 6, usermodel.RealName.ToString() + "的档案修改了家庭成员!" + "[" + ui_logcontent.Text + "]", WX.Main.CurUser.UserID, ui_logmanage.Value, Request.UserHostAddress); //7.返回处理结果或返回其它页面。 ULCode.Debug.Alert(this, "家庭成员信息修改成功!", "User_UrgentLink.aspx?UserID=" + employee.UserID.ToString() + "&companyid=" + usermodel.CompanyID.ToString()); } }
public void bindjob() { DataTable dt; WX.HR.IntoJob.MODEL intojob = WX.HR.IntoJob.GetModel("select * from HR_Intojobs where UserID='" + WX.Request.rUserId + "'"); if (intojob != null) { dt = WX.Model.DutyDetail.GetTableDepartent(ddlDepartment.SelectedValue); } else { WX.Model.User.MODEL user = WX.Request.rUser; dt = WX.Model.DutyDetail.GetTablenullDepartent(this.ddlDepartment.SelectedValue, user.RealName.ToString()); } this.ui_jobname.DataSource = dt; this.ui_jobname.DataTextField = "Name"; this.ui_jobname.DataValueField = "ID"; this.ui_jobname.DataBind(); if (this.ui_jobname.Items.Count == 0) { Button1.Enabled = false; } else { Button1.Enabled = true; } }
protected void Page_Load(object sender, EventArgs e) { if (Request["PlanId"] != null && Request["PlanId"] != "") { WX.Model.Plan.MODEL planmodel = WX.Request.rPlan; planmodel.PlanState.value = 1; planmodel.Update(); } userid = WX.Main.CurUser.UserID; WX.Main.CurUser.LoadDutyDetailUser(); if (WX.Main.CurUser.DutyDetailUser.GradeID.ToInt32() >= 30)//领导管理层 { rtype = "3"; deptuserid = WX.Main.CurUser.UserID; } else { string sSql = "select ID from TE_DutyDetail where DepartentID=" + WX.Model.User.GetCache(userid).DepartmentID.ToString() + " and DutyCatagoryID=1 and GradeID<30"; WX.Model.DutyDetail.MODEL dd = WX.Model.DutyDetail.GetModel(sSql); if (dd != null) { WX.Model.User.MODEL user = WX.Model.User.GetModel("select * from TU_Users where DutyId=" + dd.ID.ToString()); if (user != null) { deptuserid = user.UserID.ToString(); } } } }
private void LoadData() { String userID = WX.Request.rUserId; WX.Model.User.MODEL user = WX.Model.User.GetCache(userID); cbArchiveBySelf.Checked = user.ArchiveBySelf.ToBoolean(); }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { t3.Visible = !WX.Main.Priv_IsTemp; t1.Visible = WX.Main.Priv_IsTemp; if (t1.Visible) { //Employee.MODEL employee = Employee.GetModel("SELECT * FROM TU_Employees WHERE UserID='" + userId + "'"); WX.Main.CurUser.LoadEmployeeUser(); WX.Main.CurUser.LoadUserModel(false); Employee.MODEL employee = WX.Main.CurUser.EmployeeUser; //Employee.GetModel("SELECT * FROM TU_Employees WHERE UserID='" + userId + "'"); WX.Model.User.MODEL usermodel = WX.Main.CurUser.UserModel; Text_Template.MODEL ttM = Text_Template.NewDataModel(2); if (!ttM.Apply.ToBoolean()) { this.t1.Visible = true; this.t2.Visible = false; this.trSubmit.Visible = usermodel.ArchiveBySelf.ToBoolean(); this.ui_content.Value = employee.Education.isEmpty ? ttM.Template.ToString() : employee.Education.ToString(); } else { this.t1.Visible = false; this.t2.Visible = true; this.lblContent.Text = employee.Education.ToString(); this.ui_content1.Value = ttM.Template.ToString(); } } } }
protected void Button1_Click(object sender, EventArgs e) { //2.取得用户变量 string userId = WX.Request.rUserId; string dutydetailid = ui_jobname.SelectedValue; //3.验证用户变量,包含Request.QueryString及Request.Form //4.业务处理过程 int row = ULCode.QDA.XSql.Execute("insert into TU_User_X_DutyDetail(UserID,DutyDetailID) values('" + userId + "'," + dutydetailid + ")"); //填写主要业务逻辑代码 //5.(用户及业务对象)统计与状态 //6.登记日志 if (row > 0) { WX.Model.DutyDetail.MODEL dutydetail = WX.Model.DutyDetail.GetModel(Convert.ToInt32(dutydetailid)); WX.Model.User.MODEL usermodel = WX.Request.rUser; WX.HR.DutyLog.MODEL log = WX.HR.DutyLog.NewDataModel(); log.UserID.value = userId; log.NowDutyID.value = dutydetailid; log.NowDempID.value = ddlDepartment.SelectedValue; log.Backtableid.value = 5; log.Backcolumid.value = 0; log.Starttime.value = DateTime.Now; log.GradeID.value = dutydetail.GradeID.value; log.Content.value = "员工职务添加"; log.Insert(); dutydetail.UsersName.value = dutydetail.UsersName.ToString() + usermodel.RealName.ToString() + ","; dutydetail.Update(); ULCode.Debug.Alert("员工职务添加成功!", "HR_Userjobs.aspx?UserID=" + userId); } }
protected void RegisterUser(object sender, EventArgs e) { Employee.MODEL employee = WX.Request.rEmpolyee; employee.DepartmentID.value = ddlDepartment.SelectedValue; employee.DutyId.value = ui_jobname.SelectedValue; employee.Salary.value = ui_salary.Text; employee.Update(); WX.Model.Audition.MODEL auditionmodel = WX.Model.Audition.GetModel(employee.UserID.ToString()); if (auditionmodel == null) { auditionmodel = WX.Model.Audition.NewDataModel(); auditionmodel.UserID.value = employee.UserID.value; auditionmodel.FirstUser.value = WX.Main.CurUser.UserID; auditionmodel.FirstOpinion.value = TextBox1.Text; auditionmodel.FirstTime.value = DateTime.Now; auditionmodel.Insert(); } else { auditionmodel.FirstUser.value = WX.Main.CurUser.UserID; auditionmodel.FirstOpinion.value = TextBox1.Text; auditionmodel.FirstTime.value = DateTime.Now; auditionmodel.Update(); } WX.Model.User.MODEL usermodel = WX.Request.rUser; string SendUserID = WX.CommonUtils.GetUserIDListByWhereStr(1, "DepartmentID=" + employee.DepartmentID.ToString() + " and State in(10,20) order by Grade desc"); WX.Main.MessageSend("<a href=/Manage/HR/User_Resume.aspx?UserID=" + employee.UserID.ToString() + "&mes=1>" + usermodel.RealName.ToString() + "——面试通知</a>", "/Manage/Main/messagelist.aspx", SendUserID, WX.Main.CurUser.UserID, 7, 0); Response.Redirect("HR_NewIntojobs.aspx?All=1"); }
private void pageinit(string orderBy) { string vwnmae = Request["state"] == "5" ? "vw_EmployeesState5_HR" : "vw_Employees_HR"; string where = Request["state"] == "5" ? " State<=5" : " State=" + state; if (Request["redo"] != null) { WX.Model.User.MODEL usermodel = WX.Model.User.GetCache(Request["UserID"]); usermodel.State.value = 5; usermodel.Update(); WX.Model.Audition.MODEL auditionmodel = WX.Model.Audition.GetModel(usermodel.UserID.ToString()); auditionmodel.AuditionState.value = 0; auditionmodel.Update(); WX.Model.Employee.MODEL employee = WX.Request.rEmpolyee; WX.Main.MessageSend("<a href=/Manage/HR/User_Resume.aspx?UserID=" + employee.UserID.ToString() + "&mes=1>" + usermodel.RealName.ToString() + "——面试通知</a>", "/Manage/Main/messagelist.aspx", WX.CommonUtils.GetDeptUserID(1, "[Host]", employee.DepartmentID.ToInt32()), WX.Main.CurUser.UserID, 7, 0); } DataTable dt = ULCode.QDA.XSql.GetDataTable("select *,0 stateid FROM " + vwnmae + " WHERE " + where + orderBy); if (state == "0" && dt.Rows.Count <= 0) { Response.Redirect("/Manage/HR/User_AddUser.aspx"); } Gv_intojobs.DataSource = dt; Gv_intojobs.DataBind(); if (Gv_intojobs.Rows.Count > 0) { Gv_intojobs.HeaderRow.TableSection = TableRowSection.TableHeader; Gv_intojobs.HeaderStyle.Height = Unit.Pixel(40); } }
protected void Gv_intojobs_RowCommand(object sender, GridViewCommandEventArgs e) { WX.Model.User.MODEL usermodel = WX.Model.User.GetCache(e.CommandArgument); usermodel.State.value = e.CommandName == "state1" ? 6 : 2; usermodel.ArchiveBySelf.set(e.CommandName == "state1" ? 0 : 1); usermodel.Update(); WX.Model.Audition.MODEL auditionmodel = WX.Model.Audition.GetModel(usermodel.UserID.ToString()); bool flag = true; if (auditionmodel == null) { flag = false; auditionmodel = WX.Model.Audition.NewDataModel(); auditionmodel.UserID.value = usermodel.UserID.value; } auditionmodel.AuditionUser.value = WX.Main.CurUser.UserID; auditionmodel.AuditionState.value = usermodel.State.ToInt32() == 6 ? 1 : -1; auditionmodel.AuditionTime.value = DateTime.Now; if (!flag) { auditionmodel.Insert(); } else { auditionmodel.Update(); } if (auditionmodel.AuditionState.ToInt32() == 1) { WX.Main.MessageSend("<a href=/Manage/HR/HR_AddIntojobs.aspx?UserID=" + usermodel.UserID.ToString() + "&mes=1>" + usermodel.RealName.ToString() + "面试通过!请尽快办理入职——入职通知</a>", "/Manage/Main/messagelist.aspx", WX.CommonUtils.GetHRUserID, WX.Main.CurUser.UserID, 8, 0); WX.Main.MessageSend("<a href=/Manage/Private/Priv_EditUser.aspx?mes=1>恭喜面试成功!请进一步完善个人资料并办理入职——入职通知</a>", "/Manage/Main/messagelist.aspx", usermodel.UserID.ToString(), WX.Main.CurUser.UserID, 8, 0); } pageinit(); }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { if (Request["UserId"] != null) { userid = WX.Request.rUserId; } else { userid = WX.Main.CurUser.UserID; } deptid = WX.Model.User.GetCache(userid).DepartmentID.ToString(); string sSql = "select ID from TE_DutyDetail where DepartentID=" + deptid + " and DutyCatagoryID=1 and GradeID<30"; WX.Model.DutyDetail.MODEL dd = WX.Model.DutyDetail.GetModel(sSql); if (dd != null) { sSql = "select * from TU_Users where DutyId=" + dd.ID.ToString(); WX.Model.User.MODEL user = WX.Model.User.GetModel(sSql); if (user != null) { deptuserid = user.UserID.ToString(); } } } }
public string GetTitleTemp()//1部门,2名字,3部门+名字 { WX.Main.CurUser.LoadMyDepartment(); if (Request["PlanId"] != null && Request["PlanId"] != "") { WX.Model.Plan.MODEL plan = WX.Request.rPlan; if (plan != null && plan.RangeType.ToInt32() == 2) { return(WX.Main.CurUser.MyDepartMent.Name.ToString()); } if (plan != null && plan.RangeType.ToInt32() == 3) { return("公司"); } } else if (Request["rtype"] != null && Request["rtype"] != "") { if (Request["rtype"] == "2") { return(WX.CommonUtils.GetDeptNameListByDeptIdList(Request["DeptId"]).Trim());//WX.Main.CurUser.MyDepartMent.Name.ToString(); } if (Request["rtype"] == "3") { return("公司"); } } if (Request["UserID"] != "") { WX.Model.User.MODEL usermodel = WX.Model.User.NewDataModel(Request["UserID"]); return(WX.CommonUtils.GetDeptNameListByDeptIdList(usermodel.DepartmentID.ToString()).Trim() + usermodel.RealName.ToString()); } return(WX.Main.CurUser.MyDepartMent.Name.ToString() + WX.Main.CurUser.UserModel.RealName.ToString()); }
/// <summary> /// 获取上级部门信息主管/副主管/助理 /// </summary> /// <param name="DeptID">部门编号</param> /// <param name="HostName">[Host]主管,[SubHosts]副经理,[Assistants]助理</param> /// <returns></returns> public static string GetParentDeptHost(int DeptID, string HostName) { string userid = ""; WX.Model.Department.MODEL dept = WX.Model.Department.NewDataModel(DeptID); if (dept.ParentID.ToInt32() > 0) { userid = ULCode.QDA.XSql.GetValue("select " + HostName + " from TE_Departments where ID=" + dept.ParentID.ToString()).ToString(); } WX.Model.User.MODEL user = WX.Model.User.NewDataModel(userid); if (userid == "" || user == null || user.State.ToInt32() < 10 || user.State.ToInt32() >= 40) { userid = ULCode.QDA.XSql.GetValue("UserID", "select top 1 * from TU_Users where DepartmentID=" + dept.ParentID.ToString() + " and State>=10 and State<40 order by Grade desc").ToString(); user = WX.Model.User.NewDataModel(userid); if (user != null) { return(user.UserID.ToString()); } } else { return(user.UserID.ToString()); } return(""); }
private void FillDataCtrl() { string userId = Convert.ToString(Request.QueryString["id"]); //Employee.MODEL employee = Employee.NewDataModel(userId); Employee.MODEL employee = WX.Request.rEmpolyee; //Employee.GetModel("SELECT * FROM TU_Employees WHERE UserID='" + userId + "'"); WX.Model.User.MODEL usermodel = WX.Model.User.GetCache(userId); if (employee.LoadSucceed || true) { WX.Data.Dict.BindListCtrl_Companys(this.ddlCompany, null, null, usermodel.CompanyID.ToString()); for (int i = 0; i < Employee.eduarray.Length; i++) { ui_edu.Items.Add(new ListItem(Employee.eduarray[i], Employee.eduarray[i])); } ui_edu.SelectedValue = "大专"; //this.ddlCompany.SelectedItem.Value = employee.CompanyID.ToString(); this.txtRealName.Text = usermodel.RealName.ToString(); this.txtIDCard.Text = employee.IDCard.ToString(); //this.ddlPosition.SelectedItem.Value = employee.DutyId.ToString(); this.txtBirthday.Text = employee.Birthday.ToString(); this.txtMobile.Text = employee.Mobile.ToString(); if (Convert.ToBoolean(employee.Sex.ToString())) { this.rblSex.SelectedValue = "1"; } else { this.rblSex.SelectedValue = "0"; } this.txtQQNumber.Text = employee.QQ.ToString(); this.txtEmail.Text = employee.Email.ToString(); this.txtTelephone.Text = employee.Tel.ToString(); this.ui_Titles.Text = employee.Titles.ToString(); this.ui_Ethnic.Text = employee.Ethnic.ToString(); this.ui_edu.SelectedValue = employee.Edu.ToString(); this.ui_Prof.Text = employee.Prof.ToString(); this.ui_ForeignL.Text = employee.ForeignL.ToString(); this.ui_Rating.Text = employee.Rating.ToString(); this.ui_Marital.Text = employee.Marital.ToString(); this.ui_Health.Text = employee.Health.ToString(); string[] addrarry = employee.Address.ToString().Split('|'); if (addrarry.Length > 1) { this.ui_jg.Text = addrarry[1]; this.ui_hkd.Text = addrarry[2]; } this.txtAddress.Text = addrarry[0]; if (employee.UserFace.isEmpty) { this.liPreZoomImage.Text = "<img id=\"preZoomImage\" src=\"\" alt=\"\" style=\"width: 100%; height: 100%; display: none;\" />"; } else { this.liPreZoomImage.Text = "<img id=\"preZoomImage\" src=\"" + (employee.UserFace.ToString()) + "\" alt=\"\" style=\"width: 100%; height: 100%; \" />"; } this.txtSort.Text = employee.Sort.ToString(); this.txtContent.Text = employee.Introduction.ToString(); } }
protected void ModiArchiveBySelf(object sender, EventArgs e) { String userID = WX.Request.rUserId; WX.Model.User.MODEL user = WX.Model.User.GetCache(userID); user.ArchiveBySelf.set(cbArchiveBySelf.Checked); user.Update(); }
private void InitComponent() { string userId = WX.Request.rUserId; WX.Model.User.MODEL usermodel = WX.Request.rUser; Label1.Text = "当前员工姓名:" + usermodel.RealName.ToString(); WX.Data.Dict.BindListCtrl_DeptList(this.ddlDepartment, null, null, null); bindjob(); }
protected void Page_Load(object sender, EventArgs e) { if (!this.Master.A_Edit) { Response.Write("你没有权限访问此功能!"); Response.End(); return; } if (!IsPostBack) { string userId = WX.Request.rUserId; WX.Model.User.MODEL usermodel = WX.Request.rUser; ui_name.Text = usermodel.RealName.ToString(); WX.AT.Signin.MODEL signin = WX.AT.Signin.GetModel("select * from [AT_Signin] where UserID='" + userId + "' and datediff(day,Addtime,getdate())=0"); WX.AT.Status.MODEL status = WX.AT.Status.GetModel("select * from [AT_Status] where UserID='" + userId + "'"); ui_demo.Text = signin.Demo.ToString(); if (Convert.ToInt32(status.State.value) > 0 && Convert.ToInt32(status.State.value) <= 7) { switch (status.State.ToString()) { case "1": ui_state.Items.Add(new ListItem("销假", "0")); break; case "3": ui_state.Items.Add(new ListItem("销假", "0")); break; case "6": ui_state.Items.Add(new ListItem("返回", "0")); break; case "7": ui_state.Items.Add(new ListItem("返差", "0")); break; default: break; } } else { if (signin.Ontime.isEmpty) { if (DateTime.Now < WX.AT.Signin.BelateStart.AddMinutes(WX.AT.Signin.KGMinutes)) { ui_state.Items.Add(new ListItem(WX.AT.Signin.statearray[9] + "签到", "9")); } } else { if (DateTime.Now > WX.AT.Signin.OffWork.AddMinutes(-WX.AT.Signin.KGMinutes) && DateTime.Now < WX.AT.Signin.OffWork) { ui_state.Items.Add(new ListItem(WX.AT.Signin.statearray[10] + "签到", "10")); } } ui_state.Items.Add(new ListItem(WX.AT.Signin.statearray[6] + "签到", "6")); ui_state.Items.Add(new ListItem(WX.AT.Signin.statearray[7] + "签到", "7")); ui_state.Items.Add(new ListItem(WX.AT.Signin.statearray[2], "1")); ui_state.Items.Add(new ListItem(WX.AT.Signin.statearray[3], "3")); ui_state.Items.Add(new ListItem(WX.AT.Signin.statearray[8], "8")); } //ui_ctime.Text = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"); ui_stoptime.Text = DateTime.Now.AddDays(1).ToString("yyyy-MM-dd 08:30:00"); } }
public static bool IsBestDuty(int deptid, string userid) { WX.Model.User.MODEL usermodel = WX.Model.User.GetModel("select top 1 * from TU_Users where DepartmentID=" + deptid + " and State<40 order by Grade desc"); if (usermodel != null && usermodel.UserID.ToString() == userid) { return(true); } return(false); }
protected void Gv_Receive_RowCommand(object sender, GridViewCommandEventArgs e) { string[] arr = e.CommandArgument.ToString().Split('|'); WX.HR.Receive.MODEL receive = WX.HR.Receive.NewDataModel(arr[0]); if (e.CommandName == "linkup") { TextBox1.Text = receive.Question.ToString(); hidden_receid.Value = receive.ID.ToString(); } else if (e.CommandName == "linkdel") { receive.Delete(); } else { receive.State.value = e.CommandName == "State3"? 3:2; receive.ConfirmUserID.value = WX.Main.CurUser.UserID; receive.Update(); if (receive.State.ToInt32() == 3) { System.Data.DataTable dt = receive.GetDeptCount(); if (Convert.ToInt32(dt.Rows[0][0]) >= 4 && Convert.ToInt32(dt.Rows[0][1]) > Convert.ToInt32(dt.Rows[0][2]) && Convert.ToInt32(dt.Rows[0][2]) == 0) { WX.Model.User.MODEL usermodel = WX.Model.User.NewDataModel(receive.UserID.ToString()); usermodel.State.value = 40; usermodel.Update(); WX.Main.ExcuteUpdate("aspnet_Membership", "IsLockedOut=1", "UserID='" + usermodel.UserID.ToString() + "'"); WX.Model.DutyDetail.MODEL dutydetail = WX.Model.DutyDetail.GetModel(usermodel.DutyId.ToInt32()); dutydetail.UsersName.value = ULCode.QDA.XSql.GetXDataTable("select RealName from TU_Users where DutyId=" + dutydetail.ID.ToString() + " and State>6 and State<40").ToColValueList(",", 0); dutydetail.Update(); // //日志 WX.HR.DutyLog.MODEL log = WX.HR.DutyLog.NewDataModel(); log.UserID.value = usermodel.UserID.ToString(); log.Backtableid.value = 4; log.Backcolumid.value = Request["LJID"]; log.Starttime.value = DateTime.Now; log.BackDutyID.value = usermodel.DutyId.value; log.BackDempID.value = usermodel.DepartmentID.value; log.Content.value = "员工离职"; WX.HR.DutyLog.MODEL backlog = WX.HR.DutyLog.GetModel("select top 1 * from HR_DutyLogs where UserID='" + usermodel.UserID.ToString() + "' order by Starttime desc"); if (backlog != null) { backlog.stoptime.value = DateTime.Now; backlog.Nowtableid.value = 4; backlog.Nowcolumid.value = Request["LJID"]; backlog.Update(); } log.Insert(); WX.Main.MessageSend("<a href=/Manage/HR/HR_Leavejobs.aspx?LJID=" + Request["LJID"] + "&mes=1>" + usermodel.RealName.ToString() + "已离职——离职通知</a>", "/Manage/Main/messagelist.aspx", WX.CommonUtils.GetDeptUserID(1, "[Host]", usermodel.DepartmentID.ToInt32()), WX.Main.CurUser.UserID, 11, 0); WX.Main.MessageSend("<a href=/Manage/HR/HR_Leavejobs.aspx?LJID=" + Request["LJID"] + "&mes=1>" + usermodel.RealName.ToString() + "已离职——离职通知</a>", "/Manage/Main/messagelist.aspx", WX.CommonUtils.GetHRUserID, WX.Main.CurUser.UserID, 11, 0); WX.Main.MessageSend("<a href=/Manage/HR/HR_Leavejobs.aspx?LJID=" + Request["LJID"] + "&mes=1>" + usermodel.RealName.ToString() + "已离职——离职通知</a>", "/Manage/Main/messagelist.aspx", WX.CommonUtils.GetAdminUserID, WX.Main.CurUser.UserID, 11, 0); WX.Main.MessageSend("<a href=/Manage/Finance/FD_NewUserList.aspx?mes=1>" + usermodel.RealName.ToString() + "已离职——离职通知</a>", "/Manage/Main/messagelist.aspx", WX.CommonUtils.GetFDUserID, WX.Main.CurUser.UserID, 11, 0); } } } BindRECE(receive.UserID.ToString()); }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { userId = WX.Request.rUserId; WX.Model.User.MODEL usermodel = WX.Request.rUser; Label1.Text = "当前员工姓名:" + usermodel.RealName.ToString(); pageinit(); } }
private void UpdateUser(int ofid) { WX.Model.User.MODEL usermodel = WX.Request.rUser; WX.Model.DutyDetail.MODEL dutydetailback = WX.Model.DutyDetail.GetModel(usermodel.DutyId.ToInt32()); usermodel.State.value = 20; usermodel.DepartmentID.value = ui_demp.SelectedValue; usermodel.DutyId.value = ui_duty.SelectedValue; usermodel.Grade.value = DropDownList1.SelectedValue; usermodel.EditTime.value = DateTime.Now; usermodel.Update(); dutydetailback.UsersName.value = ULCode.QDA.XSql.GetXDataTable("select RealName from TU_Users where DutyId=" + dutydetailback.ID.ToString() + " and State>6 and State<40").ToColValueList(",", 0); dutydetailback.Update(); if (dutydetailback.ID.ToString() != ui_duty.SelectedValue) { WX.Model.DutyDetail.MODEL dutydetail = WX.Model.DutyDetail.GetModel(Convert.ToInt32(ui_duty.SelectedValue)); dutydetail.UsersName.value = ULCode.QDA.XSql.GetXDataTable("select RealName from TU_Users where DutyId=" + dutydetail.ID.ToString() + " and State>6 and State<40").ToColValueList(",", 0); dutydetail.Update(); } WX.Main.MessageSend("<a href=/Manage/Work/Work_ApplyOfficial.aspx?mes=1>您的转正申请通过审核,当前为正式员工——审批通知</a>", "/Manage/Main/messagelist.aspx", usermodel.UserID.ToString(), WX.Main.CurUser.UserID, 9, 0); WX.Main.MessageSend("<a href=/Manage/HR/HR_Official.aspx?UserID=" + usermodel.UserID.ToString() + "&mes=1>" + usermodel.RealName.ToString() + "的转正申请通过审核,当前为正式员工——审批通知</a>", "/Manage/Main/messagelist.aspx", WX.CommonUtils.GetDeptUserID(1, "[Host]", usermodel.DepartmentID.ToInt32()), WX.Main.CurUser.UserID, 9, 0); WX.Main.MessageSend("<a href=/Manage/HR/HR_Official.aspx?UserID=" + usermodel.UserID.ToString() + "&mes=1>" + usermodel.RealName.ToString() + "的转正申请通过审核,当前为正式员工——审批通知</a>", "/Manage/Main/messagelist.aspx", WX.CommonUtils.GetHRUserID, WX.Main.CurUser.UserID, 9, 0); WX.Main.MessageSend("<a href=/Manage/Finance/FD_NewUserList.aspx?mes=1>" + usermodel.RealName.ToString() + "的转正申请通过审核,当前为正式员工——转正通知</a>", "/Manage/Main/messagelist.aspx", WX.CommonUtils.GetFDUserID, WX.Main.CurUser.UserID, 9, 0); if (usermodel.Grade.ToInt32() > Convert.ToInt32(System.Configuration.ConfigurationManager.AppSettings["Grade_Employee"])) { WX.Main.MessageSend("<a href=/Manage/HR/HR_Official.aspx?UserID=" + usermodel.UserID.ToString() + "&mes=1>" + usermodel.RealName.ToString() + "的转正申请通过审核,当前为正式员工——审批通知</a>", "/Manage/Main/messagelist.aspx", WX.CommonUtils.GetCAUserID, WX.Main.CurUser.UserID, 9, 0); } //日志 WX.HR.DutyLog.MODEL log = WX.HR.DutyLog.NewDataModel(); log.BackDutyID.value = usermodel.DutyId.value; log.BackDempID.value = usermodel.DepartmentID.value; log.UserID.value = WX.Request.rUserId; log.NowDutyID.value = ui_duty.SelectedValue; log.NowDempID.value = ui_demp.SelectedValue; log.Backtableid.value = 1; log.Backcolumid.value = ofid; log.Starttime.value = DateTime.Now; log.GradeID.value = usermodel.Grade.value; log.Content.value = "员工转正" + log.Content.ToString(); WX.HR.DutyLog.MODEL backlog = WX.HR.DutyLog.GetModel("select top 1 * from HR_DutyLogs where UserID='" + log.UserID.ToString() + "' order by Starttime desc"); if (backlog != null) { backlog.stoptime.value = DateTime.Now; backlog.Nowtableid.value = 1; backlog.Nowcolumid.value = ofid; backlog.Update(); } log.Insert(); }
protected void Page_Load(object sender, EventArgs e) { if (!this.Master.A_Edit) { Response.Write("你没有权限访问此功能!"); Response.End(); return; } if (!IsPostBack) { WX.Model.User.MODEL usermodel = WX.Request.rUser;//WX.Model.Employee.GetModel("select * from TU_Employees where UserID='" + Request["UserID"] + "'"); liUserName.Text = String.Format("员工:{0} 用户名:{1}", usermodel.RealName, usermodel.UserName); } }
private void pageinit() { string userId = WX.Request.rUserId; WX.Model.User.MODEL usermodel = WX.Request.rUser; MenuBar1.Param2 = usermodel.State.ToString(); System.Data.DataTable dt = WX.HR.TransferKong.GetList(userId); Gv_tfk.DataSource = dt; Gv_tfk.DataBind(); if (Gv_tfk.Rows.Count > 0) { Gv_tfk.HeaderRow.TableSection = TableRowSection.TableHeader; Gv_tfk.HeaderStyle.Height = Unit.Pixel(40); } }
private void InitComponent() { string deptid = null; if (Request["mes"] != null) { WX.Model.User.MODEL usermodel = WX.Request.rUser; deptid = usermodel.DepartmentID.ToString(); WX.Main.MessageToHistory_where(String.Format("SendToUserId='{0}' and Title like'%Ass_AddConsuming.aspx?UserID=" + WX.Request.rUserId + "%'", WX.Main.CurUser.UserID, WX.Request.rUserId)); } Dict.BindListCtrl_DeptList(this.ddlDepartment, null, null, deptid); this.txtOpTime.Text = DateTime.Now.ToString("yyyy-MM-dd"); this.txtOpUserName.Text = WX.CommonUtils.GetRealNameListByUserIdList(WX.Authentication.GetUserID()); this.txtOpUserID.Value = WX.Authentication.GetUserID(); }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { string userId = WX.Request.rUserId; if (!ULCode.Validation.IsGuid(userId)) { ULCode.Debug.we("你没有权限访问此页面!"); return; } WX.Model.User.MODEL model = WX.Model.User.GetCache(userId);//WX.Model.Employee.GetModel("select * from TU_Employees where UserID='" + Request["UserID"] + "'"); liUserName.Text = String.Format("员工:{0} 用户名:{1}", model.RealName, model.UserName); InitComponent(true); } }
protected void Button1_Click(object sender, EventArgs e) { WX.HR.DutyLog.MODEL log = WX.HR.DutyLog.NewDataModel(); WX.Model.User.MODEL usermodel = WX.Main.CurUser.UserModel; WX.HR.Official.MODEL Official = WX.HR.Official.NewDataModel(); Official = WX.HR.Official.GetModel("select top 1 * from HR_Official where UserID='" + usermodel.UserID.ToString() + "' order by Addtime desc"); bool flag = true; if (Official == null) { Official = WX.HR.Official.NewDataModel(); flag = false; } Official.UserID.value = usermodel.UserID.ToString(); Official.DutyID.value = usermodel.DutyId.value; Official.salary.value = usermodel.Grade.value; Official.imagine.value = ui_imagine.Text; int ofid; if (flag) { ofid = Convert.ToInt32(Official.ID.ToString()); Official.Update(); } else { Official.Addtime.value = DateTime.Now; ofid = Official.Insert(true); } log.BackDutyID.value = usermodel.DutyId.value; log.BackDempID.value = usermodel.DepartmentID.value; //日志 log.UserID.value = usermodel.UserID.ToString(); log.Backtableid.value = 1; log.Backcolumid.value = ofid; log.Starttime.value = DateTime.Now; log.GradeID.value = usermodel.Grade.value; log.Content.value = "转正申请" + log.Content.ToString(); log.Insert(); //1、向部门发送通知 WX.Main.MessageSend("<a href=/Manage/HR/HR_Official.aspx?UserID=" + usermodel.UserID.ToString() + "&mes=1>" + usermodel.RealName.ToString() + "申请转正——转正通知</a>", "/Manage/Main/messagelist.aspx", WX.CommonUtils.GetDeptUserID(1, "[Host]", usermodel.DepartmentID.ToInt32()), WX.Main.CurUser.UserID, 9, 0); //2、向人资发送通知 WX.Main.MessageSend("<a href=/Manage/HR/HR_Official.aspx?UserID=" + usermodel.UserID.ToString() + "&mes=1>" + usermodel.RealName.ToString() + "申请转正——转正通知</a>", "/Manage/Main/messagelist.aspx", WX.CommonUtils.GetHRUserID, WX.Main.CurUser.UserID, 9, 0); Response.Redirect("Work_Apply.aspx"); }
protected void btnSubmit_Click(object sender, EventArgs e) { //Process.MODEL process = new Process.MODEL(); WX.Flow.Model.Flow.MODEL flow = WX.Flow.Model.Flow.GetCache(rFlowId); //WX.Flow.Model.Flow.NewDataModel(rFlowId); flow.LoadProcessList(false); if (flow.GetProcessByStep(1).ExecIn(null) == 0) { ULCode.Debug.Alert(this, "程序出错,请联系管理员!"); return; } int newRunId = flow.NewWork(this.txtSerialNumber.Text); this.Save(newRunId, 1); if (newRunId > 0) { WX.Flow.Model.Run.MODEL runmodel = WX.Flow.Model.Run.GetModel("select * from FL_Run where Id=" + newRunId); WX.Flow.Model.Process.MODEL process = WX.Flow.Model.Process.GetCache(runmodel.FlowId.ToInt32(), runmodel.StepNo.ToInt32()); WX.Model.User.MODEL squser = WX.Model.User.NewDataModel(runmodel.BeginUser.ToString()); if (process.Auto_Type.ToString() == "1")//经办人为流程发起人的 { WX.Main.MessageSend("<a href=/Manage/Work/Work_MyCheck.aspx?flag=0&mes=1>" + flow.Name.ToString() + "(" + WX.CommonUtils.GetRealNameListByUserIdList(runmodel.BeginUser.ToString()) + ")——请尽快审批!</a>", "/Manage/Main/messagelist.aspx", runmodel.BeginUser.ToString(), WX.Main.CurUser.UserID, 12, 0); } else if (process.Auto_Type.ToString() == "2")//经办人为部门主管的 { WX.Main.MessageSend("<a href=/Manage/Work/Work_MyCheck.aspx?flag=0&mes=1>" + flow.Name.ToString() + "(" + WX.CommonUtils.GetRealNameListByUserIdList(runmodel.BeginUser.ToString()) + ")——请尽快审批!</a>", "/Manage/Main/messagelist.aspx", WX.CommonUtils.GetDeptUserID(1, "[Host]", squser.DepartmentID.ToInt32()), WX.Main.CurUser.UserID, 12, 0); } else if (process.Auto_Type.ToString() == "4") { WX.Main.MessageSend("<a href=/Manage/Work/Work_MyCheck.aspx?flag=0&mes=1>" + flow.Name.ToString() + "(" + WX.CommonUtils.GetRealNameListByUserIdList(runmodel.BeginUser.ToString()) + ")——请尽快审批!</a>", "/Manage/Main/messagelist.aspx", WX.CommonUtils.GetParentDeptHost(squser.DepartmentID.ToInt32(), "Host"), WX.Main.CurUser.UserID, 12, 0); } else if (process.Auto_Type.ToString() == "5") { WX.Main.MessageSend("<a href=/Manage/Work/Work_MyCheck.aspx?flag=0&mes=1>" + flow.Name.ToString() + "(" + WX.CommonUtils.GetRealNameListByUserIdList(runmodel.BeginUser.ToString()) + ")——请尽快审批!</a>", "/Manage/Main/messagelist.aspx", WX.CommonUtils.GetParentDeptHost(squser.DepartmentID.ToInt32(), "SubHosts"), WX.Main.CurUser.UserID, 12, 0); } else { System.Data.DataTable dt = ULCode.QDA.XSql.GetDataTable("select UserID from Tu_Users where 1=1" + (process.Priv_UserList.ToString() != "" ? " and UserID in(" + process.Priv_UserList.ToString() + ")" : "") + (process.Priv_DutyList.ToString() != "" ? " and DutyId in(select ID from TE_DutyDetail where DutyID in(" + process.Priv_DutyList.ToString() + "))" : "") + (process.Priv_DeptList.ToString() != "" ? " and Priv_DeptList in(" + process.Priv_DeptList.ToString() + ")" : "")); for (int i = 0; i < dt.Rows.Count; i++) { WX.Main.MessageSend("<a href=/Manage/Work/Work_MyCheck.aspx?flag=0&mes=1>" + flow.Name.ToString() + "(" + WX.CommonUtils.GetRealNameListByUserIdList(runmodel.BeginUser.ToString()) + ")——请尽快审批!</a>", "/Manage/Main/messagelist.aspx", dt.Rows[i][0].ToString(), WX.Main.CurUser.UserID, 12, 0); } } //转到下一页 Response.Redirect("/Manage/Work/Work_MyWork.aspx?flag=0 "); } }
private void SaveLeaveJob(int type) { WX.HR.LeaveJob.MODEL LeaveJob = WX.HR.LeaveJob.NewDataModel(Request["LJID"]); WX.Model.User.MODEL usermodel = WX.Model.User.NewDataModel(LeaveJob.UserID.ToString()); ui_dempop.Text = ui_dempop.Text + "(" + DateTime.Now + ")"; if (WX.CommonUtils.GetDeptUserID(1, "[Host]", usermodel.DepartmentID.ToInt32()) == WX.Main.CurUser.UserID) { LeaveJob.dempManager.value = WX.Main.CurUser.UserID; LeaveJob.dempOpinion.value = ui_dempop.Text; if (type == 1) { WX.Main.MessageSend("<a href=/Manage/HR/HR_Leavejobs.aspx?LJID=" + LeaveJob.ID.ToString() + "&mes=1>" + usermodel.RealName.ToString() + "提交了离职申请,请人力资源部审批——离职通知</a>", "/Manage/Main/messagelist.aspx", WX.CommonUtils.GetHRUserID, WX.Main.CurUser.UserID, 11, 0); } } else if (WX.CommonUtils.GetHRUserID == WX.Main.CurUser.UserID) { LeaveJob.hrOpinion.value = ui_dempop.Text; LeaveJob.hrManager.value = WX.Main.CurUser.UserID; if (type == 1) { WX.Main.MessageSend("<a href=/Manage/HR/HR_Leavejobs.aspx?LJID=" + LeaveJob.ID.ToString() + "&mes=1>" + usermodel.RealName.ToString() + "提交了离职申请,请中心领导审批——离职通知</a>", "/Manage/Main/messagelist.aspx", WX.CommonUtils.GetBossUserID, WX.Main.CurUser.UserID, 11, 0); } } else if (WX.CommonUtils.GetBossUserID == WX.Main.CurUser.UserID) { LeaveJob.bossManager.value = WX.Main.CurUser.UserID; LeaveJob.bossOpinion.value = ui_dempop.Text; if (type == 1) { WX.Main.MessageSend("<a href=/Manage/Work/Work_ApplyLeavejobs.aspx?LJID=" + LeaveJob.ID.ToString() + "&mes=1>您提交的离职申请已批准,请协助各部门办理交接——离职通知</a>", "/Manage/Main/messagelist.aspx", usermodel.UserID.ToString(), WX.Main.CurUser.UserID, 11, 0); WX.Main.MessageSend("<a href=/Manage/HR/HR_Leavejobs.aspx?LJID=" + LeaveJob.ID.ToString() + "&mes=1>" + usermodel.RealName.ToString() + "提交的离职申请已批准,请做好部门交接工作——离职通知</a>", "/Manage/Main/messagelist.aspx", WX.CommonUtils.GetDeptUserID(1, "[Host]", usermodel.DepartmentID.ToInt32()), WX.Main.CurUser.UserID, 11, 0); WX.Main.MessageSend("<a href=/Manage/HR/HR_Leavejobs.aspx?LJID=" + LeaveJob.ID.ToString() + "&mes=1>" + usermodel.RealName.ToString() + "提交的离职申请已批准,请做好部门交接工作——离职通知</a>", "/Manage/Main/messagelist.aspx", WX.CommonUtils.GetHRUserID, WX.Main.CurUser.UserID, 11, 0); WX.Main.MessageSend("<a href=/Manage/HR/HR_Leavejobs.aspx?LJID=" + LeaveJob.ID.ToString() + "&mes=1>" + usermodel.RealName.ToString() + "提交的离职申请已批准,请做好物品交接工作——离职通知</a>", "/Manage/Main/messagelist.aspx", WX.CommonUtils.GetAdminUserID, WX.Main.CurUser.UserID, 11, 0); WX.Main.MessageSend("<a href=/Manage/HR/HR_Leavejobs.aspx?LJID=" + LeaveJob.ID.ToString() + "&mes=1>" + usermodel.RealName.ToString() + "提交的离职申请已批准,请做好部门交接工作——离职通知</a>", "/Manage/Main/messagelist.aspx", WX.CommonUtils.GetFDUserID, WX.Main.CurUser.UserID, 11, 0); } } if (type == 2) { LeaveJob.EndTime.value = DateTime.Now; WX.Main.MessageSend("<a href=/Manage/Work/Work_ApplyLeavejobs.aspx?LJID=" + LeaveJob.ID.ToString() + "&mes=1>您提交的离职申请没通过,点击查看详情——离职通知</a>", "/Manage/Main/messagelist.aspx", usermodel.UserID.ToString(), WX.Main.CurUser.UserID, 11, 0); WX.Main.MessageSend("<a href=/Manage/HR/HR_Leavejobs.aspx?LJID=" + LeaveJob.ID.ToString() + "&mes=1>" + usermodel.RealName.ToString() + "提交的离职申请被驳回,点击查看详情——离职通知</a>", "/Manage/Main/messagelist.aspx", WX.CommonUtils.GetDeptUserID(1, "[Host]", usermodel.DepartmentID.ToInt32()), WX.Main.CurUser.UserID, 11, 0); WX.Main.MessageSend("<a href=/Manage/HR/HR_Leavejobs.aspx?LJID=" + LeaveJob.ID.ToString() + "&mes=1>" + usermodel.RealName.ToString() + "提交了离职申请被驳回,点击查看详情——离职通知</a>", "/Manage/Main/messagelist.aspx", WX.CommonUtils.GetHRUserID, WX.Main.CurUser.UserID, 11, 0); } LeaveJob.Update(); }
protected void Button1_Click(object sender, EventArgs e) { WX.HR.LeaveJob.MODEL LeaveJob = WX.HR.LeaveJob.NewDataModel(); LeaveJob = WX.HR.LeaveJob.NewDataModel(); LeaveJob.Addtime.value = DateTime.Now; LeaveJob.UserID.value = WX.Main.CurUser.UserID; LeaveJob.reason.value = radio_reason.SelectedValue + "。" + ui_reason.Text; LeaveJob.days.value = ui_days.Text; LeaveJob.lasttime.value = ui_lasttime.Text; int ofid = LeaveJob.Insert(true); WX.Model.User.MODEL usermodel = WX.Main.CurUser.UserModel; //1、向部门发送通知 WX.Main.MessageSend("<a href=/Manage/HR/HR_Leavejobs.aspx?LJID=" + ofid + "&mes=1>" + usermodel.RealName.ToString() + "申请离职——离职通知</a>", "/Manage/Main/messagelist.aspx", WX.CommonUtils.GetDeptUserID(1, "[Host]", usermodel.DepartmentID.ToInt32()), WX.Main.CurUser.UserID, 11, 0); //2、向人资发送通知 //WX.Main.MessageSend("<a href=/Manage/HR/HR_Leavejobs.aspx?LJID=" + ofid + "&mes=1>" + usermodel.RealName.ToString() + "申请离职——离职通知</a>", "/Manage/Main/messagelist.aspx", WX.CommonUtils.GetHRUserID, WX.Main.CurUser.UserID, 11, 0); Response.Redirect("Work_Apply.aspx"); }
public void bindjob() { DataTable dt; WX.Model.User.MODEL user = WX.Request.rUser; dt = WX.Model.DutyDetail.GetTablenullDepartent(this.ddlDepartment.SelectedValue, user.RealName.ToString()); this.ui_jobname.DataSource = dt; this.ui_jobname.DataTextField = "Name"; this.ui_jobname.DataValueField = "ID"; this.ui_jobname.DataBind(); if (this.ui_jobname.Items.Count == 0) { Button1.Enabled = false; } else { Button1.Enabled = true; } }