my_list.aspx.cs
资源名称:web.rar [点击查看]
上传用户:xrffrp
上传日期:2022-03-25
资源大小:22155k
文件大小:18k
源码类别:
OA系统
开发平台:
ASP/ASPX
- using System;
- using System.Data;
- using System.Configuration;
- using System.Collections;
- using System.Web;
- using System.Web.Security;
- using System.Web.UI;
- using System.Web.UI.WebControls;
- using System.Web.UI.WebControls.WebParts;
- using System.Web.UI.HtmlControls;
- using System.Data.SqlClient;
- public partial class web_approvel_ch_my_list : System.Web.UI.Page
- {
- protected void Page_Load(object sender, EventArgs e)
- {
- if (!IsPostBack)
- {
- LoginDAO.CheckLogin(Session, Response, "../../", 2);
- ApprovelList.DataKeyNames = new string[] { "id" };
- OffList.DataKeyNames = new string[] { "id" };
- if (Request.QueryString["a_id"]!=null)
- {
- PnlApprovel.Visible = true;
- PnlFlow.Visible = true;
- FlowList.DataKeyNames = new string[] { "id" };
- this.SetValue(Request.QueryString["a_id"]);
- }
- if (Request.QueryString["o_id"] != null)
- {
- PnlOffFlow.Visible = true;
- PnlOffForm.Visible = true;
- OffFlowList.DataKeyNames = new string[] { "id" };
- this.SetOffValue(Request.QueryString["o_id"]);
- }
- if (Session["user"] != null)
- {
- User user = (User)Session["user"];
- DepartmentId.Value = user.Department.Id.ToString();
- PositionId.Value = user.PositionId.ToString();
- }
- }
- }
- protected void SetValue(string id)
- {
- SqlConnection conn = dbConnection.getConnection();
- conn.Open();
- SqlCommand cmd = new SqlCommand("select a.form_id, e.emp_name, e.emp_no, p.name position, a.apply_date," +
- "d.name department, a.days, a.begin_time, a.end_time, f1.name depart_place, f2.name arrive_place, " +
- "a.depart_time, a.arrive_time, a.state from OA_CH_BUSINESS_FORM a inner join OA_EMPLOYEE e on a.emp_id=e.id " +
- "inner join OA_DEPARTMENT d on a.department_id=d.id inner join OA_EMPLOYEE_POSITION p on " +
- "e.position=p.id inner join OA_FLIGHT_PLACE f1 on a.depart_place=f1.id inner join " +
- "OA_FLIGHT_PLACE f2 on a.arrive_place=f2.id where a.id=" + id, conn);
- SqlDataReader dr = cmd.ExecuteReader();
- int state = 0;
- if (dr.Read())
- {
- TxtFormId.Text = dr["form_id"].ToString();
- TxtEmpName.Text = dr["emp_name"].ToString();
- TxtEmpNo.Text = dr["emp_no"].ToString();
- TxtPosition.Text = dr["position"].ToString();
- TxtApplyDate.Text = dr["apply_date"].ToString();
- TxtDepartment.Text = dr["department"].ToString();
- TxtDays.Text = dr["days"].ToString();
- TxtBeginTime.Text = dr["begin_time"].ToString();
- TxtEndTime.Text = dr["end_time"].ToString();
- TxtDepartPlace.Text = dr["depart_place"].ToString();
- TxtArrivePlace.Text = dr["arrive_place"].ToString();
- TxtDepartTime.Text = dr["depart_time"].ToString();
- TxtArriveTime.Text = dr["arrive_time"].ToString();
- state = Convert.ToInt32(dr["state"].ToString());
- State.Value = state.ToString();
- }
- dr.Close();
- int flag = 0;
- cmd = new SqlCommand("select number, company, subject, linkman, tel, place, visa_begin, visa_end, "+
- "flight_go_begin, flight_back_end, is_aboard, remark from OA_CH_BUSINESS_DETAIL where form_id="+id+
- " order by number", conn);
- dr = cmd.ExecuteReader();
- while (dr.Read())
- {
- flag = 1;
- //動態創建表格行
- TableRow tr1 = new TableRow();
- TableCell td1 = new TableCell();
- td1.BorderWidth = Unit.Pixel(1);
- Label label = new Label();
- label.BorderStyle = BorderStyle.None;
- label.Text = dr["number"].ToString();
- td1.Controls.Add(label);
- tr1.Cells.Add(td1);
- TableCell td2 = new TableCell();
- td2.BorderWidth = Unit.Pixel(1);
- label = new Label();
- label.BorderStyle = BorderStyle.None;
- label.Text = dr["company"].ToString();
- td2.Controls.Add(label);
- tr1.Cells.Add(td2);
- TableCell td3 = new TableCell();
- td3.BorderWidth = Unit.Pixel(1);
- label = new Label();
- label.BorderStyle = BorderStyle.None;
- label.Text = dr["subject"].ToString();
- td3.Controls.Add(label);
- tr1.Cells.Add(td3);
- TableCell td4 = new TableCell();
- td4.BorderWidth = Unit.Pixel(1);
- label = new Label();
- label.BorderStyle = BorderStyle.None;
- label.Text = dr["linkman"].ToString();
- td4.Controls.Add(label);
- tr1.Cells.Add(td4);
- TableCell td5 = new TableCell();
- td5.BorderWidth = Unit.Pixel(1);
- label = new Label();
- label.BorderStyle = BorderStyle.None;
- label.Text = dr["tel"].ToString();
- td5.Controls.Add(label);
- tr1.Cells.Add(td5);
- TableCell td6 = new TableCell();
- td6.BorderWidth = Unit.Pixel(1);
- label = new Label();
- label.BorderStyle = BorderStyle.None;
- label.Text = dr["place"].ToString();
- td6.Controls.Add(label);
- tr1.Cells.Add(td6);
- TableCell td7 = new TableCell();
- td7.BorderWidth = Unit.Pixel(1);
- label = new Label();
- label.BorderStyle = BorderStyle.None;
- label.Text = dr["visa_begin"].ToString();
- td7.Controls.Add(label);
- tr1.Cells.Add(td7);
- TableCell td8 = new TableCell();
- td8.BorderWidth = Unit.Pixel(1);
- label = new Label();
- label.BorderStyle = BorderStyle.None;
- label.Text = dr["visa_end"].ToString();
- td8.Controls.Add(label);
- tr1.Cells.Add(td8);
- TableCell td9 = new TableCell();
- td9.BorderWidth = Unit.Pixel(1);
- label = new Label();
- label.BorderStyle = BorderStyle.None;
- label.Text = dr["flight_go_begin"].ToString();
- td9.Controls.Add(label);
- tr1.Cells.Add(td9);
- TableCell td10 = new TableCell();
- td10.BorderWidth = Unit.Pixel(1);
- label = new Label();
- label.BorderStyle = BorderStyle.None;
- label.Text = dr["flight_back_end"].ToString();
- td10.Controls.Add(label);
- tr1.Cells.Add(td10);
- TableCell td11 = new TableCell();
- td11.BorderWidth = Unit.Pixel(1);
- CheckBox chk = new CheckBox();
- chk.Text = "國外";
- chk.Enabled = false;
- if (dr["is_aboard"].ToString().Equals("Y"))
- {
- chk.Checked = true;
- }
- else
- {
- chk.Checked = false;
- }
- td11.Controls.Add(chk);
- tr1.Cells.Add(td11);
- TableCell td12 = new TableCell();
- td12.BorderWidth = Unit.Pixel(1);
- label = new Label();
- label.BorderStyle = BorderStyle.None;
- label.Text = dr["remark"].ToString();
- td12.Controls.Add(label);
- tr1.Cells.Add(td12);
- TblDetail.Rows.Add(tr1);
- }
- dr.Close();
- conn.Close();
- if (flag == 0)
- {
- TblDetail.Visible = false;
- }
- if (state != 1)
- {
- PnlFlow.Visible = false;
- Panel1.Visible = true;
- }
- }
- protected void SetOffValue(string id)
- {
- SqlConnection conn = dbConnection.getConnection();
- conn.Open();
- SqlCommand cmd = new SqlCommand("select o.form_id, e.emp_no, e.emp_name, d.name department, "+
- "e.emp_name delegate, e.position position, o.state, "+
- "t.name off_type, o.begin_time, o.end_time, o.hours, o.apply_date, o.parenthesis, "+
- "o.reason from OA_CH_OFF_FORM o inner join OA_EMPLOYEE e on o.emp_id=e.id inner join "+
- "OA_DEPARTMENT d on o.department_id=d.id inner join OA_CH_OFF_TYPE t on "+
- "o.off_type=t.id where o.id="+id, conn);
- SqlDataReader dr = cmd.ExecuteReader();
- int state = 0;
- if (dr.Read())
- {
- TxtOffFormId.Text = dr["form_id"].ToString();
- TxtOffEmpName.Text = dr["emp_no"].ToString() + dr["emp_name"].ToString();
- TxtOffDepartment.Text = dr["department"].ToString();
- TxtDelegate.Text = dr["delegate"].ToString();
- TxtOffPosition.Text = dr["position"].ToString();
- TxtOffType2.Text = dr["off_type"].ToString();
- TxtOffBeginTime.Text = dr["begin_time"].ToString();
- TxtOffEndTime.Text = dr["end_time"].ToString();
- TxtHours.Text = dr["hours"].ToString();
- TxtOffApplyDate.Text = dr["apply_date"].ToString();
- TxtParenthesis.Text = dr["parenthesis"].ToString();
- TxtReason.Text = dr["reason"].ToString();
- state = Convert.ToInt32(dr["state"].ToString());
- State.Value = state.ToString();
- }
- dr.Close();
- if (state != 1)
- {
- PnlOffFlow.Visible = false;
- Panel2.Visible = true;
- }
- conn.Close();
- }
- protected void ApprovelList_RowDataBound(object sender, GridViewRowEventArgs e)
- {
- //行高亮
- if (e.Row.RowType == DataControlRowType.DataRow)
- {
- e.Row.Attributes.Add("onmouseover", "this.style.cursor='pointer';");
- e.Row.Attributes.Add("onclick", "location.href='my_list.aspx?a_id=" + ApprovelList.DataKeys[e.Row.RowIndex].Value.ToString() + "'");
- }
- }
- protected void FlowList_RowCreated(object sender, GridViewRowEventArgs e)
- {
- if (e.Row.RowType == DataControlRowType.DataRow)
- {
- SqlConnection conn = dbConnection.getConnection();
- conn.Open();
- SqlCommand cmd = new SqlCommand("select apply_type, is_check, is_agree, comment from " +
- "OA_CH_APPROVEL_FORM_FLOW where id=" + FlowList.DataKeys[e.Row.RowIndex].Value.ToString(), conn);
- SqlDataReader dr = cmd.ExecuteReader();
- if (dr.Read())
- {
- Label label = (Label)e.Row.FindControl("LblApplyType");
- if (dr["apply_type"].ToString().Equals("1"))
- {
- label.Text = "會簽";
- }
- else
- {
- label.Text = "審批";
- }
- label = (Label)e.Row.FindControl("LblIsCheck");
- if (dr["is_check"].ToString().Equals("N"))
- {
- label.Text = "未處理";
- }
- else
- {
- label.Text = "已處理";
- label = (Label)e.Row.FindControl("LblIsAgree");
- if (dr["is_agree"].ToString().Equals("Y"))
- {
- label.Text = "已同意";
- }
- else
- {
- label.Text = "不同意";
- }
- }
- label = (Label)e.Row.FindControl("LblComment");
- label.Text = dr["comment"].ToString();
- }
- dr.Close();
- conn.Close();
- }
- }
- protected void OffList_RowDataBound(object sender, GridViewRowEventArgs e)
- {
- //行高亮
- if (e.Row.RowType == DataControlRowType.DataRow)
- {
- e.Row.Attributes.Add("onmouseover", "this.style.cursor='pointer';");
- e.Row.Attributes.Add("onclick", "location.href='my_list.aspx?o_id=" + OffList.DataKeys[e.Row.RowIndex].Value.ToString() + "'");
- }
- }
- protected void OffFlowList_RowCreated(object sender, GridViewRowEventArgs e)
- {
- if (e.Row.RowType == DataControlRowType.DataRow)
- {
- SqlConnection conn = dbConnection.getConnection();
- conn.Open();
- SqlCommand cmd = new SqlCommand("select apply_type, is_check, is_agree, comment from " +
- "OA_CH_APPROVEL_FORM_FLOW where id=" + OffFlowList.DataKeys[e.Row.RowIndex].Value.ToString(), conn);
- SqlDataReader dr = cmd.ExecuteReader();
- if (dr.Read())
- {
- Label label = (Label)e.Row.FindControl("LblApplyType");
- if (dr["apply_type"].ToString().Equals("1"))
- {
- label.Text = "會簽";
- }
- else
- {
- label.Text = "審批";
- }
- label = (Label)e.Row.FindControl("LblIsCheck");
- if (dr["is_check"].ToString().Equals("N"))
- {
- label.Text = "未處理";
- }
- else
- {
- label.Text = "已處理";
- label = (Label)e.Row.FindControl("LblIsAgree");
- if (dr["is_agree"].ToString().Equals("Y"))
- {
- label.Text = "已同意";
- }
- else
- {
- label.Text = "不同意";
- }
- }
- label = (Label)e.Row.FindControl("LblComment");
- label.Text = dr["comment"].ToString();
- }
- dr.Close();
- conn.Close();
- }
- }
- protected void BtnOk_Click(object sender, EventArgs e)
- {
- if (Request.QueryString["a_id"] != null)
- {
- string id = Request.QueryString["a_id"];
- SqlConnection conn = dbConnection.getConnection();
- conn.Open();
- if (State.Value.Equals("2"))
- {
- SqlTransaction tx = conn.BeginTransaction();
- try
- {
- SqlCommand cmd = new SqlCommand("update OA_CH_BUSINESS_FORM set state=1, total_result='跑流程中' where id=" + id, conn);
- cmd.Transaction = tx;
- cmd.ExecuteNonQuery();
- ArrayList name1 = new ArrayList();
- ArrayList mail1 = new ArrayList();
- cmd = new SqlCommand("select top 1 a.email_work,a.emp_name from oa_employee as a inner join " +
- "oa_ch_approvel_form_flow as b on b.operator_id=a.id left join OA_ch_business_form as c " +
- "on b.form_id=c.id where b.step=c.step+1 and c.id=" + id + " order by position desc", conn);
- cmd.Transaction = tx;
- SqlDataReader dr3 = cmd.ExecuteReader();
- while (dr3.Read())
- {
- name1.Add(dr3["emp_name"].ToString());
- mail1.Add(dr3["email_work"].ToString());
- //mail.mail_q(mail1[0], name1[0], TxtEmpName.Text, "中幹出差申請單");
- }
- dr3.Close();
- tx.Commit();
- }
- catch (Exception ex)
- {
- Response.Write(ex.Message);
- tx.Rollback();
- }
- }
- else
- {
- SqlCommand cmd = new SqlCommand("update OA_CH_BUSINESS_FORM set state=1, total_result='跑流程中' where id=" + id, conn);
- cmd.ExecuteNonQuery();
- }
- conn.Close();
- Response.Redirect("my_list.aspx");
- }
- }
- protected void BtnOk2_Click(object sender, EventArgs e)
- {
- if (Request.QueryString["o_id"] != null)
- {
- string id = Request.QueryString["o_id"];
- SqlConnection conn = dbConnection.getConnection();
- conn.Open();
- if (State.Value.Equals("2"))
- {
- SqlTransaction tx = conn.BeginTransaction();
- try
- {
- SqlCommand cmd = new SqlCommand("update OA_CH_OFF_FORM set state=1, total_result='跑流程中' where id=" + id, conn);
- cmd.Transaction = tx;
- cmd.ExecuteNonQuery();
- ArrayList name1 = new ArrayList();
- ArrayList mail1 = new ArrayList();
- cmd = new SqlCommand("select top 1 a.email_work,a.emp_name from oa_employee as a inner join " +
- "oa_ch_approvel_form_flow as b on b.operator_id=a.id left join OA_ch_off_form as c " +
- "on b.form_id=c.id where b.step=c.step+1 and c.id=" + id + " order by position desc", conn);
- cmd.Transaction = tx;
- SqlDataReader dr3 = cmd.ExecuteReader();
- while (dr3.Read())
- {
- name1.Add(dr3["emp_name"].ToString());
- mail1.Add(dr3["email_work"].ToString());
- //mail.mail_q(mail1[0], name1[0], TxtEmpName.Text, "中幹請假單");
- } dr3.Close();
- tx.Commit();
- //
- }
- catch (Exception ex)
- {
- Response.Write(ex.Message);
- tx.Rollback();
- }
- }
- else
- {
- SqlCommand cmd = new SqlCommand("update OA_CH_OFF_FORM set state=1, total_result='跑流程中' where id=" + id, conn);
- cmd.ExecuteNonQuery();
- Response.Redirect("my_list.aspx");
- }
- conn.Close();
- }
- }
- }