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();
}
