/// <summary>
/// 读取社保卡的Excel文件，并导入数据库，返回导入后的结果
/// </summary>
private SMT.Saas.Tools.PersonnelWS.UploadFileModel ImportClockInRd()
{
string strMsg = string.Empty;
Stream stream = null;
try
{
if (openFileDialog == null)
{
return(null);
}
if (openFileDialog.File == null)
{
return(null);
}
RefreshUI(RefreshedTypes.ProgressBar);
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.PersonnelWS.UploadFileModel UploadFile = new SMT.Saas.Tools.PersonnelWS.UploadFileModel();
UploadFile.FileName = openFileDialog.File.Name;
UploadFile.File = Buffer;
strMsg = string.Empty;
return(UploadFile);
//clientAtt.ImportClockInRdListFromExcelAsync(UploadFile, dtStart, dtEnd, strMsg);
}
catch (Exception)
{
//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);
return(null);
}
finally
{
stream.Dispose();
stream.Close();
}
}
/// <summary>
/// 读取员工入职信息的Excel文件，并导入数据库，返回导入后的结果
/// </summary>
private void ImportEmployeeEntry()
{
string strMsg = string.Empty;
try
{
if (acbCompanyName.SelectedItem == null)
{
tbFileName.Text = string.Empty;//不显示文件
ComfirmWindow.ConfirmationBoxs(Utility.GetResourceStr("CAUTION"), Utility.GetResourceStr("SELECTCOMPANY"),
Utility.GetResourceStr("CONFIRM"), MessageIcon.Exclamation);
}
if (OpenFileDialog == null || OpenFileDialog.File == null)
{
tbFileName.Text = string.Empty;//不显示文件
return;
}
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.PersonnelWS.UploadFileModel UploadFile = new SMT.Saas.Tools.PersonnelWS.UploadFileModel();
UploadFile.FileName = OpenFileDialog.File.Name;
UploadFile.File = Buffer;
string companyID = (acbCompanyName.SelectedItem as SMT.Saas.Tools.OrganizationWS.T_HR_COMPANY).COMPANYID;
Dictionary <string, string> empInfo = new Dictionary <string, string>();
empInfo.Add("ownerID", SMT.SAAS.Main.CurrentContext.Common.CurrentLoginUserInfo.EmployeeID);
empInfo.Add("ownerPostID", SMT.SAAS.Main.CurrentContext.Common.CurrentLoginUserInfo.UserPosts[0].PostID);
empInfo.Add("ownerDepartmentID", SMT.SAAS.Main.CurrentContext.Common.CurrentLoginUserInfo.UserPosts[0].DepartmentID);
empInfo.Add("ownerCompanyID", SMT.SAAS.Main.CurrentContext.Common.CurrentLoginUserInfo.UserPosts[0].CompanyID);
RefreshUI(RefreshedTypes.ShowProgressBar);
client.ImportEmployeeEntryAsync(UploadFile, companyID, empInfo);
}
catch (Exception ex)
{
ComfirmWindow.ConfirmationBoxs(Utility.GetResourceStr("ERROR"), ex.ToString(), Utility.GetResourceStr("CONFIRM"), MessageIcon.Error);
RefreshUI(RefreshedTypes.HideProgressBar);
}
}
/// <summary>
/// 读取社保卡的Excel文件，并导入数据库，返回导入后的结果
/// </summary>
private SMT.Saas.Tools.PersonnelWS.UploadFileModel ImportClockInRd()
{
string strMsg = string.Empty;
Stream stream = null;
try
{
if (openFileDialog == null)
return null;
if (openFileDialog.File == null)
return null;
RefreshUI(RefreshedTypes.ProgressBar);
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.PersonnelWS.UploadFileModel UploadFile = new SMT.Saas.Tools.PersonnelWS.UploadFileModel();
UploadFile.FileName = openFileDialog.File.Name;
UploadFile.File = Buffer;
strMsg = string.Empty;
return UploadFile;
//clientAtt.ImportClockInRdListFromExcelAsync(UploadFile, dtStart, dtEnd, strMsg);
}
catch (Exception )
{
//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);
return null;
}
finally
{
stream.Dispose();
stream.Close();
}
}
/// <summary>
/// 读取社保卡的Excel文件，并导入数据库，返回导入后的结果
/// </summary>
private void ImportClockInRd()
{
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.PersonnelWS.UploadFileModel UploadFile = new SMT.Saas.Tools.PersonnelWS.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("OWNERCOMPANYID", SMT.SAAS.Main.CurrentContext.Common.CurrentLoginUserInfo.UserPosts[0].CompanyID);
paras.Add("OWNERDEPARTMENTID", SMT.SAAS.Main.CurrentContext.Common.CurrentLoginUserInfo.UserPosts[0].CompanyID);
paras.Add("OWNERPOSTID", SMT.SAAS.Main.CurrentContext.Common.CurrentLoginUserInfo.UserPosts[0].PostID);
paras.Add("YEAR", (Nuyear.Value).ToString());
paras.Add("MONTH", (NuStartmounth.Value).ToString());
client.ImportClockInRdListFromExcelForShowAsync(UploadFile, paras, strMsg);
//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);
}
}
/// <summary>
/// 读取员工入职信息的Excel文件，并导入数据库，返回导入后的结果
/// </summary>
private void ImportEmployeeEntry()
{
string strMsg = string.Empty;
try
{
if (acbCompanyName.SelectedItem==null)
{
tbFileName.Text = string.Empty;//不显示文件
ComfirmWindow.ConfirmationBoxs(Utility.GetResourceStr("CAUTION"),Utility.GetResourceStr("SELECTCOMPANY"),
Utility.GetResourceStr("CONFIRM"), MessageIcon.Exclamation);
}
if (OpenFileDialog == null || OpenFileDialog.File == null)
{
tbFileName.Text = string.Empty;//不显示文件
return;
}
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.PersonnelWS.UploadFileModel UploadFile = new SMT.Saas.Tools.PersonnelWS.UploadFileModel();
UploadFile.FileName = OpenFileDialog.File.Name;
UploadFile.File = Buffer;
string companyID = (acbCompanyName.SelectedItem as SMT.Saas.Tools.OrganizationWS.T_HR_COMPANY).COMPANYID;
Dictionary<string, string> empInfo = new Dictionary<string, string>();
empInfo.Add("ownerID", SMT.SAAS.Main.CurrentContext.Common.CurrentLoginUserInfo.EmployeeID);
empInfo.Add("ownerPostID", SMT.SAAS.Main.CurrentContext.Common.CurrentLoginUserInfo.UserPosts[0].PostID);
empInfo.Add("ownerDepartmentID", SMT.SAAS.Main.CurrentContext.Common.CurrentLoginUserInfo.UserPosts[0].DepartmentID);
empInfo.Add("ownerCompanyID", SMT.SAAS.Main.CurrentContext.Common.CurrentLoginUserInfo.UserPosts[0].CompanyID);
RefreshUI(RefreshedTypes.ShowProgressBar);
client.ImportEmployeeEntryAsync(UploadFile, companyID, empInfo);
}
catch (Exception ex)
{
ComfirmWindow.ConfirmationBoxs(Utility.GetResourceStr("ERROR"), ex.ToString(), Utility.GetResourceStr("CONFIRM"), MessageIcon.Error);
RefreshUI(RefreshedTypes.HideProgressBar);
}
}
/// <summary>
/// 读取社保卡的Excel文件，并导入数据库，返回导入后的结果
/// </summary>
private void ImportClockInRd()
{
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.PersonnelWS.UploadFileModel UploadFile = new SMT.Saas.Tools.PersonnelWS.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("OWNERCOMPANYID", SMT.SAAS.Main.CurrentContext.Common.CurrentLoginUserInfo.UserPosts[0].CompanyID);
paras.Add("OWNERDEPARTMENTID", SMT.SAAS.Main.CurrentContext.Common.CurrentLoginUserInfo.UserPosts[0].CompanyID);
paras.Add("OWNERPOSTID", SMT.SAAS.Main.CurrentContext.Common.CurrentLoginUserInfo.UserPosts[0].PostID);
paras.Add("YEAR", (Nuyear.Value).ToString());
paras.Add("MONTH", (NuStartmounth.Value).ToString());
client.ImportClockInRdListFromExcelForShowAsync(UploadFile, paras, strMsg);
//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);
}
}
