CeramicProject/newyt/Module_data/Employee_browse.aspx.cs

158 lines
5.8 KiB
C#

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data;
using System.Data.SqlClient;
using System.IO;
public partial class Employee_browse : CommonPage
{
//创建一个共用的物料bll
Maticsoft.BLL.nr_z_ryda rybll = new Maticsoft.BLL.nr_z_ryda();
//创建一个物料模板
Maticsoft.Model.nr_z_ryda rymd = new Maticsoft.Model.nr_z_ryda();
//创建一个操作记录模板
Maticsoft.Model.nr_sys_rizhi rizhi = new Maticsoft.Model.nr_sys_rizhi();
//创建一个操作记录bll
Maticsoft.BLL.nr_sys_rizhi rizhibll = new Maticsoft.BLL.nr_sys_rizhi();
Maticsoft.BLL.nr_sys_bianma bianma = new Maticsoft.BLL.nr_sys_bianma();
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
if (Session["user"] == null)
{
Response.Redirect("../index.aspx");
}
Maticsoft.Model.nr_z_yhzh user = (Maticsoft.Model.nr_z_yhzh)(Session["user"]);
pdquanxian(user.juese);
if (Request.QueryString["uid"] != null && Request.QueryString["uid"] != "")
{
id.Value = Request.QueryString["uid"].ToString();
}
initdata(id.Value);
//jzgyxx();
}
}
#region
private void initdata(string id)
{
int idz = Convert.ToInt32(id);
rymd = rybll.GetModel(idz);
if (rymd != null)
{
bh.Text = rymd.bh.ToString();
xm.Text = rymd.xm.ToString();
jg.Text = rymd.jg.ToString();
xjd.Text = rymd.xjd.ToString();
sfzh.Text = rymd.sfzh.ToString();
csrq.Text = Convert.ToDateTime(rymd.csrq).ToString("yyyy-MM-dd").ToString();
xl.Text = DBHlper.getfirstcolmn("select mingcheng from nr_sys_bianma where id=" + rymd.xl);
lxfs.Text = rymd.lxfs.ToString();
zw.Text = DBHlper.getfirstcolmn("select mingcheng from nr_sys_bianma where id=" + rymd.zw);
rzrq.Text = Convert.ToDateTime(rymd.rzrq).ToString("yyyy-MM-dd").ToString();
//htdq.Text = Convert.ToDateTime(rymd.htdq).ToString("yyyy-MM-dd").ToString();
//jbgz.Text = Convert.ToDecimal(rymd.jbgz).ToString();
zt.Text = rymd.zt;
bz.Text = rymd.bz.ToString();
//tpzm.ImageUrl = "../Client_Folder/" + rymd.zmzp + "";
//tpbm.ImageUrl = "../Client_Folder/" + rymd.bmzp + "";
glzh.Text = rymd.glzh;
}
}
#endregion
#region
/* private void jzgyxx()
{
//修改页面时,首先吧项目明细的表头加载出来
string biao = "<table class='bule' id='ddxm' > ";
DataSet djgxds = DBHlper.Execute("select * from nr_z_ryda_gxqx where ryid='" + id.Value + "' and qxlx='登记权限'"); ;
string gxcode = "<tr><td style='width:120px;' ><span>登记工艺权限:</span></td><td class='head4'><ul>";
foreach (DataRow dr in djgxds.Tables[0].Rows)
{
gxcode += "<li class='gxli'>&nbsp" + dr["gyxx"] + "</li>";
}
gxcode += "</ul></td></tr>";
DataSet xfgxds = DBHlper.Execute("select * from nr_z_ryda_gxqx where ryid='" + id.Value + "' and qxlx='下发权限'"); ;
gxcode += "<tr><td style='width:120px;' ><span>下发工艺权限:</span></td><td class='head4'><ul>";
foreach (DataRow dr in xfgxds.Tables[0].Rows)
{
gxcode += "<li class='gxli'>&nbsp" + dr["gyxx"] + "</li>";
}
gxcode += "</ul></td></tr>";
DataSet jngxds = DBHlper.Execute("select * from nr_z_ryda_gxqx where ryid='" + id.Value + "' and qxlx='掌握技能'"); ;
gxcode += "<tr><td style='width:120px;' ><span>掌握技能权限:</span></td><td class='head4'><ul>";
foreach (DataRow dr in jngxds.Tables[0].Rows)
{
gxcode += "<li class='gxli'>&nbsp" + dr["gyxx"] + "</li>";
}
gxcode += "</ul></td></tr>";
gysq.InnerHtml = biao + gxcode + "</table>";
}*/
#endregion
#region
void pdquanxian(int juese)
{
Maticsoft.Model.nr_z_yhzh user = (Maticsoft.Model.nr_z_yhzh)(Session["user"]);
if (DBHlper.getzt(user.id) != 1)
{
Response.Redirect("../index.aspx");
}
if (DBHlper.GetPermission(juese, "人员档案", "nr_z_ryda", "查看全部") == false)
{
Response.Redirect("../Common/nopower.htm");
}
if (DBHlper.GetPermission(juese, "人员档案", "nr_z_ryda", "编辑"))
{
bt_tj.Visible = true;
}
if (DBHlper.GetPermission(juese, "人员档案", "nr_z_ryda", "删除"))
{
shanchu.Visible = true;
}
}
#endregion
protected void bt_tj_Click(object sender, EventArgs e)
{
Response.Redirect("Employee_Form.aspx?uid=" + id.Value);
}
protected void Button1_Click(object sender, EventArgs e)
{
bool ci = rybll.Delete(Convert.ToInt32(id.Value));
if (ci)
{
//给日志模板赋值
rizhi.riqi = DateTime.Now;
rizhi.leixing = "人员档案";
//将session转换对象取值
Maticsoft.Model.nr_z_yhzh zh = (Maticsoft.Model.nr_z_yhzh)Session["user"];
//拼接字符串插入日志
rizhi.jilu = zh.zhanghao + "删除了人员档案,编号为:" + bh.Text.Trim();
rizhi.yonghuming = zh.zhanghao.ToString();
rizhibll.Add(rizhi);
Response.Redirect("Employee_list.aspx", false);
}
else
{
Response.Write("<script>alert('删除失败')</script>");
}
}
}