protected void btn_submit_Click(object sender, EventArgs e) { if (FilesAdd.PostedFile != null && FilesAdd.PostedFile.ContentLength > 0) { //string fn = System.IO.Path.GetFileName(FileAdd.PostedFile.FileName); string fn = string.Format("{0:yyyyMMddHHmmssffff}", DateTime.Now) + "_" + System.IO.Path.GetFileName(FilesAdd.PostedFile.FileName); string SaveLocation = Server.MapPath("LeaveFiles") + "\\" + fn; try { FilesAdd.PostedFile.SaveAs(SaveLocation); txt_FilesAdd = SaveLocation; //Response.Write("The file has been uploaded."); ShowMsgHelper.Alert("The file has been uploaded."); } catch (Exception ex) { //Response.Write("Error: " + ex.Message); ShowMsgHelper.Alert_Error("Error: " + ex.Message); } } else { //Response.Write("Please select a file to upload."); ShowMsgHelper.Alert_Wern("Please select a file to upload."); } }
protected void Page_Load(object sender, EventArgs e) { _key = Request["key"]; txt_EmpID = RequestSession.GetSessionUser().UserId.ToString(); txt_EmpName = RequestSession.GetSessionUser().UserName.ToString(); if (!IsPostBack) { string sql = "select * from uvw_doLeaveDays where EmpID='" + txt_EmpID + "' "; StringBuilder sb_sql = new StringBuilder(sql); DataTable dt = DataFactory.SqlDataBase().GetDataTableBySQL(sb_sql); CJform.Visible = false; if (dt != null && dt.Rows.Count > 0) { flo_njDays = float.Parse(dt.Rows[0].ItemArray[1].ToString()); flo_txDays = float.Parse(dt.Rows[0].ItemArray[2].ToString()); } else { flo_njDays = 0; flo_txDays = 0; } if (!string.IsNullOrEmpty(_key)) { sql = "select ApprovalFlag,FilesAdd from Base_PerLeaveApply where id='" + _key + "'"; sb_sql = new StringBuilder(sql); dt = DataFactory.SqlDataBase().GetDataTableBySQL(sb_sql); if (dt.Rows[0].ItemArray[0] != null) { int_AppFlag = int.Parse(dt.Rows[0].ItemArray[0].ToString()); InitData(); if (int_AppFlag != 0 && int_AppFlag != 3) { Save.Visible = false; ShowMsgHelper.Alert_Wern("Read Only!"); } if (dt.Rows[0].ItemArray[1] == null || dt.Rows[0].ItemArray[1].ToString().Length == 0) { DownFiles.Visible = false; } else { DownFiles.Visible = true; txt_downFilesAdd = dt.Rows[0].ItemArray[1].ToString(); } } else { ShowMsgHelper.Alert_Wern("Data Error!"); } } } }
private void bind(string fileName) { string strConn = "Provider=Microsoft.Jet.OLEDB.4.0;" + "Data Source=" + fileName + ";" + "Extended Properties='Excel 8.0; HDR=Yes; IMEX=1'"; OleDbDataAdapter da = new OleDbDataAdapter("SELECT * FROM [Sheet1$]", strConn); DataSet ds = new DataSet(); try { da.Fill(ds); dt = ds.Tables[0]; this.GV_OriData.DataSource = dt; this.GV_OriData.DataBind(); InsertToDB(); } catch (Exception err) { ShowMsgHelper.Alert_Wern("Error!" + err.ToString()); } }
protected void Reject_Click(object sender, EventArgs e) { string txt_Remark = ""; int int_AppStatus = 3; //if (txt_NextApprover == null || txt_NextApprover.Length <= 0) //{ // int_AppStatus = 2; // txt_NextApprover = ""; //} //else //{ // int_AppStatus = 1; //} string sql1 = "update Base_PerLeaveApply set ApprovalFlag=" + int_AppStatus + " where id='" + _key + "' "; StringBuilder sb_sql1 = new StringBuilder(sql1); int i1 = DataFactory.SqlDataBase().ExecuteBySql(sb_sql1); if (i1 > 0) { string Cur_Date = DateTime.Now.ToString("yyyy-MM-dd"); string sql2 = "insert into Base_PerLeaveApplyDetail(PAid,ApproverId,ApprovalStatus,ApprovalRemark,ApprovalDate) "; sql2 = sql2 + "select " + _key + ",'" + txt_EmpID + "'," + int_AppStatus + ",'" + txt_Remark + "','" + Cur_Date + "' "; StringBuilder sb_sql2 = new StringBuilder(sql2); int i2 = DataFactory.SqlDataBase().ExecuteBySql(sb_sql2); if (i2 > 0) { ShowMsgHelper.AlertMsg("Success"); } else { ShowMsgHelper.Alert_Wern("Error"); } } else { ShowMsgHelper.Alert_Wern("Error"); } }
protected void Save_Click(object sender, EventArgs e) { btnLeaveDays_Click(null, null); int intMaxPerTime = 9999; int intMaxPerYear = 9999; int intMustFile = 0; String yy = DateTime.Now.Year.ToString(); String mm = DateTime.Now.Month.ToString(); String days = DateTime.DaysInMonth(int.Parse(yy), int.Parse(mm)).ToString(); DateTime FirstDay = DateTime.Parse(yy + "/" + mm + "/1"); DateTime LastDay = FirstDay.AddYears(1); float floAllLeaveDays = 0; string sqlii = "select isnull(SUM(leavedays),0) as leavedays from Base_PerLeaveApply where EmpID='" + txt_EmpID + "' and LeaveID=" + LeaveID.SelectedValue + " and BeginDate>='" + FirstDay + "' and EndDate<'" + LastDay + "' and ApprovalFlag=2"; StringBuilder sb_sqlii = new StringBuilder(sqlii); DataTable dtii = DataFactory.SqlDataBase().GetDataTableBySQL(sb_sqlii); if (dtii != null && dtii.Rows.Count > 0) { floAllLeaveDays = float.Parse(dtii.Rows[0].ItemArray[0].ToString()); } string sqli = "select * from Base_ATS_LeaveSetting where id=" + LeaveID.SelectedValue; StringBuilder sb_sqli = new StringBuilder(sqli); DataTable dti = DataFactory.SqlDataBase().GetDataTableBySQL(sb_sqli); if (dti != null && dti.Rows.Count > 0) { if (int.Parse(dti.Rows[0].ItemArray[2].ToString()) > 0) { intMaxPerTime = int.Parse(dti.Rows[0].ItemArray[2].ToString()); } if (int.Parse(dti.Rows[0].ItemArray[3].ToString()) > 0) { intMaxPerYear = int.Parse(dti.Rows[0].ItemArray[3].ToString()); } if (int.Parse(dti.Rows[0].ItemArray[4].ToString()) > 0) { intMustFile = int.Parse(dti.Rows[0].ItemArray[4].ToString()); } } else { ShowMsgHelper.Alert_Error("System Error,Call Admin"); } DateTimeFormatInfo dtFormat = new System.Globalization.DateTimeFormatInfo(); dtFormat.ShortDatePattern = "yyyy/MM/dd"; if ((Convert.ToDateTime(BeginDate.Text, dtFormat) > Convert.ToDateTime(EndDate.Text, dtFormat)) || (Convert.ToDateTime(BeginDate.Text, dtFormat) == Convert.ToDateTime(EndDate.Text, dtFormat) && BeginFlag.Value == "0" && EndFlag.Value == "0")) { ShowMsgHelper.Alert_Wern("Date Error"); } else { if (intMustFile == 1 && (txt_FilesAdd == null || txt_FilesAdd == "")) { ShowMsgHelper.Alert_Wern("Must Upload the Proof Files!"); } else { if (float.Parse(LeaveDays.Text) > intMaxPerTime || floAllLeaveDays > intMaxPerYear) { ShowMsgHelper.Alert_Wern("Over the Limit!!"); } else { if (LeaveID.SelectedValue == "7" && float.Parse(LeaveDays.Text) > float.Parse(njDays.Text)) { ShowMsgHelper.Alert_Wern("Over the number of AL!"); } else { Hashtable ht = new Hashtable(); ht = ControlBindHelper.GetWebControls(this.Page); //ht["EmpID"] = txt_EmpID; //ht["CreateDate"] = CreateDate.Text; //ht["ApprovalFlag"] = 0; if (int_AppFlag == 3) { ht["ApprovalFlag"] = 1; } //ht["NextApprover"] = txt_NextApprover; ht["LeaveID"] = LeaveID.SelectedValue; ht["FilesAdd"] = txt_FilesAdd; ht["LeaveDays"] = LeaveDays.Text; if (cbNC.Checked == true) { ht["NCJ"] = 1; } else { ht["NCJ"] = 0; } if (cbDBT.Checked == true) { ht["DBT"] = 1; ht["DBTnum"] = DBT.Text; } else { ht["DBT"] = 0; ht["DBTnum"] = 0; } int IsOk = DataFactory.SqlDataBase().UpdateByHashtable("Base_PerLeaveApply", "id", _key, ht); if (IsOk > 0) { ShowMsgHelper.AlertMsg("Success!"); } else { ShowMsgHelper.Alert_Error("Error!"); } } } } } }
private string AutoApproval(string strApproverID, string _key) { string strResult = ""; string txt_NextApprover = ""; //CallDays(); string sql1 = "select Boss_id from Base_UserInfo where user_id='" + strApproverID + "'"; StringBuilder sb_sql1 = new StringBuilder(sql1); DataTable dt1 = DataFactory.SqlDataBase().GetDataTableBySQL(sb_sql1); if (dt1.Rows[0].ItemArray[0] != null) { txt_NextApprover = dt1.Rows[0].ItemArray[0].ToString(); } else { txt_NextApprover = ""; } string txt_Remark = ""; int int_AppStatus = 99; if (txt_NextApprover == null || txt_NextApprover.Length <= 0) { int_AppStatus = 2; txt_NextApprover = ""; } else { int_AppStatus = 1; } //txt_Remark = ApprovalRemark.InnerText; flotxDays = float.Parse(txDays.Text); sql1 = "update Base_PerTravelApply set ApprovalFlag=" + int_AppStatus + ",NextApprover='" + txt_NextApprover + "' where id='" + _key + "' "; sb_sql1 = new StringBuilder(sql1); int i1 = DataFactory.SqlDataBase().ExecuteBySql(sb_sql1); if (i1 > 0) { string Cur_Date = DateTime.Now.ToString("yyyy-MM-dd"); string sql2 = "insert into Base_PerTravelApplyDetail(PTid,ApproverId,ApprovalStatus,ApprovalRemark,ApprovalDate) "; sql2 = sql2 + "select " + _key + ",'" + strApproverID + "'," + int_AppStatus + ",'" + txt_Remark + "','" + Cur_Date + "' "; StringBuilder sb_sql2 = new StringBuilder(sql2); int i2 = DataFactory.SqlDataBase().ExecuteBySql(sb_sql2); if (i2 > 0) { GenModel gm = new GenModel(); if (txt_NextApprover != null && txt_NextApprover != "" && gm.GetEMailFromID(txt_NextApprover) != "" && gm.GetEMailFromID(txt_NextApprover) != null) { gm.SendMail2(gm.GetEMailFromID(txt_NextApprover), "You have a new Task!", "You have a new Task!"); } if (gm.GetEMailFromID(txt_EmpID) != null) { gm.SendMail2(gm.GetEMailFromID(txt_EmpID), "Your TraveList has been updated!", "Your TraveList has been updated!"); } if (txt_NextApprover == null || txt_NextApprover == "") { string sql3 = "update Base_LeaveConsole set SYTX=SYTX+" + flotxDays + " where EmpID='" + txt_EmpID + "' "; StringBuilder sb_sql3 = new StringBuilder(sql3); int i3 = DataFactory.SqlDataBase().ExecuteBySql(sb_sql3); } ShowMsgHelper.AlertMsg("Success"); } else { ShowMsgHelper.Alert_Wern("Error"); } } else { ShowMsgHelper.Alert_Wern("Error"); } strResult = txt_NextApprover; return(strResult); }
protected void Pass_Click(object sender, EventArgs e) { string txt_Remark = ""; int int_AppStatus = 99; if (txt_NextApprover == null || txt_NextApprover.Length <= 0) { int_AppStatus = 2; txt_NextApprover = ""; } else { int_AppStatus = 1; } txt_Remark = ApprovalRemark.InnerText; string sql1 = "update Base_PerLeaveApply set ApprovalFlag=" + int_AppStatus + ",NextApprover='" + txt_NextApprover + "' where id='" + _key + "' "; StringBuilder sb_sql1 = new StringBuilder(sql1); int i1 = DataFactory.SqlDataBase().ExecuteBySql(sb_sql1); if (i1 > 0) { string Cur_Date = DateTime.Now.ToString("yyyy-MM-dd"); string sql2 = "insert into Base_PerLeaveApplyDetail(PAid,ApproverId,ApprovalStatus,ApprovalRemark,ApprovalDate) "; sql2 = sql2 + "select " + _key + ",'" + txt_EmpID + "'," + int_AppStatus + ",'" + txt_Remark + "','" + Cur_Date + "' "; StringBuilder sb_sql2 = new StringBuilder(sql2); int i2 = DataFactory.SqlDataBase().ExecuteBySql(sb_sql2); if (i2 > 0) { GenModel gm = new GenModel(); if (txt_NextApprover != null && txt_NextApprover != "" && gm.GetEMailFromID(txt_NextApprover) != "" && gm.GetEMailFromID(txt_NextApprover) != null) { gm.SendMail2(gm.GetEMailFromID(txt_NextApprover), "You have a new Task!", "You have a new Task!"); } if (gm.GetEMailFromID(strUserID) != null) { gm.SendMail2(gm.GetEMailFromID(strUserID), "Your LeaveList has been updated!", "Your LeaveList has been updated!"); } if (txt_NextApprover == null || txt_NextApprover == "") { } else { //string strNextApprover = AutoApproval(txt_NextApprover, _key); string strNextApprover = txt_NextApprover; while (BLisAutoApproval(strNextApprover)) { strNextApprover = AutoApproval(strNextApprover, _key); } } ShowMsgHelper.AlertMsg("Success"); } else { ShowMsgHelper.Alert_Wern("Error"); } } else { ShowMsgHelper.Alert_Wern("Error"); } }
protected void Save_Click(object sender, EventArgs e) { btnLeaveDays_Click(null, null); int intMaxPerTime = 9999; int intMaxPerYear = 9999; int intMustFile = 0; string strNextApprover = ""; String yy = DateTime.Now.Year.ToString(); String mm = DateTime.Now.Month.ToString(); String days = DateTime.DaysInMonth(int.Parse(yy), int.Parse(mm)).ToString(); DateTime FirstDay = DateTime.Parse(yy + "/" + mm + "/1"); DateTime LastDay = FirstDay.AddYears(1); float floAllLeaveDays = 0; string sqlii = "select isnull(SUM(leavedays),0) as leavedays from Base_PerLeaveApply where EmpID='" + txt_EmpID + "' and LeaveID=" + LeaveID.SelectedValue + " and BeginDate>='" + FirstDay + "' and EndDate<'" + LastDay + "' and ApprovalFlag=2"; StringBuilder sb_sqlii = new StringBuilder(sqlii); DataTable dtii = DataFactory.SqlDataBase().GetDataTableBySQL(sb_sqlii); if (dtii != null && dtii.Rows.Count > 0) { floAllLeaveDays = float.Parse(dtii.Rows[0].ItemArray[0].ToString()); } string sqli = "select * from Base_ATS_LeaveSetting where id=" + LeaveID.SelectedValue; StringBuilder sb_sqli = new StringBuilder(sqli); DataTable dti = DataFactory.SqlDataBase().GetDataTableBySQL(sb_sqli); if (dti != null && dti.Rows.Count > 0) { if (int.Parse(dti.Rows[0].ItemArray[2].ToString()) > 0) { intMaxPerTime = int.Parse(dti.Rows[0].ItemArray[2].ToString()); } if (int.Parse(dti.Rows[0].ItemArray[3].ToString()) > 0) { intMaxPerYear = int.Parse(dti.Rows[0].ItemArray[3].ToString()); } if (int.Parse(dti.Rows[0].ItemArray[4].ToString()) > 0) { intMustFile = int.Parse(dti.Rows[0].ItemArray[4].ToString()); } } else { ShowMsgHelper.Alert_Error("System Error,Call Admin"); } DateTimeFormatInfo dtFormat = new System.Globalization.DateTimeFormatInfo(); dtFormat.ShortDatePattern = "yyyy/MM/dd"; if ((Convert.ToDateTime(BeginDate.Text, dtFormat) > Convert.ToDateTime(EndDate.Text, dtFormat)) || (Convert.ToDateTime(BeginDate.Text, dtFormat) == Convert.ToDateTime(EndDate.Text, dtFormat) && BeginFlag.Value == "0" && EndFlag.Value == "0")) { ShowMsgHelper.Alert_Wern("Date Error"); } else { if (intMustFile == 1 && (txt_FilesAdd == null || txt_FilesAdd == "")) { ShowMsgHelper.Alert_Wern("Must Upload the Proof Files!"); } else { if (float.Parse(LeaveDays.Text) > intMaxPerTime || floAllLeaveDays > intMaxPerYear) { ShowMsgHelper.Alert_Wern("Over the Limit!"); } else { if (LeaveID.SelectedValue == "7" && float.Parse(LeaveDays.Text) > float.Parse(njDays.Text)) { ShowMsgHelper.Alert_Wern("Over the number of AL!"); } else { string txt_NextApprover = ""; string sql = "select Boss_id from Base_UserInfo where user_id='" + txt_EmpID + "'"; StringBuilder sb_sql = new StringBuilder(sql); DataTable dt = DataFactory.SqlDataBase().GetDataTableBySQL(sb_sql); if (strHRid != "0000") { txt_NextApprover = strHRid; } else { if (dt.Rows[0].ItemArray[0] != null) { txt_NextApprover = dt.Rows[0].ItemArray[0].ToString();; } } Hashtable ht = new Hashtable(); ht = ControlBindHelper.GetWebControls(this.Page); ht["EmpID"] = txt_EmpID; ht["CreateDate"] = CreateDate.Text; ht["ApprovalFlag"] = 0; ht["NextApprover"] = txt_NextApprover; ht["LeaveID"] = LeaveID.SelectedValue; ht["FilesAdd"] = txt_FilesAdd; ht["LeaveDays"] = LeaveDays.Text; if (cbNC.Checked == true) { ht["NCJ"] = 1; } else { ht["NCJ"] = 0; } if (cbDBT.Checked == true) { ht["DBT"] = 1; ht["DBTnum"] = DBT.Text; } else { ht["DBT"] = 0; ht["DBTnum"] = 0; } int IsOk = DataFactory.SqlDataBase().InsertByHashtableReturnPkVal("Base_PerLeaveApply", ht); if (IsOk > 0) { //GenModel gm = new GenModel(); //string strMailResult = gm.SendMail("*****@*****.**", "*****@*****.**", "MailTest", "MailTest"); //if (strMailResult != "发送成功!") //{ // ShowMsgHelper.AlertMsg(strMailResult); //} GenModel gm = new GenModel(); if (txt_NextApprover != null && txt_NextApprover != "" && gm.GetEMailFromID(txt_NextApprover) != "" && gm.GetEMailFromID(txt_NextApprover) != null) { gm.SendMail2(gm.GetEMailFromID(txt_NextApprover), "You have a new Task!", "You have a new Task!"); } if (gm.GetEMailFromID(txt_EmpID) != null) { gm.SendMail2(gm.GetEMailFromID(txt_EmpID), "Your LeaveList has been updated!", "Your LeaveList has been updated!"); } if (BLisAutoApproval(txt_NextApprover)) { string strsql = "select id from Base_PerLeaveApply where EmpID='" + txt_EmpID + "' and LeaveID='" + LeaveID.SelectedValue + "' and BeginDate='" + BeginDate.Text + "' and EndDate='" + EndDate.Text + "' and CreateDate='" + CreateDate.Text + "' "; StringBuilder sbsql = new StringBuilder(strsql); DataTable dtsql = DataFactory.SqlDataBase().GetDataTableBySQL(sbsql); string strid = dtsql.Rows[0].ItemArray[0].ToString(); strNextApprover = AutoApproval(txt_NextApprover, strid); while (BLisAutoApproval(strNextApprover)) { strNextApprover = AutoApproval(strNextApprover, strid); } } ShowMsgHelper.AlertMsg("Success!"); } else { ShowMsgHelper.Alert_Error("Error!"); } } } } } }