/// <summary>
/// 从数据行读取
/// </summary>
/// <param name="dr">数据行</param>
protected override BaseEntity GetFrom(IDataRow dr)
{
Id = BaseBusinessLogic.ConvertToInt(dr[BasePermissionScopeEntity.FieldId]);
ResourceCategory = BaseBusinessLogic.ConvertToString(dr[BasePermissionScopeEntity.FieldResourceCategory]);
ResourceId = BaseBusinessLogic.ConvertToString(dr[BasePermissionScopeEntity.FieldResourceId]);
TargetCategory = BaseBusinessLogic.ConvertToString(dr[BasePermissionScopeEntity.FieldTargetCategory]);
TargetId = BaseBusinessLogic.ConvertToString(dr[BasePermissionScopeEntity.FieldTargetId]);
PermissionId = BaseBusinessLogic.ConvertToString(dr[BasePermissionScopeEntity.FieldPermissionId]);
ContainChild = BaseBusinessLogic.ConvertToInt(dr[BasePermissionScopeEntity.FieldContainChild]);
PermissionConstraint = BaseBusinessLogic.ConvertToString(dr[BasePermissionScopeEntity.FieldPermissionConstraint]);
Enabled = BaseBusinessLogic.ConvertToInt(dr[BasePermissionScopeEntity.FieldEnabled]);
DeletionStateCode = BaseBusinessLogic.ConvertToInt(dr[BasePermissionScopeEntity.FieldDeletionStateCode]);
Description = BaseBusinessLogic.ConvertToString(dr[BasePermissionScopeEntity.FieldDescription]);
CreateOn = BaseBusinessLogic.ConvertToNullableDateTime(dr[BasePermissionScopeEntity.FieldCreateOn]);
CreateBy = BaseBusinessLogic.ConvertToString(dr[BasePermissionScopeEntity.FieldCreateBy]);
CreateUserId = BaseBusinessLogic.ConvertToString(dr[BasePermissionScopeEntity.FieldCreateUserId]);
ModifiedOn = BaseBusinessLogic.ConvertToNullableDateTime(dr[BasePermissionScopeEntity.FieldModifiedOn]);
ModifiedBy = BaseBusinessLogic.ConvertToString(dr[BasePermissionScopeEntity.FieldModifiedBy]);
ModifiedUserId = BaseBusinessLogic.ConvertToString(dr[BasePermissionScopeEntity.FieldModifiedUserId]);
// 获取扩展属性
GetFromExpand(dr);
return(this);
}
/// <summary>
/// 从数据行读取
/// </summary>
/// <param name="dataRow">数据行</param>
protected override BaseEntity GetFrom(IDataRow dr)
{
GetFromExpand(dr);
UserId = BaseBusinessLogic.ConvertToString(dr[UserByGUIDEntity.FieldUserId]);
FullName = BaseBusinessLogic.ConvertToString(dr[UserByGUIDEntity.FieldFullName]);
Salary = BaseBusinessLogic.ConvertToNullableDecimal(dr[UserByGUIDEntity.FieldSalary]);
Age = BaseBusinessLogic.ConvertToNullableInt(dr[UserByGUIDEntity.FieldAge]);
Birthday = BaseBusinessLogic.ConvertToNullableDateTime(dr[UserByGUIDEntity.FieldBirthday]);
Photo = BaseBusinessLogic.ConvertToByte(dr[UserByGUIDEntity.FieldPhoto]);
AllowEdit = BaseBusinessLogic.ConvertToNullableInt(dr[UserByGUIDEntity.FieldAllowEdit]);
AllowDelete = BaseBusinessLogic.ConvertToNullableInt(dr[UserByGUIDEntity.FieldAllowDelete]);
Enabled = BaseBusinessLogic.ConvertToInt(dr[UserByGUIDEntity.FieldEnabled]);
DeletionStateCode = BaseBusinessLogic.ConvertToNullableInt(dr[UserByGUIDEntity.FieldDeletionStateCode]);
SortCode = BaseBusinessLogic.ConvertToInt(dr[UserByGUIDEntity.FieldSortCode]);
Description = BaseBusinessLogic.ConvertToString(dr[UserByGUIDEntity.FieldDescription]);
CreateOn = BaseBusinessLogic.ConvertToNullableDateTime(dr[UserByGUIDEntity.FieldCreateOn]);
CreateUserId = BaseBusinessLogic.ConvertToString(dr[UserByGUIDEntity.FieldCreateUserId]);
CreateBy = BaseBusinessLogic.ConvertToString(dr[UserByGUIDEntity.FieldCreateBy]);
ModifiedOn = BaseBusinessLogic.ConvertToNullableDateTime(dr[UserByGUIDEntity.FieldModifiedOn]);
ModifiedUserId = BaseBusinessLogic.ConvertToString(dr[UserByGUIDEntity.FieldModifiedUserId]);
ModifiedBy = BaseBusinessLogic.ConvertToString(dr[UserByGUIDEntity.FieldModifiedBy]);
return(this);
}
/// <summary>
/// 从数据行读取
/// </summary>
/// <param name="dr">数据行</param>
protected override BaseEntity GetFrom(IDataRow dr)
{
Id = BaseBusinessLogic.ConvertToString(dr[BaseLogEntity.FieldId]);
// 2016-02-14 吉日嘎拉 改进日志的记录数据、把一些核心参数记录下来。
TaskId = BaseBusinessLogic.ConvertToString(dr[BaseLogEntity.FieldTaskId]);
Service = BaseBusinessLogic.ConvertToString(dr[BaseLogEntity.FieldService]);
CompanyId = BaseBusinessLogic.ConvertToString(dr[BaseLogEntity.FieldCompanyId]);
ElapsedTicks = BaseBusinessLogic.ConvertToInt(dr[BaseLogEntity.FieldElapsedTicks]);
StartTime = BaseBusinessLogic.ConvertToDateTime(dr[BaseLogEntity.FieldStartTime]);
UserId = BaseBusinessLogic.ConvertToString(dr[BaseLogEntity.FieldUserId]);
UserRealName = BaseBusinessLogic.ConvertToString(dr[BaseLogEntity.FieldUserRealName]);
Parameters = BaseBusinessLogic.ConvertToString(dr[BaseLogEntity.FieldParameters]);
UrlReferrer = BaseBusinessLogic.ConvertToString(dr[BaseLogEntity.FieldUrlReferrer]);
WebUrl = BaseBusinessLogic.ConvertToString(dr[BaseLogEntity.FieldWebUrl]);
ClientIP = BaseBusinessLogic.ConvertToString(dr[BaseLogEntity.FieldClientIP]);
ServerIP = BaseBusinessLogic.ConvertToString(dr[BaseLogEntity.FieldServerIP]);
Description = BaseBusinessLogic.ConvertToString(dr[BaseLogEntity.FieldDescription]);
// 获取扩展属性
GetFromExpand(dr);
return(this);
}
/// <summary>
/// 从数据流读取
/// </summary>
/// <param name="dataReader">数据流</param>
public BaseItemDetailsEntity GetFrom(IDataReader dataReader)
{
this.GetFromExpand(dataReader);
this.Id = BaseBusinessLogic.ConvertToInt(dataReader[BaseItemDetailsEntity.FieldId]);
this.ParentId = BaseBusinessLogic.ConvertToInt(dataReader[BaseItemDetailsEntity.FieldParentId]);
this.ItemCode = BaseBusinessLogic.ConvertToString(dataReader[BaseItemDetailsEntity.FieldItemCode]);
this.ItemName = BaseBusinessLogic.ConvertToString(dataReader[BaseItemDetailsEntity.FieldItemName]);
this.ItemValue = BaseBusinessLogic.ConvertToString(dataReader[BaseItemDetailsEntity.FieldItemValue]);
this.AllowEdit = BaseBusinessLogic.ConvertToInt(dataReader[BaseItemDetailsEntity.FieldAllowEdit]);
this.AllowDelete = BaseBusinessLogic.ConvertToInt(dataReader[BaseItemDetailsEntity.FieldAllowDelete]);
this.IsPublic = BaseBusinessLogic.ConvertToInt(dataReader[BaseItemDetailsEntity.FieldIsPublic]);
this.Enabled = BaseBusinessLogic.ConvertToInt(dataReader[BaseItemDetailsEntity.FieldEnabled]);
this.DeletionStateCode = BaseBusinessLogic.ConvertToInt(dataReader[BaseItemDetailsEntity.FieldDeletionStateCode]);
this.SortCode = BaseBusinessLogic.ConvertToInt(dataReader[BaseItemDetailsEntity.FieldSortCode]);
this.Description = BaseBusinessLogic.ConvertToString(dataReader[BaseItemDetailsEntity.FieldDescription]);
this.CreateOn = BaseBusinessLogic.ConvertToDateTime(dataReader[BaseItemDetailsEntity.FieldCreateOn]);
this.CreateUserId = BaseBusinessLogic.ConvertToString(dataReader[BaseItemDetailsEntity.FieldCreateUserId]);
this.CreateBy = BaseBusinessLogic.ConvertToString(dataReader[BaseItemDetailsEntity.FieldCreateBy]);
this.ModifiedOn = BaseBusinessLogic.ConvertToDateTime(dataReader[BaseItemDetailsEntity.FieldModifiedOn]);
this.ModifiedUserId = BaseBusinessLogic.ConvertToString(dataReader[BaseItemDetailsEntity.FieldModifiedUserId]);
this.ModifiedBy = BaseBusinessLogic.ConvertToString(dataReader[BaseItemDetailsEntity.FieldModifiedBy]);
return(this);
}
/// <summary>
/// 从数据行读取
/// </summary>
/// <param name="dr">数据行</param>
protected override BaseEntity GetFrom(IDataRow dr)
{
Id = BaseBusinessLogic.ConvertToInt(dr[BaseTableColumnsEntity.FieldId]);
TableCode = BaseBusinessLogic.ConvertToString(dr[BaseTableColumnsEntity.FieldTableCode]);
ColumnCode = BaseBusinessLogic.ConvertToString(dr[BaseTableColumnsEntity.FieldColumnCode]);
ColumnName = BaseBusinessLogic.ConvertToString(dr[BaseTableColumnsEntity.FieldColumnName]);
IsPublic = BaseBusinessLogic.ConvertToInt(dr[BaseTableColumnsEntity.FieldIsPublic]);
Enabled = BaseBusinessLogic.ConvertToInt(dr[BaseTableColumnsEntity.FieldEnabled]);
AllowEdit = BaseBusinessLogic.ConvertToInt(dr[BaseTableColumnsEntity.FieldAllowEdit]);
AllowDelete = BaseBusinessLogic.ConvertToInt(dr[BaseTableColumnsEntity.FieldAllowDelete]);
DeletionStateCode = BaseBusinessLogic.ConvertToInt(dr[BaseTableColumnsEntity.FieldDeletionStateCode]);
SortCode = BaseBusinessLogic.ConvertToInt(dr[BaseTableColumnsEntity.FieldSortCode]);
Description = BaseBusinessLogic.ConvertToString(dr[BaseTableColumnsEntity.FieldDescription]);
CreateOn = BaseBusinessLogic.ConvertToNullableDateTime(dr[BaseTableColumnsEntity.FieldCreateOn]);
CreateUserId = BaseBusinessLogic.ConvertToString(dr[BaseTableColumnsEntity.FieldCreateUserId]);
CreateBy = BaseBusinessLogic.ConvertToString(dr[BaseTableColumnsEntity.FieldCreateBy]);
ModifiedOn = BaseBusinessLogic.ConvertToNullableDateTime(dr[BaseTableColumnsEntity.FieldModifiedOn]);
ModifiedUserId = BaseBusinessLogic.ConvertToString(dr[BaseTableColumnsEntity.FieldModifiedUserId]);
ModifiedBy = BaseBusinessLogic.ConvertToString(dr[BaseTableColumnsEntity.FieldModifiedBy]);
// 获取扩展属性
GetFromExpand(dr);
return(this);
}
/// <summary>
/// 从数据行读取
/// </summary>
/// <param name="dr">数据行</param>
protected override BaseEntity GetFrom(IDataRow dr)
{
Id = BaseBusinessLogic.ConvertToString(dr[BaseUserEntity.FieldId]);
// 2016-03-02 吉日嘎拉 防止程序出错，没有这个字段也可以正常运行
if (dr.ContainsColumn(BaseUserLogOnEntity.FieldCompanyId))
{
CompanyId = BaseBusinessLogic.ConvertToString(dr[BaseUserLogOnEntity.FieldCompanyId]);
}
Mobile = BaseBusinessLogic.ConvertToString(dr[BaseUserContactEntity.FieldMobile]);
MobileValiated = BaseBusinessLogic.ConvertToInt(dr[BaseUserContactEntity.FieldMobileValiated]);
MobileVerificationDate = BaseBusinessLogic.ConvertToNullableDateTime(dr[BaseUserContactEntity.FieldMobileVerificationDate]);
ShowMobile = BaseBusinessLogic.ConvertToInt(dr[BaseUserContactEntity.FieldShowMobile]);
Telephone = BaseBusinessLogic.ConvertToString(dr[BaseUserContactEntity.FieldTelephone]);
Extension = BaseBusinessLogic.ConvertToString(dr[BaseUserContactEntity.FieldExtension]);
ShortNumber = BaseBusinessLogic.ConvertToString(dr[BaseUserContactEntity.FieldShortNumber]);
WW = BaseBusinessLogic.ConvertToString(dr[BaseUserContactEntity.FieldWW]);
QQ = BaseBusinessLogic.ConvertToString(dr[BaseUserContactEntity.FieldQQ]);
WeChat = BaseBusinessLogic.ConvertToString(dr[BaseUserContactEntity.FieldWeChat]);
WeChatOpenId = BaseBusinessLogic.ConvertToString(dr[BaseUserContactEntity.FieldWeChatOpenId]);
WeChatValiated = BaseBusinessLogic.ConvertToInt(dr[BaseUserContactEntity.FieldWeChatValiated]);
YiXin = BaseBusinessLogic.ConvertToString(dr[BaseUserContactEntity.FieldYiXin]);
YiXinValiated = BaseBusinessLogic.ConvertToInt(dr[BaseUserContactEntity.FieldYiXinValiated]);
Email = BaseBusinessLogic.ConvertToString(dr[BaseUserContactEntity.FieldEmail]);
EmailValiated = BaseBusinessLogic.ConvertToInt(dr[BaseUserContactEntity.FieldEmailValiated]);
CompanyMail = BaseBusinessLogic.ConvertToString(dr[BaseUserContactEntity.FieldCompanyMail]);
EmergencyContact = BaseBusinessLogic.ConvertToString(dr[BaseUserContactEntity.FieldEmergencyContact]);
YY = BaseBusinessLogic.ConvertToString(dr[BaseUserContactEntity.FieldYY]);
CreateOn = BaseBusinessLogic.ConvertToNullableDateTime(dr[BaseUserContactEntity.FieldCreateOn]);
CreateUserId = BaseBusinessLogic.ConvertToString(dr[BaseUserContactEntity.FieldCreateUserId]);
CreateBy = BaseBusinessLogic.ConvertToString(dr[BaseUserContactEntity.FieldCreateBy]);
ModifiedOn = BaseBusinessLogic.ConvertToNullableDateTime(dr[BaseUserContactEntity.FieldModifiedOn]);
ModifiedUserId = BaseBusinessLogic.ConvertToString(dr[BaseUserContactEntity.FieldModifiedUserId]);
ModifiedBy = BaseBusinessLogic.ConvertToString(dr[BaseUserContactEntity.FieldModifiedBy]);
// 获取扩展属性
GetFromExpand(dr);
return(this);
}
/// <summary>
/// 从数据流读取
/// </summary>
/// <param name="dataReader">数据流</param>
public BaseWorkFlowCurrentEntity GetFrom(IDataReader dataReader)
{
this.GetFromExpand(dataReader);;
this.Id = BaseBusinessLogic.ConvertToString(dataReader[BaseWorkFlowCurrentEntity.FieldId]);
this.CategoryCode = BaseBusinessLogic.ConvertToString(dataReader[BaseWorkFlowCurrentEntity.FieldCategoryCode]);
this.CategoryFullName = BaseBusinessLogic.ConvertToString(dataReader[BaseWorkFlowCurrentEntity.FieldCategoryFullName]);
this.ObjectId = BaseBusinessLogic.ConvertToString(dataReader[BaseWorkFlowCurrentEntity.FieldObjectId]);
this.ObjectFullName = BaseBusinessLogic.ConvertToString(dataReader[BaseWorkFlowCurrentEntity.FieldObjectFullName]);
this.WorkFlowId = BaseBusinessLogic.ConvertToInt(dataReader[BaseWorkFlowCurrentEntity.FieldWorkFlowId]);
this.ActivityId = BaseBusinessLogic.ConvertToInt(dataReader[BaseWorkFlowCurrentEntity.FieldActivityId]);
this.ActivityFullName = BaseBusinessLogic.ConvertToString(dataReader[BaseWorkFlowCurrentEntity.FieldActivityFullName]);
this.ToDepartmentId = BaseBusinessLogic.ConvertToString(dataReader[BaseWorkFlowCurrentEntity.FieldToDepartmentId]);
this.ToDepartmentName = BaseBusinessLogic.ConvertToString(dataReader[BaseWorkFlowCurrentEntity.FieldToDepartmentName]);
this.ToUserId = BaseBusinessLogic.ConvertToString(dataReader[BaseWorkFlowCurrentEntity.FieldToUserId]);
this.ToUserRealName = BaseBusinessLogic.ConvertToString(dataReader[BaseWorkFlowCurrentEntity.FieldToUserRealName]);
this.ToRoleId = BaseBusinessLogic.ConvertToString(dataReader[BaseWorkFlowCurrentEntity.FieldToRoleId]);
this.ToRoleRealName = BaseBusinessLogic.ConvertToString(dataReader[BaseWorkFlowCurrentEntity.FieldToRoleRealName]);
this.AuditUserId = BaseBusinessLogic.ConvertToString(dataReader[BaseWorkFlowCurrentEntity.FieldAuditUserId]);
this.AuditUserCode = BaseBusinessLogic.ConvertToString(dataReader[BaseWorkFlowCurrentEntity.FieldAuditUserCode]);
this.AuditUserRealName = BaseBusinessLogic.ConvertToString(dataReader[BaseWorkFlowCurrentEntity.FieldAuditUserRealName]);
this.SendDate = BaseBusinessLogic.ConvertToDateTime(dataReader[BaseWorkFlowCurrentEntity.FieldSendDate]);
this.AuditDate = BaseBusinessLogic.ConvertToDateTime(dataReader[BaseWorkFlowCurrentEntity.FieldAuditDate]);
this.AuditIdea = BaseBusinessLogic.ConvertToString(dataReader[BaseWorkFlowCurrentEntity.FieldAuditIdea]);
this.AuditStatus = BaseBusinessLogic.ConvertToString(dataReader[BaseWorkFlowCurrentEntity.FieldAuditStatus]);
this.AuditStatusName = BaseBusinessLogic.ConvertToString(dataReader[BaseWorkFlowCurrentEntity.FieldAuditStatusName]);
this.SortCode = BaseBusinessLogic.ConvertToInt(dataReader[BaseWorkFlowCurrentEntity.FieldSortCode]);
this.Enabled = BaseBusinessLogic.ConvertToInt(dataReader[BaseWorkFlowCurrentEntity.FieldEnabled]);
this.DeletionStateCode = BaseBusinessLogic.ConvertToInt(dataReader[BaseWorkFlowCurrentEntity.FieldDeletionStateCode]);
this.Description = BaseBusinessLogic.ConvertToString(dataReader[BaseWorkFlowCurrentEntity.FieldDescription]);
this.CreateOn = BaseBusinessLogic.ConvertToDateTime(dataReader[BaseWorkFlowCurrentEntity.FieldCreateOn]);
this.CreateUserId = BaseBusinessLogic.ConvertToString(dataReader[BaseWorkFlowCurrentEntity.FieldCreateUserId]);
this.CreateBy = BaseBusinessLogic.ConvertToString(dataReader[BaseWorkFlowCurrentEntity.FieldCreateBy]);
this.ModifiedOn = BaseBusinessLogic.ConvertToDateTime(dataReader[BaseWorkFlowCurrentEntity.FieldModifiedOn]);
this.ModifiedUserId = BaseBusinessLogic.ConvertToString(dataReader[BaseWorkFlowCurrentEntity.FieldModifiedUserId]);
this.ModifiedBy = BaseBusinessLogic.ConvertToString(dataReader[BaseWorkFlowCurrentEntity.FieldModifiedBy]);
return(this);
}
/// <summary>
/// 从数据行读取
/// </summary>
/// <param name="dr">数据行</param>
protected override BaseEntity GetFrom(IDataRow dr)
{
GetFromExpand(dr);
Id = BaseBusinessLogic.ConvertToDecimal(dr[ItemsSystemEntity.FieldId]);
ParentId = BaseBusinessLogic.ConvertToNullableDecimal(dr[ItemsSystemEntity.FieldParentId]);
Description = BaseBusinessLogic.ConvertToString(dr[ItemsSystemEntity.FieldDescription]);
Enabled = BaseBusinessLogic.ConvertToDecimal(dr[ItemsSystemEntity.FieldEnabled]);
ModifiedUserId = BaseBusinessLogic.ConvertToString(dr[ItemsSystemEntity.FieldModifiedUserId]);
SortCode = BaseBusinessLogic.ConvertToNullableDecimal(dr[ItemsSystemEntity.FieldSortCode]);
Ispublic = BaseBusinessLogic.ConvertToDecimal(dr[ItemsSystemEntity.FieldIspublic]);
CreateBy = BaseBusinessLogic.ConvertToString(dr[ItemsSystemEntity.FieldCreateby]);
CreateOn = BaseBusinessLogic.ConvertToNullableDateTime(dr[ItemsSystemEntity.FieldCreateon]);
ItemValue = BaseBusinessLogic.ConvertToString(dr[ItemsSystemEntity.FieldItemValue]);
CreateUserId = BaseBusinessLogic.ConvertToString(dr[ItemsSystemEntity.FieldCreateUserId]);
Logonurl = BaseBusinessLogic.ConvertToString(dr[ItemsSystemEntity.FieldLogonUrl]);
AllowDelete = BaseBusinessLogic.ConvertToDecimal(dr[ItemsSystemEntity.FieldAllowDelete]);
ModifiedOn = BaseBusinessLogic.ConvertToNullableDateTime(dr[ItemsSystemEntity.FieldModifiedOn]);
itemName = BaseBusinessLogic.ConvertToString(dr[ItemsSystemEntity.FieldItemName]);
AllowEdit = BaseBusinessLogic.ConvertToDecimal(dr[ItemsSystemEntity.FieldAllowEdit]);
ModifiedBy = BaseBusinessLogic.ConvertToString(dr[ItemsSystemEntity.FieldModifiedBy]);
itemCode = BaseBusinessLogic.ConvertToString(dr[ItemsSystemEntity.FieldItemCode]);
DeletionStateCode = BaseBusinessLogic.ConvertToNullableDecimal(dr[ItemsSystemEntity.FieldDeletionStateCode]);
return(this);
}
/// <summary>
/// 从数据行读取
/// </summary>
/// <param name="dr">数据行</param>
protected override BaseEntity GetFrom(IDataRow dr)
{
Id = BaseBusinessLogic.ConvertToString(dr[BaseRoleEntity.FieldId]);
OrganizeId = BaseBusinessLogic.ConvertToString(dr[BaseRoleEntity.FieldOrganizeId]);
Code = BaseBusinessLogic.ConvertToString(dr[BaseRoleEntity.FieldCode]);
RealName = BaseBusinessLogic.ConvertToString(dr[BaseRoleEntity.FieldRealName]);
CategoryCode = BaseBusinessLogic.ConvertToString(dr[BaseRoleEntity.FieldCategoryCode]);
AllowEdit = BaseBusinessLogic.ConvertToInt(dr[BaseRoleEntity.FieldAllowEdit]);
AllowDelete = BaseBusinessLogic.ConvertToInt(dr[BaseRoleEntity.FieldAllowDelete]);
IsVisible = BaseBusinessLogic.ConvertToInt(dr[BaseRoleEntity.FieldIsVisible]);
SortCode = BaseBusinessLogic.ConvertToInt(dr[BaseRoleEntity.FieldSortCode]);
DeletionStateCode = BaseBusinessLogic.ConvertToInt(dr[BaseRoleEntity.FieldDeletionStateCode]);
Enabled = BaseBusinessLogic.ConvertToInt(dr[BaseRoleEntity.FieldEnabled]);
Description = BaseBusinessLogic.ConvertToString(dr[BaseRoleEntity.FieldDescription]);
CreateOn = BaseBusinessLogic.ConvertToNullableDateTime(dr[BaseRoleEntity.FieldCreateOn]);
CreateUserId = BaseBusinessLogic.ConvertToString(dr[BaseRoleEntity.FieldCreateUserId]);
CreateBy = BaseBusinessLogic.ConvertToString(dr[BaseRoleEntity.FieldCreateBy]);
ModifiedOn = BaseBusinessLogic.ConvertToNullableDateTime(dr[BaseRoleEntity.FieldModifiedOn]);
ModifiedUserId = BaseBusinessLogic.ConvertToString(dr[BaseRoleEntity.FieldModifiedUserId]);
ModifiedBy = BaseBusinessLogic.ConvertToString(dr[BaseRoleEntity.FieldModifiedBy]);
// 获取扩展属性
GetFromExpand(dr);
return this;
}
/// <summary>
/// 从数据行读取
/// </summary>
/// <param name="dr">数据行</param>
protected override BaseEntity GetFrom(IDataRow dr)
{
Id = BaseBusinessLogic.ConvertToString(dr[BaseNewsEntity.FieldId]);
CompanyId = BaseBusinessLogic.ConvertToString(dr[BaseNewsEntity.FieldCompanyId]);
CompanyName = BaseBusinessLogic.ConvertToString(dr[BaseNewsEntity.FieldCompanyName]);
DepartmentId = BaseBusinessLogic.ConvertToString(dr[BaseNewsEntity.FieldDepartmentId]);
DepartmentName = BaseBusinessLogic.ConvertToString(dr[BaseNewsEntity.FieldDepartmentName]);
FolderId = BaseBusinessLogic.ConvertToString(dr[BaseNewsEntity.FieldFolderId]);
CategoryCode = BaseBusinessLogic.ConvertToString(dr[BaseNewsEntity.FieldCategoryCode]);
Code = BaseBusinessLogic.ConvertToString(dr[BaseNewsEntity.FieldCode]);
Title = BaseBusinessLogic.ConvertToString(dr[BaseNewsEntity.FieldTitle]);
FilePath = BaseBusinessLogic.ConvertToString(dr[BaseNewsEntity.FieldFilePath]);
Introduction = BaseBusinessLogic.ConvertToString(dr[BaseNewsEntity.FieldIntroduction]);
Contents = BaseBusinessLogic.ConvertToString(dr[BaseNewsEntity.FieldContents]);
Source = BaseBusinessLogic.ConvertToString(dr[BaseNewsEntity.FieldSource]);
Keywords = BaseBusinessLogic.ConvertToString(dr[BaseNewsEntity.FieldKeywords]);
FileSize = BaseBusinessLogic.ConvertToInt(dr[BaseNewsEntity.FieldFileSize]);
ImageUrl = BaseBusinessLogic.ConvertToString(dr[BaseNewsEntity.FieldImageUrl]);
SubPage = BaseBusinessLogic.ConvertToInt(dr[BaseNewsEntity.FieldSubPage]);
HomePage = BaseBusinessLogic.ConvertToInt(dr[BaseNewsEntity.FieldHomePage]);
AuditStatus = BaseBusinessLogic.ConvertToString(dr[BaseNewsEntity.FieldAuditStatus]);
ReadCount = BaseBusinessLogic.ConvertToInt(dr[BaseNewsEntity.FieldReadCount]);
DeletionStateCode = BaseBusinessLogic.ConvertToInt(dr[BaseNewsEntity.FieldDeletionStateCode]);
Description = BaseBusinessLogic.ConvertToString(dr[BaseNewsEntity.FieldDescription]);
Enabled = BaseBusinessLogic.ConvertToInt(dr[BaseNewsEntity.FieldEnabled]);
SortCode = BaseBusinessLogic.ConvertToInt(dr[BaseNewsEntity.FieldSortCode]);
CreateOn = BaseBusinessLogic.ConvertToNullableDateTime(dr[BaseNewsEntity.FieldCreateOn]);
CreateBy = BaseBusinessLogic.ConvertToString(dr[BaseNewsEntity.FieldCreateBy]);
CreateUserId = BaseBusinessLogic.ConvertToString(dr[BaseNewsEntity.FieldCreateUserId]);
ModifiedOn = BaseBusinessLogic.ConvertToNullableDateTime(dr[BaseNewsEntity.FieldModifiedOn]);
ModifiedBy = BaseBusinessLogic.ConvertToString(dr[BaseNewsEntity.FieldModifiedBy]);
ModifiedUserId = BaseBusinessLogic.ConvertToString(dr[BaseNewsEntity.FieldModifiedUserId]);
// 获取扩展属性
GetFromExpand(dr);
return(this);
}
/// <summary>
/// 从数据流读取
/// </summary>
/// <param name="dataReader">数据流</param>
public BaseContactDetailsEntity GetFrom(IDataReader dataReader)
{
this.GetFromExpand(dataReader);
this.Id = BaseBusinessLogic.ConvertToString(dataReader[BaseContactDetailsEntity.FieldId]);
this.ContactId = BaseBusinessLogic.ConvertToString(dataReader[BaseContactDetailsEntity.FieldContactId]);
this.Category = BaseBusinessLogic.ConvertToString(dataReader[BaseContactDetailsEntity.FieldCategory]);
this.ReceiverId = BaseBusinessLogic.ConvertToString(dataReader[BaseContactDetailsEntity.FieldReceiverId]);
this.ReceiverRealName = BaseBusinessLogic.ConvertToString(dataReader[BaseContactDetailsEntity.FieldReceiverRealName]);
this.IsNew = BaseBusinessLogic.ConvertToInt(dataReader[BaseContactDetailsEntity.FieldIsNew]);
this.NewComment = BaseBusinessLogic.ConvertToInt(dataReader[BaseContactDetailsEntity.FieldNewComment]);
this.LastViewIP = BaseBusinessLogic.ConvertToString(dataReader[BaseContactDetailsEntity.FieldLastViewIP]);
this.LastViewDate = BaseBusinessLogic.ConvertToString(dataReader[BaseContactDetailsEntity.FieldLastViewDate]);
this.Enabled = BaseBusinessLogic.ConvertToInt(dataReader[BaseContactDetailsEntity.FieldEnabled]);
this.DeletionStateCode = BaseBusinessLogic.ConvertToInt(dataReader[BaseContactDetailsEntity.FieldDeletionStateCode]);
this.SortCode = BaseBusinessLogic.ConvertToInt(dataReader[BaseContactDetailsEntity.FieldSortCode]);
this.Description = BaseBusinessLogic.ConvertToString(dataReader[BaseContactDetailsEntity.FieldDescription]);
this.CreateOn = BaseBusinessLogic.ConvertToDateTime(dataReader[BaseContactDetailsEntity.FieldCreateOn]);
this.CreateUserId = BaseBusinessLogic.ConvertToString(dataReader[BaseContactDetailsEntity.FieldCreateUserId]);
this.CreateBy = BaseBusinessLogic.ConvertToString(dataReader[BaseContactDetailsEntity.FieldCreateBy]);
this.ModifiedOn = BaseBusinessLogic.ConvertToDateTime(dataReader[BaseContactDetailsEntity.FieldModifiedOn]);
this.ModifiedUserId = BaseBusinessLogic.ConvertToString(dataReader[BaseContactDetailsEntity.FieldModifiedUserId]);
this.ModifiedBy = BaseBusinessLogic.ConvertToString(dataReader[BaseContactDetailsEntity.FieldModifiedBy]);
return(this);
}
/// <summary>
/// 从数据行读取
/// </summary>
/// <param name="dr">数据行</param>
protected override BaseEntity GetFrom(IDataRow dr)
{
Id = BaseBusinessLogic.ConvertToInt(dr[BaseWorkFlowHistoryEntity.FieldId]);
CurrentFlowId = BaseBusinessLogic.ConvertToString(dr[BaseWorkFlowHistoryEntity.FieldCurrentFlowId]);
ProcessId = BaseBusinessLogic.ConvertToInt(dr[BaseWorkFlowHistoryEntity.FieldProcessId]);
ActivityId = BaseBusinessLogic.ConvertToInt(dr[BaseWorkFlowHistoryEntity.FieldActivityId]);
ActivityCode = BaseBusinessLogic.ConvertToString(dr[BaseWorkFlowHistoryEntity.FieldActivityCode]);
ActivityFullName = BaseBusinessLogic.ConvertToString(dr[BaseWorkFlowHistoryEntity.FieldActivityFullName]);
ToDepartmentId = BaseBusinessLogic.ConvertToString(dr[BaseWorkFlowHistoryEntity.FieldToDepartmentId]);
ToDepartmentName = BaseBusinessLogic.ConvertToString(dr[BaseWorkFlowHistoryEntity.FieldToDepartmentName]);
ToUserId = BaseBusinessLogic.ConvertToString(dr[BaseWorkFlowHistoryEntity.FieldToUserId]);
ToUserRealName = BaseBusinessLogic.ConvertToString(dr[BaseWorkFlowHistoryEntity.FieldToUserRealName]);
ToRoleId = BaseBusinessLogic.ConvertToString(dr[BaseWorkFlowHistoryEntity.FieldToRoleId]);
ToRoleRealName = BaseBusinessLogic.ConvertToString(dr[BaseWorkFlowHistoryEntity.FieldToRoleRealName]);
AuditUserId = BaseBusinessLogic.ConvertToString(dr[BaseWorkFlowHistoryEntity.FieldAuditUserId]);
AuditUserCode = BaseBusinessLogic.ConvertToString(dr[BaseWorkFlowHistoryEntity.FieldAuditUserCode]);
AuditUserRealName = BaseBusinessLogic.ConvertToString(dr[BaseWorkFlowHistoryEntity.FieldAuditUserRealName]);
SendDate = BaseBusinessLogic.ConvertToNullableDateTime(dr[BaseWorkFlowHistoryEntity.FieldSendDate]);
AuditDate = BaseBusinessLogic.ConvertToNullableDateTime(dr[BaseWorkFlowHistoryEntity.FieldAuditDate]);
AuditIdea = BaseBusinessLogic.ConvertToString(dr[BaseWorkFlowHistoryEntity.FieldAuditIdea]);
AuditStatus = BaseBusinessLogic.ConvertToString(dr[BaseWorkFlowHistoryEntity.FieldAuditStatus]);
AuditStatusName = BaseBusinessLogic.ConvertToString(dr[BaseWorkFlowHistoryEntity.FieldAuditStatusName]);
SortCode = BaseBusinessLogic.ConvertToInt(dr[BaseWorkFlowHistoryEntity.FieldSortCode]);
Enabled = BaseBusinessLogic.ConvertToInt(dr[BaseWorkFlowHistoryEntity.FieldEnabled]);
DeletionStateCode = BaseBusinessLogic.ConvertToInt(dr[BaseWorkFlowHistoryEntity.FieldDeletionStateCode]);
Description = BaseBusinessLogic.ConvertToString(dr[BaseWorkFlowHistoryEntity.FieldDescription]);
CreateOn = BaseBusinessLogic.ConvertToNullableDateTime(dr[BaseWorkFlowHistoryEntity.FieldCreateOn]);
CreateUserId = BaseBusinessLogic.ConvertToString(dr[BaseWorkFlowHistoryEntity.FieldCreateUserId]);
CreateBy = BaseBusinessLogic.ConvertToString(dr[BaseWorkFlowHistoryEntity.FieldCreateBy]);
ModifiedOn = BaseBusinessLogic.ConvertToNullableDateTime(dr[BaseWorkFlowHistoryEntity.FieldModifiedOn]);
ModifiedUserId = BaseBusinessLogic.ConvertToString(dr[BaseWorkFlowHistoryEntity.FieldModifiedUserId]);
ModifiedBy = BaseBusinessLogic.ConvertToString(dr[BaseWorkFlowHistoryEntity.FieldModifiedBy]);
// 获取扩展属性
GetFromExpand(dr);
return(this);
}
/// <summary>
/// 从数据流读取
/// </summary>
/// <param name="dataReader">数据流</param>
public BaseRoleEntity GetFrom(IDataReader dataReader)
{
this.GetFromExpand(dataReader);
this.Id = BaseBusinessLogic.ConvertToInt(dataReader[BaseRoleEntity.FieldId]);
this.SystemId = BaseBusinessLogic.ConvertToString(dataReader[BaseRoleEntity.FieldSystemId]);
this.OrganizeId = BaseBusinessLogic.ConvertToString(dataReader[BaseRoleEntity.FieldOrganizeId]);
this.Code = BaseBusinessLogic.ConvertToString(dataReader[BaseRoleEntity.FieldCode]);
this.RealName = BaseBusinessLogic.ConvertToString(dataReader[BaseRoleEntity.FieldRealName]);
this.CategoryCode = BaseBusinessLogic.ConvertToString(dataReader[BaseRoleEntity.FieldCategoryCode]);
this.AllowEdit = BaseBusinessLogic.ConvertToInt(dataReader[BaseRoleEntity.FieldAllowEdit]);
this.AllowDelete = BaseBusinessLogic.ConvertToInt(dataReader[BaseRoleEntity.FieldAllowDelete]);
this.IsVisible = BaseBusinessLogic.ConvertToInt(dataReader[BaseRoleEntity.FieldIsVisible]);
this.SortCode = BaseBusinessLogic.ConvertToInt(dataReader[BaseRoleEntity.FieldSortCode]);
this.DeletionStateCode = BaseBusinessLogic.ConvertToInt(dataReader[BaseRoleEntity.FieldDeletionStateCode]);
this.Enabled = BaseBusinessLogic.ConvertToInt(dataReader[BaseRoleEntity.FieldEnabled]);
this.Description = BaseBusinessLogic.ConvertToString(dataReader[BaseRoleEntity.FieldDescription]);
this.CreateOn = BaseBusinessLogic.ConvertToDateTime(dataReader[BaseRoleEntity.FieldCreateOn]);
this.CreateUserId = BaseBusinessLogic.ConvertToString(dataReader[BaseRoleEntity.FieldCreateUserId]);
this.CreateBy = BaseBusinessLogic.ConvertToString(dataReader[BaseRoleEntity.FieldCreateBy]);
this.ModifiedOn = BaseBusinessLogic.ConvertToDateTime(dataReader[BaseRoleEntity.FieldModifiedOn]);
this.ModifiedUserId = BaseBusinessLogic.ConvertToString(dataReader[BaseRoleEntity.FieldModifiedUserId]);
this.ModifiedBy = BaseBusinessLogic.ConvertToString(dataReader[BaseRoleEntity.FieldModifiedBy]);
return(this);
}
/// <summary>
/// 从数据行读取
/// </summary>
/// <param name="dr">数据行</param>
protected override BaseEntity GetFrom(IDataRow dr)
{
Id = BaseBusinessLogic.ConvertToInt(dr[BaseWorkFlowStepEntity.FieldId]);
ProcessId = BaseBusinessLogic.ConvertToInt(dr[BaseWorkFlowStepEntity.FieldProcessId]);
Code = BaseBusinessLogic.ConvertToString(dr[BaseWorkFlowStepEntity.FieldCode]);
FullName = BaseBusinessLogic.ConvertToString(dr[BaseWorkFlowStepEntity.FieldFullName]);
AuditDepartmentId = BaseBusinessLogic.ConvertToString(dr[BaseWorkFlowStepEntity.FieldAuditDepartmentId]);
AuditDepartmentName = BaseBusinessLogic.ConvertToString(dr[BaseWorkFlowStepEntity.FieldAuditDepartmentName]);
AuditUserId = BaseBusinessLogic.ConvertToString(dr[BaseWorkFlowStepEntity.FieldAuditUserId]);
AuditUserCode = BaseBusinessLogic.ConvertToString(dr[BaseWorkFlowStepEntity.FieldAuditUserCode]);
AuditUserRealName = BaseBusinessLogic.ConvertToString(dr[BaseWorkFlowStepEntity.FieldAuditUserRealName]);
AuditRoleId = BaseBusinessLogic.ConvertToString(dr[BaseWorkFlowStepEntity.FieldAuditRoleId]);
AuditRoleRealName = BaseBusinessLogic.ConvertToString(dr[BaseWorkFlowStepEntity.FieldAuditRoleRealName]);
if (dr.ContainsColumn(BaseWorkFlowStepEntity.FieldActivityId))
{
ActivityId = BaseBusinessLogic.ConvertToInt(dr[BaseWorkFlowStepEntity.FieldActivityId]);
}
else
{
ActivityId = BaseBusinessLogic.ConvertToInt(dr[BaseWorkFlowStepEntity.FieldId]);
}
ActivityType = BaseBusinessLogic.ConvertToString(dr[BaseWorkFlowStepEntity.FieldActivityType]);
AllowPrint = BaseBusinessLogic.ConvertToInt(dr[BaseWorkFlowStepEntity.FieldAllowPrint]);
AllowEditDocuments = BaseBusinessLogic.ConvertToInt(dr[BaseWorkFlowStepEntity.FieldAllowEditDocuments]);
SortCode = BaseBusinessLogic.ConvertToInt(dr[BaseWorkFlowStepEntity.FieldSortCode]);
Enabled = BaseBusinessLogic.ConvertToInt(dr[BaseWorkFlowStepEntity.FieldEnabled]);
DeletionStateCode = BaseBusinessLogic.ConvertToInt(dr[BaseWorkFlowStepEntity.FieldDeletionStateCode]);
Description = BaseBusinessLogic.ConvertToString(dr[BaseWorkFlowStepEntity.FieldDescription]);
CreateOn = BaseBusinessLogic.ConvertToNullableDateTime(dr[BaseWorkFlowStepEntity.FieldCreateOn]);
CreateUserId = BaseBusinessLogic.ConvertToString(dr[BaseWorkFlowStepEntity.FieldCreateUserId]);
CreateBy = BaseBusinessLogic.ConvertToString(dr[BaseWorkFlowStepEntity.FieldCreateBy]);
ModifiedOn = BaseBusinessLogic.ConvertToNullableDateTime(dr[BaseWorkFlowStepEntity.FieldModifiedOn]);
ModifiedUserId = BaseBusinessLogic.ConvertToString(dr[BaseWorkFlowStepEntity.FieldModifiedUserId]);
ModifiedBy = BaseBusinessLogic.ConvertToString(dr[BaseWorkFlowStepEntity.FieldModifiedBy]);
return(this);
}
/// <summary>
/// 导入Excel数据到本地数据库
/// </summary>
public bool Import()
{
if (string.IsNullOrEmpty(txtFileFullPath.Text.Trim()))
{
XtraMessageBox.Show(@"请选择录单模板", AppMessage.MSG0000, MessageBoxButtons.OK, MessageBoxIcon.Information);
btnOpenExcel_Click(this, null);
return(false);
}
if (!File.Exists(txtFileFullPath.Text))
{
XtraMessageBox.Show(@"选中文件不存在，请重新选择导入Excel文件", AppMessage.MSG0000, MessageBoxButtons.OK, MessageBoxIcon.Information);
btnOpenExcel_Click(this, null);
return(false);
}
var startDateTime = DateTime.Now;
StartDt = startDateTime;
if (!splashScreenManagerImportExcel.IsSplashFormVisible)
{
splashScreenManagerImportExcel.ShowWaitForm();
}
Application.DoEvents();
splashScreenManagerImportExcel.SetWaitFormCaption("请稍后");
splashScreenManagerImportExcel.SetWaitFormDescription("开始导入Excel数据...");
try
{
DataTable chooseDt = ExcelHelper.ExcelToDataTable(txtFileFullPath.Text.Trim(), 38, 0, 3);
if (chooseDt != null && chooseDt.Rows.Count > 0)
{
var list = new List <ZtoPrintBillEntity>();
int temp = 0;
var defaultUserList = new ZtoUserManager(BillPrintHelper.DbHelper).GetList <ZtoUserEntity>(new KeyValuePair <string, object>(ZtoUserEntity.FieldIsDefault, 1), new KeyValuePair <string, object>(ZtoUserEntity.FieldIssendorreceive, 1));
ZtoUserEntity defaultUserEntity = null;
if (defaultUserList.Any())
{
defaultUserEntity = defaultUserList.First();
}
foreach (DataRow dr in chooseDt.Rows)
{
++temp;
splashScreenManagerImportExcel.SetWaitFormDescription(string.Format("正在导入Excel数据：{0}/{1}", temp, chooseDt.Rows.Count));
ZtoPrintBillEntity entity = new ZtoPrintBillEntity();
if (ckTodaySend.Checked)
{
entity.SendDate = DateTime.Now.ToString(BaseSystemInfo.DateFormat);
}
if (ckUserDefaultSendMan.Checked)
{
if (defaultUserEntity != null)
{
entity.SendMan = defaultUserEntity.Realname;
entity.SendPhone = defaultUserEntity.Mobile + " " + defaultUserEntity.TelePhone;
entity.SendProvince = defaultUserEntity.Province;
entity.SendCity = defaultUserEntity.City;
entity.SendCounty = defaultUserEntity.County;
entity.SendAddress = defaultUserEntity.Address;
entity.SendSite = "";
entity.SendDeparture = entity.SendProvince;
entity.SendCompany = defaultUserEntity.Company;
entity.SendDepartment = defaultUserEntity.Department;
entity.SendPostcode = defaultUserEntity.Postcode;
}
}
else
{
if (this.Tag != null)
{
var sendUserEntity = this.Tag as ZtoUserEntity;
// 表示选择了一个发件人的信息，这样也不用读取Excel里面的发件人了
if (sendUserEntity != null)
{
entity.SendMan = sendUserEntity.Realname;
entity.SendPhone = sendUserEntity.Mobile + " " + sendUserEntity.TelePhone;
entity.SendProvince = sendUserEntity.Province;
entity.SendCity = sendUserEntity.City;
entity.SendCounty = sendUserEntity.County;
entity.SendAddress = sendUserEntity.Address;
entity.SendSite = "";
entity.SendDeparture = sendUserEntity.Province;
entity.SendCompany = sendUserEntity.Company;
entity.SendDepartment = sendUserEntity.Department;
entity.SendPostcode = sendUserEntity.Postcode;
}
}
else
{
entity.SendMan = BaseBusinessLogic.ConvertToString(dr[2]);
entity.SendPhone = BaseBusinessLogic.ConvertToString(dr[3]);
entity.SendProvince = BaseBusinessLogic.ConvertToString(dr[4]);
entity.SendCity = BaseBusinessLogic.ConvertToString(dr[5]);
entity.SendCounty = BaseBusinessLogic.ConvertToString(dr[6]);
entity.SendAddress = BaseBusinessLogic.ConvertToString(dr[7]);
entity.SendSite = "";
entity.SendDeparture = BaseBusinessLogic.ConvertToString(dr[26]);
if (string.IsNullOrEmpty(entity.SendDeparture))
{
entity.SendDeparture = entity.SendProvince;
}
entity.SendCompany = BaseBusinessLogic.ConvertToString(dr[27]);
entity.SendDepartment = BaseBusinessLogic.ConvertToString(dr[28]);
entity.SendPostcode = BaseBusinessLogic.ConvertToString(dr[29]);
}
}
entity.ReceiveMan = BaseBusinessLogic.ConvertToString(dr[8]);
entity.ReceivePhone = BaseBusinessLogic.ConvertToString(dr[9]);
entity.ReceiveProvince = BaseBusinessLogic.ConvertToString(dr[10]);
entity.ReceiveCity = BaseBusinessLogic.ConvertToString(dr[11]);
entity.ReceiveCounty = BaseBusinessLogic.ConvertToString(dr[12]);
entity.ReceiveAddress = BaseBusinessLogic.ConvertToString(dr[13]);
entity.ReceiveDestination = BaseBusinessLogic.ConvertToString(dr[30]);
if (string.IsNullOrEmpty(entity.ReceiveDestination))
{
entity.ReceiveDestination = entity.ReceiveProvince;
}
entity.ReceiveCompany = BaseBusinessLogic.ConvertToString(dr[31]);
entity.ReceivePostcode = BaseBusinessLogic.ConvertToString(dr[32]);
entity.GoodsName = BaseBusinessLogic.ConvertToString(dr[14]);
entity.Weight = BaseBusinessLogic.ConvertToString(dr[15]);
entity.TranFee = BaseBusinessLogic.ConvertToString(dr[16]);
entity.GOODS_PAYMENT = BaseBusinessLogic.ConvertToDecimal(dr[17]);
entity.TOPAYMENT = BaseBusinessLogic.ConvertToDecimal(dr[18]);
entity.Length = BaseBusinessLogic.ConvertToString(dr[33]);
entity.Width = BaseBusinessLogic.ConvertToString(dr[34]);
entity.Height = BaseBusinessLogic.ConvertToString(dr[35]);
entity.TotalNumber = BaseBusinessLogic.ConvertToString(dr[36]);
entity.OrderNumber = BaseBusinessLogic.ConvertToString(dr[37]);
entity.Remark = BaseBusinessLogic.ConvertToString(dr[22]);
entity.CreateUserName = "";
entity.CreateSite = "";
entity.CreateOn = DateTime.Now;
entity.PaymentType = "现金";
// 如果Excel里面没有填写订单号系统自动生成一个订单号，这样提取电子面单单号就不用怕了，2016-1-23 14:07:12
if (string.IsNullOrEmpty(entity.OrderNumber))
{
// 导入自动生成订单号（电子面单）79170-南昌昌南 18779176845 这个qq提供的思路，2016-1-20 20:08:50
entity.OrderNumber = Guid.NewGuid().ToString("N").ToLower();
}
if (!ckGetServerPrintMark.Checked)
{
entity.BigPen = string.Format("{0} {1} {2}", entity.ReceiveProvince, entity.ReceiveCity, entity.ReceiveCounty);
}
else
{
entity.BigPen = "";
}
list.Add(entity);
}
if (!ckGetServerPrintMark.Checked)
{
var manager = new ZtoPrintBillManager(BillPrintHelper.DbHelper);
foreach (ZtoPrintBillEntity ztoPrintBillEntity in list)
{
manager.Add(ztoPrintBillEntity, true);
}
if (splashScreenManagerImportExcel != null && splashScreenManagerImportExcel.IsSplashFormVisible)
{
splashScreenManagerImportExcel.CloseWaitForm();
}
GridDataBind();
var ts = DateTime.Now - startDateTime;
lblTime.Text = string.Format("耗时:{0}时{1}分{2}秒{3}毫秒", ts.Hours, ts.Minutes, ts.Seconds, ts.Milliseconds);
Close();
}
else
{
splashScreenManagerImportExcel.SetWaitFormDescription("正在联网获取大头笔信息，请稍后......");
// 开线程去读取大头笔的
CheckBillCode(list);
}
}
else
{
XtraMessageBox.Show(@"模板没有填写任何数据，导入失败", AppMessage.MSG0000, MessageBoxButtons.OK, MessageBoxIcon.Error);
return(false);
}
}
catch (Exception ex)
{
ProcessException(ex);
return(false);
}
finally
{
if (splashScreenManagerImportExcel != null && splashScreenManagerImportExcel.IsSplashFormVisible)
{
splashScreenManagerImportExcel.CloseWaitForm();
}
}
return(true);
}
/// <summary>
/// 从数据行读取
/// </summary>
/// <param name="dr">数据行</param>
protected override BaseEntity GetFrom(IDataRow dr)
{
GetFromExpand(dr);
if (dr.ContainsColumn(ZtoPrintBillEntity.FieldId))
{
Id = BaseBusinessLogic.ConvertToDecimal(dr[ZtoPrintBillEntity.FieldId]);
}
if (dr.ContainsColumn(ZtoPrintBillEntity.FieldSendPostcode))
{
SendPostcode = BaseBusinessLogic.ConvertToString(dr[ZtoPrintBillEntity.FieldSendPostcode]);
}
if (dr.ContainsColumn(ZtoPrintBillEntity.FieldReceiveMan))
{
ReceiveMan = BaseBusinessLogic.ConvertToString(dr[ZtoPrintBillEntity.FieldReceiveMan]);
}
if (dr.ContainsColumn(ZtoPrintBillEntity.FieldReceiveProvince))
{
ReceiveProvince = BaseBusinessLogic.ConvertToString(dr[ZtoPrintBillEntity.FieldReceiveProvince]);
}
if (dr.ContainsColumn(ZtoPrintBillEntity.FieldCreateUserName))
{
CreateUserName = BaseBusinessLogic.ConvertToString(dr[ZtoPrintBillEntity.FieldCreateUserName]);
}
if (dr.ContainsColumn(ZtoPrintBillEntity.FieldModifiedSite))
{
ModifiedSite = BaseBusinessLogic.ConvertToString(dr[ZtoPrintBillEntity.FieldModifiedSite]);
}
if (dr.ContainsColumn(ZtoPrintBillEntity.FieldModifiedUserName))
{
ModifiedUserName = BaseBusinessLogic.ConvertToString(dr[ZtoPrintBillEntity.FieldModifiedUserName]);
}
if (dr.ContainsColumn(ZtoPrintBillEntity.FieldPaymentType))
{
PaymentType = BaseBusinessLogic.ConvertToString(dr[ZtoPrintBillEntity.FieldPaymentType]);
}
if (dr.ContainsColumn(ZtoPrintBillEntity.FieldLength))
{
Length = BaseBusinessLogic.ConvertToString(dr[ZtoPrintBillEntity.FieldLength]);
}
if (dr.ContainsColumn(ZtoPrintBillEntity.FieldSendMan))
{
SendMan = BaseBusinessLogic.ConvertToString(dr[ZtoPrintBillEntity.FieldSendMan]);
}
if (dr.ContainsColumn(ZtoPrintBillEntity.FieldModifiedOn))
{
ModifiedOn = BaseBusinessLogic.ConvertToNullableDateTime(dr[ZtoPrintBillEntity.FieldModifiedOn]);
}
if (dr.ContainsColumn(ZtoPrintBillEntity.FieldReceiveAddress))
{
ReceiveAddress = BaseBusinessLogic.ConvertToString(dr[ZtoPrintBillEntity.FieldReceiveAddress]);
}
if (dr.ContainsColumn(ZtoPrintBillEntity.FieldReceivePostcode))
{
ReceivePostcode = BaseBusinessLogic.ConvertToString(dr[ZtoPrintBillEntity.FieldReceivePostcode]);
}
if (dr.ContainsColumn(ZtoPrintBillEntity.FieldReceivePhone))
{
ReceivePhone = BaseBusinessLogic.ConvertToString(dr[ZtoPrintBillEntity.FieldReceivePhone]);
}
if (dr.ContainsColumn(ZtoPrintBillEntity.FieldSendDepartment))
{
SendDepartment = BaseBusinessLogic.ConvertToString(dr[ZtoPrintBillEntity.FieldSendDepartment]);
}
if (dr.ContainsColumn(ZtoPrintBillEntity.FieldSendDate))
{
SendDate = BaseBusinessLogic.ConvertToString(dr[ZtoPrintBillEntity.FieldSendDate]);
}
if (dr.ContainsColumn(ZtoPrintBillEntity.FieldSendProvince))
{
SendProvince = BaseBusinessLogic.ConvertToString(dr[ZtoPrintBillEntity.FieldSendProvince]);
}
if (dr.ContainsColumn(ZtoPrintBillEntity.FieldTranFee))
{
TranFee = BaseBusinessLogic.ConvertToString(dr[ZtoPrintBillEntity.FieldTranFee]);
}
if (dr.ContainsColumn(ZtoPrintBillEntity.FieldSendDeparture))
{
SendDeparture = BaseBusinessLogic.ConvertToString(dr[ZtoPrintBillEntity.FieldSendDeparture]);
}
if (dr.ContainsColumn(ZtoPrintBillEntity.FieldSendPhone))
{
SendPhone = BaseBusinessLogic.ConvertToString(dr[ZtoPrintBillEntity.FieldSendPhone]);
}
if (dr.ContainsColumn(ZtoPrintBillEntity.FieldSendCity))
{
SendCity = BaseBusinessLogic.ConvertToString(dr[ZtoPrintBillEntity.FieldSendCity]);
}
if (dr.ContainsColumn(ZtoPrintBillEntity.FieldGoodsName))
{
GoodsName = BaseBusinessLogic.ConvertToString(dr[ZtoPrintBillEntity.FieldGoodsName]);
}
if (dr.ContainsColumn(ZtoPrintBillEntity.FieldWeight))
{
Weight = BaseBusinessLogic.ConvertToString(dr[ZtoPrintBillEntity.FieldWeight]);
}
if (dr.ContainsColumn(ZtoPrintBillEntity.FieldHeight))
{
Height = BaseBusinessLogic.ConvertToString(dr[ZtoPrintBillEntity.FieldHeight]);
}
if (dr.ContainsColumn(ZtoPrintBillEntity.FieldReceiveCounty))
{
ReceiveCounty = BaseBusinessLogic.ConvertToString(dr[ZtoPrintBillEntity.FieldReceiveCounty]);
}
if (dr.ContainsColumn(ZtoPrintBillEntity.FieldReceiveDestination))
{
ReceiveDestination = BaseBusinessLogic.ConvertToString(dr[ZtoPrintBillEntity.FieldReceiveDestination]);
}
if (dr.ContainsColumn(ZtoPrintBillEntity.FieldSendCompany))
{
SendCompany = BaseBusinessLogic.ConvertToString(dr[ZtoPrintBillEntity.FieldSendCompany]);
}
if (dr.ContainsColumn(ZtoPrintBillEntity.FieldCreateOn))
{
CreateOn = BaseBusinessLogic.ConvertToDateTime(dr[ZtoPrintBillEntity.FieldCreateOn]);
}
if (dr.ContainsColumn(ZtoPrintBillEntity.FieldBillCode))
{
BillCode = BaseBusinessLogic.ConvertToString(dr[ZtoPrintBillEntity.FieldBillCode]);
}
if (dr.ContainsColumn(ZtoPrintBillEntity.FieldTotalNumber))
{
TotalNumber = BaseBusinessLogic.ConvertToString(dr[ZtoPrintBillEntity.FieldTotalNumber]);
}
if (dr.ContainsColumn(ZtoPrintBillEntity.FieldRemark))
{
Remark = BaseBusinessLogic.ConvertToString(dr[ZtoPrintBillEntity.FieldRemark]);
}
if (dr.ContainsColumn(ZtoPrintBillEntity.FieldCreateSite))
{
CreateSite = BaseBusinessLogic.ConvertToString(dr[ZtoPrintBillEntity.FieldCreateSite]);
}
if (dr.ContainsColumn(ZtoPrintBillEntity.FieldSendSite))
{
SendSite = BaseBusinessLogic.ConvertToString(dr[ZtoPrintBillEntity.FieldSendSite]);
}
if (dr.ContainsColumn(ZtoPrintBillEntity.FieldWidth))
{
Width = BaseBusinessLogic.ConvertToString(dr[ZtoPrintBillEntity.FieldWidth]);
}
if (dr.ContainsColumn(ZtoPrintBillEntity.FieldReceiveCity))
{
ReceiveCity = BaseBusinessLogic.ConvertToString(dr[ZtoPrintBillEntity.FieldReceiveCity]);
}
if (dr.ContainsColumn(ZtoPrintBillEntity.FieldSendAddress))
{
SendAddress = BaseBusinessLogic.ConvertToString(dr[ZtoPrintBillEntity.FieldSendAddress]);
}
if (dr.ContainsColumn(ZtoPrintBillEntity.FieldSendCounty))
{
SendCounty = BaseBusinessLogic.ConvertToString(dr[ZtoPrintBillEntity.FieldSendCounty]);
}
if (dr.ContainsColumn(ZtoPrintBillEntity.FieldReceiveCompany))
{
ReceiveCompany = BaseBusinessLogic.ConvertToString(dr[ZtoPrintBillEntity.FieldReceiveCompany]);
}
if (dr.ContainsColumn(ZtoPrintBillEntity.FieldBigPen))
{
BigPen = BaseBusinessLogic.ConvertToString(dr[ZtoPrintBillEntity.FieldBigPen]);
}
if (dr.ContainsColumn(ZtoPrintBillEntity.FieldOrderNumber))
{
OrderNumber = BaseBusinessLogic.ConvertToString(dr[ZtoPrintBillEntity.FieldOrderNumber]);
}
if (dr.ContainsColumn(ZtoPrintBillEntity.FieldExpressId))
{
ExpressId = BaseBusinessLogic.ConvertToString(dr[ZtoPrintBillEntity.FieldExpressId]);
}
if (dr.ContainsColumn(ZtoPrintBillEntity.FieldToPayMent))
{
TOPAYMENT = BaseBusinessLogic.ConvertToDecimal(dr[ZtoPrintBillEntity.FieldToPayMent]);
}
if (dr.ContainsColumn(ZtoPrintBillEntity.FieldGoodsPayMent))
{
GOODS_PAYMENT = BaseBusinessLogic.ConvertToDecimal(dr[ZtoPrintBillEntity.FieldGoodsPayMent]);
}
return(this);
}
/// <summary>
/// 导入Excel数据到本地数据库
/// </summary>
public bool Import()
{
if (string.IsNullOrEmpty(txtFileFullPath.Text.Trim()))
{
XtraMessageBox.Show(@"请选择录单模板", AppMessage.MSG0000, MessageBoxButtons.OK, MessageBoxIcon.Information);
btnOpenExcel_Click(this, null);
return(false);
}
if (!File.Exists(txtFileFullPath.Text))
{
XtraMessageBox.Show(@"选中文件不存在，请重新选择导入Excel文件", AppMessage.MSG0000, MessageBoxButtons.OK, MessageBoxIcon.Information);
btnOpenExcel_Click(this, null);
return(false);
}
if (!splashScreenManagerImportExcel.IsSplashFormVisible)
{
splashScreenManagerImportExcel.ShowWaitForm();
}
Application.DoEvents();
splashScreenManagerImportExcel.SetWaitFormCaption("请稍后");
splashScreenManagerImportExcel.SetWaitFormDescription("开始导入Excel数据...");
try
{
int crossRow = int.Parse(cmbPrintNumber.Text) - 1;
if (crossRow < 0)
{
crossRow = 1;
}
DataTable chooseDt = ExcelHelper.ExcelToDataTable(txtFileFullPath.Text.Trim(), 38, 0, crossRow);
if (chooseDt != null && chooseDt.Rows.Count > 0)
{
var list = new List <ZtoUserEntity>();
int temp = 0;
foreach (DataRow dr in chooseDt.Rows)
{
++temp;
splashScreenManagerImportExcel.SetWaitFormDescription(string.Format("正在导入Excel数据：{0}/{1}", temp, chooseDt.Rows.Count));
var userEntity = new ZtoUserEntity {
Realname = BaseBusinessLogic.ConvertToString(dr[8])
};
if (ValidateUtil.IsMobile(BaseBusinessLogic.ConvertToString(dr[9])))
{
userEntity.Mobile = BaseBusinessLogic.ConvertToString(dr[9]);
}
else
{
userEntity.TelePhone = BaseBusinessLogic.ConvertToString(dr[9]);
}
var tempProvince = BaseBusinessLogic.ConvertToString(dr[10]);
// 收件人地址（有可能用户不填写收件省市区）
userEntity.Address = BaseBusinessLogic.ConvertToString(dr[13]);
if (tempProvince != null)
{
userEntity.Province = tempProvince.Trim();
}
var tempCity = BaseBusinessLogic.ConvertToString(dr[11]);
if (tempCity != null)
{
userEntity.City = tempCity.Trim();
}
var tempCounty = BaseBusinessLogic.ConvertToString(dr[12]);
if (tempCounty != null)
{
userEntity.County = tempCounty.Trim();
}
if (string.IsNullOrEmpty(userEntity.Province) && string.IsNullOrEmpty(userEntity.City) && string.IsNullOrEmpty(userEntity.County))
{
if (!string.IsNullOrEmpty(userEntity.Address))
{
var result = BaiduMapHelper.GetProvCityDistFromBaiduMap(userEntity.Address);
if (result != null)
{
userEntity.Province = result.Result.AddressComponent.Province;
userEntity.City = result.Result.AddressComponent.City;
userEntity.County = result.Result.AddressComponent.District;
}
}
}
userEntity.Company = BaseBusinessLogic.ConvertToString(dr[31]);
userEntity.Postcode = BaseBusinessLogic.ConvertToString(dr[32]);
userEntity.Issendorreceive = "0";
if (string.IsNullOrEmpty(userEntity.Postcode))
{
if (!string.IsNullOrEmpty(userEntity.City) && !string.IsNullOrEmpty(userEntity.County))
{
userEntity.Postcode = NetworkHelper.GetPostCodeByAddress(userEntity.City, userEntity.County);
}
}
if (!string.IsNullOrEmpty(userEntity.Province))
{
var areaEntity = _areaManager.GetList <BaseAreaEntity>(new KeyValuePair <string, object>(BaseAreaEntity.FieldFullName, userEntity.Province)).FirstOrDefault();
if (areaEntity != null)
{
userEntity.ProvinceId = areaEntity.Id;
}
}
if (!string.IsNullOrEmpty(userEntity.City))
{
var areaEntity = _areaManager.GetList <BaseAreaEntity>(new KeyValuePair <string, object>(BaseAreaEntity.FieldFullName, userEntity.City)).FirstOrDefault();
if (areaEntity != null)
{
userEntity.CityId = areaEntity.Id;
}
}
if (!string.IsNullOrEmpty(userEntity.County))
{
var areaEntity = _areaManager.GetList <BaseAreaEntity>(new KeyValuePair <string, object>(BaseAreaEntity.FieldFullName, userEntity.County)).FirstOrDefault();
if (areaEntity != null)
{
userEntity.CountyId = areaEntity.Id;
}
}
userEntity.CreateOn = DateTime.Now;
list.Add(userEntity);
}
using (IDbHelper dbHelper = DbHelperFactory.GetHelper(CurrentDbType.SQLite, BillPrintHelper.BillPrintConnectionString))
{
try
{
dbHelper.BeginTransaction();
var manager = new ZtoUserManager(dbHelper);
foreach (ZtoUserEntity ztoUserEntity in list)
{
manager.Add(ztoUserEntity, true);
}
dbHelper.CommitTransaction();
GridDataBind();
}
catch (Exception ex)
{
dbHelper.RollbackTransaction();
ProcessException(ex);
}
}
if (splashScreenManagerImportExcel != null && splashScreenManagerImportExcel.IsSplashFormVisible)
{
splashScreenManagerImportExcel.CloseWaitForm();
}
Close();
}
else
{
XtraMessageBox.Show(@"模板没有填写任何数据，导入失败", AppMessage.MSG0000, MessageBoxButtons.OK, MessageBoxIcon.Error);
return(false);
}
}
catch (Exception ex)
{
ProcessException(ex);
return(false);
}
finally
{
if (splashScreenManagerImportExcel != null && splashScreenManagerImportExcel.IsSplashFormVisible)
{
splashScreenManagerImportExcel.CloseWaitForm();
}
}
return(true);
}
/// <summary>
/// 导入Excel数据到本地数据库
/// </summary>
public bool Import()
{
if (string.IsNullOrEmpty(txtFileFullPath.Text.Trim()))
{
XtraMessageBox.Show(@"请选择录单模板", AppMessage.MSG0000, MessageBoxButtons.OK, MessageBoxIcon.Information);
btnOpenExcel_Click(this, null);
return(false);
}
if (!File.Exists(txtFileFullPath.Text))
{
XtraMessageBox.Show(@"选中文件不存在，请重新选择导入Excel文件", AppMessage.MSG0000, MessageBoxButtons.OK, MessageBoxIcon.Information);
btnOpenExcel_Click(this, null);
return(false);
}
var startDateTime = DateTime.Now;
StartDt = startDateTime;
if (!splashScreenManagerImportExcel.IsSplashFormVisible)
{
splashScreenManagerImportExcel.ShowWaitForm();
}
Application.DoEvents();
splashScreenManagerImportExcel.SetWaitFormCaption("请稍后");
splashScreenManagerImportExcel.SetWaitFormDescription("开始导入Excel数据...");
try
{
DataTable chooseDt = ExcelHelper.ExcelToDataTable(txtFileFullPath.Text.Trim(), 11, 0, 1);
if (chooseDt != null && chooseDt.Rows.Count > 0)
{
var list = new List <ZtoPrintBillEntity>();
int temp = 0;
var defaultUserList = new ZtoUserManager(BillPrintHelper.DbHelper).GetList <ZtoUserEntity>(new KeyValuePair <string, object>(ZtoUserEntity.FieldIsDefault, 1), new KeyValuePair <string, object>(ZtoUserEntity.FieldIssendorreceive, 1));
ZtoUserEntity defaultUserEntity = null;
if (defaultUserList.Any())
{
defaultUserEntity = defaultUserList.First();
}
foreach (DataRow dr in chooseDt.Rows)
{
++temp;
splashScreenManagerImportExcel.SetWaitFormDescription(string.Format("正在导入Excel数据：{0}/{1}", temp, chooseDt.Rows.Count));
ZtoPrintBillEntity entity = new ZtoPrintBillEntity();
if (ckTodaySend.Checked)
{
entity.SendDate = DateTime.Now.ToString(BaseSystemInfo.DateFormat);
}
if (ckUserDefaultSendMan.Checked)
{
if (defaultUserEntity != null)
{
entity.SendMan = defaultUserEntity.Realname;
entity.SendPhone = defaultUserEntity.Mobile + " " + defaultUserEntity.TelePhone;
entity.SendProvince = defaultUserEntity.Province;
entity.SendCity = defaultUserEntity.City;
entity.SendCounty = defaultUserEntity.County;
entity.SendAddress = defaultUserEntity.Address;
entity.SendDeparture = entity.SendProvince;
entity.SendCompany = defaultUserEntity.Company;
entity.SendDepartment = defaultUserEntity.Department;
entity.SendPostcode = defaultUserEntity.Postcode;
}
}
else
{
// 使用Excel里面的发件人
entity.SendMan = BaseBusinessLogic.ConvertToString(dr[6]);
entity.SendPhone = BaseBusinessLogic.ConvertToString(dr[7]);
entity.SendAddress = BaseBusinessLogic.ConvertToString(dr[8]);
if (string.IsNullOrEmpty(entity.SendProvince) && string.IsNullOrEmpty(entity.SendCity) && string.IsNullOrEmpty(entity.SendCounty))
{
if (!string.IsNullOrEmpty(entity.SendAddress))
{
var baiAddressEntity = BaiduMapHelper.GetProvCityDistFromBaiduMap(entity.SendAddress);
if (baiAddressEntity != null)
{
entity.SendProvince = baiAddressEntity.Result.AddressComponent.Province;
entity.SendCity = baiAddressEntity.Result.AddressComponent.City;
entity.SendCounty = baiAddressEntity.Result.AddressComponent.District;
}
}
}
entity.SendDeparture = entity.SendProvince;
if (string.IsNullOrEmpty(entity.SendDeparture))
{
entity.SendDeparture = entity.SendProvince;
}
entity.SendCompany = BaseBusinessLogic.ConvertToString(dr[10]);
entity.SendDepartment = BaseBusinessLogic.ConvertToString(dr[11]);
entity.SendPostcode = BaseBusinessLogic.ConvertToString(dr[9]);
}
entity.ReceiveMan = BaseBusinessLogic.ConvertToString(dr[0]);
entity.ReceivePhone = BaseBusinessLogic.ConvertToString(dr[1]);
entity.ReceiveAddress = BaseBusinessLogic.ConvertToString(dr[2]);
//if (string.IsNullOrEmpty(entity.ReceiveProvince) && string.IsNullOrEmpty(entity.ReceiveCity) && string.IsNullOrEmpty(entity.ReceiveCounty))
//{
// if (!string.IsNullOrEmpty(entity.ReceiveAddress))
// {
// var baiAddressEntity = BaiduHelper.GetProvCityDistFromBaiduMap(entity.ReceiveAddress);
// if (baiAddressEntity != null)
// {
// entity.ReceiveProvince = baiAddressEntity.Result.AddressComponent.Province;
// entity.ReceiveCity = baiAddressEntity.Result.AddressComponent.City;
// entity.ReceiveCounty = baiAddressEntity.Result.AddressComponent.District;
// }
// }
//}
entity.ReceiveDestination = entity.ReceiveProvince;
if (string.IsNullOrEmpty(entity.ReceiveDestination))
{
entity.ReceiveDestination = entity.ReceiveProvince;
}
//entity.ReceiveCompany = BaseBusinessLogic.ConvertToString(dr[31]);
//entity.ReceivePostcode = BaseBusinessLogic.ConvertToString(dr[32]);
//entity.GoodsName = BaseBusinessLogic.ConvertToString(dr[14]);
//entity.Weight = BaseBusinessLogic.ConvertToString(dr[15]);
//entity.TranFee = BaseBusinessLogic.ConvertToString(dr[16]);
//entity.Length = BaseBusinessLogic.ConvertToString(dr[33]);
//entity.Width = BaseBusinessLogic.ConvertToString(dr[34]);
//entity.Height = BaseBusinessLogic.ConvertToString(dr[35]);
//entity.TotalNumber = BaseBusinessLogic.ConvertToString(dr[36]);
entity.Remark = BaseBusinessLogic.ConvertToString(dr[4]);
entity.OrderNumber = BaseBusinessLogic.ConvertToString(dr[3]);
entity.TranFee = BaseBusinessLogic.ConvertToString(dr[5]);
entity.CreateOn = DateTime.Now;
if (!ckGetServerPrintMark.Checked)
{
entity.BigPen = string.Format("{0} {1} {2}", entity.ReceiveProvince, entity.ReceiveCity, entity.ReceiveCounty);
}
else
{
entity.BigPen = "";
}
list.Add(entity);
}
if (!ckGetServerPrintMark.Checked)
{
var manager = new ZtoPrintBillManager(BillPrintHelper.DbHelper);
foreach (ZtoPrintBillEntity ztoPrintBillEntity in list)
{
manager.Add(ztoPrintBillEntity, true);
}
if (splashScreenManagerImportExcel != null && splashScreenManagerImportExcel.IsSplashFormVisible)
{
splashScreenManagerImportExcel.CloseWaitForm();
}
GridDataBind();
var ts = DateTime.Now - startDateTime;
lblTime.Text = string.Format("耗时:{0}时{1}分{2}秒{3}毫秒", ts.Hours, ts.Minutes, ts.Seconds, ts.Milliseconds);
Close();
}
else
{
splashScreenManagerImportExcel.SetWaitFormDescription("正在联网获取大头笔信息");
if (splashScreenManagerImportExcel != null && splashScreenManagerImportExcel.IsSplashFormVisible)
{
splashScreenManagerImportExcel.CloseWaitForm();
}
// 开线程去读取大头笔的
CheckBillCode(list);
}
}
else
{
XtraMessageBox.Show(@"模板没有填写任何数据，导入失败", AppMessage.MSG0000, MessageBoxButtons.OK, MessageBoxIcon.Error);
return(false);
}
}
catch (Exception ex)
{
ProcessException(ex);
return(false);
}
finally
{
if (splashScreenManagerImportExcel != null && splashScreenManagerImportExcel.IsSplashFormVisible)
{
splashScreenManagerImportExcel.CloseWaitForm();
}
}
return(true);
}
/// <summary>
/// 从数据行读取
/// </summary>
/// <param name="dr">数据行</param>
protected override BaseEntity GetFrom(IDataRow dr)
{
GetFromExpand(dr);
if (dr.ContainsColumn(ZtoPrintCancelEntity.FieldSendPhone))
{
SendPhone = BaseBusinessLogic.ConvertToString(dr[ZtoPrintCancelEntity.FieldSendPhone]);
}
if (dr.ContainsColumn(ZtoPrintCancelEntity.FieldReceiveMan))
{
ReceiveMan = BaseBusinessLogic.ConvertToString(dr[ZtoPrintCancelEntity.FieldReceiveMan]);
}
if (dr.ContainsColumn(ZtoPrintCancelEntity.FieldCreateUserName))
{
CreateUserName = BaseBusinessLogic.ConvertToString(dr[ZtoPrintCancelEntity.FieldCreateUserName]);
}
if (dr.ContainsColumn(ZtoPrintCancelEntity.FieldModifiedSite))
{
ModifiedSite = BaseBusinessLogic.ConvertToString(dr[ZtoPrintCancelEntity.FieldModifiedSite]);
}
if (dr.ContainsColumn(ZtoPrintCancelEntity.FieldModifiedUserName))
{
ModifiedUserName = BaseBusinessLogic.ConvertToString(dr[ZtoPrintCancelEntity.FieldModifiedUserName]);
}
if (dr.ContainsColumn(ZtoPrintCancelEntity.FieldCreateOn))
{
CreateOn = BaseBusinessLogic.ConvertToNullableDateTime(dr[ZtoPrintCancelEntity.FieldCreateOn]);
}
if (dr.ContainsColumn(ZtoPrintCancelEntity.FieldOrderNumber))
{
OrderNumber = BaseBusinessLogic.ConvertToString(dr[ZtoPrintCancelEntity.FieldOrderNumber]);
}
if (dr.ContainsColumn(ZtoPrintCancelEntity.FieldBillCode))
{
BillCode = BaseBusinessLogic.ConvertToString(dr[ZtoPrintCancelEntity.FieldBillCode]);
}
if (dr.ContainsColumn(ZtoPrintCancelEntity.FieldSendMan))
{
SendMan = BaseBusinessLogic.ConvertToString(dr[ZtoPrintCancelEntity.FieldSendMan]);
}
if (dr.ContainsColumn(ZtoPrintCancelEntity.FieldRemark))
{
Remark = BaseBusinessLogic.ConvertToString(dr[ZtoPrintCancelEntity.FieldRemark]);
}
if (dr.ContainsColumn(ZtoPrintCancelEntity.FieldModifiedOn))
{
ModifiedOn = BaseBusinessLogic.ConvertToNullableDateTime(dr[ZtoPrintCancelEntity.FieldModifiedOn]);
}
if (dr.ContainsColumn(ZtoPrintCancelEntity.FieldCreateSite))
{
CreateSite = BaseBusinessLogic.ConvertToString(dr[ZtoPrintCancelEntity.FieldCreateSite]);
}
if (dr.ContainsColumn(ZtoPrintCancelEntity.FieldReceiveAddress))
{
ReceiveAddress = BaseBusinessLogic.ConvertToString(dr[ZtoPrintCancelEntity.FieldReceiveAddress]);
}
if (dr.ContainsColumn(ZtoPrintCancelEntity.FieldId))
{
Id = BaseBusinessLogic.ConvertToString(dr[ZtoPrintCancelEntity.FieldId]);
}
if (dr.ContainsColumn(ZtoPrintCancelEntity.FieldReceivePhone))
{
ReceivePhone = BaseBusinessLogic.ConvertToString(dr[ZtoPrintCancelEntity.FieldReceivePhone]);
}
if (dr.ContainsColumn(ZtoPrintCancelEntity.FieldSendAddress))
{
SendAddress = BaseBusinessLogic.ConvertToString(dr[ZtoPrintCancelEntity.FieldSendAddress]);
}
if (dr.ContainsColumn(ZtoPrintCancelEntity.FieldSendProvince))
{
SendProvince = BaseBusinessLogic.ConvertToString(dr[ZtoPrintCancelEntity.FieldSendProvince]);
}
return(this);
}
/// <summary>
/// 从数据行读取
/// </summary>
/// <param name="dr">数据行</param>
protected override BaseEntity GetFrom(IDataRow dr)
{
GetFromExpand(dr);
if (dr.ContainsColumn(ZtoUserEntity.FieldId))
{
Id = BaseBusinessLogic.ConvertToDecimal(dr[ZtoUserEntity.FieldId]);
}
if (dr.ContainsColumn(ZtoUserEntity.FieldPostcode))
{
Postcode = BaseBusinessLogic.ConvertToString(dr[ZtoUserEntity.FieldPostcode]);
}
if (dr.ContainsColumn(ZtoUserEntity.FieldRealname))
{
Realname = BaseBusinessLogic.ConvertToString(dr[ZtoUserEntity.FieldRealname]);
}
if (dr.ContainsColumn(ZtoUserEntity.FieldCreateUserName))
{
CreateUserName = BaseBusinessLogic.ConvertToString(dr[ZtoUserEntity.FieldCreateUserName]);
}
if (dr.ContainsColumn(ZtoUserEntity.FieldCityId))
{
CityId = BaseBusinessLogic.ConvertToString(dr[ZtoUserEntity.FieldCityId]);
}
if (dr.ContainsColumn(ZtoUserEntity.FieldModifiedUserName))
{
ModifiedUserName = BaseBusinessLogic.ConvertToString(dr[ZtoUserEntity.FieldModifiedUserName]);
}
if (dr.ContainsColumn(ZtoUserEntity.FieldCreateOn))
{
CreateOn = BaseBusinessLogic.ConvertToNullableDateTime(dr[ZtoUserEntity.FieldCreateOn]);
}
if (dr.ContainsColumn(ZtoUserEntity.FieldDepartment))
{
Department = BaseBusinessLogic.ConvertToString(dr[ZtoUserEntity.FieldDepartment]);
}
if (dr.ContainsColumn(ZtoUserEntity.FieldProvince))
{
Province = BaseBusinessLogic.ConvertToString(dr[ZtoUserEntity.FieldProvince]);
}
if (dr.ContainsColumn(ZtoUserEntity.FieldCounty))
{
County = BaseBusinessLogic.ConvertToString(dr[ZtoUserEntity.FieldCounty]);
}
if (dr.ContainsColumn(ZtoUserEntity.FieldCountyId))
{
CountyId = BaseBusinessLogic.ConvertToString(dr[ZtoUserEntity.FieldCountyId]);
}
if (dr.ContainsColumn(ZtoUserEntity.FieldRemark))
{
Remark = BaseBusinessLogic.ConvertToString(dr[ZtoUserEntity.FieldRemark]);
}
if (dr.ContainsColumn(ZtoUserEntity.FieldModifiedOn))
{
ModifiedOn = BaseBusinessLogic.ConvertToNullableDateTime(dr[ZtoUserEntity.FieldModifiedOn]);
}
if (dr.ContainsColumn(ZtoUserEntity.FieldProvinceId))
{
ProvinceId = BaseBusinessLogic.ConvertToString(dr[ZtoUserEntity.FieldProvinceId]);
}
if (dr.ContainsColumn(ZtoUserEntity.FieldCity))
{
City = BaseBusinessLogic.ConvertToString(dr[ZtoUserEntity.FieldCity]);
}
if (dr.ContainsColumn(ZtoUserEntity.FieldAddress))
{
Address = BaseBusinessLogic.ConvertToString(dr[ZtoUserEntity.FieldAddress]);
}
if (dr.ContainsColumn(ZtoUserEntity.FieldIssendorreceive))
{
Issendorreceive = BaseBusinessLogic.ConvertToString(dr[ZtoUserEntity.FieldIssendorreceive]);
}
if (dr.ContainsColumn(ZtoUserEntity.FieldTelePhone))
{
TelePhone = BaseBusinessLogic.ConvertToString(dr[ZtoUserEntity.FieldTelePhone]);
}
if (dr.ContainsColumn(ZtoUserEntity.FieldMobile))
{
Mobile = BaseBusinessLogic.ConvertToString(dr[ZtoUserEntity.FieldMobile]);
}
if (dr.ContainsColumn(ZtoUserEntity.FieldCompany))
{
Company = BaseBusinessLogic.ConvertToString(dr[ZtoUserEntity.FieldCompany]);
}
if (dr.ContainsColumn(ZtoUserEntity.FieldIsDefault))
{
IsDefault = BaseBusinessLogic.ConvertToString(dr[ZtoUserEntity.FieldIsDefault]);
}
return(this);
}
/// <summary>
/// 从数据行读取
/// </summary>
/// <param name="dr">数据行</param>
protected override BaseEntity GetFrom(IDataRow dr)
{
Id = BaseBusinessLogic.ConvertToString(dr[BaseOrganizeEntity.FieldId]);
ParentId = BaseBusinessLogic.ConvertToString(dr[BaseOrganizeEntity.FieldParentId]);
ParentName = BaseBusinessLogic.ConvertToString(dr[BaseOrganizeEntity.FieldParentName]);
Layer = BaseBusinessLogic.ConvertToInt(dr[BaseOrganizeEntity.FieldLayer]);
Code = BaseBusinessLogic.ConvertToString(dr[BaseOrganizeEntity.FieldCode]);
FullName = BaseBusinessLogic.ConvertToString(dr[BaseOrganizeEntity.FieldFullName]);
ShortName = BaseBusinessLogic.ConvertToString(dr[BaseOrganizeEntity.FieldShortName]);
StandardName = BaseBusinessLogic.ConvertToString(dr[BaseOrganizeEntity.FieldStandardName]);
StandardCode = BaseBusinessLogic.ConvertToString(dr[BaseOrganizeEntity.FieldStandardCode]);
QuickQuery = BaseBusinessLogic.ConvertToString(dr[BaseOrganizeEntity.FieldQuickQuery]);
SimpleSpelling = BaseBusinessLogic.ConvertToString(dr[BaseOrganizeEntity.FieldSimpleSpelling]);
CategoryCode = BaseBusinessLogic.ConvertToString(dr[BaseOrganizeEntity.FieldCategoryCode]);
OuterPhone = BaseBusinessLogic.ConvertToString(dr[BaseOrganizeEntity.FieldOuterPhone]);
InnerPhone = BaseBusinessLogic.ConvertToString(dr[BaseOrganizeEntity.FieldInnerPhone]);
Fax = BaseBusinessLogic.ConvertToString(dr[BaseOrganizeEntity.FieldFax]);
Postalcode = BaseBusinessLogic.ConvertToString(dr[BaseOrganizeEntity.FieldPostalcode]);
ProvinceId = BaseBusinessLogic.ConvertToString(dr[BaseOrganizeEntity.FieldProvinceId]);
Province = BaseBusinessLogic.ConvertToString(dr[BaseOrganizeEntity.FieldProvince]);
CityId = BaseBusinessLogic.ConvertToString(dr[BaseOrganizeEntity.FieldCityId]);
City = BaseBusinessLogic.ConvertToString(dr[BaseOrganizeEntity.FieldCity]);
DistrictId = BaseBusinessLogic.ConvertToString(dr[BaseOrganizeEntity.FieldDistrictId]);
District = BaseBusinessLogic.ConvertToString(dr[BaseOrganizeEntity.FieldDistrict]);
StreetId = BaseBusinessLogic.ConvertToString(dr[BaseOrganizeEntity.FieldStreetId]);
Street = BaseBusinessLogic.ConvertToString(dr[BaseOrganizeEntity.FieldStreet]);
Address = BaseBusinessLogic.ConvertToString(dr[BaseOrganizeEntity.FieldAddress]);
Web = BaseBusinessLogic.ConvertToString(dr[BaseOrganizeEntity.FieldWeb]);
IsInnerOrganize = BaseBusinessLogic.ConvertToInt(dr[BaseOrganizeEntity.FieldIsInnerOrganize]);
Bank = BaseBusinessLogic.ConvertToString(dr[BaseOrganizeEntity.FieldBank]);
BankAccount = BaseBusinessLogic.ConvertToString(dr[BaseOrganizeEntity.FieldBankAccount]);
CompanyId = BaseBusinessLogic.ConvertToString(dr[BaseOrganizeEntity.FieldCompanyId]);
CompanyCode = BaseBusinessLogic.ConvertToString(dr[BaseOrganizeEntity.FieldCompanyCode]);
CompanyName = BaseBusinessLogic.ConvertToString(dr[BaseOrganizeEntity.FieldCompanyName]);
if (dr.ContainsColumn(BaseOrganizeEntity.FieldCostCenterId))
{
CostCenterId = BaseBusinessLogic.ConvertToString(dr[BaseOrganizeEntity.FieldCostCenterId]);
}
CostCenter = BaseBusinessLogic.ConvertToString(dr[BaseOrganizeEntity.FieldCostCenter]);
if (dr.ContainsColumn(BaseOrganizeEntity.FieldFinancialCenterId))
{
FinancialCenterId = BaseBusinessLogic.ConvertToString(dr[BaseOrganizeEntity.FieldFinancialCenterId]);
}
FinancialCenter = BaseBusinessLogic.ConvertToString(dr[BaseOrganizeEntity.FieldFinancialCenter]);
if (dr.ContainsColumn(BaseOrganizeEntity.FieldManageId))
{
ManageId = BaseBusinessLogic.ConvertToString(dr[BaseOrganizeEntity.FieldManageId]);
}
if (dr.ContainsColumn(BaseOrganizeEntity.FieldManageName))
{
ManageName = BaseBusinessLogic.ConvertToString(dr[BaseOrganizeEntity.FieldManageName]);
}
Area = BaseBusinessLogic.ConvertToString(dr[BaseOrganizeEntity.FieldArea]);
JoiningMethods = BaseBusinessLogic.ConvertToString(dr[BaseOrganizeEntity.FieldJoiningMethods]);
DeletionStateCode = BaseBusinessLogic.ConvertToInt(dr[BaseOrganizeEntity.FieldDeletionStateCode]);
Enabled = BaseBusinessLogic.ConvertToInt(dr[BaseOrganizeEntity.FieldEnabled]);
SortCode = BaseBusinessLogic.ConvertToInt(dr[BaseOrganizeEntity.FieldSortCode]);
Description = BaseBusinessLogic.ConvertToString(dr[BaseOrganizeEntity.FieldDescription]);
CreateOn = BaseBusinessLogic.ConvertToNullableDateTime(dr[BaseOrganizeEntity.FieldCreateOn]);
CreateUserId = BaseBusinessLogic.ConvertToString(dr[BaseOrganizeEntity.FieldCreateUserId]);
CreateBy = BaseBusinessLogic.ConvertToString(dr[BaseOrganizeEntity.FieldCreateBy]);
ModifiedOn = BaseBusinessLogic.ConvertToNullableDateTime(dr[BaseOrganizeEntity.FieldModifiedOn]);
ModifiedUserId = BaseBusinessLogic.ConvertToString(dr[BaseOrganizeEntity.FieldModifiedUserId]);
ModifiedBy = BaseBusinessLogic.ConvertToString(dr[BaseOrganizeEntity.FieldModifiedBy]);
// 获取扩展属性
GetFromExpand(dr);
return(this);
}
/// <summary>
/// 从数据流读取
/// </summary>
/// <param name="dataReader">数据流</param>
public BaseUserEntity GetFrom(IDataReader dataReader)
{
this.GetFromExpand(dataReader);
this.Id = BaseBusinessLogic.ConvertToString(dataReader[BaseUserEntity.FieldId]);
this.Code = BaseBusinessLogic.ConvertToString(dataReader[BaseUserEntity.FieldCode]);
this.UserName = BaseBusinessLogic.ConvertToString(dataReader[BaseUserEntity.FieldUserName]);
this.RealName = BaseBusinessLogic.ConvertToString(dataReader[BaseUserEntity.FieldRealName]);
this.QuickQuery = BaseBusinessLogic.ConvertToString(dataReader[BaseUserEntity.FieldQuickQuery]);
this.RoleId = BaseBusinessLogic.ConvertToString(dataReader[BaseUserEntity.FieldRoleId]);
this.SecurityLevel = BaseBusinessLogic.ConvertToInt(dataReader[BaseUserEntity.FieldSecurityLevel]);
this.UserFrom = BaseBusinessLogic.ConvertToString(dataReader[BaseUserEntity.FieldUserFrom]);
this.WorkCategory = BaseBusinessLogic.ConvertToString(dataReader[BaseUserEntity.FieldWorkCategory]);
this.CompanyId = BaseBusinessLogic.ConvertToString(dataReader[BaseUserEntity.FieldCompanyId]);
this.CompanyName = BaseBusinessLogic.ConvertToString(dataReader[BaseUserEntity.FieldCompanyName]);
this.SubCompanyId = BaseBusinessLogic.ConvertToString(dataReader[BaseUserEntity.FieldSubCompanyId]);
this.SubCompanyName = BaseBusinessLogic.ConvertToString(dataReader[BaseUserEntity.FieldSubCompanyName]);
this.DepartmentId = BaseBusinessLogic.ConvertToString(dataReader[BaseUserEntity.FieldDepartmentId]);
this.DepartmentName = BaseBusinessLogic.ConvertToString(dataReader[BaseUserEntity.FieldDepartmentName]);
this.WorkgroupId = BaseBusinessLogic.ConvertToString(dataReader[BaseUserEntity.FieldWorkgroupId]);
this.WorkgroupName = BaseBusinessLogic.ConvertToString(dataReader[BaseUserEntity.FieldWorkgroupName]);
this.Gender = BaseBusinessLogic.ConvertToString(dataReader[BaseUserEntity.FieldGender]);
this.Mobile = BaseBusinessLogic.ConvertToString(dataReader[BaseUserEntity.FieldMobile]);
this.Telephone = BaseBusinessLogic.ConvertToString(dataReader[BaseUserEntity.FieldTelephone]);
this.Birthday = BaseBusinessLogic.ConvertToString(dataReader[BaseUserEntity.FieldBirthday]);
this.Duty = BaseBusinessLogic.ConvertToString(dataReader[BaseUserEntity.FieldDuty]);
this.Title = BaseBusinessLogic.ConvertToString(dataReader[BaseUserEntity.FieldTitle]);
this.UserPassword = BaseBusinessLogic.ConvertToString(dataReader[BaseUserEntity.FieldUserPassword]);
this.ChangePasswordDate = BaseBusinessLogic.ConvertToDateTime(dataReader[BaseUserEntity.FieldChangePasswordDate]);
this.CommunicationPassword = BaseBusinessLogic.ConvertToString(dataReader[BaseUserEntity.FieldCommunicationPassword]);
this.SignedPassword = BaseBusinessLogic.ConvertToString(dataReader[BaseUserEntity.FieldSignedPassword]);
this.PublicKey = BaseBusinessLogic.ConvertToString(dataReader[BaseUserEntity.FieldPublicKey]);
this.OICQ = BaseBusinessLogic.ConvertToString(dataReader[BaseUserEntity.FieldOICQ]);
this.Email = BaseBusinessLogic.ConvertToString(dataReader[BaseUserEntity.FieldEmail]);
this.Lang = BaseBusinessLogic.ConvertToString(dataReader[BaseUserEntity.FieldLang]);
this.Theme = BaseBusinessLogic.ConvertToString(dataReader[BaseUserEntity.FieldTheme]);
this.AllowStartTime = BaseBusinessLogic.ConvertToDateTime(dataReader[BaseUserEntity.FieldAllowStartTime]);
this.AllowEndTime = BaseBusinessLogic.ConvertToDateTime(dataReader[BaseUserEntity.FieldAllowEndTime]);
this.LockStartDate = BaseBusinessLogic.ConvertToDateTime(dataReader[BaseUserEntity.FieldLockStartDate]);
this.LockEndDate = BaseBusinessLogic.ConvertToDateTime(dataReader[BaseUserEntity.FieldLockEndDate]);
this.FirstVisit = BaseBusinessLogic.ConvertToDateTime(dataReader[BaseUserEntity.FieldFirstVisit]);
this.PreviousVisit = BaseBusinessLogic.ConvertToDateTime(dataReader[BaseUserEntity.FieldPreviousVisit]);
this.LastVisit = BaseBusinessLogic.ConvertToDateTime(dataReader[BaseUserEntity.FieldLastVisit]);
this.LogOnCount = BaseBusinessLogic.ConvertToInt(dataReader[BaseUserEntity.FieldLogOnCount]);
this.IsStaff = BaseBusinessLogic.ConvertToInt(dataReader[BaseUserEntity.FieldIsStaff]);
this.AuditStatus = BaseBusinessLogic.ConvertToString(dataReader[BaseUserEntity.FieldAuditStatus]);
this.IsVisible = BaseBusinessLogic.ConvertToInt(dataReader[BaseUserEntity.FieldIsVisible]);
this.UserOnLine = BaseBusinessLogic.ConvertToInt(dataReader[BaseUserEntity.FieldUserOnLine]);
this.IPAddress = BaseBusinessLogic.ConvertToString(dataReader[BaseUserEntity.FieldIPAddress]);
this.MACAddress = BaseBusinessLogic.ConvertToString(dataReader[BaseUserEntity.FieldMACAddress]);
this.OpenId = BaseBusinessLogic.ConvertToString(dataReader[BaseUserEntity.FieldOpenId]);
this.Question = BaseBusinessLogic.ConvertToString(dataReader[BaseUserEntity.FieldQuestion]);
this.AnswerQuestion = BaseBusinessLogic.ConvertToString(dataReader[BaseUserEntity.FieldAnswerQuestion]);
this.UserAddressId = BaseBusinessLogic.ConvertToString(dataReader[BaseUserEntity.FieldUserAddressId]);
this.DeletionStateCode = BaseBusinessLogic.ConvertToInt(dataReader[BaseUserEntity.FieldDeletionStateCode]);
this.Enabled = BaseBusinessLogic.ConvertToInt(dataReader[BaseUserEntity.FieldEnabled]);
this.SortCode = BaseBusinessLogic.ConvertToInt(dataReader[BaseUserEntity.FieldSortCode]);
this.Description = BaseBusinessLogic.ConvertToString(dataReader[BaseUserEntity.FieldDescription]);
this.CreateOn = BaseBusinessLogic.ConvertToDateTime(dataReader[BaseUserEntity.FieldCreateOn]);
this.CreateUserId = BaseBusinessLogic.ConvertToString(dataReader[BaseUserEntity.FieldCreateUserId]);
this.CreateBy = BaseBusinessLogic.ConvertToString(dataReader[BaseUserEntity.FieldCreateBy]);
this.ModifiedOn = BaseBusinessLogic.ConvertToDateTime(dataReader[BaseUserEntity.FieldModifiedOn]);
this.ModifiedUserId = BaseBusinessLogic.ConvertToString(dataReader[BaseUserEntity.FieldModifiedUserId]);
this.ModifiedBy = BaseBusinessLogic.ConvertToString(dataReader[BaseUserEntity.FieldModifiedBy]);
this.Signature = BaseBusinessLogic.ConvertToString(dataReader[BaseUserEntity.FieldSignature]);
return(this);
}
/// <summary>
/// 从数据流读取
/// </summary>
/// <param name="dataReader">数据流</param>
public BaseStaffEntity GetFrom(IDataReader dataReader)
{
this.GetFromExpand(dataReader);;
this.Id = BaseBusinessLogic.ConvertToInt(dataReader[BaseStaffEntity.FieldId]);
this.UserId = BaseBusinessLogic.ConvertToInt(dataReader[BaseStaffEntity.FieldUserId]);
this.UserName = BaseBusinessLogic.ConvertToString(dataReader[BaseStaffEntity.FieldUserName]);
this.RealName = BaseBusinessLogic.ConvertToString(dataReader[BaseStaffEntity.FieldRealName]);
this.Code = BaseBusinessLogic.ConvertToString(dataReader[BaseStaffEntity.FieldCode]);
this.Gender = BaseBusinessLogic.ConvertToString(dataReader[BaseStaffEntity.FieldGender]);
this.SubCompanyId = BaseBusinessLogic.ConvertToString(dataReader[BaseStaffEntity.FieldSubCompanyId]);
this.CompanyId = BaseBusinessLogic.ConvertToString(dataReader[BaseStaffEntity.FieldCompanyId]);
this.DepartmentId = BaseBusinessLogic.ConvertToString(dataReader[BaseStaffEntity.FieldDepartmentId]);
this.WorkgroupId = BaseBusinessLogic.ConvertToString(dataReader[BaseStaffEntity.FieldWorkgroupId]);
this.QuickQuery = BaseBusinessLogic.ConvertToString(dataReader[BaseStaffEntity.FieldQuickQuery]);
this.DutyId = BaseBusinessLogic.ConvertToString(dataReader[BaseStaffEntity.FieldDutyId]);
this.IdentificationCode = BaseBusinessLogic.ConvertToString(dataReader[BaseStaffEntity.FieldIdentificationCode]);
this.IDCard = BaseBusinessLogic.ConvertToString(dataReader[BaseStaffEntity.FieldIDCard]);
this.BankCode = BaseBusinessLogic.ConvertToString(dataReader[BaseStaffEntity.FieldBankCode]);
this.Email = BaseBusinessLogic.ConvertToString(dataReader[BaseStaffEntity.FieldEmail]);
this.Mobile = BaseBusinessLogic.ConvertToString(dataReader[BaseStaffEntity.FieldMobile]);
this.ShortNumber = BaseBusinessLogic.ConvertToString(dataReader[BaseStaffEntity.FieldShortNumber]);
this.Telephone = BaseBusinessLogic.ConvertToString(dataReader[BaseStaffEntity.FieldTelephone]);
this.OICQ = BaseBusinessLogic.ConvertToString(dataReader[BaseStaffEntity.FieldOICQ]);
this.OfficePhone = BaseBusinessLogic.ConvertToString(dataReader[BaseStaffEntity.FieldOfficePhone]);
this.OfficeZipCode = BaseBusinessLogic.ConvertToString(dataReader[BaseStaffEntity.FieldOfficeZipCode]);
this.OfficeAddress = BaseBusinessLogic.ConvertToString(dataReader[BaseStaffEntity.FieldOfficeAddress]);
this.OfficeFax = BaseBusinessLogic.ConvertToString(dataReader[BaseStaffEntity.FieldOfficeFax]);
this.Age = BaseBusinessLogic.ConvertToString(dataReader[BaseStaffEntity.FieldAge]);
this.Birthday = BaseBusinessLogic.ConvertToString(dataReader[BaseStaffEntity.FieldBirthday]);
this.Education = BaseBusinessLogic.ConvertToString(dataReader[BaseStaffEntity.FieldEducation]);
this.School = BaseBusinessLogic.ConvertToString(dataReader[BaseStaffEntity.FieldSchool]);
this.GraduationDate = BaseBusinessLogic.ConvertToString(dataReader[BaseStaffEntity.FieldGraduationDate]);
this.Major = BaseBusinessLogic.ConvertToString(dataReader[BaseStaffEntity.FieldMajor]);
this.Degree = BaseBusinessLogic.ConvertToString(dataReader[BaseStaffEntity.FieldDegree]);
this.TitleId = BaseBusinessLogic.ConvertToString(dataReader[BaseStaffEntity.FieldTitleId]);
this.TitleDate = BaseBusinessLogic.ConvertToString(dataReader[BaseStaffEntity.FieldTitleDate]);
this.TitleLevel = BaseBusinessLogic.ConvertToString(dataReader[BaseStaffEntity.FieldTitleLevel]);
this.WorkingDate = BaseBusinessLogic.ConvertToString(dataReader[BaseStaffEntity.FieldWorkingDate]);
this.JoinInDate = BaseBusinessLogic.ConvertToString(dataReader[BaseStaffEntity.FieldJoinInDate]);
this.HomeZipCode = BaseBusinessLogic.ConvertToString(dataReader[BaseStaffEntity.FieldHomeZipCode]);
this.HomeAddress = BaseBusinessLogic.ConvertToString(dataReader[BaseStaffEntity.FieldHomeAddress]);
this.HomePhone = BaseBusinessLogic.ConvertToString(dataReader[BaseStaffEntity.FieldHomePhone]);
this.HomeFax = BaseBusinessLogic.ConvertToString(dataReader[BaseStaffEntity.FieldHomeFax]);
this.Province = BaseBusinessLogic.ConvertToString(dataReader[BaseStaffEntity.FieldProvince]);
this.CarCode = BaseBusinessLogic.ConvertToString(dataReader[BaseStaffEntity.FieldCarCode]);
this.City = BaseBusinessLogic.ConvertToString(dataReader[BaseStaffEntity.FieldCity]);
this.Area = BaseBusinessLogic.ConvertToString(dataReader[BaseStaffEntity.FieldArea]);
this.NativePlace = BaseBusinessLogic.ConvertToString(dataReader[BaseStaffEntity.FieldNativePlace]);
this.Party = BaseBusinessLogic.ConvertToString(dataReader[BaseStaffEntity.FieldParty]);
this.Nation = BaseBusinessLogic.ConvertToString(dataReader[BaseStaffEntity.FieldNation]);
this.Nationality = BaseBusinessLogic.ConvertToString(dataReader[BaseStaffEntity.FieldNationality]);
this.WorkingProperty = BaseBusinessLogic.ConvertToString(dataReader[BaseStaffEntity.FieldWorkingProperty]);
this.Competency = BaseBusinessLogic.ConvertToString(dataReader[BaseStaffEntity.FieldCompetency]);
this.EmergencyContact = BaseBusinessLogic.ConvertToString(dataReader[BaseStaffEntity.FieldEmergencyContact]);
this.IsDimission = BaseBusinessLogic.ConvertToInt(dataReader[BaseStaffEntity.FieldIsDimission]);
this.DimissionDate = BaseBusinessLogic.ConvertToString(dataReader[BaseStaffEntity.FieldDimissionDate]);
this.DimissionCause = BaseBusinessLogic.ConvertToString(dataReader[BaseStaffEntity.FieldDimissionCause]);
this.DimissionWhither = BaseBusinessLogic.ConvertToString(dataReader[BaseStaffEntity.FieldDimissionWhither]);
this.Enabled = BaseBusinessLogic.ConvertToInt(dataReader[BaseStaffEntity.FieldEnabled]);
this.DeletionStateCode = BaseBusinessLogic.ConvertToInt(dataReader[BaseStaffEntity.FieldDeletionStateCode]);
this.SortCode = BaseBusinessLogic.ConvertToInt(dataReader[BaseStaffEntity.FieldSortCode]);
this.Description = BaseBusinessLogic.ConvertToString(dataReader[BaseStaffEntity.FieldDescription]);
this.CreateOn = BaseBusinessLogic.ConvertToDateTime(dataReader[BaseStaffEntity.FieldCreateOn]);
this.CreateUserId = BaseBusinessLogic.ConvertToString(dataReader[BaseStaffEntity.FieldCreateUserId]);
this.CreateBy = BaseBusinessLogic.ConvertToString(dataReader[BaseStaffEntity.FieldCreateBy]);
this.ModifiedOn = BaseBusinessLogic.ConvertToDateTime(dataReader[BaseStaffEntity.FieldModifiedOn]);
this.ModifiedUserId = BaseBusinessLogic.ConvertToString(dataReader[BaseStaffEntity.FieldModifiedUserId]);
this.ModifiedBy = BaseBusinessLogic.ConvertToString(dataReader[BaseStaffEntity.FieldModifiedBy]);
return(this);
}
/// <summary>
/// 从数据行读取
/// </summary>
/// <param name="dr">数据行</param>
protected override BaseEntity GetFrom(IDataRow dr)
{
Id = BaseBusinessLogic.ConvertToString(dr[BaseUserEntity.FieldId]);
UserFrom = BaseBusinessLogic.ConvertToString(dr[BaseUserEntity.FieldUserFrom]);
Code = BaseBusinessLogic.ConvertToString(dr[BaseUserEntity.FieldCode]);
UserName = BaseBusinessLogic.ConvertToString(dr[BaseUserEntity.FieldUserName]);
NickName = BaseBusinessLogic.ConvertToString(dr[BaseUserEntity.FieldNickName]);
RealName = BaseBusinessLogic.ConvertToString(dr[BaseUserEntity.FieldRealName]);
QuickQuery = BaseBusinessLogic.ConvertToString(dr[BaseUserEntity.FieldQuickQuery]);
SimpleSpelling = BaseBusinessLogic.ConvertToString(dr[BaseUserEntity.FieldSimpleSpelling]);
SecurityLevel = BaseBusinessLogic.ConvertToInt(dr[BaseUserEntity.FieldSecurityLevel]);
WorkCategory = BaseBusinessLogic.ConvertToString(dr[BaseUserEntity.FieldWorkCategory]);
CompanyId = BaseBusinessLogic.ConvertToString(dr[BaseUserEntity.FieldCompanyId]);
// 2015-12-29 吉日嘎拉 防止程序出错，没有这个字段也可以正常运行
if (dr.ContainsColumn(BaseUserEntity.FieldCompanyCode))
{
CompanyCode = BaseBusinessLogic.ConvertToString(dr[BaseUserEntity.FieldCompanyCode]);
}
CompanyName = BaseBusinessLogic.ConvertToString(dr[BaseUserEntity.FieldCompanyName]);
SubCompanyId = BaseBusinessLogic.ConvertToString(dr[BaseUserEntity.FieldSubCompanyId]);
SubCompanyName = BaseBusinessLogic.ConvertToString(dr[BaseUserEntity.FieldSubCompanyName]);
DepartmentId = BaseBusinessLogic.ConvertToString(dr[BaseUserEntity.FieldDepartmentId]);
DepartmentName = BaseBusinessLogic.ConvertToString(dr[BaseUserEntity.FieldDepartmentName]);
SubDepartmentId = BaseBusinessLogic.ConvertToString(dr[BaseUserEntity.FieldSubDepartmentId]);
SubDepartmentName = BaseBusinessLogic.ConvertToString(dr[BaseUserEntity.FieldSubDepartmentName]);
WorkgroupId = BaseBusinessLogic.ConvertToString(dr[BaseUserEntity.FieldWorkgroupId]);
WorkgroupName = BaseBusinessLogic.ConvertToString(dr[BaseUserEntity.FieldWorkgroupName]);
IDCard = BaseBusinessLogic.ConvertToString(dr[BaseUserEntity.FieldIDCard]);
Gender = BaseBusinessLogic.ConvertToString(dr[BaseUserEntity.FieldGender]);
Birthday = BaseBusinessLogic.ConvertToString(dr[BaseUserEntity.FieldBirthday]);
Duty = BaseBusinessLogic.ConvertToString(dr[BaseUserEntity.FieldDuty]);
Title = BaseBusinessLogic.ConvertToString(dr[BaseUserEntity.FieldTitle]);
Province = BaseBusinessLogic.ConvertToString(dr[BaseUserEntity.FieldProvince]);
City = BaseBusinessLogic.ConvertToString(dr[BaseUserEntity.FieldCity]);
District = BaseBusinessLogic.ConvertToString(dr[BaseUserEntity.FieldDistrict]);
HomeAddress = BaseBusinessLogic.ConvertToString(dr[BaseUserEntity.FieldHomeAddress]);
Score = BaseBusinessLogic.ConvertToInt(dr[BaseUserEntity.FieldScore]);
IsAdministrator = BaseBusinessLogic.ConvertToBoolean(dr[BaseUserEntity.FieldIsAdministrator]);
Lang = BaseBusinessLogic.ConvertToString(dr[BaseUserEntity.FieldLang]);
Theme = BaseBusinessLogic.ConvertToString(dr[BaseUserEntity.FieldTheme]);
Signature = BaseBusinessLogic.ConvertToString(dr[BaseUserEntity.FieldSignature]);
IsStaff = BaseBusinessLogic.ConvertToInt(dr[BaseUserEntity.FieldIsStaff]);
IsCheckBalance = BaseBusinessLogic.ConvertToInt(dr[BaseUserEntity.FieldIsCheckBalance]);
AuditStatus = BaseBusinessLogic.ConvertToString(dr[BaseUserEntity.FieldAuditStatus]);
ManagerId = BaseBusinessLogic.ConvertToString(dr[BaseUserEntity.FieldManagerId]);
ManagerAuditStatus = BaseBusinessLogic.ConvertToString(dr[BaseUserEntity.FieldManagerAuditStatus]);
ManagerAuditDate = BaseBusinessLogic.ConvertToNullableDateTime(dr[BaseUserEntity.FieldManagerAuditDate]);
IsVisible = BaseBusinessLogic.ConvertToInt(dr[BaseUserEntity.FieldIsVisible]);
DeletionStateCode = BaseBusinessLogic.ConvertToInt(dr[BaseUserEntity.FieldDeletionStateCode]);
Enabled = BaseBusinessLogic.ConvertToInt(dr[BaseUserEntity.FieldEnabled]);
SortCode = BaseBusinessLogic.ConvertToInt(dr[BaseUserEntity.FieldSortCode]);
Description = BaseBusinessLogic.ConvertToString(dr[BaseUserEntity.FieldDescription]);
CreateOn = BaseBusinessLogic.ConvertToNullableDateTime(dr[BaseUserEntity.FieldCreateOn]);
CreateUserId = BaseBusinessLogic.ConvertToString(dr[BaseUserEntity.FieldCreateUserId]);
CreateBy = BaseBusinessLogic.ConvertToString(dr[BaseUserEntity.FieldCreateBy]);
ModifiedOn = BaseBusinessLogic.ConvertToNullableDateTime(dr[BaseUserEntity.FieldModifiedOn]);
ModifiedUserId = BaseBusinessLogic.ConvertToString(dr[BaseUserEntity.FieldModifiedUserId]);
ModifiedBy = BaseBusinessLogic.ConvertToString(dr[BaseUserEntity.FieldModifiedBy]);
// 获取扩展属性
GetFromExpand(dr);
return(this);
}
/// <summary>
/// 更新实体
/// </summary>
/// <param name="entity">实体</param>
public static int LogOnStatistics()
{
int result = 0;
bool update = false;
int i = 0;
// 电脑登录系统、没有登记过的，全部登记上来。
BaseOrganizeLogOnEntity organizeLogOnEntity = null;
string sqlQuery = string.Empty;
sqlQuery = @"SELECT u.companyid id
, MIN(l.firstvisit) firstvisit
, MAX(l.lastvisit) lastvisit
FROM baseuserlogon l
, baseuser u
WHERE l.id = u.id
GROUP BY u.companyid";
BaseOrganizeLogOnManager organizeLogOnManager = new BaseOrganizeLogOnManager();
BaseOrganizeLogOnManager manager = new BaseOrganizeLogOnManager();
using (IDataReader dataReader = manager.ExecuteReader(sqlQuery))
{
while (dataReader.Read())
{
i++;
string id = BaseBusinessLogic.ConvertToString(dataReader[BaseOrganizeLogOnEntity.FieldId]);
DateTime?firstVisit = BaseBusinessLogic.ConvertToNullableDateTime(dataReader[BaseOrganizeLogOnEntity.FieldFirstVisit]);
DateTime?lastVisit = BaseBusinessLogic.ConvertToNullableDateTime(dataReader[BaseOrganizeLogOnEntity.FieldLastVisit]);
organizeLogOnEntity = organizeLogOnManager.GetObject(id);
if (organizeLogOnEntity == null)
{
organizeLogOnEntity = new BaseOrganizeLogOnEntity();
organizeLogOnEntity.Id = id;
organizeLogOnEntity.FirstVisit = firstVisit;
organizeLogOnEntity.LastVisit = lastVisit;
organizeLogOnManager.AddObject(organizeLogOnEntity);
}
else
{
update = false;
if (firstVisit.HasValue)
{
if (organizeLogOnEntity.FirstVisit == null || organizeLogOnEntity.FirstVisit > firstVisit)
{
organizeLogOnEntity.FirstVisit = firstVisit;
update = true;
}
}
if (lastVisit.HasValue)
{
if (organizeLogOnEntity.LastVisit == null || organizeLogOnEntity.LastVisit < lastVisit)
{
organizeLogOnEntity.LastVisit = lastVisit;
update = true;
}
}
if (update)
{
organizeLogOnManager.UpdateObject(organizeLogOnEntity);
}
}
if (update)
{
System.Console.WriteLine("第 " + i.ToString() + " companyid : " + id);
}
else
{
System.Console.WriteLine("第 " + i.ToString());
}
}
dataReader.Close();
}
// 巴枪登录系统、没有登记过的，全部登记上来。
sqlQuery = @"SELECT u.companyid id
, MIN(l.firstvisit) firstvisit
, MAX(l.lastvisit) lastvisit
FROM pdauserlogon l
, baseuser u
WHERE l.id = u.id
GROUP BY u.companyid";
using (IDataReader dataReader = manager.ExecuteReader(sqlQuery))
{
i = 0;
while (dataReader.Read())
{
i++;
string id = BaseBusinessLogic.ConvertToString(dataReader[BaseOrganizeLogOnEntity.FieldId]);
DateTime?firstVisit = BaseBusinessLogic.ConvertToNullableDateTime(dataReader[BaseOrganizeLogOnEntity.FieldFirstVisit]);
DateTime?lastVisit = BaseBusinessLogic.ConvertToNullableDateTime(dataReader[BaseOrganizeLogOnEntity.FieldLastVisit]);
organizeLogOnEntity = organizeLogOnManager.GetObject(id);
if (organizeLogOnEntity == null)
{
organizeLogOnEntity = new BaseOrganizeLogOnEntity();
organizeLogOnEntity.Id = id;
organizeLogOnEntity.FirstVisit = firstVisit;
organizeLogOnEntity.LastVisit = lastVisit;
organizeLogOnManager.Add(organizeLogOnEntity);
}
else
{
update = false;
if (firstVisit.HasValue)
{
if (organizeLogOnEntity.FirstVisit == null || organizeLogOnEntity.FirstVisit > firstVisit)
{
organizeLogOnEntity.FirstVisit = firstVisit;
update = true;
}
}
if (lastVisit.HasValue)
{
if (organizeLogOnEntity.LastVisit == null || organizeLogOnEntity.LastVisit < lastVisit)
{
organizeLogOnEntity.LastVisit = lastVisit;
update = true;
}
}
organizeLogOnManager.UpdateObject(organizeLogOnEntity);
}
if (update)
{
System.Console.WriteLine("第 " + i.ToString() + " companyid : " + id);
}
else
{
System.Console.WriteLine("第 " + i.ToString());
}
}
dataReader.Close();
}
System.Console.WriteLine("公司整体登录状态已经更新完毕。");
return(result);
}
/// <summary>
/// 导入Excel数据到本地数据库
/// </summary>
public bool Import()
{
if (string.IsNullOrEmpty(txtFileFullPath.Text.Trim()))
{
XtraMessageBox.Show(@"请选择淘宝订单Excel", AppMessage.MSG0000, MessageBoxButtons.OK, MessageBoxIcon.Information);
btnOpenExcel_Click(this, null);
return(false);
}
if (!File.Exists(txtFileFullPath.Text))
{
XtraMessageBox.Show(@"选中文件不存在，请重新选择导入Excel文件", AppMessage.MSG0000, MessageBoxButtons.OK, MessageBoxIcon.Information);
btnOpenExcel_Click(this, null);
return(false);
}
#region 检查是否选择了发件人
ZtoUserEntity defaultUserEntity = null;
if (ckUserDefaultSendMan.Checked)
{
// 获取到默认的发件人
var defaultUserList = new ZtoUserManager(BillPrintHelper.DbHelper).GetList <ZtoUserEntity>(new KeyValuePair <string, object>(ZtoUserEntity.FieldIsDefault, 1), new KeyValuePair <string, object>(ZtoUserEntity.FieldIssendorreceive, 1));
if (defaultUserList.Any())
{
defaultUserEntity = defaultUserList.FirstOrDefault();
if (defaultUserEntity == null)
{
XtraMessageBox.Show(@"请添加一个默认的发件人，然后再导入订单数据", AppMessage.MSG0000, MessageBoxButtons.OK, MessageBoxIcon.Information);
return(false);
}
}
else
{
XtraMessageBox.Show(@"请添加一个默认的发件人，然后再导入订单数据", AppMessage.MSG0000, MessageBoxButtons.OK, MessageBoxIcon.Information);
return(false);
}
}
else
{
if (this.Tag != null)
{
defaultUserEntity = this.Tag as ZtoUserEntity;
// 表示选择了一个发件人的信息，这样也不用读取Excel里面的发件人了
if (defaultUserEntity == null)
{
XtraMessageBox.Show(@"请重新选择一个发件人，然后再导入订单数据", AppMessage.MSG0000, MessageBoxButtons.OK, MessageBoxIcon.Information);
ckChooseSendMan.Checked = true;
Import();
}
}
else
{
XtraMessageBox.Show(@"请选择一个发件人，然后再导入订单数据", AppMessage.MSG0000, MessageBoxButtons.OK, MessageBoxIcon.Information);
ckChooseSendMan.Checked = true;
Import();
}
}
#endregion
var startDateTime = DateTime.Now;
StartDt = startDateTime;
if (!splashScreenManagerImportExcel.IsSplashFormVisible)
{
splashScreenManagerImportExcel.ShowWaitForm();
}
Application.DoEvents();
splashScreenManagerImportExcel.SetWaitFormCaption("请稍后");
splashScreenManagerImportExcel.SetWaitFormDescription("开始导入淘宝订单Excel数据...");
try
{
DataTable chooseDt;
if (Path.GetExtension(txtFileFullPath.Text) == ".csv")
{
var readCsv = new ReadCsvHelper(txtFileFullPath.Text);
readCsv.CreateTable();
chooseDt = readCsv.GetResoultTable();
}
else
{
chooseDt = ExcelHelper.ExcelToDataTable(txtFileFullPath.Text, 0, null);
}
if (chooseDt != null && chooseDt.Rows.Count > 0)
{
var list = new List <ZtoPrintBillEntity>();
int temp = 0;
foreach (DataRow dr in chooseDt.Rows)
{
++temp;
splashScreenManagerImportExcel.SetWaitFormDescription(string.Format("正在导入Excel数据：{0}/{1}", temp, chooseDt.Rows.Count));
var entity = new ZtoPrintBillEntity();
if (ckTodaySend.Checked)
{
entity.SendDate = DateTime.Now.ToString(BaseSystemInfo.DateFormat);
}
if (defaultUserEntity != null)
{
entity.SendMan = defaultUserEntity.Realname;
entity.SendPhone = defaultUserEntity.Mobile + " " + defaultUserEntity.TelePhone;
entity.SendProvince = defaultUserEntity.Province;
entity.SendCity = defaultUserEntity.City;
entity.SendCounty = defaultUserEntity.County;
entity.SendAddress = defaultUserEntity.Address;
entity.SendCompany = defaultUserEntity.Company;
entity.SendDepartment = defaultUserEntity.Department;
entity.SendPostcode = defaultUserEntity.Postcode;
}
entity.SendSite = "";
entity.SendDeparture = entity.SendProvince;
entity.ReceiveMan = BaseBusinessLogic.ConvertToString(dr[12]);
entity.ReceivePhone = BaseBusinessLogic.ConvertToString(dr[16]);
entity.ReceiveProvince = "";
entity.ReceiveCity = "";
entity.ReceiveCounty = "";
entity.ReceiveAddress = BaseBusinessLogic.ConvertToString(dr[13]).Replace(" ", "");
// 目的地
entity.ReceiveDestination = "";
if (string.IsNullOrEmpty(entity.ReceiveDestination))
{
entity.ReceiveDestination = entity.ReceiveProvince;
}
entity.ReceiveCompany = "";
entity.ReceivePostcode = "";
entity.GoodsName = BaseBusinessLogic.ConvertToString(dr[19]);
entity.Weight = "";
entity.TranFee = "";
entity.GOODS_PAYMENT = 0;
entity.TOPAYMENT = 0;
entity.Length = "";
entity.Width = "";
entity.Height = "";
entity.TotalNumber = "";
entity.OrderNumber = BaseBusinessLogic.ConvertToString(dr[0]);
entity.Remark = BaseBusinessLogic.ConvertToString(dr[23]);
entity.CreateUserName = "";
entity.CreateSite = "";
entity.CreateOn = DateTime.Now;
entity.PaymentType = "";
// 如果Excel里面没有填写订单号系统自动生成一个订单号，这样提取电子面单单号就不用怕了，2016-1-23 14:07:12
if (string.IsNullOrEmpty(entity.OrderNumber))
{
// 导入自动生成订单号（电子面单）79170-南昌昌南 18779176845 这个qq提供的思路，2016-1-20 20:08:50
entity.OrderNumber = Guid.NewGuid().ToString("N").ToLower();
}
if (!ckGetServerPrintMark.Checked)
{
entity.BigPen = string.Format("{0} {1} {2}", entity.ReceiveProvince, entity.ReceiveCity, entity.ReceiveCounty);
}
else
{
entity.BigPen = "";
}
list.Add(entity);
}
if (!ckGetServerPrintMark.Checked)
{
var manager = new ZtoPrintBillManager(BillPrintHelper.DbHelper);
foreach (ZtoPrintBillEntity ztoPrintBillEntity in list)
{
manager.Add(ztoPrintBillEntity, true);
}
if (splashScreenManagerImportExcel != null && splashScreenManagerImportExcel.IsSplashFormVisible)
{
splashScreenManagerImportExcel.CloseWaitForm();
}
GridDataBind();
Close();
}
else
{
splashScreenManagerImportExcel.SetWaitFormDescription("正在联网获取大头笔信息，请稍后......");
// 开线程去读取大头笔的
CheckBillCode(list);
}
}
else
{
XtraMessageBox.Show(@"模板没有填写任何数据，导入失败", AppMessage.MSG0000, MessageBoxButtons.OK, MessageBoxIcon.Error);
return(false);
}
}
catch (Exception ex)
{
ProcessException(ex);
return(false);
}
finally
{
if (splashScreenManagerImportExcel != null && splashScreenManagerImportExcel.IsSplashFormVisible)
{
splashScreenManagerImportExcel.CloseWaitForm();
}
}
return(true);
}