protected void Page_Load(object sender, EventArgs e) { if (!Page.IsPostBack) { BaseFun fun = new BaseFun(); //初始化年份 //for (int i = 0; i < 5; i++) //{ // txt_year.Items.Add(new ListItem((year - i).ToString(), (year - i).ToString())); //} string strsql = "select distinct year(dingdian_date)year from Baojia_agreement_flow order by year(dingdian_date) desc "; DataSet dsYear = DbHelperSQL.Query(strsql); fun.initDropDownList(dropYear, dsYear.Tables[0], "year", "year"); int year = Convert.ToInt16(DateTime.Now.ToString("yyyy")); string mnth = DateTime.Now.Month.ToString(); DataSet ds = DbHelperSQL.Query("exec BaoJia_Dingdian_Query '" + dropYear.SelectedValue + "','0','','',''"); DataSet dt_mx = DbHelperSQL.Query("exec BaoJia_Dingdian_Query '" + dropYear.SelectedValue + "','0','0','',''"); DataTable dt = ds.Tables[0]; gv.DataSource = dt; gv.DataBind(); Getsum(dt_mx.Tables[0]); gvdetail.DataSource = dt_mx.Tables[0]; gvdetail.DataBind(); setGridLink(); bindChartYear(ds.Tables[1]); LinkBtn.Style.Add("display", "none"); } }
/// <summary> /// 抓取所有单据相关的部门 LIST /// </summary> public void Get_ddlDepart() { //给部门检索ddlxgry Dropdownlist 绑定数据源 BaseFun fun = new BaseFun(); string strSQL = @" select distinct dept_name as dept_sname,dept_name from( SELECT b.dept_name as dept_name FROM [dbo].[Baojia_sign_flow] A JOIN HRM_EMP_MES B ON A.EMPID=B.workcode AND a.receive_date is not null ) aa where 1=1 order by aa.dept_name " ; DataTable departList = DbHelperSQL.Query(strSQL).Tables[0]; if (departList.Rows.Count > 0) { fun.initDropDownList(this.ddl_depart, departList, "dept_sname", "dept_name"); } ddl_depart.Items.Insert(0, new ListItem("", "")); //根据当前进入的人员所在部门,直接默认选择该部门 //根据人员工号,获取该人员所属部门名称 string getdepat_name = @" select distinct dept_name from HRM_EMP_MES where workcode='" + Session["empid"].ToString() + "'"; if (DbHelperSQL.Query(getdepat_name).Tables[0].Rows.Count > 0) { this.ddl_depart.SelectedValue = DbHelperSQL.Query(getdepat_name).Tables[0].Rows[0][0].ToString(); } }
public void Get_updateuser_bydepart(string deptname) { if (deptname == "") { Get_ddl_update_user(); } else { //给相关人员Dropdownlist 绑定数据源 BaseFun fun = new BaseFun(); string strSQL = @"SELECT DISTINCT AA.empid empid, AA.lastname lastname FROM ( select A.EMPID AS empid, B.lastname AS lastname, B.dept_name AS dept_name from [dbo].[Baojia_sign_flow] a JOIN HRM_EMP_MES B ON A.EMPID = B.workcode AND a.receive_date is not null ) AA WHERE AA.dept_name='" + deptname + "' "; DataTable Updateusers = DbHelperSQL.Query(strSQL).Tables[0]; if (Updateusers.Rows.Count > 0) { fun.initDropDownList(this.ddl_update_user, Updateusers, "empid", "lastname"); } ddl_update_user.Items.Insert(0, new ListItem("", "")); } }
/// 零件状态下拉 public void ini_HeTong_Status() { string strSQL = @" SELECT [lookup_code] ,[lookup_desc] FROM [MES].[dbo].[Baojia_lookup_table] where lookup_type='lj_status_q' and status='Y' order by lookup_code"; DataTable dt = DbHelperSQL.Query(strSQL).Tables[0]; BaseFun fun = new BaseFun(); fun.initDropDownList(this.ddlHetong_status, dt, "lookup_code", "lookup_desc"); }
/// 项目大小下拉 public void ini_Project_Size() { string strSQL = @"select null as lookup_code,'' as lookup_desc union all SELECT [lookup_code] ,[lookup_desc] FROM [MES].[dbo].[Baojia_lookup_table] where lookup_type='project_size' and status='Y'"; DataTable dt = DbHelperSQL.Query(strSQL).Tables[0]; BaseFun fun = new BaseFun(); fun.initDropDownList(this.ddlProject_size, dt, "lookup_code", "lookup_desc"); }
protected void Page_Load(object sender, EventArgs e) { this.GridView1.PageSize = 200; if (Session["empid"] == null || Session["job"] == null) { //Session["empid"] = "02088"; // 给Session["empid"] & Session["job"] 初始化 InitUser.GetLoginUserInfo(Page, Request.ServerVariables["LOGON_USER"]); } if (!IsPostBack) { Get_ddl_update_user(); //给相关人员Dropdownlist 绑定数据源 Get_ddlDepart(); //给相关部门Dropdownlist 绑定数据源 Get_updateuser_bydepart(this.ddl_depart.SelectedValue.ToString()); //根据部门号重新绑定人员 //年份 string sqlyear = "select distinct year(receive_date) year from Baojia_sign_flow where receive_date is not null"; BaseFun fun = new BaseFun(); fun.initDropDownList(ddlyear, DbHelperSQL.Query(sqlyear).Tables[0], "year", "year"); BaseFun.setDropSelectValue(ddlyear, DateTime.Now.Year.ToString(), ""); } }
public void Get_ddl_update_user() { //给相关人员Dropdownlist 绑定数据源 BaseFun fun = new BaseFun(); string strSQL = @" SELECT DISTINCT AA.empid empid, AA.lastname lastname FROM ( select A.create_by_empid AS empid, B.lastname AS lastname, B.dept_name AS dept_name from [dbo].[Baojia_mst] a JOIN HRM_EMP_MES B ON A.create_by_empid = B.workcode where a.baojia_status='已报出' ) AA WHERE 1 = 1 "; DataTable Updateusers = DbHelperSQL.Query(strSQL).Tables[0]; if (Updateusers.Rows.Count > 0) { fun.initDropDownList(this.ddl_update_user, Updateusers, "empid", "lastname"); } ddl_update_user.Items.Insert(0, new ListItem("", "")); }
public void Get_ddl_update_user() { //给相关人员Dropdownlist 绑定数据源 BaseFun fun = new BaseFun(); string strSQL = @" SELECT DISTINCT AA.empid empid, AA.lastname lastname FROM ( select A.empid AS empid, B.lastname AS lastname, B.dept_name AS dept_name from [dbo].[Baojia_sign_flow] a JOIN HRM_EMP_MES B ON A.empid = B.workcode where a.receive_date is not null ) AA WHERE 1 = 1 "; DataTable Updateusers = DbHelperSQL.Query(strSQL).Tables[0]; if (Updateusers.Rows.Count > 0) { fun.initDropDownList(this.ddl_update_user, Updateusers, "empid", "lastname"); } ddl_update_user.Items.Insert(0, new ListItem("", "")); //进入界面直接默认显示该人员 // this.ddl_update_user.SelectedValue = Session["empid"].ToString(); }