protected void ButtonImportSave_Click(object sender, EventArgs e) { try { string strFilePath = GetImpFileName(); if (strFilePath == string.Empty) { return; } this.dataSet = new DataSet(); this.dataSet.Clear(); this.dataSet.Tables.Add("WFM_Import"); this.dataSet.Tables["WFM_Import"].Columns.Add(new DataColumn("ErrorMsg", typeof(string))); this.dataSet.Tables["WFM_Import"].Columns.Add(new DataColumn("orgcode", typeof(string))); this.dataSet.Tables["WFM_Import"].Columns.Add(new DataColumn("orgname", typeof(string))); this.dataSet.Tables["WFM_Import"].Columns.Add(new DataColumn("billtypename", typeof(string))); this.dataSet.Tables["WFM_Import"].Columns.Add(new DataColumn("Overtimetype", typeof(string))); this.dataSet.Tables["WFM_Import"].Columns.Add(new DataColumn("LeaveDays", typeof(string))); this.dataSet.Tables["WFM_Import"].Columns.Add(new DataColumn("Shiwei", typeof(string))); this.dataSet.Tables["WFM_Import"].Columns.Add(new DataColumn("Manger", typeof(string))); this.dataSet.Tables["WFM_Import"].Columns.Add(new DataColumn("leaveType", typeof(string))); this.dataSet.Tables["WFM_Import"].Columns.Add(new DataColumn("outtype", typeof(string))); this.dataSet.Tables["WFM_Import"].Columns.Add(new DataColumn("outtypeDays", typeof(string))); this.dataSet.Tables["WFM_Import"].Columns.Add(new DataColumn("auditman1", typeof(string))); this.dataSet.Tables["WFM_Import"].Columns.Add(new DataColumn("localname1", typeof(string))); this.dataSet.Tables["WFM_Import"].Columns.Add(new DataColumn("audittypename1", typeof(string))); this.dataSet.Tables["WFM_Import"].Columns.Add(new DataColumn("auditmantype1", typeof(string))); this.dataSet.Tables["WFM_Import"].Columns.Add(new DataColumn("auditman2", typeof(string))); this.dataSet.Tables["WFM_Import"].Columns.Add(new DataColumn("localname2", typeof(string))); this.dataSet.Tables["WFM_Import"].Columns.Add(new DataColumn("audittypename2", typeof(string))); this.dataSet.Tables["WFM_Import"].Columns.Add(new DataColumn("auditmantype2", typeof(string))); this.dataSet.Tables["WFM_Import"].Columns.Add(new DataColumn("auditman3", typeof(string))); this.dataSet.Tables["WFM_Import"].Columns.Add(new DataColumn("localname3", typeof(string))); this.dataSet.Tables["WFM_Import"].Columns.Add(new DataColumn("audittypename3", typeof(string))); this.dataSet.Tables["WFM_Import"].Columns.Add(new DataColumn("auditmantype3", typeof(string))); this.dataSet.Tables["WFM_Import"].Columns.Add(new DataColumn("auditman4", typeof(string))); this.dataSet.Tables["WFM_Import"].Columns.Add(new DataColumn("localname4", typeof(string))); this.dataSet.Tables["WFM_Import"].Columns.Add(new DataColumn("audittypename4", typeof(string))); this.dataSet.Tables["WFM_Import"].Columns.Add(new DataColumn("auditmantype4", typeof(string))); this.dataSet.Tables["WFM_Import"].Columns.Add(new DataColumn("auditman5", typeof(string))); this.dataSet.Tables["WFM_Import"].Columns.Add(new DataColumn("localname5", typeof(string))); this.dataSet.Tables["WFM_Import"].Columns.Add(new DataColumn("audittypename5", typeof(string))); this.dataSet.Tables["WFM_Import"].Columns.Add(new DataColumn("auditmantype5", typeof(string))); this.dataSet.Tables["WFM_Import"].Columns.Add(new DataColumn("auditman6", typeof(string))); this.dataSet.Tables["WFM_Import"].Columns.Add(new DataColumn("localname6", typeof(string))); this.dataSet.Tables["WFM_Import"].Columns.Add(new DataColumn("audittypename6", typeof(string))); this.dataSet.Tables["WFM_Import"].Columns.Add(new DataColumn("auditmantype6", typeof(string))); this.dataSet.Tables["WFM_Import"].Columns.Add(new DataColumn("auditman7", typeof(string))); this.dataSet.Tables["WFM_Import"].Columns.Add(new DataColumn("localname7", typeof(string))); this.dataSet.Tables["WFM_Import"].Columns.Add(new DataColumn("audittypename7", typeof(string))); this.dataSet.Tables["WFM_Import"].Columns.Add(new DataColumn("auditmantype7", typeof(string))); this.dataSet.Tables["WFM_Import"].Columns.Add(new DataColumn("auditman8", typeof(string))); this.dataSet.Tables["WFM_Import"].Columns.Add(new DataColumn("localname8", typeof(string))); this.dataSet.Tables["WFM_Import"].Columns.Add(new DataColumn("audittypename8", typeof(string))); this.dataSet.Tables["WFM_Import"].Columns.Add(new DataColumn("auditmantype8", typeof(string))); this.dataSet.Tables["WFM_Import"].Columns.Add(new DataColumn("auditman9", typeof(string))); this.dataSet.Tables["WFM_Import"].Columns.Add(new DataColumn("localname9", typeof(string))); this.dataSet.Tables["WFM_Import"].Columns.Add(new DataColumn("audittypename9", typeof(string))); this.dataSet.Tables["WFM_Import"].Columns.Add(new DataColumn("auditmantype9", typeof(string))); this.dataSet.Tables["WFM_Import"].Columns.Add(new DataColumn("auditman10", typeof(string))); this.dataSet.Tables["WFM_Import"].Columns.Add(new DataColumn("localname10", typeof(string))); this.dataSet.Tables["WFM_Import"].Columns.Add(new DataColumn("audittypename10", typeof(string))); this.dataSet.Tables["WFM_Import"].Columns.Add(new DataColumn("auditmantype10", typeof(string))); this.dataSet.Tables["WFM_Import"].Columns.Add(new DataColumn("auditman11", typeof(string))); this.dataSet.Tables["WFM_Import"].Columns.Add(new DataColumn("localname11", typeof(string))); this.dataSet.Tables["WFM_Import"].Columns.Add(new DataColumn("audittypename11", typeof(string))); this.dataSet.Tables["WFM_Import"].Columns.Add(new DataColumn("auditmantype11", typeof(string))); this.dataSet.Tables["WFM_Import"].Columns.Add(new DataColumn("auditman12", typeof(string))); this.dataSet.Tables["WFM_Import"].Columns.Add(new DataColumn("localname12", typeof(string))); this.dataSet.Tables["WFM_Import"].Columns.Add(new DataColumn("audittypename12", typeof(string))); this.dataSet.Tables["WFM_Import"].Columns.Add(new DataColumn("auditmantype12", typeof(string))); this.dataSet.Tables["WFM_Import"].Columns.Add(new DataColumn("auditman13", typeof(string))); this.dataSet.Tables["WFM_Import"].Columns.Add(new DataColumn("localname13", typeof(string))); this.dataSet.Tables["WFM_Import"].Columns.Add(new DataColumn("audittypename13", typeof(string))); this.dataSet.Tables["WFM_Import"].Columns.Add(new DataColumn("auditmantype13", typeof(string))); this.dataSet.Tables["WFM_Import"].Columns.Add(new DataColumn("auditman14", typeof(string))); this.dataSet.Tables["WFM_Import"].Columns.Add(new DataColumn("localname14", typeof(string))); this.dataSet.Tables["WFM_Import"].Columns.Add(new DataColumn("audittypename14", typeof(string))); this.dataSet.Tables["WFM_Import"].Columns.Add(new DataColumn("auditmantype14", typeof(string))); this.dataSet.Tables["WFM_Import"].Columns.Add(new DataColumn("auditman15", typeof(string))); this.dataSet.Tables["WFM_Import"].Columns.Add(new DataColumn("localname15", typeof(string))); this.dataSet.Tables["WFM_Import"].Columns.Add(new DataColumn("audittypename15", typeof(string))); this.dataSet.Tables["WFM_Import"].Columns.Add(new DataColumn("auditmantype15", typeof(string))); this.dataSet.Tables["WFM_Import"].Columns.Add(new DataColumn("auditman16", typeof(string))); this.dataSet.Tables["WFM_Import"].Columns.Add(new DataColumn("localname16", typeof(string))); this.dataSet.Tables["WFM_Import"].Columns.Add(new DataColumn("audittypename16", typeof(string))); this.dataSet.Tables["WFM_Import"].Columns.Add(new DataColumn("auditmantype16", typeof(string))); this.dataSet.Tables["WFM_Import"].Columns.Add(new DataColumn("auditman17", typeof(string))); this.dataSet.Tables["WFM_Import"].Columns.Add(new DataColumn("localname17", typeof(string))); this.dataSet.Tables["WFM_Import"].Columns.Add(new DataColumn("audittypename17", typeof(string))); this.dataSet.Tables["WFM_Import"].Columns.Add(new DataColumn("auditmantype17", typeof(string))); this.dataSet.Tables["WFM_Import"].Columns.Add(new DataColumn("auditman18", typeof(string))); this.dataSet.Tables["WFM_Import"].Columns.Add(new DataColumn("localname18", typeof(string))); this.dataSet.Tables["WFM_Import"].Columns.Add(new DataColumn("audittypename18", typeof(string))); this.dataSet.Tables["WFM_Import"].Columns.Add(new DataColumn("auditmantype18", typeof(string))); this.dataSet.Tables["WFM_Import"].Columns.Add(new DataColumn("auditman19", typeof(string))); this.dataSet.Tables["WFM_Import"].Columns.Add(new DataColumn("localname19", typeof(string))); this.dataSet.Tables["WFM_Import"].Columns.Add(new DataColumn("audittypename19", typeof(string))); this.dataSet.Tables["WFM_Import"].Columns.Add(new DataColumn("auditmantype19", typeof(string))); this.dataSet.Tables["WFM_Import"].Columns.Add(new DataColumn("auditman20", typeof(string))); this.dataSet.Tables["WFM_Import"].Columns.Add(new DataColumn("localname20", typeof(string))); this.dataSet.Tables["WFM_Import"].Columns.Add(new DataColumn("audittypename20", typeof(string))); this.dataSet.Tables["WFM_Import"].Columns.Add(new DataColumn("auditmantype20", typeof(string))); string OrgCode = string.Empty; string OrgName = string.Empty; string BillTypeName = string.Empty; string errorMsg = string.Empty; string Overtimetype = string.Empty; string LeaveDays = string.Empty; string Shiwei = string.Empty; string Manger = string.Empty; string leaveType = string.Empty; string outtype = string.Empty; string outtypeDays = string.Empty; string[,] AuditMan = new string[20, 4]; string WorkNo = string.Empty; string AuditTypeName = string.Empty; string AuditManType = string.Empty; string AuditMan1 = string.Empty; string LocalName1 = string.Empty; string AuditTypeName1 = string.Empty; string AuditManType1 = string.Empty; string AuditMan2 = string.Empty; string LocalName2 = string.Empty; string AuditTypeName2 = string.Empty; string AuditManType2 = string.Empty; string AuditMan3 = string.Empty; string LocalName3 = string.Empty; string AuditTypeName3 = string.Empty; string AuditManType3 = string.Empty; string AuditMan4 = string.Empty; string LocalName4 = string.Empty; string AuditTypeName4 = string.Empty; string AuditManType4 = string.Empty; string AuditMan5 = string.Empty; string LocalName5 = string.Empty; string AuditTypeName5 = string.Empty; string AuditManType5 = string.Empty; string AuditMan6 = string.Empty; string LocalName6 = string.Empty; string AuditTypeName6 = string.Empty; string AuditManType6 = string.Empty; string AuditMan7 = string.Empty; string LocalName7 = string.Empty; string AuditTypeName7 = string.Empty; string AuditManType7 = string.Empty; string AuditMan8 = string.Empty; string LocalName8 = string.Empty; string AuditTypeName8 = string.Empty; string AuditManType8 = string.Empty; string AuditMan9 = string.Empty; string LocalName9 = string.Empty; string AuditTypeName9 = string.Empty; string AuditManType9 = string.Empty; string AuditMan10 = string.Empty; string LocalName10 = string.Empty; string AuditTypeName10 = string.Empty; string AuditManType10 = string.Empty; string AuditMan11 = string.Empty; string LocalName11 = string.Empty; string AuditTypeName11 = string.Empty; string AuditManType11 = string.Empty; string AuditMan12 = string.Empty; string LocalName12 = string.Empty; string AuditTypeName12 = string.Empty; string AuditManType12 = string.Empty; string AuditMan13 = string.Empty; string LocalName13 = string.Empty; string AuditTypeName13 = string.Empty; string AuditManType13 = string.Empty; string AuditMan14 = string.Empty; string LocalName14 = string.Empty; string AuditTypeName14 = string.Empty; string AuditManType14 = string.Empty; string AuditMan15 = string.Empty; string LocalName15 = string.Empty; string AuditTypeName15 = string.Empty; string AuditManType15 = string.Empty; string AuditMan16 = string.Empty; string LocalName16 = string.Empty; string AuditTypeName16 = string.Empty; string AuditManType16 = string.Empty; string AuditMan17 = string.Empty; string LocalName17 = string.Empty; string AuditTypeName17 = string.Empty; string AuditManType17 = string.Empty; string AuditMan18 = string.Empty; string LocalName18 = string.Empty; string AuditTypeName18 = string.Empty; string AuditManType18 = string.Empty; string AuditMan19 = string.Empty; string LocalName19 = string.Empty; string AuditTypeName19 = string.Empty; string AuditManType19 = string.Empty; string AuditMan20 = string.Empty; string LocalName20 = string.Empty; string AuditTypeName20 = string.Empty; string AuditManType20 = string.Empty; HSSFWorkbook hssfworkbook; StringBuilder sb = new StringBuilder(20000); using (Stream fileStream = new FileStream(strFilePath, FileMode.Open)) { hssfworkbook = new HSSFWorkbook(fileStream); } Sheet insertSheet = hssfworkbook.GetSheet("Sheet1"); int nRows = 1; int index = 0; int errorCount = 0; while (insertSheet.GetRow(nRows) != null) { try { Row dr = insertSheet.GetRow(nRows); OrgCode = dr.GetCell(0) == null ? string.Empty : dr.GetCell(0).ToString().Trim(); OrgName = dr.GetCell(1) == null ? string.Empty : dr.GetCell(1).ToString().Trim(); BillTypeName = dr.GetCell(2) == null ? string.Empty : dr.GetCell(2).ToString().Trim(); Overtimetype = dr.GetCell(3) == null ? string.Empty : dr.GetCell(3).ToString().Trim(); LeaveDays = dr.GetCell(4) == null ? string.Empty : dr.GetCell(4).ToString().Trim(); if (LeaveDays != string.Empty) { LeaveDays = LeaveDays.Substring(0, LeaveDays.IndexOf("[")); } Shiwei = dr.GetCell(5) == null ? string.Empty : dr.GetCell(5).ToString().Trim(); if (Shiwei != string.Empty) { Shiwei = Shiwei.Substring(0, Shiwei.IndexOf("[")); } Manger = dr.GetCell(6) == null ? string.Empty : dr.GetCell(6).ToString().Trim(); if (Manger != string.Empty) { Manger = Manger.Substring(0, Manger.IndexOf("[")); } leaveType = dr.GetCell(7) == null ? string.Empty : dr.GetCell(7).ToString().Trim(); if (leaveType != string.Empty) { leaveType = leaveType.Substring(0, leaveType.IndexOf("[")); } outtype = dr.GetCell(8) == null ? string.Empty : dr.GetCell(8).ToString().Trim(); if (outtype != string.Empty) { outtype = outtype.Substring(0, outtype.IndexOf("[")); } outtypeDays = dr.GetCell(9) == null ? string.Empty : dr.GetCell(9).ToString().Trim(); if (outtypeDays != string.Empty) { outtypeDays = outtypeDays.Substring(0, outtypeDays.IndexOf("[")); } AuditMan1 = dr.GetCell(10) == null ? string.Empty : dr.GetCell(10).ToString().Trim(); AuditMan1 = dr.GetCell(11) == null ? string.Empty : dr.GetCell(11).ToString().Trim(); LocalName1 = dr.GetCell(12) == null ? string.Empty : dr.GetCell(12).ToString().Trim(); AuditTypeName1 = dr.GetCell(13) == null ? string.Empty : dr.GetCell(13).ToString().Trim(); AuditManType1 = dr.GetCell(14) == null ? string.Empty : dr.GetCell(14).ToString().Trim(); AuditMan2 = dr.GetCell(15) == null ? string.Empty : dr.GetCell(15).ToString().Trim(); LocalName2 = dr.GetCell(16) == null ? string.Empty : dr.GetCell(16).ToString().Trim(); AuditTypeName2 = dr.GetCell(17) == null ? string.Empty : dr.GetCell(17).ToString().Trim(); AuditManType2 = dr.GetCell(18) == null ? string.Empty : dr.GetCell(18).ToString().Trim(); AuditMan3 = dr.GetCell(19) == null ? string.Empty : dr.GetCell(19).ToString().Trim(); LocalName3 = dr.GetCell(20) == null ? string.Empty : dr.GetCell(20).ToString().Trim(); AuditTypeName3 = dr.GetCell(21) == null ? string.Empty : dr.GetCell(21).ToString().Trim(); AuditManType3 = dr.GetCell(22) == null ? string.Empty : dr.GetCell(22).ToString().Trim(); AuditMan4 = dr.GetCell(23) == null ? string.Empty : dr.GetCell(23).ToString().Trim(); LocalName4 = dr.GetCell(24) == null ? string.Empty : dr.GetCell(24).ToString().Trim(); AuditTypeName4 = dr.GetCell(25) == null ? string.Empty : dr.GetCell(25).ToString().Trim(); AuditManType4 = dr.GetCell(26) == null ? string.Empty : dr.GetCell(26).ToString().Trim(); AuditMan5 = dr.GetCell(27) == null ? string.Empty : dr.GetCell(27).ToString().Trim(); LocalName5 = dr.GetCell(28) == null ? string.Empty : dr.GetCell(28).ToString().Trim(); AuditTypeName5 = dr.GetCell(29) == null ? string.Empty : dr.GetCell(29).ToString().Trim(); AuditManType5 = dr.GetCell(30) == null ? string.Empty : dr.GetCell(30).ToString().Trim(); AuditMan6 = dr.GetCell(31) == null ? string.Empty : dr.GetCell(31).ToString().Trim(); LocalName6 = dr.GetCell(32) == null ? string.Empty : dr.GetCell(32).ToString().Trim(); AuditTypeName6 = dr.GetCell(33) == null ? string.Empty : dr.GetCell(33).ToString().Trim(); AuditManType6 = dr.GetCell(34) == null ? string.Empty : dr.GetCell(34).ToString().Trim(); AuditMan7 = dr.GetCell(35) == null ? string.Empty : dr.GetCell(35).ToString().Trim(); LocalName7 = dr.GetCell(36) == null ? string.Empty : dr.GetCell(36).ToString().Trim(); AuditTypeName7 = dr.GetCell(37) == null ? string.Empty : dr.GetCell(37).ToString().Trim(); AuditManType7 = dr.GetCell(38) == null ? string.Empty : dr.GetCell(38).ToString().Trim(); AuditMan8 = dr.GetCell(39) == null ? string.Empty : dr.GetCell(39).ToString().Trim(); LocalName8 = dr.GetCell(40) == null ? string.Empty : dr.GetCell(40).ToString().Trim(); AuditTypeName8 = dr.GetCell(41) == null ? string.Empty : dr.GetCell(41).ToString().Trim(); AuditManType8 = dr.GetCell(42) == null ? string.Empty : dr.GetCell(42).ToString().Trim(); AuditMan9 = dr.GetCell(43) == null ? string.Empty : dr.GetCell(43).ToString().Trim(); LocalName9 = dr.GetCell(44) == null ? string.Empty : dr.GetCell(44).ToString().Trim(); AuditTypeName9 = dr.GetCell(45) == null ? string.Empty : dr.GetCell(45).ToString().Trim(); AuditManType9 = dr.GetCell(46) == null ? string.Empty : dr.GetCell(46).ToString().Trim(); AuditMan10 = dr.GetCell(47) == null ? string.Empty : dr.GetCell(47).ToString().Trim(); LocalName10 = dr.GetCell(48) == null ? string.Empty : dr.GetCell(48).ToString().Trim(); AuditTypeName10 = dr.GetCell(49) == null ? string.Empty : dr.GetCell(49).ToString().Trim(); AuditManType10 = dr.GetCell(50) == null ? string.Empty : dr.GetCell(50).ToString().Trim(); AuditMan11 = dr.GetCell(51) == null ? string.Empty : dr.GetCell(51).ToString().Trim(); LocalName11 = dr.GetCell(52) == null ? string.Empty : dr.GetCell(52).ToString().Trim(); AuditTypeName11 = dr.GetCell(53) == null ? string.Empty : dr.GetCell(53).ToString().Trim(); AuditManType11 = dr.GetCell(54) == null ? string.Empty : dr.GetCell(54).ToString().Trim(); AuditMan12 = dr.GetCell(55) == null ? string.Empty : dr.GetCell(55).ToString().Trim(); LocalName12 = dr.GetCell(56) == null ? string.Empty : dr.GetCell(56).ToString().Trim(); AuditTypeName12 = dr.GetCell(57) == null ? string.Empty : dr.GetCell(57).ToString().Trim(); AuditManType12 = dr.GetCell(58) == null ? string.Empty : dr.GetCell(58).ToString().Trim(); AuditMan13 = dr.GetCell(59) == null ? string.Empty : dr.GetCell(59).ToString().Trim(); LocalName13 = dr.GetCell(60) == null ? string.Empty : dr.GetCell(60).ToString().Trim(); AuditTypeName13 = dr.GetCell(61) == null ? string.Empty : dr.GetCell(61).ToString().Trim(); AuditManType13 = dr.GetCell(62) == null ? string.Empty : dr.GetCell(62).ToString().Trim(); AuditMan14 = dr.GetCell(63) == null ? string.Empty : dr.GetCell(63).ToString().Trim(); LocalName14 = dr.GetCell(64) == null ? string.Empty : dr.GetCell(64).ToString().Trim(); AuditTypeName14 = dr.GetCell(65) == null ? string.Empty : dr.GetCell(65).ToString().Trim(); AuditManType14 = dr.GetCell(66) == null ? string.Empty : dr.GetCell(66).ToString().Trim(); AuditMan15 = dr.GetCell(67) == null ? string.Empty : dr.GetCell(67).ToString().Trim(); LocalName15 = dr.GetCell(68) == null ? string.Empty : dr.GetCell(68).ToString().Trim(); AuditTypeName15 = dr.GetCell(69) == null ? string.Empty : dr.GetCell(69).ToString().Trim(); AuditManType15 = dr.GetCell(70) == null ? string.Empty : dr.GetCell(70).ToString().Trim(); AuditMan16 = dr.GetCell(71) == null ? string.Empty : dr.GetCell(71).ToString().Trim(); LocalName16 = dr.GetCell(72) == null ? string.Empty : dr.GetCell(72).ToString().Trim(); AuditTypeName16 = dr.GetCell(73) == null ? string.Empty : dr.GetCell(73).ToString().Trim(); AuditManType16 = dr.GetCell(74) == null ? string.Empty : dr.GetCell(74).ToString().Trim(); AuditMan17 = dr.GetCell(75) == null ? string.Empty : dr.GetCell(75).ToString().Trim(); LocalName17 = dr.GetCell(76) == null ? string.Empty : dr.GetCell(76).ToString().Trim(); AuditTypeName17 = dr.GetCell(77) == null ? string.Empty : dr.GetCell(77).ToString().Trim(); AuditManType17 = dr.GetCell(78) == null ? string.Empty : dr.GetCell(78).ToString().Trim(); AuditMan18 = dr.GetCell(79) == null ? string.Empty : dr.GetCell(79).ToString().Trim(); LocalName18 = dr.GetCell(80) == null ? string.Empty : dr.GetCell(80).ToString().Trim(); AuditTypeName18 = dr.GetCell(81) == null ? string.Empty : dr.GetCell(81).ToString().Trim(); AuditManType18 = dr.GetCell(82) == null ? string.Empty : dr.GetCell(82).ToString().Trim(); AuditMan19 = dr.GetCell(83) == null ? string.Empty : dr.GetCell(83).ToString().Trim(); LocalName19 = dr.GetCell(84) == null ? string.Empty : dr.GetCell(84).ToString().Trim(); AuditTypeName19 = dr.GetCell(85) == null ? string.Empty : dr.GetCell(85).ToString().Trim(); AuditManType19 = dr.GetCell(86) == null ? string.Empty : dr.GetCell(86).ToString().Trim(); AuditMan20 = dr.GetCell(87) == null ? string.Empty : dr.GetCell(87).ToString().Trim(); LocalName20 = dr.GetCell(88) == null ? string.Empty : dr.GetCell(88).ToString().Trim(); AuditTypeName20 = dr.GetCell(89) == null ? string.Empty : dr.GetCell(89).ToString().Trim(); AuditManType20 = dr.GetCell(90) == null ? string.Empty : dr.GetCell(90).ToString().Trim(); } catch (Exception ex) { Page.ClientScript.RegisterStartupScript(this.GetType(), "alert", "<script>alert('" + Message.IsNotExcel + "');</script>"); return; } int t = 0; int intCount = 10; while (t < 20) { for (int j = 0; j < 4; j++) { if (insertSheet.GetRow(nRows).GetCell(intCount) != null) { AuditMan[t, j] = insertSheet.GetRow(nRows).GetCell(intCount).ToString().Trim(); } else { AuditMan[t, j] = string.Empty; } intCount++; } t++; } if (OrgCode.Length > 0) { int i = wfset.IsExistsDeptCode(OrgCode); if (i <= 0) { if (errorMsg.Length > 0) { errorMsg = errorMsg + ","; } errorMsg = errorMsg + Message.deptcodenotexit; } } else { if (errorMsg.Length > 0) { errorMsg = errorMsg + ","; } errorMsg = errorMsg + Message.deptcodenotisnull; } if (BillTypeName.Length > 0) { switch (BillTypeName) { case "D001": case "OTMProjectApply": if (Overtimetype == string.Empty) { if (errorMsg.Length > 0) { errorMsg = errorMsg + ","; } errorMsg = errorMsg + Message.overtimenotisnull; } break; case "D002": if (LeaveDays == string.Empty || Shiwei == string.Empty || Manger == string.Empty || leaveType == string.Empty) { if (errorMsg.Length > 0) { errorMsg = errorMsg + ","; } errorMsg = errorMsg + Message.leaveinfonotisnull; } break; case "D003": if (outtype == string.Empty || outtypeDays == string.Empty) { if (errorMsg.Length > 0) { errorMsg = errorMsg + ","; } errorMsg = errorMsg + Message.outawayisnotnull; } break; default: if (errorMsg.Length > 0) { errorMsg = errorMsg + ","; } errorMsg = errorMsg + Message.doctypenotexit; break; } } else { if (errorMsg.Length > 0) { errorMsg = errorMsg + ","; } errorMsg = errorMsg + Message.doctypenotidnull; } Dictionary<int, List<string>> driy = new Dictionary<int, List<string>>(); List<string> exit = new List<string>(); for (t = 0; t < 20; t++) { WorkNo = AuditMan[t, 0].ToString(); AuditTypeName = AuditMan[t, 2].ToString(); AuditManType = AuditMan[t, 3].ToString(); if (WorkNo.Length <= 0) { break; } List<PersonModel> listperson = person.GetPersonUserId(WorkNo); if (listperson != null && listperson.Count > 0) { List<string> personstr = new List<string>(); personstr.Add(WorkNo); exit.Add(WorkNo); personstr.Add(listperson[0].Cname); personstr.Add(listperson[0].Mail); string manger= wfset.GetManager(WorkNo); //這里管理職有點問題 personstr.Add(manger); personstr.Add(AuditManType); personstr.Add(AuditTypeName); driy.Add(t, personstr); } else { if (errorMsg.Length > 0) { errorMsg = errorMsg + ","; } errorMsg = errorMsg + Message.supvisor + (t + 1).ToString() + Message.ErrWorkNoNotEXIST; } } List<string> reasonList1 = new List<string>(); switch (BillTypeName) { case "D001": case "OTMProjectApply": reasonList1.Add(Overtimetype); break; case "D002": reasonList1.Add(LeaveDays); reasonList1.Add(Shiwei); reasonList1.Add(Manger); reasonList1.Add(leaveType); break; case "D003": reasonList1.Add(outtype); reasonList1.Add(outtypeDays); break; } WorkFlowLimitBll worklimit = new WorkFlowLimitBll(); DataTable dt = worklimit.GetSignLimitInfo(OrgCode, BillTypeName, reasonList1); List<string> sup = new List<string>(); if (dt != null && dt.Rows.Count > 0) { for (int l = 0; l < dt.Rows.Count; l++) { string temp = dt.Rows[l]["flow_empno"].ToString(); if (!exit.Contains(temp)) { sup.Add(temp); } } } if (sup.Count > 0) { if (errorMsg.Length > 0) { errorMsg = errorMsg + ","; } string temp1 = string.Empty; foreach (string item in sup) { temp1 += item + ","; } if (temp1 != string.Empty) { temp1 = temp1.Substring(0, temp1.Length - 1); } errorMsg = errorMsg + Message.supvisor + temp1 + Message.inthiswayexit; } if (errorMsg.Length == 0) { if (driy.Count > 0) { List<string> reasonList = new List<string>(); switch (BillTypeName) { case "D001": case "OTMProjectApply": reasonList.Add(Overtimetype); break; case "D002": reasonList.Add(LeaveDays); reasonList.Add(Shiwei); reasonList.Add(Manger); reasonList.Add(leaveType); break; case "D003": reasonList.Add(outtype); reasonList.Add(outtypeDays); break; } wfset.SaveData(OrgCode, BillTypeName, reasonList, driy); } index++; } else if (errorMsg.Length > 0) { errorCount++; this.dataSet.Tables["WFM_Import"].Rows.Add(new string[] { errorMsg, OrgCode, OrgName, BillTypeName,Overtimetype,LeaveDays,Shiwei,Manger,leaveType,outtype,outtypeDays, AuditMan1, LocalName1, AuditTypeName1, AuditManType1, AuditMan2, LocalName2, AuditTypeName2, AuditManType2, AuditMan3, LocalName3, AuditTypeName3, AuditManType3, AuditMan4, LocalName4, AuditTypeName4, AuditManType4, AuditMan5, LocalName5, AuditTypeName5, AuditManType5, AuditMan6, LocalName6, AuditTypeName6, AuditManType6, AuditMan7, LocalName7, AuditTypeName7, AuditManType7, AuditMan8, LocalName8, AuditTypeName8, AuditManType8, AuditMan9, LocalName9, AuditTypeName9, AuditManType9, AuditMan10, LocalName10, AuditTypeName10, AuditManType10,AuditMan11, LocalName11, AuditTypeName11, AuditManType11,AuditMan12, LocalName12, AuditTypeName12, AuditManType12, AuditMan13, LocalName13, AuditTypeName13, AuditManType13,AuditMan14, LocalName14, AuditTypeName14, AuditManType14 }); } errorMsg = string.Empty; if (nRows % 250 == 0 || (insertSheet.GetRow(nRows + 1) == null)) { break; } nRows++; } this.labeluploadMsg.Text = string.Concat(Message.NumberOfSuccessed, index, " ;", Message.NumberOfFailed, errorCount, " ."); this.UltraWebGridImport.DataSource = this.dataSet.Tables["WFM_Import"].DefaultView; this.UltraWebGridImport.DataBind(); } catch (Exception ex) { Page.ClientScript.RegisterStartupScript(this.GetType(), "alert", "<script>alert('" + ex.Message + "');</script>"); } }
protected void Btn_save_Click(object sender, EventArgs e) { string deptid = hf_deptid.Value; string formtype = ddl_doctype_1.SelectedValue; List<string> list = new List<string>(); if (tr_overtimetype.Visible) { list.Add(ddl_overtimetype.SelectedValue); } else if (tr_leave1.Visible) { list.Add(ddl_leavedays.SelectedValue); list.Add(ddl_shiwei.SelectedValue); list.Add(ddl_manager.SelectedValue); list.Add(ddl_leavetype.SelectedValue); } else if(tr_chucai.Visible) { list.Add(ddl_chucai.SelectedValue); list.Add(ddl_chucaidays.SelectedValue); } Dictionary<int, List<string>> dciy = new Dictionary<int, List<string>>(); List<string> exit= new List<string>(); if (UltraWebGridBill.Rows.Count > 0) { int i = 0; foreach (Infragistics.WebUI.UltraWebGrid.UltraGridRow dr in UltraWebGridBill.Rows) { List<string> listdata = new List<string>(); string empno = dr.Cells[0].Text == null ? string.Empty : dr.Cells[0].Text; exit.Add(empno); listdata.Add(empno); string empname = dr.Cells[1].Text == null ? string.Empty : dr.Cells[1].Text; listdata.Add(empname); string notes = dr.Cells[2].Text == null ? string.Empty : dr.Cells[2].Text; listdata.Add(notes); string manager = dr.Cells[3].Text == null ? string.Empty : dr.Cells[3].Text; listdata.Add(manager); string signlevel = dr.Cells[4].Text == null ? string.Empty : dr.Cells[4].Text; listdata.Add(signlevel); string signtype = dr.Cells[5].Text == null ? string.Empty : dr.Cells[5].Text; listdata.Add(signtype); dciy.Add(i, listdata); i++; } } WorkFlowLimitBll worklimit = new WorkFlowLimitBll(); DataTable dt = worklimit.GetSignLimitInfo(deptid, formtype, list); List<string> sup = new List<string>(); if (dt != null && dt.Rows.Count > 0) { for (int l = 0; l < dt.Rows.Count; l++) { string temp = dt.Rows[l]["flow_empno"].ToString(); if (!exit.Contains(temp)) { sup.Add(temp); } } } if (sup.Count > 0) { string temp1 = string.Empty; foreach (string item in sup) { temp1 += item + ","; } if (temp1 != string.Empty) { temp1 = temp1.Substring(0, temp1.Length - 1); } Page.ClientScript.RegisterStartupScript(GetType(), "show", "alert('" + Message.thisdeptcanhavesup + ":" + temp1 + " " + Message.signdoc + "')", true); } else { if (workflowset.SaveData(deptid, formtype, list, dciy)) { Page.ClientScript.RegisterStartupScript(GetType(), "show", "alert('" + Message.SaveSuccess + "')", true); } else { Page.ClientScript.RegisterStartupScript(GetType(), "show", "alert('" + Message.SaveFailed + "')", true); } } }