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);
}
private void BindGrid6()
{
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()));
Grid6.DataSource = dt;
Grid6.DataBind();
}
//protected void Button7_Click(object sender, EventArgs e)
//{
// //string selectedId = Tree1.SelectedNodeID;
// //if (!String.IsNullOrEmpty(selectedId))
// //{
// // string message = "选中的节点：" + Tree1.FindNode(selectedId).Text;
// // //Alert.Show(message);
// //}
// //else
// //{
// // Alert.Show("chengg！");
// //}
//}
protected void Tree1_NodeCommand(object sender, TreeCommandEventArgs e)
{
//int id = Convert.ToInt32(e.Node.NodeID);
DataSet ds = bll.筛选存放地点(Convert.ToInt32(e.Node.NodeID));
DataTable dt = ds.Tables[0].Copy();//复制一份table
DataTable source = dt;
// 3.绑定到Grid
Grid6.DataSource = source;//DataTable
Grid6.DataBind();
//Alert.Show(e.Node.NodeID);
}
private void BindGrid6(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 [USER_NAME],PRECOUNTS,COUNTS,CONVERT(decimal(16,2),(CASE WHEN PRECOUNTS>0 THEN (CONVERT(decimal(16,2),COUNTS)/CONVERT(decimal(16,2),PRECOUNTS)*100) ELSE COUNTS END)) AS 'PCTS'
FROM (
SELECT [USER_NAME]
,(SELECT COUNT(*) FROM [UOF].[dbo].[TB_EIP_SCH_WORK]
WHERE [SUBJECT] LIKE '%拜訪%'
AND CONVERT(nvarchar,[START_TIME],111)>=@SDATE AND CONVERT(nvarchar,[START_TIME],111)<=@EDATE
AND [EXECUTE_USER]=[USER_GUID]) AS PRECOUNTS
,COUNT([COMPANY_NAME] ) 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'
GROUP BY [USER_NAME] ,[USER_GUID]
) AS TEMP
WHERE [USER_NAME] COLLATE Chinese_Taiwan_Stroke_CI_AS IN (SELECT [USER_NAME] FROM [HJ_BM_DB].[dbo].[COPSALES])
ORDER BY [USER_NAME]
";
m_db.AddParameter("@SDATE", SDATE);
m_db.AddParameter("@EDATE", EDATE);
DataTable dt = new DataTable();
dt.Load(m_db.ExecuteReader(cmdTxt));
Grid6.DataSource = dt;
Grid6.DataBind();
}
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 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);
}
}
}
