private void BindGrid5(string SDATE, string EDATE)
{
string connectionString = ConfigurationManager.ConnectionStrings["connectionstring"].ToString();
Ede.Uof.Utility.Data.DatabaseHelper m_db = new Ede.Uof.Utility.Data.DatabaseHelper(connectionString);
string cmdTxt = @" SELECT COUNT(*) AS COUNTS
FROM [HJ_BM_DB].[dbo].[tb_NOTE],[HJ_BM_DB].[dbo].[tb_COMPANY]
LEFT JOIN [HJ_BM_DB].[dbo].[tb_USER] ON [USER_ID]=[OWNER_ID]
WHERE [tb_COMPANY].COMPANY_ID=[tb_NOTE].COMPANY_ID
AND CONVERT(nvarchar,[tb_NOTE].[CREATE_DATETIME],111)>=@SDATE AND CONVERT(nvarchar,[tb_NOTE].[CREATE_DATETIME],111)<=@EDATE
AND [tb_NOTE].[COMPANY_ID]<>'0'
";
m_db.AddParameter("@SDATE", SDATE);
m_db.AddParameter("@EDATE", EDATE);
DataTable dt = new DataTable();
dt.Load(m_db.ExecuteReader(cmdTxt));
Grid5.DataSource = dt;
Grid5.DataBind();
}
private void BindGrid5()
{
string connectionString = ConfigurationManager.ConnectionStrings["ERPconnectionstring"].ToString();
Ede.Uof.Utility.Data.DatabaseHelper m_db = new Ede.Uof.Utility.Data.DatabaseHelper(connectionString);
StringBuilder cmdTxt = new StringBuilder();
StringBuilder QUERYS = new StringBuilder();
cmdTxt.AppendFormat(@"
SELECT
[ID]
,[KINDS]
,[NAMES]
,[MOQS]
,[INDAYS]
,[COMMENTS]
FROM [TKBUSINESS].[dbo].[TBPURMOQ]
WHERE [KINDS]=@KINDS
ORDER BY [ID]
");
m_db.AddParameter("@KINDS", "內襯");
//m_db.AddParameter("@EDATE", EDATE);
DataTable dt = new DataTable();
dt.Load(m_db.ExecuteReader(cmdTxt.ToString()));
Grid5.DataSource = dt;
Grid5.DataBind();
}
private void btnDesnaStrelica_Click(object sender, RoutedEventArgs e)
{
vrednost -= 750;
brojac++;
if (brojac == 3)
{
btnDesnaStrelica.Visibility = Visibility.Hidden;
}
else if (brojac == 0 || brojac == 1)
{
btnLevaStrelica.Visibility = Visibility.Visible;
btnDesnaStrelica.Visibility = Visibility.Visible;
}
DoubleAnimation doubleAnimation = new DoubleAnimation();
PowerEase powerEase = new PowerEase();
powerEase.EasingMode = EasingMode.EaseInOut;
powerEase.Power = 10;
doubleAnimation.To = vrednost;
doubleAnimation.Duration = new Duration(new TimeSpan(0, 0, 0, 0, 700));
// doubleAnimation.EasingFunction = powerEase;
Grid1.BeginAnimation(Canvas.LeftProperty, doubleAnimation);
Grid2.BeginAnimation(Canvas.LeftProperty, doubleAnimation);
Grid3.BeginAnimation(Canvas.LeftProperty, doubleAnimation);
Grid4.BeginAnimation(Canvas.LeftProperty, doubleAnimation);
Grid5.BeginAnimation(Canvas.LeftProperty, doubleAnimation);
Grid6.BeginAnimation(Canvas.LeftProperty, doubleAnimation);
Grid7.BeginAnimation(Canvas.LeftProperty, doubleAnimation);
}
protected void TabStrip1_TabIndexChanged(object sender, EventArgs e)
{
if (TabStrip1.ActiveTabIndex == 0)
{
}
else if (TabStrip1.ActiveTabIndex == 1)
{
//查询关联备件
string sbmc = "";
int 所属单位 = 0;
int[] selections = Grid1.SelectedRowIndexArray;
foreach (int rowIndex in selections)
{
sbmc = Grid1.DataKeys[rowIndex][4].ToString();
所属单位 = Convert.ToInt16(Grid1.DataKeys[rowIndex][10]);
}
Grid2.DataSource = bll.设备名称关联备件(sbmc, 所属单位);
Grid2.DataBind();
}
else if (TabStrip1.ActiveTabIndex == 2)
{
//维修情况
//string sbbh = "";
//int[] selections = Grid1.SelectedRowIndexArray;
//foreach (int rowIndex in selections)
//{
// sbbh = Grid1.DataKeys[rowIndex][3].ToString();
//}
Grid3.DataSource = bll.设备编号关联维修情况(设备编号.Text);
Grid3.DataBind();
}
else if (TabStrip1.ActiveTabIndex == 3)
{
//设备BOM
}
else if (TabStrip1.ActiveTabIndex == 4)
{
//备件消耗
Grid4.DataSource = bll.设备编号查询备件消耗(设备编号.Text);
Grid4.DataBind();
}
else if (TabStrip1.ActiveTabIndex == 5)
{
//预防性维修
string sbbc = 设备名称.Text;
//text.Text = bll.查询单台设备平均故障时间("999-1252", "喷枪");
List <预防性维修> listmodel = bll.查询设备平均故障时间(sbbc);
Grid5.DataSource = listmodel;
Grid5.DataBind();
//List<预防性维修> listmodel = bll.查询设备平均故障时间("车体喷砂系统");
}
}
public void LoadOrderDep01(string ORDDER_ID)
{
if (String.IsNullOrEmpty(ORDDER_ID))
{
Grid4.DataSource = null;
Grid5.DataSource = null;
Grid4.DataBind();
Grid5.DataBind();
}
ORDER_DEP01Bll.GetInstence().BandGrid(this, Grid4, 1, ORDDER_ID);
ORDER_DEP01Bll.GetInstence().BandGrid(this, Grid5, 2, ORDDER_ID);
}
protected void CheckBox3_CheckedChanged(object sender, CheckedEventArgs e)
{
if (CheckBox3.Checked == true)
{
GridColumn column = Grid5.FindColumn("负责人");//根据条件来隐藏列
column.Hidden = !column.Hidden;
}
else
{
GridColumn column = Grid5.FindColumn("负责人");//根据条件来隐藏列
column.Hidden = !column.Hidden;
}
}
protected void Button9_Click1(object sender, EventArgs e)
{
int ID = Convert.ToInt32(HttpContext.Current.Session["UserID"]);
School资产报修BLL bll = new School资产报修BLL();
string xa = bll.用户权限(ID);
object a = Grid1.SelectedRow.DataKeys[0];
int xx = Convert.ToInt32(a);
int sort = Convert.ToInt32(Grid1.SelectedRow.DataKeys[9]);
string nm = HttpContext.Current.Session["姓名"].ToString();
string ren = bll.ren(xx);
if (xa == "资产管理员" && sort == 1)
{
DataSet ds = bll.查维修人();
DataTable dt = ds.Tables[0];
Grid5.DataSource = dt;
Grid5.DataBind();
Window4.Hidden = false;
}
else if (xa == "维修人员" && sort == 2)
{
School待办业务BLL blla = new School待办业务BLL();
TextBox2.Text = nm;
TextBox1.Text = blla.获取维修人电话(nm);
Window5.Hidden = false;
}
else if (sort == 3 && ren == nm)
{
DateTime dtime = DateTime.Now;
string sj = dtime.Year + "-" + dtime.Month + "-" + dtime.Day;
DatePicker2.EmptyText = sj;
if (DatePicker2.Text == "")
{
DatePicker2.Text = DatePicker2.EmptyText;
}
Window6.Hidden = false;
}
else
{
Alert.ShowInTop("您没有此权限！");
}
}
private void bindEvaluateTableToGrid()
{
string exception = "";
EvaluateTable evaluateTable = new EvaluateTable();
string evaluatedID = Request.QueryString["id"];
if (EvaluationManagementCtrl.GetEvaluateTable(evaluatedID, ref evaluateTable, ref exception))
{
ViewState["KeyWeight"] = evaluateTable.KeyWeight;
ViewState["ResponseWeight"] = evaluateTable.KeyWeight;
ViewState["QualifyWeight"] = evaluateTable.QualifyWeitht;
ViewState["AttitudeWeight"] = evaluateTable.AttitudeWeight;
ViewState["RejectWeight"] = evaluateTable.RejectWeight;
Label_EvaluatedName.Text = evaluateTable.EvaluatedName;
Label_PostName.Text = evaluateTable.PostName;
Label_LaborDep.Text = evaluateTable.LaborDep;
Label_LaborUnit.Text = evaluateTable.LaborUnit;
RadioButtonList_Relation.SelectedValue = Request.QueryString["relation"];
Label_Period.Text = evaluateTable.StartTime + " ~ " + evaluateTable.StopTime;
//关键岗位职责指标
DataTable table1 = new DataTable();
table1.Columns.Add("Title");
table1.Columns.Add("Quota");
foreach (Quota item in evaluateTable.KeyResponse)
{
table1.Rows.Add(item.Title, item.Content[0]);
}
Grid1.DataSource = table1;
Grid1.DataBind();
//关键岗位胜任能力指标
DataTable table2 = new DataTable();
table2.Columns.Add("Title");
table2.Columns.Add("Quota1");
table2.Columns.Add("Quota2");
table2.Columns.Add("Quota3");
table2.Columns.Add("Quota4");
foreach (Quota item in evaluateTable.KeyQualify)
{
table2.Rows.Add(item.Title, item.Content[0], item.Content[1], item.Content[2], item.Content[3]);
}
Grid2.DataSource = table2;
Grid2.DataBind();
//关键岗位工作态度指标
DataTable table3 = new DataTable();
table3.Columns.Add("Title");
table3.Columns.Add("Quota1");
table3.Columns.Add("Quota2");
table3.Columns.Add("Quota3");
table3.Columns.Add("Quota4");
foreach (Quota item in evaluateTable.KeyAttitude)
{
table3.Rows.Add(item.Title, item.Content[0], item.Content[1], item.Content[2], item.Content[3]);
}
Grid3.DataSource = table3;
Grid3.DataBind();
//岗位职责指标
DataTable table4 = new DataTable();
table4.Columns.Add("Title");
table4.Columns.Add("Quota");
foreach (Quota item in evaluateTable.Response)
{
table4.Rows.Add(item.Title, item.Content[0]);
}
Grid4.DataSource = table4;
Grid4.DataBind();
//岗位胜任能力指标
DataTable table5 = new DataTable();
table5.Columns.Add("Title");
table5.Columns.Add("Quota1");
table5.Columns.Add("Quota2");
table5.Columns.Add("Quota3");
table5.Columns.Add("Quota4");
foreach (Quota item in evaluateTable.Qualify)
{
table5.Rows.Add(item.Title, item.Content[0], item.Content[1], item.Content[2], item.Content[3]);
}
Grid5.DataSource = table5;
Grid5.DataBind();
//岗位工作态度指标
DataTable table6 = new DataTable();
table6.Columns.Add("Title");
table6.Columns.Add("Quota1");
table6.Columns.Add("Quota2");
table6.Columns.Add("Quota3");
table6.Columns.Add("Quota4");
foreach (Quota item in evaluateTable.Attitude)
{
table6.Rows.Add(item.Title, item.Content[0], item.Content[1], item.Content[2], item.Content[3]);
}
Grid6.DataSource = table6;
Grid6.DataBind();
//否决指标
DataTable table7 = new DataTable();
table7.Columns.Add("Title");
table7.Columns.Add("Quota");
table7.Rows.Add("严重违反规章制度", "累计旷工3天以上的；\n严重失职，营私舞弊，给本单位造成3000元以上经济损失或者其它严重后果的；\n同时与其他用人单位建立劳动关系，对完成本单位工作任务造成严重影响，或者经本单位提出，拒不改正的；\n违背职业道德，行贿、受贿价值超过3000元以上的；\n被依法追究刑事责任的；");
table7.Rows.Add(evaluateTable.Reject[0].Title, evaluateTable.Reject[0].Content[0]);
Grid7.DataSource = table7;
Grid7.DataBind();
System.Web.UI.WebControls.DropDownList ddl = Grid7.Rows[1].FindControl("DropDownList_Reject") as System.Web.UI.WebControls.DropDownList;
ddl.Visible = false;
}
}
protected void TabStrip2_TabIndexChanged(object sender, EventArgs e)
{
if (TabStrip2.ActiveTabIndex == 0)
{
}
else if (TabStrip2.ActiveTabIndex == 1)
{
//查询 拍照补录
// 1.获取数据总数
// Grid3.RecordCount = 700;//测试，去数据库获取总数
// 2.获取当前分页数据
DataSet ds = bll.拍照补录查询("");
DataTable dt = ds.Tables[0].Copy();//复制一份table
DataTable source = dt;
// 3.绑定到Grid
Grid3.DataSource = source;//DataTable
Grid3.DataBind();
}
else if (TabStrip2.ActiveTabIndex == 2)
{
DataSet dspk = bll.盘亏处理查询("");
DataTable dtpk = dspk.Tables[0].Copy(); //复制一份table
Grid4.DataSource = dtpk; //DataTable
Grid4.DataBind();
}
else if (TabStrip2.ActiveTabIndex == 3)
{
//Grid5
Grid5.DataSource = bll.查询盘点报告();//DataTable
Grid5.DataBind();
//绑定条件数据
List <School学校名称表> xxmc = bll.查询学校名称();
单位.DataTextField = "学校名称";
单位.DataValueField = "ID";
单位.DataSource = xxmc;
单位.DataBind();
School资产转移BLL bllzy = new School资产转移BLL();
List <School一级部门表> gsbm = bllzy.byzc();
部门.DataTextField = "名称";
部门.DataValueField = "ID";
部门.DataSource = gsbm;
部门.DataBind();
List <School一级类别表> yjlb = bll.查询一级类别();
一级.DataTextField = "名称";
一级.DataValueField = "ID";
一级.DataSource = yjlb;
一级.DataBind();
List <School建筑物信息表> 查询建筑物 = bll.查询建筑物信息表();
存放地点.DataTextField = "名称";
存放地点.DataValueField = "ID";
存放地点.DataSource = 查询建筑物;
存放地点.DataBind();
}
}
private void LoadDataList()
{
try
{
DataSet _DataList = null;
_DataList = DatabaseManager.Data.DBAccessManager.RetrieveDashBoardDataByEmpID(Int32.Parse(Page.User.Identity.Name.ToString()), Int32.Parse(businessUnitDDList.SelectedValue), Int32.Parse(DivisionLocationList.SelectedValue));
if (_DataList.Tables.Count > 0)
{
if (_DataList.Tables[0].Rows.Count > 0) // Employee Divisional Chart
{
DataTable _DataTable = _DataList.Tables[0];
Division_EmpListChart(_DataTable);
}
else
{
EmpListChart1.Items.Clear();
}
if (_DataList.Tables[1].Rows.Count > 0) // Employee Location Chart
{
DataTable _DataTable = _DataList.Tables[1];
Location_EmpListChart(_DataTable);
}
else
{
EmpListChart2.Items.Clear();
}
if (_DataList.Tables[2].Rows.Count > 0) // Employee Age Profile Chart
{
DataTable _DataTable = _DataList.Tables[2];
AgeProfile_EmpListChart(_DataTable);
}
else
{
EmpListChart3.Items.Clear();
}
if (_DataList.Tables[3].Rows.Count > 0) // Employee Service Profile Chart
{
DataTable _DataTable = _DataList.Tables[3];
ServiceProfile_EmpListChart(_DataTable);
}
else
{
EmpListChart4.Items.Clear();
}
if (_DataList.Tables[4].Rows.Count > 0) // Expiring Labor Cards in the next 6 months.
{
DataTable _DataTable = _DataList.Tables[4];
Grid3.DataSource = _DataTable;
Grid3.DataBind();
}
else
{
Grid3.DataSource = null;
Grid3.DataBind();
}
if (_DataList.Tables[5].Rows.Count > 0) // Expiring Visa in the next 6 months.
{
DataTable _DataTable = _DataList.Tables[5];
Grid4.DataSource = _DataTable;
Grid4.DataBind();
}
else
{
Grid4.DataSource = null;
Grid4.DataBind();
}
if (_DataList.Tables[6].Rows.Count > 0) // Expiring Passports in the next 6 months.
{
DataTable _DataTable = _DataList.Tables[6];
Grid5.DataSource = _DataTable;
Grid5.DataBind();
}
else
{
Grid5.DataSource = null;
Grid5.DataBind();
}
if (_DataList.Tables[7].Rows.Count > 0) // Pending Leave in the current week.
{
DataTable _DataTable = _DataList.Tables[7];
Grid1.DataSource = _DataTable;
Grid1.DataBind();
}
else
{
Grid1.DataSource = null;
Grid1.DataBind();
}
if (_DataList.Tables[8].Rows.Count > 0) // Upcoming Holidays
{
DataTable _DataTable = _DataList.Tables[8];
Grid2.DataSource = _DataTable;
Grid2.DataBind();
}
else
{
Grid2.DataSource = null;
Grid2.DataBind();
}
if (_DataList.Tables[10].Rows.Count > 0) // Upcoming Probation endings
{
DataTable _DataTable = _DataList.Tables[10];
Grid7.DataSource = _DataTable;
Grid7.DataBind();
}
else
{
Grid7.DataSource = null;
Grid7.DataBind();
}
if (_DataList.Tables[11].Rows.Count > 0) // Business Visa Expiry
{
DataTable _DataTable = _DataList.Tables[11];
Grid10.DataSource = _DataTable;
Grid10.DataBind();
}
else
{
Grid10.DataSource = null;
Grid10.DataBind();
}
}
}
catch (Exception exception)
{
ErrorLogging.LogError(exception, "Unknown Exception Occured. Please contact support.");
}
}
private void LoadDataList()
{
try
{
DataSet _DataList = null;
_DataList = DatabaseManager.Data.DBAccessManager.RetrieveDashBoardDataByEmpID(Int32.Parse(Page.User.Identity.Name.ToString()), Int32.Parse(businessUnitDDList.SelectedValue), Int32.Parse(DivisionLocationList.SelectedValue));
if (_DataList.Tables.Count > 0)
{
if (_DataList.Tables[0].Rows.Count > 0) // Employee Divisional PieChart
{
PieXML = "";
DataTable _DataTable = _DataList.Tables[0];
PieXML = CreatePieGraph1(_DataTable, "Employee Count Breakdown By Business Unit/Dept", "", "Count", "Division/Dept");
FCLiteral1.Text = FusionCharts.RenderChartHTML("../FusionCharts/FCF_Pie3D.swf", "", PieXML, "DivisionDeptChart", PieWidth, PieHeight, false);
}
else
{
FCLiteral1.Visible = false;
}
if (_DataList.Tables[1].Rows.Count > 0) // Employee Location PieChart
{
PieXML = "";
DataTable _DataTable = _DataList.Tables[1];
PieXML = CreatePieGraph1(_DataTable, "Employee Count Breakdown By Country", "", "Country", "Count");
FCLiteral2.Text = FusionCharts.RenderChartHTML("../FusionCharts/FCF_Pie3D.swf", "", PieXML, "CountryChart", PieWidth, PieHeight, false);
}
else
{
FCLiteral2.Visible = false;
}
if (_DataList.Tables[2].Rows.Count > 0) // Employee Age Profile PieChart
{
DataTable _DataTable = _DataList.Tables[2];
CreateBarGraph1(_DataTable);
}
else
{
FCLiteral3.Visible = false;
}
if (_DataList.Tables[3].Rows.Count > 0) // Employee Service Profile PieChart
{
PieXML = "";
DataTable _DataTable = _DataList.Tables[3];
PieXML = CreatePieGraph1(_DataTable, "Employee Service Year Profile", "", "Count", "Division/Dept");
FCLiteral4.Text = FusionCharts.RenderChartHTML("../FusionCharts/FCF_Pie3D.swf", "", PieXML, "ServiceChart", PieWidth, PieHeight, false);
}
else
{
FCLiteral4.Visible = false;
}
if (_DataList.Tables[4].Rows.Count > 0) // Expiring Labor Cards in the next 6 months.
{
DataTable _DataTable = _DataList.Tables[4];
Grid3.DataSource = _DataTable;
Grid3.DataBind();
}
else
{
Grid3.DataSource = null;
Grid3.DataBind();
}
if (_DataList.Tables[5].Rows.Count > 0) // Expiring Visa in the next 6 months.
{
DataTable _DataTable = _DataList.Tables[5];
Grid4.DataSource = _DataTable;
Grid4.DataBind();
}
else
{
Grid4.DataSource = null;
Grid4.DataBind();
}
if (_DataList.Tables[6].Rows.Count > 0) // Expiring Passports in the next 6 months.
{
DataTable _DataTable = _DataList.Tables[6];
Grid5.DataSource = _DataTable;
Grid5.DataBind();
}
else
{
Grid5.DataSource = null;
Grid5.DataBind();
}
if (_DataList.Tables[7].Rows.Count > 0) // Pending Leave in the current week.
{
DataTable _DataTable = _DataList.Tables[7];
Grid1.DataSource = _DataTable;
Grid1.DataBind();
}
else
{
Grid1.DataSource = null;
Grid1.DataBind();
}
if (_DataList.Tables[8].Rows.Count > 0) // Upcoming Holidays
{
DataTable _DataTable = _DataList.Tables[8];
Grid2.DataSource = _DataTable;
Grid2.DataBind();
}
else
{
Grid2.DataSource = null;
Grid2.DataBind();
}
if (_DataList.Tables[10].Rows.Count > 0) // Upcoming Probation endings
{
DataTable _DataTable = _DataList.Tables[10];
Grid7.DataSource = _DataTable;
Grid7.DataBind();
}
else
{
Grid7.DataSource = null;
Grid7.DataBind();
}
if (_DataList.Tables[11].Rows.Count > 0) // Business Visa Expiry
{
DataTable _DataTable = _DataList.Tables[11];
Grid10.DataSource = _DataTable;
Grid10.DataBind();
}
else
{
Grid10.DataSource = null;
Grid10.DataBind();
}
}
}
catch (Exception exception)
{
ErrorLogging.LogError(exception, "Unknown Exception Occured. Please contact support.");
}
}
protected void gridCallBack_Callback(object sender, CallBackEventArgs e)
{
hfMessage.Value = "";
int n = OrgList.SelectedIndex;
try
{
if (e.Parameters[0] != "")
{
if (e.Parameters[1] == "Up")
{
UpData(e.Parameters[0]);
}
else if (e.Parameters[1] == "Down")
{
DownData(e.Parameters[0]);
}
else
{
DeleteData(e.Parameters[0]);
}
}
else if (e.Parameters[0] == "")
{
BindGrid(n);
}
if (n == 0)
{
Grid1.RenderControl(e.Output);
}
else if (n == 1)
{
Grid2.RenderControl(e.Output);
}
else if (n == 2)
{
Grid3.RenderControl(e.Output);
}
else if (n == 3)
{
Grid4.RenderControl(e.Output);
}
else if (n == 4)
{
Grid5.RenderControl(e.Output);
}
else if (n == 5)
{
Grid6.RenderControl(e.Output);
}
else if (n == 6)
{
Grid7.RenderControl(e.Output);
}
else if (n == 7)
{
Grid8.RenderControl(e.Output);
}
else if (n == 8)
{
Grid9.RenderControl(e.Output);
}
else if (n == 9)
{
Grid10.RenderControl(e.Output);
}
else if (n == 10)
{
Grid11.RenderControl(e.Output);
}
else if (n == 11)
{
Grid12.RenderControl(e.Output);
}
else if (n == 12)
{
Grid13.RenderControl(e.Output);
}
else if (n == 13)
{
Grid14.RenderControl(e.Output);
}
}
catch
{
BindGrid(n);
}
hfMessage.RenderControl(e.Output);
}
private void BindGrid(int n)
{
if (n == 0)
{
EducationLevelBLL objBLL = new EducationLevelBLL();
IList <EducationLevel> objList = objBLL.GetAllEducationLevel();
Grid1.DataSource = objList;
Grid1.DataBind();
Grid1.Visible = true;
Grid2.Visible = false;
Grid3.Visible = false;
Grid4.Visible = false;
Grid5.Visible = false;
Grid6.Visible = false;
Grid7.Visible = false;
Grid8.Visible = false;
Grid9.Visible = false;
}
if (n == 1)
{
PoliticalStatusBLL objBLL = new PoliticalStatusBLL();
IList <PoliticalStatus> objList = objBLL.GetAllPoliticalStatus();
Grid2.DataSource = objList;
Grid2.DataBind();
Grid1.Visible = false;
Grid2.Visible = true;
Grid3.Visible = false;
Grid4.Visible = false;
Grid5.Visible = false;
Grid6.Visible = false;
Grid7.Visible = false;
Grid8.Visible = false;
Grid9.Visible = false;
}
if (n == 2)
{
WorkGroupLeaderLevelBLL objBLL = new WorkGroupLeaderLevelBLL();
IList <WorkGroupLeaderLevel> objList = objBLL.GetAllWorkGroupLeaderLevel();
Grid3.DataSource = objList;
Grid3.DataBind();
Grid1.Visible = false;
Grid2.Visible = false;
Grid3.Visible = true;
Grid4.Visible = false;
Grid5.Visible = false;
Grid6.Visible = false;
Grid7.Visible = false;
Grid8.Visible = false;
Grid9.Visible = false;
}
if (n == 3)
{
TechnicianTypeBLL objBLL = new TechnicianTypeBLL();
IList <TechnicianType> objList = objBLL.GetAllTechnicianType();
Grid4.DataSource = objList;
Grid4.DataBind();
Grid1.Visible = false;
Grid2.Visible = false;
Grid3.Visible = false;
Grid4.Visible = true;
Grid5.Visible = false;
Grid6.Visible = false;
Grid7.Visible = false;
Grid8.Visible = false;
Grid9.Visible = false;
}
if (n == 4)
{
TechnicianTitleTypeBLL objBLL = new TechnicianTitleTypeBLL();
IList <TechnicianTitleType> objList = objBLL.GetAllTechnicianTitleType();
Grid5.DataSource = objList;
Grid5.DataBind();
Grid1.Visible = false;
Grid2.Visible = false;
Grid3.Visible = false;
Grid4.Visible = false;
Grid5.Visible = true;
Grid6.Visible = false;
Grid7.Visible = false;
Grid8.Visible = false;
Grid9.Visible = false;
}
if (n == 5)
{
EducationEmployeeTypeBLL objBLL = new EducationEmployeeTypeBLL();
IList <EducationEmployeeType> objList = objBLL.GetAllEducationEmployeeType();
Grid6.DataSource = objList;
Grid6.DataBind();
Grid1.Visible = false;
Grid2.Visible = false;
Grid3.Visible = false;
Grid4.Visible = false;
Grid5.Visible = false;
Grid6.Visible = true;
Grid7.Visible = false;
Grid8.Visible = false;
Grid9.Visible = false;
}
if (n == 6)
{
CommitteeHeadShipBLL objBLL = new CommitteeHeadShipBLL();
IList <CommitteeHeadShip> objList = objBLL.GetAllCommitteeHeadShip();
Grid7.DataSource = objList;
Grid7.DataBind();
Grid1.Visible = false;
Grid2.Visible = false;
Grid3.Visible = false;
Grid4.Visible = false;
Grid5.Visible = false;
Grid6.Visible = false;
Grid7.Visible = true;
Grid8.Visible = false;
Grid9.Visible = false;
}
if (n == 7)
{
RandomExamModularTypeBLL objBLL = new RandomExamModularTypeBLL();
IList <RandomExamModularType> objList = objBLL.GetAllRandomExamModularType();
Grid8.DataSource = objList;
Grid8.DataBind();
Grid1.Visible = false;
Grid2.Visible = false;
Grid3.Visible = false;
Grid4.Visible = false;
Grid5.Visible = false;
Grid6.Visible = false;
Grid7.Visible = false;
Grid8.Visible = true;
Grid9.Visible = false;
}
if (n == 8)
{
OracleAccess oracle = new OracleAccess();
DataTable dt = oracle.RunSqlDataSet("select * from zj_trainplan_type order by trainplan_type_id").Tables[0];
Grid9.DataSource = dt;
Grid9.DataBind();
Grid1.Visible = false;
Grid2.Visible = false;
Grid3.Visible = false;
Grid4.Visible = false;
Grid5.Visible = false;
Grid6.Visible = false;
Grid7.Visible = false;
Grid8.Visible = false;
Grid9.Visible = true;
}
if (n == 9)
{
OracleAccess oracle = new OracleAccess();
DataTable dt = oracle.RunSqlDataSet("select * from zj_safe_level order by order_index").Tables[0];
Grid10.DataSource = dt;
Grid10.DataBind();
Grid1.Visible = false;
Grid2.Visible = false;
Grid3.Visible = false;
Grid4.Visible = false;
Grid5.Visible = false;
Grid6.Visible = false;
Grid7.Visible = false;
Grid8.Visible = false;
Grid9.Visible = false;
Grid10.Visible = true;
}
if (n == 10)
{
OracleAccess oracle = new OracleAccess();
DataTable dt = oracle.RunSqlDataSet("select * from zj_certificate order by order_index").Tables[0];
Grid11.DataSource = dt;
Grid11.DataBind();
Grid1.Visible = false;
Grid2.Visible = false;
Grid3.Visible = false;
Grid4.Visible = false;
Grid5.Visible = false;
Grid6.Visible = false;
Grid7.Visible = false;
Grid8.Visible = false;
Grid9.Visible = false;
Grid10.Visible = false;
Grid11.Visible = true;
}
if (n == 11)
{
OracleAccess oracle = new OracleAccess();
DataTable dt = oracle.RunSqlDataSet(@"select a.*,b.certificate_name from zj_certificate_level a
left join zj_certificate b on a.certificate_id=b.certificate_id order by a.order_index").Tables[0];
Grid12.DataSource = dt;
Grid12.DataBind();
Grid1.Visible = false;
Grid2.Visible = false;
Grid3.Visible = false;
Grid4.Visible = false;
Grid5.Visible = false;
Grid6.Visible = false;
Grid7.Visible = false;
Grid8.Visible = false;
Grid9.Visible = false;
Grid10.Visible = false;
Grid11.Visible = false;
Grid12.Visible = true;
}
if (n == 12)
{
OracleAccess oracle = new OracleAccess();
DataTable dt = oracle.RunSqlDataSet(" select * from zj_certificate_unit order by order_index").Tables[0];
Grid13.DataSource = dt;
Grid13.DataBind();
Grid1.Visible = false;
Grid2.Visible = false;
Grid3.Visible = false;
Grid4.Visible = false;
Grid5.Visible = false;
Grid6.Visible = false;
Grid7.Visible = false;
Grid8.Visible = false;
Grid9.Visible = false;
Grid10.Visible = false;
Grid11.Visible = false;
Grid12.Visible = false;
Grid13.Visible = true;
}
if (n == 13)
{
OracleAccess oracle = new OracleAccess();
DataTable dt = oracle.RunSqlDataSet(" select * from zj_train_unit order by order_index").Tables[0];
Grid14.DataSource = dt;
Grid14.DataBind();
Grid1.Visible = false;
Grid2.Visible = false;
Grid3.Visible = false;
Grid4.Visible = false;
Grid5.Visible = false;
Grid6.Visible = false;
Grid7.Visible = false;
Grid8.Visible = false;
Grid9.Visible = false;
Grid10.Visible = false;
Grid11.Visible = false;
Grid12.Visible = false;
Grid13.Visible = false;
Grid14.Visible = true;
}
}
//确认申报
protected void Button1_Click(object sender, EventArgs e)
{
if (类别.SelectedValue.ToString() == "待报废")
{
if (类别.SelectedValue.ToString() == "待报废")
{
OffSession();
string 职务 = Session["职务"].ToString();
List <int> intlist = new List <int>();
int[] selections = Grid2.SelectedRowIndexArray;
Console.Write(selections.Length);
if (selections.Length == 0)
{
Alert.Show("请选择");
}
else
{
Window2.Hidden = false;
Console.Write(selections);
foreach (int rowIndex in selections)
{
int ID = Convert.ToInt32(Grid2.DataKeys[rowIndex][0]);
intlist.Add(ID);
}
List <School办公设备信息表> listdata = bll.资产申报确定设备(intlist, 类别.SelectedValue);
string flowstate = 类别.SelectedValue;
//int 总数 = 0;
//int 总价 = 0;
float 总数 = 0.0f;
float 总价 = 0.0f;
if (listdata != null)
{
foreach (School办公设备信息表 itemjj in listdata)
{
总数 += itemjj.数量;
总价 += Convert.ToInt32(itemjj.价格);
}
}
Grid3.DataSource = listdata;//DataTable
Grid3.DataBind();
Grid4.DataSource = listdata;//DataTable
Grid4.DataBind();
JObject summary = new JObject();
//summary.Add("major", "全部合计");
summary.Add("数量", 总数.ToString("F2"));
summary.Add("价格", 总价.ToString("F2"));
Grid3.SummaryData = summary;
Grid4.SummaryData = summary;
//Grid7.SummaryData = summary;
//Grid8.SummaryData = summary;
//待报废Grid3
报废流程状态.Text = "待审核";
报废流程状态.Enabled = false;
报废_申报单位.Text = Session["二级部门名称"].ToString();
报废_申报单位.Enabled = false;
报废_申报日期.Text = DateTime.Now.ToShortDateString();
报废单据编号.Text = SchoolUtility.strbumber("ZCCZBF");;
报废单据编号.Enabled = false;
报废_申请人.Text = HttpContext.Current.Session["姓名"].ToString();
报废_申请人.Enabled = false;
报废_职务.Text = 职务;
报废_职务.Enabled = false;
}
}
}
else if (类别.SelectedValue.ToString() == "待调拨")
{
OffSession();
string 职务 = Session["职务"].ToString();
if (职务 == "资产管理员")
{
School清查盘点BLL pdbll = new School清查盘点BLL();
List <School一级部门表> xxmc = SchoolUtility.查询一级部门不带全部();;
调拨调入单位.DataTextField = "名称";
调拨调入单位.DataValueField = "ID";
调拨调入单位.DataSource = xxmc;
调拨调入单位.DataBind();
List <int> intlist = new List <int>();
int[] selections = Grid2.SelectedRowIndexArray;
if (selections.Length == 0)
{
Alert.Show("请选择");
}
else
{
Window3.Hidden = false;
foreach (int rowIndex in selections)
{
int ID = Convert.ToInt32(Grid2.DataKeys[rowIndex][0]);
intlist.Add(ID);
}
List <School办公设备信息表> listdata = bll.资产申报确定设备(intlist, 类别.SelectedValue);
string flowstate = 类别.SelectedValue;
Grid5.DataSource = listdata;//DataTable
Grid5.DataBind();
Grid6.DataSource = listdata;
Grid6.DataBind();
//当前用户部门是调出单位 调入单位操作人选填
调拨流程状态.Text = "待审核";
调拨流程状态.Enabled = false;
调拨调出单位.Text = Session["二级部门名称"].ToString();
调拨调出单位.Enabled = false;
调拨申报日期.Text = DateTime.Now.ToShortDateString();
调拨验收日期.Text = DateTime.Now.ToShortDateString();
DateTime dt = DateTime.Now;
string y = dt.Year.ToString();
string m = dt.Month.ToString();
string d = dt.Day.ToString();
string h = dt.Hour.ToString();
string mm = dt.Minute.ToString();
调拨单据编号.Text = SchoolUtility.strbumber("ZCCZDB");
调拨单据编号.Enabled = false;
调拨_申请人.Text = HttpContext.Current.Session["姓名"].ToString();
调拨_申请人.Enabled = false;
调拨职务.Enabled = false;
调拨电话.Enabled = false;
调拨职务.Text = HttpContext.Current.Session["职务"].ToString();
try
{
调拨电话.Text = HttpContext.Current.Session["联系电话"].ToString();
}
catch (Exception)
{
调拨电话.Text = "";
}
}
}
else
{
Alert.Show("您没有资产处置-调拨处理的权限，请联系资产管理员", MessageBoxIcon.Warning);
}
}
}
