private void ImportPayFile() { OpenFileDialog OpenFileDialog = new OpenFileDialog(); OpenFileDialog.Multiselect = false; OpenFileDialog.Filter = "Excel Files (*.xls)|*.xls;"; NumericUpDown nuYear = Utility.FindChildControl<NumericUpDown>(expander, "years"); NumericUpDown nuStartmounth = Utility.FindChildControl<NumericUpDown>(expander, "months"); if (string.IsNullOrEmpty(_txtBox.Text)) { ComfirmWindow.ConfirmationBoxs(Utility.GetResourceStr("ERROR"), Utility.GetResourceStr("ERROR", "发放标记不能为空"), Utility.GetResourceStr("CONFIRM"), MessageIcon.Error); //Utility.ShowCustomMessage(MessageTypes.Message, Utility.GetResourceStr("ERROR"), "发放标记不能为空"); //第四,五列发放标记不能为空 return; } if (OpenFileDialog.ShowDialog() != true) { return; } if (OpenFileDialog.File == null) return; try { Stream Stream = (System.IO.Stream)OpenFileDialog.File.OpenRead(); byte[] Buffer = new byte[Stream.Length]; Stream.Read(Buffer, 0, (int)Stream.Length); Stream.Dispose(); Stream.Close(); SMT.Saas.Tools.SalaryWS.UploadFileModel UploadFile = new SMT.Saas.Tools.SalaryWS.UploadFileModel(); UploadFile.FileName = OpenFileDialog.File.Name; UploadFile.File = Buffer; client.ImportExcelAsync(UploadFile,nuYear.Value.ToString(),nuStartmounth.Value.ToString(),_txtBox.Text.Trim()); } catch (Exception ex) { ComfirmWindow.ConfirmationBoxs(Utility.GetResourceStr("ERROR"), Utility.GetResourceStr("ERROR"), Utility.GetResourceStr("CONFIRM"), MessageIcon.Error); //Utility.ShowCustomMessage(MessageTypes.Message, Utility.GetResourceStr("ERROR"), ex.Message.ToString()); } }
/// <summary> /// 读取员工加扣款卡的Excel文件,并导入数据库,返回导入后的结果 /// </summary> private void ImportEmployeeAddSum() { string strMsg = string.Empty; try { //if (cbxCity.SelectedItem == null) //{ // //Utility.ShowCustomMessage(MessageTypes.Error, Utility.GetResourceStr("ERROR"), Utility.GetResourceStr("STRINGNOTNULL", "CITY")); // ComfirmWindow.ConfirmationBoxs(Utility.GetResourceStr("CAUTION"), Utility.GetResourceStr("STRINGNOTNULL", "CITY"), //Utility.GetResourceStr("CONFIRM"), MessageIcon.Exclamation); // return; //} if (string.IsNullOrEmpty(tbFileName.Text)) { //Utility.ShowCustomMessage(MessageTypes.Error, Utility.GetResourceStr("ERROR"), Utility.GetResourceStr("IMPORTSELECT")); ComfirmWindow.ConfirmationBoxs(Utility.GetResourceStr("CAUTION"), Utility.GetResourceStr("IMPORTSELECT"), Utility.GetResourceStr("CONFIRM"), MessageIcon.Exclamation); return; } if (OpenFileDialog == null) return; if (OpenFileDialog.File == null) return; RefreshUI(RefreshedTypes.ShowProgressBar); Stream Stream = (System.IO.Stream)OpenFileDialog.File.OpenRead(); byte[] Buffer = new byte[Stream.Length]; Stream.Read(Buffer, 0, (int)Stream.Length); Stream.Dispose(); Stream.Close(); SMT.Saas.Tools.SalaryWS.UploadFileModel UploadFile = new SMT.Saas.Tools.SalaryWS.UploadFileModel(); UploadFile.FileName = OpenFileDialog.File.Name; UploadFile.File = Buffer; strMsg = string.Empty; Dictionary<string, string> paras = new Dictionary<string, string>(); //paras.Add("CITY", (cbxCity.SelectedItem as T_SYS_DICTIONARY).DICTIONARYVALUE.ToString()); paras.Add("OWNERID", SMT.SAAS.Main.CurrentContext.Common.CurrentLoginUserInfo.EmployeeID); paras.Add("CREATEUSERID", SMT.SAAS.Main.CurrentContext.Common.CurrentLoginUserInfo.EmployeeID); paras.Add("CREATECOMPANYID", SMT.SAAS.Main.CurrentContext.Common.CurrentLoginUserInfo.UserPosts[0].CompanyID); paras.Add("CREATEDEPARTMENTID", SMT.SAAS.Main.CurrentContext.Common.CurrentLoginUserInfo.UserPosts[0].CompanyID); paras.Add("CREATEPOSTID", SMT.SAAS.Main.CurrentContext.Common.CurrentLoginUserInfo.UserPosts[0].PostID); paras.Add("YEAR", (Nuyear.Value).ToString()); paras.Add("MONTH", (NuStartmounth.Value).ToString()); salaryClient.ImportEmployeeAddSumFromExcelForShowAsync(UploadFile, paras, strMsg, true); //client.ImportClockInRdListFromExcelAsync(UploadFile, paras, strMsg); //client.ImportClockInRdListFromExcelAsync(UploadFile, SMT.SAAS.Main.CurrentContext.Common.CurrentLoginUserInfo.EmployeeID, strMsg); //clientAtt.ImportClockInRdListFromExcelAsync(UploadFile, dtStart, dtEnd, strMsg); } catch (Exception ex) { //Utility.ShowCustomMessage(MessageTypes.Error, Utility.GetResourceStr("ERROR"), Utility.GetResourceStr(ex.Message.ToString())); ComfirmWindow.ConfirmationBoxs(Utility.GetResourceStr("ERROR"), Utility.GetResourceStr("ERRORINFO"), Utility.GetResourceStr("CONFIRM"), MessageIcon.Error); RefreshUI(RefreshedTypes.HideProgressBar); } }
private void ImportPayFile() { OpenFileDialog OpenFileDialog = new OpenFileDialog(); OpenFileDialog.Multiselect = false; OpenFileDialog.Filter = "Excel Files (*.xls)|*.xls;"; if (OpenFileDialog.ShowDialog() != true) { return; } if (OpenFileDialog.File == null) return; try { Stream Stream = (System.IO.Stream)OpenFileDialog.File.OpenRead(); byte[] Buffer = new byte[Stream.Length]; Stream.Read(Buffer, 0, (int)Stream.Length); Stream.Dispose(); Stream.Close(); SMT.Saas.Tools.SalaryWS.UploadFileModel UploadFile = new SMT.Saas.Tools.SalaryWS.UploadFileModel(); UploadFile.FileName = OpenFileDialog.File.Name; UploadFile.File = Buffer; //client.ImportExcelAsync(UploadFile); } catch (Exception ex) { ComfirmWindow.ConfirmationBoxs(Utility.GetResourceStr("ERROR"), Utility.GetResourceStr("ERROR"), Utility.GetResourceStr("CONFIRM"), MessageIcon.Error); //Utility.ShowCustomMessage(MessageTypes.Message, Utility.GetResourceStr("ERROR"), ex.Message.ToString()); } }
/// <summary> /// 读取员工加扣款卡的Excel文件,并导入数据库,返回导入后的结果 /// </summary> private void ImportEmployeeAddSum() { string strMsg = string.Empty; try { //if (cbxCity.SelectedItem == null) //{ // //Utility.ShowCustomMessage(MessageTypes.Error, Utility.GetResourceStr("ERROR"), Utility.GetResourceStr("STRINGNOTNULL", "CITY")); // ComfirmWindow.ConfirmationBoxs(Utility.GetResourceStr("CAUTION"), Utility.GetResourceStr("STRINGNOTNULL", "CITY"), //Utility.GetResourceStr("CONFIRM"), MessageIcon.Exclamation); // return; //} if (string.IsNullOrEmpty(tbFileName.Text)) { //Utility.ShowCustomMessage(MessageTypes.Error, Utility.GetResourceStr("ERROR"), Utility.GetResourceStr("IMPORTSELECT")); ComfirmWindow.ConfirmationBoxs(Utility.GetResourceStr("CAUTION"), Utility.GetResourceStr("IMPORTSELECT"), Utility.GetResourceStr("CONFIRM"), MessageIcon.Exclamation); return; } if (OpenFileDialog == null) { return; } if (OpenFileDialog.File == null) { return; } RefreshUI(RefreshedTypes.ShowProgressBar); Stream Stream = (System.IO.Stream)OpenFileDialog.File.OpenRead(); byte[] Buffer = new byte[Stream.Length]; Stream.Read(Buffer, 0, (int)Stream.Length); Stream.Dispose(); Stream.Close(); SMT.Saas.Tools.SalaryWS.UploadFileModel UploadFile = new SMT.Saas.Tools.SalaryWS.UploadFileModel(); UploadFile.FileName = OpenFileDialog.File.Name; UploadFile.File = Buffer; strMsg = string.Empty; Dictionary <string, string> paras = new Dictionary <string, string>(); //paras.Add("CITY", (cbxCity.SelectedItem as T_SYS_DICTIONARY).DICTIONARYVALUE.ToString()); paras.Add("OWNERID", SMT.SAAS.Main.CurrentContext.Common.CurrentLoginUserInfo.EmployeeID); paras.Add("CREATEUSERID", SMT.SAAS.Main.CurrentContext.Common.CurrentLoginUserInfo.EmployeeID); paras.Add("CREATECOMPANYID", SMT.SAAS.Main.CurrentContext.Common.CurrentLoginUserInfo.UserPosts[0].CompanyID); paras.Add("CREATEDEPARTMENTID", SMT.SAAS.Main.CurrentContext.Common.CurrentLoginUserInfo.UserPosts[0].CompanyID); paras.Add("CREATEPOSTID", SMT.SAAS.Main.CurrentContext.Common.CurrentLoginUserInfo.UserPosts[0].PostID); paras.Add("YEAR", (Nuyear.Value).ToString()); paras.Add("MONTH", (NuStartmounth.Value).ToString()); salaryClient.ImportEmployeeAddSumFromExcelForShowAsync(UploadFile, paras, strMsg, true); //client.ImportClockInRdListFromExcelAsync(UploadFile, paras, strMsg); //client.ImportClockInRdListFromExcelAsync(UploadFile, SMT.SAAS.Main.CurrentContext.Common.CurrentLoginUserInfo.EmployeeID, strMsg); //clientAtt.ImportClockInRdListFromExcelAsync(UploadFile, dtStart, dtEnd, strMsg); } catch (Exception ex) { //Utility.ShowCustomMessage(MessageTypes.Error, Utility.GetResourceStr("ERROR"), Utility.GetResourceStr(ex.Message.ToString())); ComfirmWindow.ConfirmationBoxs(Utility.GetResourceStr("ERROR"), Utility.GetResourceStr("ERRORINFO"), Utility.GetResourceStr("CONFIRM"), MessageIcon.Error); RefreshUI(RefreshedTypes.HideProgressBar); } }