/// <summary>
/// 按条件分页查询(带记录状态Enabled和删除状态Deleted)
/// </summary>
/// <param name="companyId">查看公司主键</param>
/// <param name="departmentId">查看部门主键</param>
/// <param name="userId">查看用户主键</param>
/// <param name="startTime">创建开始时间</param>
/// <param name="endTime">创建结束时间</param>
/// <param name="searchKey">查询关键字</param>
/// <param name="recordCount">记录数</param>
/// <param name="pageNo">当前页</param>
/// <param name="pageSize">每页显示</param>
/// <param name="sortExpression">排序字段</param>
/// <param name="sortDirection">排序方向</param>
/// <param name="showDisabled">是否显示无效记录</param>
/// <param name="showDeleted">是否显示已删除记录</param>
/// <param name="systemCode">子系统编码</param>
/// <param name="userName">用户名</param>
/// <param name="companyName">公司名称</param>
/// <param name="result">结果</param>
/// <returns>数据表</returns>
public DataTable GetDataTableByPage(string companyId, string departmentId, string userId, string startTime, string endTime, string searchKey, out int recordCount, int pageNo = 1, int pageSize = 20, string sortExpression = BaseLogonLogEntity.FieldCreateTime, string sortDirection = "DESC", bool showDisabled = true, bool showDeleted = true, string systemCode = null, string userName = null, string companyName = null, string result = null)
{
var sb = Pool.StringBuilder.Get().Append(" 1 = 1");
//是否显示无效记录
if (!showDisabled)
{
sb.Append(" AND " + BaseLogonLogEntity.FieldEnabled + " = 1");
}
//是否显示已删除记录
if (!showDeleted)
{
sb.Append(" AND " + BaseLogonLogEntity.FieldDeleted + " = 0");
}
if (ValidateUtil.IsInt(companyId))
{
sb.Append(" AND " + BaseLogonLogEntity.FieldCompanyId + " = " + companyId);
}
// 只有管理员才能看到所有的
//if (!(UserInfo.IsAdministrator && BaseSystemInfo.AdministratorEnabled))
//{
//sb.Append(" AND (" + BaseLogonLogEntity.FieldUserCompanyId + " = 0 OR " + BaseLogonLogEntity.FieldUserCompanyId + " = " + UserInfo.CompanyId + ")");
//}
if (ValidateUtil.IsInt(departmentId))
{
//sb.Append(" AND " + BaseLogonLogEntity.FieldDepartmentId + " = " + departmentId);
}
if (ValidateUtil.IsInt(userId))
{
sb.Append(" AND " + BaseLogonLogEntity.FieldUserId + " = " + userId);
}
//创建时间
if (ValidateUtil.IsDateTime(startTime))
{
sb.Append(" AND " + BaseLogonLogEntity.FieldCreateTime + " >= '" + startTime + "'");
}
if (ValidateUtil.IsDateTime(endTime))
{
sb.Append(" AND " + BaseLogonLogEntity.FieldCreateTime + " <= DATEADD(s,-1,DATEADD(d,1,'" + endTime + "'))");
}
//子系统编码
if (!string.IsNullOrEmpty(systemCode))
{
sb.Append(" AND " + BaseLogonLogEntity.CurrentTableName + "." + BaseLogonLogEntity.FieldSystemCode + " = N'" + systemCode + "'");
}
//用户名
if (!string.IsNullOrEmpty(userName))
{
userName = dbHelper.SqlSafe(userName);
sb.Append(" AND " + BaseLogonLogEntity.FieldUserName + " = N'" + userName + "'");
}
//操作状态
if (!string.IsNullOrEmpty(result))
{
result = dbHelper.SqlSafe(result);
sb.Append(" AND " + BaseLogonLogEntity.FieldResult + " = N'" + result + "'");
}
if (!string.IsNullOrEmpty(searchKey))
{
searchKey = StringUtil.GetLikeSearchKey(dbHelper.SqlSafe(searchKey));
sb.Append(" AND (" + BaseLogonLogEntity.FieldUserName + " LIKE N'%" + searchKey + "%' OR " + BaseLogonLogEntity.FieldCompanyName + " LIKE N'%" + searchKey + "%' OR " + BaseLogonLogEntity.FieldOperationType + " LIKE N'%" + searchKey + "%' OR " + BaseLogonLogEntity.FieldIpAddress + " LIKE N'%" + searchKey + "%' OR " + BaseLogonLogEntity.FieldLogonStatus + " LIKE N'%" + searchKey + "%' OR " + BaseLogonLogEntity.FieldRealName + " LIKE N'%" + searchKey + "%')");
}
sb.Replace(" 1 = 1 AND ", "");
return(GetDataTableByPage(out recordCount, pageNo, pageSize, sortExpression, sortDirection, CurrentTableName, sb.Put(), null, "*"));
}
/// <summary>
/// 按条件分页高级查询(带记录状态Enabled和删除状态Deleted)
/// </summary>
/// <param name="systemCode">系统编码</param>
/// <param name="organizationId">查看公司主键</param>
/// <param name="userId">查看用户主键</param>
/// <param name="roleId">角色编号</param>
/// <param name="roleIdExcluded">排除角色编号</param>
/// <param name="moduleId">模块菜单编号</param>
/// <param name="moduleIdExcluded">排除模块菜单编号</param>
/// <param name="showInvisible">是否显示隐藏</param>
/// <param name="disabledUserOnly">仅显示禁用</param>
/// <param name="startTime">开始时间</param>
/// <param name="endTime">结束时间</param>
/// <param name="searchKey">查询关键字</param>
/// <param name="recordCount">记录数</param>
/// <param name="pageNo">当前页</param>
/// <param name="pageSize">每页显示</param>
/// <param name="sortExpression">排序字段</param>
/// <param name="sortDirection">排序方向</param>
/// <param name="showDisabled">是否显示无效记录</param>
/// <param name="showDeleted">是否显示已删除记录</param>
/// <returns>数据表</returns>
public DataTable GetDataTableByPage(string systemCode, string organizationId, string userId, string roleId, string roleIdExcluded, string moduleId, string moduleIdExcluded, bool showInvisible, bool disabledUserOnly, string startTime, string endTime, string searchKey, out int recordCount, int pageNo = 1, int pageSize = 20, string sortExpression = "CreateTime", string sortDirection = "DESC", bool showDisabled = true, bool showDeleted = true)
{
//用户表名
var tableNameUser = BaseUserEntity.CurrentTableName;
//用户登录表名
var tableNameUserLogon = BaseUserLogonEntity.CurrentTableName;
var sb = Pool.StringBuilder.Get().Append(" 1 = 1");
//只显示已锁定用户
if (disabledUserOnly)
{
sb.Append(" AND " + BaseUserEntity.FieldEnabled + " = 0 ");
//已锁定
showDisabled = true;
//未删除
showDeleted = false;
}
//是否显示无效记录
if (!showDisabled)
{
sb.Append(" AND " + BaseUserEntity.FieldEnabled + " = 1 ");
}
//是否显示已删除记录
if (!showDeleted)
{
sb.Append(" AND " + BaseUserEntity.FieldDeleted + " = 0 ");
}
if (ValidateUtil.IsInt(organizationId) && int.Parse(organizationId) > 0)
{
//只选择当前
//sb.Append(" AND (" + BaseUserEntity.FieldCompanyId + " = " + organizationId + ")";
//只选择当前和下一级
//sb.Append(" AND " + BaseUserEntity.FieldDepartmentId
// + " IN ( SELECT " + BaseOrganizationEntity.FieldId
// + " FROM " + BaseOrganizationEntity.CurrentTableName
// + " WHERE " + BaseOrganizationEntity.FieldId + " = " + organizationId + " OR " + BaseOrganizationEntity.FieldParentId + " = " + organizationId + ")";
//所有下级的都列出来
var organizationManager = new BaseOrganizationManager(UserInfo);
var ids = organizationManager.GetChildrensId(BaseOrganizationEntity.FieldId, organizationId, BaseOrganizationEntity.FieldParentId);
if (ids != null && ids.Length > 0)
{
sb.Append(" AND (" + BaseUserEntity.FieldCompanyId + " IN (" + StringUtil.ArrayToList(ids) + ")"
+ " OR " + BaseUserEntity.FieldSubCompanyId + " IN (" + StringUtil.ArrayToList(ids) + ")"
+ " OR " + BaseUserEntity.FieldDepartmentId + " IN (" + StringUtil.ArrayToList(ids) + ")"
+ " OR " + BaseUserEntity.FieldSubDepartmentId + " IN (" + StringUtil.ArrayToList(ids) + ")"
+ " OR " + BaseUserEntity.FieldWorkgroupId + " IN (" + StringUtil.ArrayToList(ids) + "))");
}
}
//if (ValidateUtil.IsInt(departmentId))
//{
// sb.Append(" AND " + BaseUserEntity.FieldDepartmentId + " = " + departmentId;
//}
if (ValidateUtil.IsInt(userId))
{
// sb.Append(" AND UserId = " + userId);
}
//是否显示已隐藏记录
if (!showInvisible)
{
sb.Append(" AND " + BaseUserEntity.FieldIsVisible + " = 1 ");
}
//角色
var tableNameUserRole = UserInfo.SystemCode + "UserRole";
if (!string.IsNullOrEmpty(systemCode))
{
tableNameUserRole = systemCode + "UserRole";
}
//指定角色
if (ValidateUtil.IsInt(roleId))
{
sb.Append(" AND ( " + BaseUserEntity.FieldId + " IN ");
sb.Append(" (SELECT DISTINCT " + BaseUserRoleEntity.FieldUserId);
sb.Append(" FROM " + tableNameUserRole);
sb.Append(" WHERE " + BaseUserRoleEntity.FieldRoleId + " = '" + roleId + "'");
sb.Append(" AND " + BaseUserRoleEntity.FieldEnabled + " = 1");
sb.Append(" AND " + BaseUserRoleEntity.FieldDeleted + " = 0)) ");
}
//排除指定角色
if (ValidateUtil.IsInt(roleIdExcluded))
{
sb.Append(" AND ( " + BaseUserEntity.FieldId + " NOT IN ");
sb.Append(" (SELECT DISTINCT " + BaseUserRoleEntity.FieldUserId);
sb.Append(" FROM " + tableNameUserRole);
sb.Append(" WHERE " + BaseUserRoleEntity.FieldRoleId + " = '" + roleIdExcluded + "'");
sb.Append(" AND " + BaseUserRoleEntity.FieldEnabled + " = 1");
sb.Append(" AND " + BaseUserRoleEntity.FieldDeleted + " = 0)) ");
}
//用户菜单模块表
var tableNamePermission = UserInfo.SystemCode + "Permission";
if (!string.IsNullOrEmpty(systemCode))
{
tableNamePermission = systemCode + "Permission";
}
//指定的菜单模块
if (ValidateUtil.IsInt(moduleId))
{
sb.Append(" AND ( " + BaseUserEntity.FieldId + " IN ");
sb.Append(" (SELECT DISTINCT " + BasePermissionEntity.FieldResourceId);
sb.Append(" FROM " + tableNamePermission);
sb.Append(" WHERE " + BasePermissionEntity.FieldPermissionId + " = '" + moduleId + "'");
sb.Append(" AND " + BasePermissionEntity.FieldResourceCategory + " = '" + BaseUserEntity.CurrentTableName + "' ");
sb.Append(" AND " + BasePermissionEntity.FieldEnabled + " = 1");
sb.Append(" AND " + BasePermissionEntity.FieldDeleted + " = 0)) ");
}
//排除指定菜单模块
if (ValidateUtil.IsInt(moduleIdExcluded))
{
sb.Append(" AND ( " + BaseUserEntity.FieldId + " NOT IN ");
sb.Append(" (SELECT DISTINCT " + BasePermissionEntity.FieldResourceId);
sb.Append(" FROM " + tableNamePermission);
sb.Append(" WHERE " + BasePermissionEntity.FieldPermissionId + " = '" + moduleIdExcluded + "'");
sb.Append(" AND " + BasePermissionEntity.FieldResourceCategory + " = '" + BaseUserEntity.CurrentTableName + "' ");
sb.Append(" AND " + BasePermissionEntity.FieldEnabled + " = 1");
sb.Append(" AND " + BasePermissionEntity.FieldDeleted + " = 0)) ");
}
//关键词
if (!string.IsNullOrEmpty(searchKey))
{
searchKey = StringUtil.GetLikeSearchKey(dbHelper.SqlSafe(searchKey));
sb.Append(" AND (" + BaseUserEntity.FieldRealName + " LIKE N'%" + searchKey + "%'");
sb.Append(" OR " + BaseUserEntity.FieldUserName + " LIKE N'%" + searchKey + "%'");
sb.Append(" OR " + BaseUserEntity.FieldNickName + " LIKE N'%" + searchKey + "%'");
sb.Append(" OR " + BaseUserEntity.FieldCompanyName + " LIKE N'%" + searchKey + "%'");
sb.Append(" OR " + BaseUserEntity.FieldSubCompanyName + " LIKE N'%" + searchKey + "%'");
sb.Append(" OR " + BaseUserEntity.FieldDepartmentName + " LIKE N'%" + searchKey + "%'");
sb.Append(" OR " + BaseUserEntity.FieldSubDepartmentName + " LIKE N'%" + searchKey + "%'");
sb.Append(" OR " + BaseUserEntity.FieldWorkgroupName + " LIKE N'%" + searchKey + "%'");
sb.Append(" OR " + BaseUserEntity.FieldCode + " LIKE N'%" + searchKey + "%'");
sb.Append(" OR " + BaseUserEntity.FieldDescription + " LIKE N'%" + searchKey + "%'");
sb.Append(" OR " + BaseUserEntity.FieldQuickQuery + " LIKE N'%" + searchKey + "%'");
sb.Append(" OR " + BaseUserEntity.FieldSimpleSpelling + " LIKE N'%" + searchKey + "%')");
}
if (ValidateUtil.IsDateTime(startTime))
{
sb.Append(" AND " + BaseUserEntity.FieldCreateTime + " >= '" + startTime + "'");
}
if (ValidateUtil.IsDateTime(endTime))
{
sb.Append(" AND " + BaseUserEntity.FieldCreateTime + " <= DATEADD(s,-1,DATEADD(d,1,'" + endTime + "'))");
}
sb.Replace(" 1 = 1 AND ", "");
//重新构造viewName
var viewName = string.Empty;
viewName = "SELECT DISTINCT " + tableNameUser + "." + BaseUserEntity.FieldId;
viewName += "," + tableNameUser + "." + BaseUserEntity.FieldUserFrom;
viewName += "," + tableNameUser + "." + BaseUserEntity.FieldUserName;
viewName += "," + tableNameUser + "." + BaseUserEntity.FieldRealName;
viewName += "," + tableNameUser + "." + BaseUserEntity.FieldNickName;
viewName += "," + tableNameUser + "." + BaseUserEntity.FieldCode;
viewName += "," + tableNameUser + "." + BaseUserEntity.FieldIdCard;
viewName += "," + tableNameUser + "." + BaseUserEntity.FieldQuickQuery;
viewName += "," + tableNameUser + "." + BaseUserEntity.FieldSimpleSpelling;
viewName += "," + tableNameUser + "." + BaseUserEntity.FieldCompanyId;
viewName += "," + tableNameUser + "." + BaseUserEntity.FieldCompanyName;
viewName += "," + tableNameUser + "." + BaseUserEntity.FieldSubCompanyId;
viewName += "," + tableNameUser + "." + BaseUserEntity.FieldSubCompanyName;
viewName += "," + tableNameUser + "." + BaseUserEntity.FieldDepartmentId;
viewName += "," + tableNameUser + "." + BaseUserEntity.FieldDepartmentName;
viewName += "," + tableNameUser + "." + BaseUserEntity.FieldSubDepartmentId;
viewName += "," + tableNameUser + "." + BaseUserEntity.FieldSubDepartmentName;
viewName += "," + tableNameUser + "." + BaseUserEntity.FieldWorkgroupId;
viewName += "," + tableNameUser + "." + BaseUserEntity.FieldWorkgroupName;
viewName += "," + tableNameUser + "." + BaseUserEntity.FieldWorkCategory;
viewName += "," + tableNameUser + "." + BaseUserEntity.FieldSecurityLevel;
viewName += "," + tableNameUser + "." + BaseUserEntity.FieldTitle;
viewName += "," + tableNameUser + "." + BaseUserEntity.FieldDuty;
viewName += "," + tableNameUser + "." + BaseUserEntity.FieldLang;
viewName += "," + tableNameUser + "." + BaseUserEntity.FieldGender;
viewName += "," + tableNameUser + "." + BaseUserEntity.FieldBirthday;
viewName += "," + tableNameUser + "." + BaseUserEntity.FieldScore;
//viewName += "," + tableNameUser + "." + BaseUserEntity.FieldFans;
viewName += "," + tableNameUser + "." + BaseUserEntity.FieldHomeAddress;
viewName += "," + tableNameUser + "." + BaseUserEntity.FieldSignature;
viewName += "," + tableNameUser + "." + BaseUserEntity.FieldTheme;
viewName += "," + tableNameUser + "." + BaseUserEntity.FieldIsStaff;
viewName += "," + tableNameUser + "." + BaseUserEntity.FieldIsVisible;
viewName += "," + tableNameUser + "." + BaseUserEntity.FieldProvince;
viewName += "," + tableNameUser + "." + BaseUserEntity.FieldCity;
viewName += "," + tableNameUser + "." + BaseUserEntity.FieldDistrict;
viewName += "," + tableNameUser + "." + BaseUserEntity.FieldAuditStatus;
viewName += "," + tableNameUser + "." + BaseUserEntity.FieldEnabled;
viewName += "," + tableNameUser + "." + BaseUserEntity.FieldDeleted;
viewName += "," + tableNameUser + "." + BaseUserEntity.FieldSortCode;
viewName += "," + tableNameUser + "." + BaseUserEntity.FieldDescription;
viewName += "," + tableNameUser + "." + BaseUserEntity.FieldIsAdministrator;
viewName += "," + tableNameUser + "." + BaseUserEntity.FieldIsCheckBalance;
//用户表
viewName += "," + tableNameUser + "." + BaseUserEntity.FieldCreateTime;
viewName += "," + tableNameUser + "." + BaseUserEntity.FieldCreateUserId;
viewName += "," + tableNameUser + "." + BaseUserEntity.FieldCreateBy;
viewName += "," + tableNameUser + "." + BaseUserEntity.FieldUpdateTime;
viewName += "," + tableNameUser + "." + BaseUserEntity.FieldUpdateUserId;
viewName += "," + tableNameUser + "." + BaseUserEntity.FieldUpdateBy;
//用户登录表
viewName += "," + tableNameUserLogon + "." + BaseUserLogonEntity.FieldAllowStartTime;
viewName += "," + tableNameUserLogon + "." + BaseUserLogonEntity.FieldAllowEndTime;
viewName += "," + tableNameUserLogon + "." + BaseUserLogonEntity.FieldLockStartTime;
viewName += "," + tableNameUserLogon + "." + BaseUserLogonEntity.FieldLockEndTime;
viewName += "," + tableNameUserLogon + "." + BaseUserLogonEntity.FieldFirstVisitTime;
viewName += "," + tableNameUserLogon + "." + BaseUserLogonEntity.FieldPreviousVisitTime;
viewName += "," + tableNameUserLogon + "." + BaseUserLogonEntity.FieldLastVisitTime;
viewName += "," + tableNameUserLogon + "." + BaseUserLogonEntity.FieldChangePasswordTime;
viewName += "," + tableNameUserLogon + "." + BaseUserLogonEntity.FieldLogonCount;
viewName += "," + tableNameUserLogon + "." + BaseUserLogonEntity.FieldConcurrentUser;
viewName += "," + tableNameUserLogon + "." + BaseUserLogonEntity.FieldUserOnline;
//不从用户登录表读取这些字段，从用户表读取即可
//viewName += "," + tableNameUserLogon + "." + BaseUserLogonEntity.FieldCreateTime;
//viewName += "," + tableNameUserLogon + "." + BaseUserLogonEntity.FieldCreateUserId;
//viewName += "," + tableNameUserLogon + "." + BaseUserLogonEntity.FieldCreateBy;
//viewName += "," + tableNameUserLogon + "." + BaseUserLogonEntity.FieldUpdateTime;
//viewName += "," + tableNameUserLogon + "." + BaseUserLogonEntity.FieldUpdateUserId;
//viewName += "," + tableNameUserLogon + "." + BaseUserLogonEntity.FieldUpdateBy;
viewName += " FROM " + tableNameUser + " INNER JOIN " + tableNameUserLogon;
viewName += " ON " + tableNameUser + "." + BaseUserEntity.FieldId + " = " + tableNameUserLogon + "." + BaseUserLogonEntity.FieldUserId;
//指定角色，就读取相应的UserRole授权日期
if (ValidateUtil.IsInt(roleId))
{
viewName = "SELECT DISTINCT " + tableNameUser + "." + BaseUserEntity.FieldId;
viewName += "," + tableNameUser + "." + BaseUserEntity.FieldUserFrom;
viewName += "," + tableNameUser + "." + BaseUserEntity.FieldUserName;
viewName += "," + tableNameUser + "." + BaseUserEntity.FieldRealName;
viewName += "," + tableNameUser + "." + BaseUserEntity.FieldNickName;
viewName += "," + tableNameUser + "." + BaseUserEntity.FieldCode;
viewName += "," + tableNameUser + "." + BaseUserEntity.FieldIdCard;
viewName += "," + tableNameUser + "." + BaseUserEntity.FieldQuickQuery;
viewName += "," + tableNameUser + "." + BaseUserEntity.FieldSimpleSpelling;
viewName += "," + tableNameUser + "." + BaseUserEntity.FieldCompanyId;
viewName += "," + tableNameUser + "." + BaseUserEntity.FieldCompanyName;
viewName += "," + tableNameUser + "." + BaseUserEntity.FieldSubCompanyId;
viewName += "," + tableNameUser + "." + BaseUserEntity.FieldSubCompanyName;
viewName += "," + tableNameUser + "." + BaseUserEntity.FieldDepartmentId;
viewName += "," + tableNameUser + "." + BaseUserEntity.FieldDepartmentName;
viewName += "," + tableNameUser + "." + BaseUserEntity.FieldSubDepartmentId;
viewName += "," + tableNameUser + "." + BaseUserEntity.FieldSubDepartmentName;
viewName += "," + tableNameUser + "." + BaseUserEntity.FieldWorkgroupId;
viewName += "," + tableNameUser + "." + BaseUserEntity.FieldWorkgroupName;
viewName += "," + tableNameUser + "." + BaseUserEntity.FieldWorkCategory;
viewName += "," + tableNameUser + "." + BaseUserEntity.FieldSecurityLevel;
viewName += "," + tableNameUser + "." + BaseUserEntity.FieldTitle;
viewName += "," + tableNameUser + "." + BaseUserEntity.FieldDuty;
viewName += "," + tableNameUser + "." + BaseUserEntity.FieldLang;
viewName += "," + tableNameUser + "." + BaseUserEntity.FieldGender;
viewName += "," + tableNameUser + "." + BaseUserEntity.FieldBirthday;
viewName += "," + tableNameUser + "." + BaseUserEntity.FieldScore;
//viewName += "," + tableNameUser + "." + BaseUserEntity.FieldFans;
viewName += "," + tableNameUser + "." + BaseUserEntity.FieldHomeAddress;
viewName += "," + tableNameUser + "." + BaseUserEntity.FieldSignature;
viewName += "," + tableNameUser + "." + BaseUserEntity.FieldTheme;
viewName += "," + tableNameUser + "." + BaseUserEntity.FieldIsStaff;
viewName += "," + tableNameUser + "." + BaseUserEntity.FieldIsVisible;
viewName += "," + tableNameUser + "." + BaseUserEntity.FieldProvince;
viewName += "," + tableNameUser + "." + BaseUserEntity.FieldCity;
viewName += "," + tableNameUser + "." + BaseUserEntity.FieldDistrict;
viewName += "," + tableNameUser + "." + BaseUserEntity.FieldAuditStatus;
viewName += "," + tableNameUser + "." + BaseUserEntity.FieldEnabled;
viewName += "," + tableNameUser + "." + BaseUserEntity.FieldDeleted;
viewName += "," + tableNameUser + "." + BaseUserEntity.FieldSortCode;
viewName += "," + tableNameUser + "." + BaseUserEntity.FieldDescription;
viewName += "," + tableNameUser + "." + BaseUserEntity.FieldIsAdministrator;
viewName += "," + tableNameUser + "." + BaseUserEntity.FieldIsCheckBalance;
//用户登录表
viewName += "," + tableNameUserLogon + "." + BaseUserLogonEntity.FieldAllowStartTime;
viewName += "," + tableNameUserLogon + "." + BaseUserLogonEntity.FieldAllowEndTime;
viewName += "," + tableNameUserLogon + "." + BaseUserLogonEntity.FieldLockStartTime;
viewName += "," + tableNameUserLogon + "." + BaseUserLogonEntity.FieldLockEndTime;
viewName += "," + tableNameUserLogon + "." + BaseUserLogonEntity.FieldFirstVisitTime;
viewName += "," + tableNameUserLogon + "." + BaseUserLogonEntity.FieldPreviousVisitTime;
viewName += "," + tableNameUserLogon + "." + BaseUserLogonEntity.FieldLastVisitTime;
viewName += "," + tableNameUserLogon + "." + BaseUserLogonEntity.FieldChangePasswordTime;
viewName += "," + tableNameUserLogon + "." + BaseUserLogonEntity.FieldLogonCount;
viewName += "," + tableNameUserLogon + "." + BaseUserLogonEntity.FieldConcurrentUser;
viewName += "," + tableNameUserLogon + "." + BaseUserLogonEntity.FieldUserOnline;
//授权日期
viewName += "," + tableNameUserRole + "." + BaseUserRoleEntity.FieldCreateTime;
viewName += "," + tableNameUserRole + "." + BaseUserRoleEntity.FieldCreateUserId;
viewName += "," + tableNameUserRole + "." + BaseUserRoleEntity.FieldCreateBy;
viewName += "," + tableNameUserRole + "." + BaseUserRoleEntity.FieldUpdateTime;
viewName += "," + tableNameUserRole + "." + BaseUserRoleEntity.FieldUpdateUserId;
viewName += "," + tableNameUserRole + "." + BaseUserRoleEntity.FieldUpdateBy;
viewName += " FROM " + tableNameUser + " INNER JOIN " + tableNameUserRole;
viewName += " ON " + tableNameUser + "." + BaseUserEntity.FieldId + " = " + tableNameUserRole + "." + BaseUserRoleEntity.FieldUserId;
viewName += " INNER JOIN " + tableNameUserLogon;
viewName += " ON " + tableNameUser + "." + BaseUserEntity.FieldId + " = " + tableNameUserLogon + "." + BaseUserLogonEntity.FieldUserId;
viewName += " WHERE (" + tableNameUserRole + "." + BaseUserRoleEntity.FieldRoleId + " = " + roleId + ")";
}
//指定菜单模块，就读取相应的Permission授权日期
else if (ValidateUtil.IsInt(moduleId))
{
viewName = "SELECT DISTINCT " + tableNameUser + "." + BaseUserEntity.FieldId;
viewName += "," + tableNameUser + "." + BaseUserEntity.FieldUserFrom;
viewName += "," + tableNameUser + "." + BaseUserEntity.FieldUserName;
viewName += "," + tableNameUser + "." + BaseUserEntity.FieldRealName;
viewName += "," + tableNameUser + "." + BaseUserEntity.FieldNickName;
viewName += "," + tableNameUser + "." + BaseUserEntity.FieldCode;
viewName += "," + tableNameUser + "." + BaseUserEntity.FieldIdCard;
viewName += "," + tableNameUser + "." + BaseUserEntity.FieldQuickQuery;
viewName += "," + tableNameUser + "." + BaseUserEntity.FieldSimpleSpelling;
viewName += "," + tableNameUser + "." + BaseUserEntity.FieldCompanyId;
viewName += "," + tableNameUser + "." + BaseUserEntity.FieldCompanyName;
viewName += "," + tableNameUser + "." + BaseUserEntity.FieldSubCompanyId;
viewName += "," + tableNameUser + "." + BaseUserEntity.FieldSubCompanyName;
viewName += "," + tableNameUser + "." + BaseUserEntity.FieldDepartmentId;
viewName += "," + tableNameUser + "." + BaseUserEntity.FieldDepartmentName;
viewName += "," + tableNameUser + "." + BaseUserEntity.FieldSubDepartmentId;
viewName += "," + tableNameUser + "." + BaseUserEntity.FieldSubDepartmentName;
viewName += "," + tableNameUser + "." + BaseUserEntity.FieldWorkgroupId;
viewName += "," + tableNameUser + "." + BaseUserEntity.FieldWorkgroupName;
viewName += "," + tableNameUser + "." + BaseUserEntity.FieldWorkCategory;
viewName += "," + tableNameUser + "." + BaseUserEntity.FieldSecurityLevel;
viewName += "," + tableNameUser + "." + BaseUserEntity.FieldTitle;
viewName += "," + tableNameUser + "." + BaseUserEntity.FieldDuty;
viewName += "," + tableNameUser + "." + BaseUserEntity.FieldLang;
viewName += "," + tableNameUser + "." + BaseUserEntity.FieldGender;
viewName += "," + tableNameUser + "." + BaseUserEntity.FieldBirthday;
viewName += "," + tableNameUser + "." + BaseUserEntity.FieldScore;
//viewName += "," + tableNameUser + "." + BaseUserEntity.FieldFans;
viewName += "," + tableNameUser + "." + BaseUserEntity.FieldHomeAddress;
viewName += "," + tableNameUser + "." + BaseUserEntity.FieldSignature;
viewName += "," + tableNameUser + "." + BaseUserEntity.FieldTheme;
viewName += "," + tableNameUser + "." + BaseUserEntity.FieldIsStaff;
viewName += "," + tableNameUser + "." + BaseUserEntity.FieldIsVisible;
viewName += "," + tableNameUser + "." + BaseUserEntity.FieldProvince;
viewName += "," + tableNameUser + "." + BaseUserEntity.FieldCity;
viewName += "," + tableNameUser + "." + BaseUserEntity.FieldDistrict;
viewName += "," + tableNameUser + "." + BaseUserEntity.FieldAuditStatus;
viewName += "," + tableNameUser + "." + BaseUserEntity.FieldEnabled;
viewName += "," + tableNameUser + "." + BaseUserEntity.FieldDeleted;
viewName += "," + tableNameUser + "." + BaseUserEntity.FieldSortCode;
viewName += "," + tableNameUser + "." + BaseUserEntity.FieldDescription;
viewName += "," + tableNameUser + "." + BaseUserEntity.FieldIsAdministrator;
viewName += "," + tableNameUser + "." + BaseUserEntity.FieldIsCheckBalance;
//用户登录表
viewName += "," + tableNameUserLogon + "." + BaseUserLogonEntity.FieldAllowStartTime;
viewName += "," + tableNameUserLogon + "." + BaseUserLogonEntity.FieldAllowEndTime;
viewName += "," + tableNameUserLogon + "." + BaseUserLogonEntity.FieldLockStartTime;
viewName += "," + tableNameUserLogon + "." + BaseUserLogonEntity.FieldLockEndTime;
viewName += "," + tableNameUserLogon + "." + BaseUserLogonEntity.FieldFirstVisitTime;
viewName += "," + tableNameUserLogon + "." + BaseUserLogonEntity.FieldPreviousVisitTime;
viewName += "," + tableNameUserLogon + "." + BaseUserLogonEntity.FieldLastVisitTime;
viewName += "," + tableNameUserLogon + "." + BaseUserLogonEntity.FieldChangePasswordTime;
viewName += "," + tableNameUserLogon + "." + BaseUserLogonEntity.FieldLogonCount;
viewName += "," + tableNameUserLogon + "." + BaseUserLogonEntity.FieldConcurrentUser;
viewName += "," + tableNameUserLogon + "." + BaseUserLogonEntity.FieldUserOnline;
//授权日期
viewName += "," + tableNamePermission + "." + BasePermissionEntity.FieldCreateTime;
viewName += "," + tableNamePermission + "." + BasePermissionEntity.FieldCreateUserId;
viewName += "," + tableNamePermission + "." + BasePermissionEntity.FieldCreateBy;
viewName += "," + tableNamePermission + "." + BasePermissionEntity.FieldUpdateTime;
viewName += "," + tableNamePermission + "." + BasePermissionEntity.FieldUpdateUserId;
viewName += "," + tableNamePermission + "." + BasePermissionEntity.FieldUpdateBy;
viewName += " FROM " + tableNameUser + " INNER JOIN " + tableNamePermission;
viewName += " ON " + tableNameUser + "." + BaseUserEntity.FieldId + " = " + tableNamePermission + "." + BasePermissionEntity.FieldResourceId;
viewName += " INNER JOIN " + tableNameUserLogon;
viewName += " ON " + tableNameUser + "." + BaseUserEntity.FieldId + " = " + tableNameUserLogon + "." + BaseUserLogonEntity.FieldUserId;
viewName += " WHERE (" + tableNamePermission + "." + BasePermissionEntity.FieldResourceCategory + " = '" + tableNameUser + "')";
viewName += " AND (" + tableNamePermission + "." + BasePermissionEntity.FieldPermissionId + " = " + moduleId + ")";
}
//从视图读取
if (!string.IsNullOrEmpty(viewName))
{
tableNameUser = viewName;
}
return(GetDataTableByPage(out recordCount, pageNo, pageSize, sortExpression, sortDirection, tableNameUser, sb.Put(), null, "*"));
}
private void skinComboBox_PfCustomer_SelectedIndexChanged(object sender, EventArgs e)
{
shopID = ValidateUtil.CheckEmptyValue(skinComboBox_PfCustomer.SelectedValue);
}
private void BindData()
{
this.listView1.CheckBoxes = chkSelect.Checked;
this.listView1.Items.Clear();
this.imageList1.Images.Clear();
this.imageList2.Images.Clear();
imageDict.Clear();//刷新需要清除
List <FileUploadInfo> fileList = BLLFactory <FileUpload> .Instance.GetByAttachGUID(this.AttachmentGUID);
int k = 0;
System.Drawing.Icon icon = null;
foreach (FileUploadInfo fileInfo in fileList)
{
string file = fileInfo.FileName;
string extension = FileUtil.GetExtension(file);
#region 取缩略图存到 imageList1 的操作
//如果是图片，取得它的图片数据作为缩略图
bool isImage = ValidateUtil.IsImageFile(fileInfo.FileExtend);
if (isImage)
{
try
{
FileUploadInfo tmpInfo = BLLFactory <FileUpload> .Instance.Download(fileInfo.ID, 48, 48);
if (tmpInfo != null && tmpInfo.FileData != null)
{
this.imageList1.Images.Add(ImageHelper.BitmapFromBytes(tmpInfo.FileData));
this.imageList2.Images.Add(ImageHelper.BitmapFromBytes(tmpInfo.FileData));
}
else
{
icon = IconReaderHelper.ExtractIconForExtension(extension, true); //大图标
this.imageList1.Images.Add(icon);
icon = IconReaderHelper.ExtractIconForExtension(extension, false); //小图标
this.imageList2.Images.Add(icon);
}
}
catch (Exception ex)
{
icon = IconReaderHelper.ExtractIconForExtension(extension, true); //大图标
this.imageList1.Images.Add(icon);
icon = IconReaderHelper.ExtractIconForExtension(extension, false); //小图标
this.imageList2.Images.Add(icon);
LogHelper.WriteLog(LogLevel.LOG_LEVEL_CRIT, ex, typeof(FrmAttachmentGroupView));
MessageDxUtil.ShowError(ex.Message);
}
}
else
{
icon = IconReaderHelper.ExtractIconForExtension(extension, true); //大图标
this.imageList1.Images.Add(icon);
icon = IconReaderHelper.ExtractIconForExtension(extension, false); //小图标
this.imageList2.Images.Add(icon);
}
#endregion
if (!imageDict.ContainsKey(file))
{
imageDict.Add(file, k++);
}
}
foreach (FileUploadInfo fileInfo in fileList)
{
ListViewItem item = listView1.Items.Add(fileInfo.FileName);
double fileSize = ConvertHelper.ToDouble(fileInfo.FileSize / 1024, 1);
item.SubItems.Add(fileSize.ToString("#,#KB"));
item.SubItems.Add(fileInfo.AddTime.ToShortDateString());
item.ImageIndex = GetImageKey(fileInfo.FileName);
item.Tag = fileInfo.ID;
}
}
public override bool CheckInput()
{
bool result = true;//默认是可以通过
#region MyRegion
if (this.txtDictType.Text.Trim().Length == 0)
{
MessageDxUtil.ShowWarning(Const.MsgCheckInput + lblDictType.Text.Replace(Const.MsgCheckSign, string.Empty));
this.txtDictType.Focus();
result = false;
}
if (this.txtValue.Text.Trim().Length == 0)
{
MessageDxUtil.ShowWarning(Const.MsgCheckInput + lblValue.Text.Replace(Const.MsgCheckSign, string.Empty));
this.txtValue.Focus();
result = false;
}
if (this.txtName.Text.Trim().Length == 0)
{
MessageDxUtil.ShowWarning(Const.MsgCheckInput + lblName.Text.Replace(Const.MsgCheckSign, string.Empty));
this.txtName.Focus();
result = false;
}
if (this.txtSeq.Text.Trim().Length == 0)
{
MessageDxUtil.ShowWarning(Const.MsgCheckInput + lblSeq.Text.Replace(Const.MsgCheckSign, string.Empty));
this.txtSeq.Focus();
result = false;
}
string Id = txtValue.Text;
if (result)
{
if (!ValidateUtil.IsNumeric(Id))
{
MessageDxUtil.ShowWarning(lblValue.Text.Replace(Const.MsgCheckSign, string.Empty) + Const.MsgErrFormatByNum);
txtValue.Focus();
result = false;
}
}
// 检查对应的值是否已经存在数据库了
if (result && string.IsNullOrEmpty(ID))
{
SearchCondition condition = new SearchCondition();
condition.AddCondition("DictType_ID", Convert.ToInt32(this.txtDictType.Tag), SqlOperator.Equal);
condition.AddCondition("Value", Convert.ToInt32(Id), SqlOperator.Equal);
string where = condition.BuildConditionSql().Replace("Where", "");
var lst = BLLFactory <DictData> .Instance.Find(where);
if (lst.Count > 0)
{
MessageDxUtil.ShowTips(string.Format("已存在此值域数据[字典大类编号:{0},字典值:{1},字典名称:{2}]", lst[0].DictType_ID, lst[0].Value, lst[0].Name));
this.txtValue.Focus();
result = false;
}
}
#endregion
return(result);
}
public override bool CheckInput()
{
bool result = true;//默认是可以通过
#region MyRegion
if (txtID.Text.Trim().Length == 0)
{
MessageDxUtil.ShowWarning(Const.MsgCheckInput + lblID.Text.Replace(Const.MsgCheckSign, string.Empty));
this.txtID.Focus();
result = false;
}
if (txtName.Text.Trim().Length == 0)
{
MessageDxUtil.ShowWarning(Const.MsgCheckInput + lblName.Text.Replace(Const.MsgCheckSign, string.Empty));
txtName.Focus();
result = false;
}
if (txtParent.Text.Trim().Length == 0)
{
MessageDxUtil.ShowWarning(Const.MsgCheckInput + lblParent.Text.Replace(Const.MsgCheckSign, string.Empty));
txtParent.Focus();
result = false;
}
string Id = txtID.Text;
if (result)
{
if (!ValidateUtil.IsNumeric(Id))
{
MessageDxUtil.ShowWarning(txtID.Text.Replace(Const.MsgCheckSign, string.Empty) + Const.MsgErrFormatByNum);
txtID.Focus();
result = false;
}
}
if (result && string.IsNullOrEmpty(ID))
{
Int32 NumId = Convert.ToInt32(Id);
#region 加载数据字典大项
XmlHelper xmldicthelper = new XmlHelper(@"XML\dict.xml");
XmlNodeList xmlNodeLst = xmldicthelper.Read("datatype/dataitem");
for (Int32 i = 0; i < xmlNodeLst.Count; i++)
{
// 将节点转换为元素，便于得到节点的属性值
XmlElement xe = (XmlElement)xmlNodeLst[i];
// 得到DataTypeInfo节点的所有子节点
XmlNodeList xnl0 = xe.ChildNodes;
if (NumId == Convert.ToInt32(xnl0.Item(0).InnerText))
{
MessageDxUtil.ShowTips(string.Format("已存在类别编号[{0}],类别名称[{1}]", NumId, xnl0.Item(2).InnerText));
txtID.Focus();
result = false;
}
if (PID != -1 && Convert.ToInt32(this.txtParent.Tag) >= 1)
{
MessageDxUtil.ShowTips("数据类型只允许2级目录");
txtID.Focus();
result = false;
}
}
#endregion
}
#endregion
return(result);
}
private void BaseButton_ConfirmRefund_Click(object sender, EventArgs e)
{
try
{
if (originalRetailCostume == null)
{
GlobalMessageBox.Show("请选择销售单！");
return;
}
if (!string.IsNullOrEmpty(this.originalRetailCostume.RetailOrder.RefundOrderID))
{
GlobalMessageBox.Show("该销售单号已经退过货，不能再次退货！");
return;
}
if (this.originalRetailCostume.RetailOrder.IsCancel)
{
GlobalMessageBox.Show("该销售单号已被冲单！");
return;
}
if (this.guideComboBox1.SelectedIndex == 0)
{
GlobalMessageBox.Show("该笔单的导购员不能为空！");
return;
}
string id = IDHelper.GetID(OrderPrefix.RefundOrder, GlobalCache.GetShop(shopID).AutoCode);
//if (this.currentRetailCostume.RetailOrder.ShopID != shopID || this.currentRetailCostume.RetailOrder.EmOnline)
//{
// GlobalMessageBox.Show("该商品不是在本店销售的，不能退货！");
// return;
//}
bool isNoHasGuidFlag = false;
if (this.currentRetailCostume.RetailDetailList != null && this.currentRetailCostume.RetailDetailList.Count > 0)
{
foreach (RetailDetail detail in this.currentRetailCostume.RetailDetailList)
{
if (detail.GuideID == null || detail.GuideID == "")
{
isNoHasGuidFlag = true;
break;
}
}
}
if (isNoHasGuidFlag)
{
GlobalMessageBox.Show("导购员不能为空，请检查列表里所有款号的导购员！");
return;
}
#region 创建RefundCostume对象
string selectShopid = ValidateUtil.CheckEmptyValue(this.skinComboBoxShopID.SelectedValue);
List <Guide> guideList = CommonGlobalCache.GuideList.FindAll(t => t.State == 0 && t.ShopID == selectShopid);
this.GuideName.DataSource = guideList;
this.GuideName.DisplayMember = "Name";
this.GuideName.ValueMember = "ID";
RefundCostume costume = new RefundCostume()
{
RefundOrder = null,
RefundDetailList = new List <RetailDetail>()
};
int totalCount = 0;
decimal totalPrice = 0;
decimal totalCost = 0;
foreach (RetailDetail detail in this.currentRetailCostume.RetailDetailList)
{
if (detail.IsRefund && detail.RefundCount > 0)
{
totalCount += detail.RefundCount;
totalPrice += detail.RefundCount * detail.Price;
totalCost += detail.RefundCount * detail.CostPrice;
costume.RefundDetailList.Add(this.RetailDetailToRefundDetail(detail, id));
}
}
List <String> costumeIds = new List <string>();
foreach (var item in costume.RefundDetailList)
{
if (!costumeIds.Contains(item.CostumeID))
{
costumeIds.Add(item.CostumeID);
}
}
if (costumeIds != null && costumeIds.Count > 0)
{
//判断是否又禁用的商品，并提示返回
InteractResult interactResult = GlobalCache.ServerProxy.IsCostumeValid(costumeIds);
if (interactResult.ExeResult == ExeResult.Error)
{
GlobalMessageBox.Show(interactResult.Msg);
return;
}
}
RetailOrder refundOrder = new RetailOrder()
{
ID = id,
IsRefundOrder = true,
OriginOrderID = this.currentRetailCostume.RetailOrder.ID,
// GuideID = this.currentRetailCostume.RetailOrder.GuideID,
// OperateGuideID = this.currentRetailCostume.RetailOrder.GuideID,
GuideID = (string)this.guideComboBox1.SelectedValue,
ShopID = shopID,
MemeberID = this.currentRetailCostume.RetailOrder.MemeberID,
SalesPromotionID = this.currentRetailCostume.RetailOrder.SalesPromotionID,
PromotionText = this.currentRetailCostume.RetailOrder.PromotionText,
EntryUserID = CommonGlobalCache.CurrentUserID,
// TotalMoneyReceived = this.currentRetailCostume.RetailOrder.TotalMoneyReceived,
// TotalMoneyReceivedActual = this.currentRetailCostume.RetailOrder.TotalMoneyReceivedActual,
MoneyBankCard = 0,
MoneyWeiXin = 0,
MoneyAlipay = 0,
MoneyOther = 0,
SmallMoneyRemoved = 0,
MoneyChange = 0,
TotalCount = totalCount * -1,
TotalCost = totalCost * -1,
TotalPrice = totalPrice * -1,
MoneyDiscounted = -totalCount == this.originalRetailCostume.RetailOrder.TotalCount ? this.originalRetailCostume.RetailOrder.MoneyDiscounted * -1 : 0,//若是全部退款，折扣金额为原始折扣金额，否则为0
Remarks = this.skinTextBox_RefundReason.SkinTxt.Text.Trim(),
CreateTime = dateTimePicker_Start.Value,
EntryTime = DateTime.Now,
IsNotPay = this.currentRetailCostume.RetailOrder.IsNotPay,
};
costume.RefundOrder = refundOrder;
#endregion
decimal sourceTotalMoneyReceived = this.currentRetailCostume.RetailOrder.TotalMoneyReceived;
#region 根据活动获取退款的金额，并赋值给RefundCostume
decimal originalDonate = 0;
if (this.originalRetailCostume.RetailOrder.MoneyVipCard != 0)
{
originalDonate = this.originalRetailCostume.RetailOrder.MoneyVipCardDonate / this.originalRetailCostume.RetailOrder.MoneyVipCard;
}
//应该退还的金额
decimal moneyBuyByTicket = CalGiftTicket(costume);
SettlementMoney settlementMoney = new SettlementMoney(balanceRound);
RefundMoney refundMoney = settlementMoney.GetRefundMoney(this.originalRetailCostume, costume, moneyBuyByTicket, GlobalCache.GetSalesPromotionFromAll(this.originalRetailCostume.RetailOrder.SalesPromotionID), GlobalCache.CurrentShop.MinDiscount);
costume.RefundOrder.MoneyCash = refundMoney.RefundCash * -1;
costume.RefundOrder.MoneyCash2 = costume.RefundOrder.MoneyCash;
costume.RefundOrder.MoneyIntegration = refundMoney.RefundIntegration * -1;
costume.RefundOrder.MoneyVipCard = refundMoney.RefundStoredCard * -1;
costume.RefundOrder.MoneyVipCardMain = refundMoney.RefundStoredCard * (1 - originalDonate) * -1;
costume.RefundOrder.MoneyVipCardDonate = refundMoney.RefundStoredCard * originalDonate * -1;
//costume.RefundOrder.MoneyBuyByTicket = moneyBuyByTicket;
costume.RefundOrder.RetailMoneyDeductedByTicket = originalRetailCostume.RetailOrder.MoneyDeductedByTicket;
costume.RefundOrder.MoneyDeductedByTicket = moneyBuyByTicket;
//总计=现金+积分+VIP卡+优惠券
//这笔单的应收金额 - （不退的那几件以原价* 数量 -满减金额） - （退的那几件）优惠券
costume.RefundOrder.TotalMoneyReceived = costume.RefundOrder.MoneyCash + costume.RefundOrder.MoneyIntegration + costume.RefundOrder.MoneyVipCard;
costume.RefundOrder.TotalMoneyReceivedActual = costume.RefundOrder.MoneyCash + costume.RefundOrder.MoneyVipCardMain;
costume.RefundOrder.Benefit = costume.RefundOrder.TotalMoneyReceivedActual - costume.RefundOrder.TotalCost;
////平摊
#endregion
if (Math.Abs(costume.RefundOrder.TotalCount) < 1)
{
GlobalMessageBox.Show("退货数量不能小于1");
return;
}
//foreach (RetailDetail detail in costume.RefundDetailList)
//{
// if (detail.IsRefund && detail.RefundCount > 0)
// {
// detail.SinglePrice = detail.SumMoney / detail.BuyCount * -1;
// }
//}
ConfirmRefundForm confirmRefundForm = new ConfirmRefundForm(costume, shopID, this.dataGridView1, sourceTotalMoneyReceived, 1);
DialogResult result = confirmRefundForm.ShowDialog();
if (result == DialogResult.Cancel)
{
return;
}
this.ResetForm();
}
catch (Exception ee)
{
GlobalUtil.ShowError(ee);
}
}
private string IntToErrInfo(string strerridx)
{
string result = string.Empty;
if (string.IsNullOrEmpty(strerridx))
{
return(result);
}
if (!ValidateUtil.IsNumeric(strerridx))
{
return(result);
}
Int32 erridx = Convert.ToInt32(strerridx);
// 1 - LOG_LEVEL_EMERG
// 2 - LOG_LEVEL_ALERT
// 3 - LOG_LEVEL_CRIT
// 4 - LOG_LEVEL_ERR
// 5 - LOG_LEVEL_WARN
// 6 - LOG_LEVEL_NOTICE
// 7 - LOG_LEVEL_INFO
// 8 - LOG_LEVEL_DEBUG
// 9 - LOG_LEVEL_SQL
switch (erridx)
{
case 1:
result = "LOG_LEVEL_EMERG";
break;
case 2:
result = "LOG_LEVEL_ALERT";
break;
case 3:
result = "LOG_LEVEL_CRIT";
break;
case 4:
result = "LOG_LEVEL_ERR";
break;
case 5:
result = "LOG_LEVEL_WARN";
break;
case 6:
result = "LOG_LEVEL_NOTICE";
break;
case 7:
result = "LOG_LEVEL_INFO";
break;
case 8:
result = "LOG_LEVEL_DEBUG";
break;
case 9:
result = "LOG_LEVEL_SQL";
break;
}
return(result);
}
private void skinComboBox_PfCustomer_SelectedIndexChanged(object sender, EventArgs e)
{
PfCustomeID = ValidateUtil.CheckEmptyValue(skinComboBox_PfCustomer.SelectedValue);
// this.BaseButton_Search_Click(null, null);
}
private int SendMobile(string url, out string returnMsg)
{
int result = 0;
returnMsg = string.Empty;
string webResponse = string.Empty;
webResponse = DotNet.Business.Utilities.GetResponse(url);
if (!string.IsNullOrEmpty(webResponse))
{
if (ValidateUtil.IsInt(webResponse))
{
result = int.Parse(webResponse);
}
}
/*
* bool flag = false;
* returnMsg = "未知错误";
* switch (webResponse)
* {
* case "1":
* case "Success":
* flag = true;
* returnMsg = "提交短信成功";
* return flag;
* case "0":
* returnMsg = "失败";
* return flag;
* case "-1":
* returnMsg = "用户名或者密码不正确";
* return flag;
* case "2":
* returnMsg = "余额不够";
* return flag;
* case "3":
* returnMsg = "黑词审核中";
* return flag;
* case "4":
* returnMsg = "出现异常，人工处理中";
* return flag;
* case "5":
* returnMsg = "提交频率太快";
* return flag;
* case "6":
* returnMsg = "有效号码为空";
* return flag;
* case "7":
* returnMsg = "短信内容为空";
* return flag;
* case "8":
* returnMsg = "一级黑词";
* return flag;
* case "9":
* returnMsg = "没有url提交权限";
* return flag;
* case "10":
* returnMsg = "发送号码过多";
* return flag;
* case "11":
* returnMsg = "产品ID异常";
* return flag;
* }
*/
return(result);
}
/// <summary>
/// 导入K8系统网点信息
/// </summary>
/// <param name="connectionString">数据库连接</param>
/// <param name="conditional">条件，不需要同步所有的数据</param>
/// <returns>影响行数</returns>
public int Synchronous(string connectionString = null, string conditional = null)
{
// delete from baseorganize where id < 1000000
int result = 0;
if (string.IsNullOrEmpty(connectionString))
{
connectionString = ConfigurationHelper.AppSettings("K8Connection", BaseSystemInfo.EncryptDbConnection);
}
if (!string.IsNullOrEmpty(connectionString))
{
// 01：可以从k8里读取公司、用户、密码的。
IDbHelper dbHelper = DbHelperFactory.GetHelper(CurrentDbType.Oracle, connectionString);
BaseOrganizeManager organizeManager = new Business.BaseOrganizeManager(this.DbHelper, this.UserInfo);
// 不不存在的组织机构删除掉TAB_SITE是远程试图
string commandText = string.Empty;
if (string.IsNullOrWhiteSpace(conditional))
{
commandText = "DELETE FROM BASEORGANIZE WHERE id <= 10000 AND id NOT IN (SELECT id FROM TAB_SITE WHERE id <= 10000)";
organizeManager.DbHelper.ExecuteNonQuery(commandText);
System.Console.WriteLine(commandText);
commandText = "DELETE FROM BASEORGANIZE WHERE id > 10000 AND id <= 20000 AND id NOT IN (SELECT id FROM TAB_SITE WHERE id > 10000 AND id <= 20000)";
organizeManager.DbHelper.ExecuteNonQuery(commandText);
System.Console.WriteLine(commandText);
commandText = "DELETE FROM BASEORGANIZE WHERE id > 20000 AND id <= 30000 AND id NOT IN (SELECT id FROM TAB_SITE WHERE id > 20000 AND id <= 30000)";
organizeManager.DbHelper.ExecuteNonQuery(commandText);
System.Console.WriteLine(commandText);
commandText = "DELETE FROM BASEORGANIZE WHERE id > 30000 AND id <= 40000 AND id NOT IN (SELECT id FROM TAB_SITE WHERE id > 30000 AND id <= 40000)";
organizeManager.DbHelper.ExecuteNonQuery(commandText);
System.Console.WriteLine(commandText);
commandText = "DELETE FROM BASEORGANIZE WHERE id > 40000 AND id <= 50000 AND id NOT IN (SELECT id FROM TAB_SITE WHERE id > 40000 AND id <= 50000)";
organizeManager.DbHelper.ExecuteNonQuery(commandText);
System.Console.WriteLine(commandText);
commandText = "DELETE FROM BASEORGANIZE WHERE id > 50000 AND id <= 60000 AND id NOT IN (SELECT id FROM TAB_SITE WHERE id > 50000 AND id <= 60000)";
organizeManager.DbHelper.ExecuteNonQuery(commandText);
System.Console.WriteLine(commandText);
commandText = "DELETE FROM BASEORGANIZE WHERE id > 60000 AND id <= 70000 AND id NOT IN (SELECT id FROM TAB_SITE WHERE id > 60000 AND id <= 70000)";
organizeManager.DbHelper.ExecuteNonQuery(commandText);
System.Console.WriteLine(commandText);
commandText = "DELETE FROM BASEORGANIZE WHERE id > 70000 AND id <= 80000 AND id NOT IN (SELECT id FROM TAB_SITE WHERE id > 70000 AND id <= 80000)";
organizeManager.DbHelper.ExecuteNonQuery(commandText);
System.Console.WriteLine(commandText);
commandText = "DELETE FROM BASEORGANIZE WHERE id > 80000 AND id <= 90000 AND id NOT IN (SELECT id FROM TAB_SITE WHERE id > 80000 AND id <= 90000)";
organizeManager.DbHelper.ExecuteNonQuery(commandText);
System.Console.WriteLine(commandText);
commandText = "DELETE FROM BASEORGANIZE WHERE id > 90000 AND id <= 100000 AND id NOT IN (SELECT id FROM TAB_SITE WHERE id > 90000 AND id <= 100000)";
organizeManager.DbHelper.ExecuteNonQuery(commandText);
System.Console.WriteLine(commandText);
commandText = "DELETE FROM BASEORGANIZE WHERE id > 100000 AND id <= 1000000 AND id NOT IN (SELECT id FROM TAB_SITE WHERE id > 100000 AND id <= 1000000)";
organizeManager.DbHelper.ExecuteNonQuery(commandText);
System.Console.WriteLine(commandText);
}
/*
* string commandText = "SELECT Id FROM BASEORGANIZE WHERE id < 1000000";
* using (IDataReader dataReader = organizeManager.DbHelper.ExecuteReader(commandText))
* {
* while (dataReader.Read())
* {
* string id = dataReader["id"].ToString();
* commandText = "SELECT COUNT(1) AS Rcount FROM TAB_SITE WHERE id='" + id + "'";
* object rcount = dbHelper.ExecuteScalar(commandText);
* if (rcount == null || rcount.ToString().Equals("0"))
* {
* commandText = "DELETE FROM BASEORGANIZE WHERE id ='" + id + "'";
* organizeManager.DbHelper.ExecuteNonQuery(commandText);
* }
* }
* }
*/
// 同步数据
// commandText = "SELECT * FROM TAB_SITE WHERE (BL_NOT_INPUT IS NULL OR BL_NOT_INPUT = 0) ";
commandText = "SELECT * FROM TAB_SITE WHERE 1=1 ";
if (!string.IsNullOrEmpty(conditional))
{
commandText += conditional;
}
commandText += " ORDER BY ID DESC";
using (IDataReader dr = DbHelper.ExecuteReader(commandText))
{
System.Console.WriteLine(commandText);
while (dr.Read())
{
// 这里需要从数据库读取、否则容易造成丢失数据
BaseOrganizeEntity entity = organizeManager.GetObject(dr["ID"].ToString());
if (entity == null)
{
entity = new BaseOrganizeEntity();
entity.Id = int.Parse(dr["ID"].ToString());
}
entity.Code = dr["SITE_CODE"].ToString();
if (string.IsNullOrEmpty(entity.ParentName) || !entity.ParentName.Equals(dr["SUPERIOR_SITE"].ToString()))
{
entity.ParentName = dr["SUPERIOR_SITE"].ToString();
entity.ParentId = null;
}
entity.FullName = dr["SITE_NAME"].ToString();
entity.ShortName = dr["SITE_NAME"].ToString();
entity.CategoryCode = dr["TYPE"].ToString();
entity.OuterPhone = dr["PHONE"].ToString();
entity.Fax = dr["FAX"].ToString();
entity.Province = dr["PROVINCE"].ToString();
entity.City = dr["CITY"].ToString();
entity.District = dr["RANGE_NAME"].ToString();
entity.FinancialCenter = dr["SUPERIOR_FINANCE_CENTER"].ToString();
entity.Area = dr["AREA_NAME"].ToString();
entity.CostCenter = dr["SUPERIOR_TWO_FINANCE_CENTER"].ToString();
entity.Manager = dr["PRINCIPAL"].ToString();
entity.Master = dr["MANAGER"].ToString();
entity.BusinessPhone = dr["SALE_PHONE"].ToString();
entity.Description = dr["SITE_DESC"].ToString();
entity.MasterMobile = dr["MANAGER_PHONE"].ToString();
entity.EmergencyCall = dr["EXIGENCE_PHONE"].ToString();
entity.BankAccount = dr["FINANCIAL_ACCOUNT"].ToString();
entity.Street = dr["COUNTY_NAME"].ToString();
int weightRatio = 0;
int.TryParse(dr["THROW_RATE"].ToString(), out weightRatio);
entity.WeightRatio = weightRatio;
entity.CompanyName = dr["SITE1_NAME"].ToString();
entity.JoiningMethods = dr["NC_TYPE"].ToString();
int sendAir = 0;
if (!string.IsNullOrEmpty(dr["BL_AIR"].ToString()) && ValidateUtil.IsInt(dr["BL_AIR"].ToString()))
{
sendAir = int.Parse(dr["BL_AIR"].ToString());
}
entity.SendAir = sendAir;
entity.LevelTwoTransferCenter = dr["TWO_BALANCE_CENTER"].ToString();
Decimal billSubsidy = 0;
if (!string.IsNullOrEmpty(dr["CENTER_DISPATCH_FEE"].ToString()) && ValidateUtil.IsDouble(dr["CENTER_DISPATCH_FEE"].ToString()))
{
billSubsidy = Decimal.Parse(dr["CENTER_DISPATCH_FEE"].ToString());
}
entity.BillSubsidy = billSubsidy;
Decimal sendFee = 0;
if (!string.IsNullOrEmpty(dr["DISP_FEE"].ToString()) && ValidateUtil.IsDouble(dr["DISP_FEE"].ToString()))
{
sendFee = Decimal.Parse(dr["DISP_FEE"].ToString());
}
entity.SendFee = sendFee;
Decimal levelTwoTransferFee = 0;
if (!string.IsNullOrEmpty(dr["TRANSFER_FEE"].ToString()) && ValidateUtil.IsDouble(dr["TRANSFER_FEE"].ToString()))
{
levelTwoTransferFee = Decimal.Parse(dr["TRANSFER_FEE"].ToString());
}
entity.LevelTwoTransferFee = levelTwoTransferFee;
entity.BigArea = dr["BIG_AREA_NAME"].ToString();
entity.StatisticalName = dr["REC_CENTER"].ToString();
entity.BillBalanceSite = dr["TRANSFER_CENTER"].ToString();
entity.ProvinceSite = dr["PROV_SITE"].ToString();
int calculateComeFee = 0;
if (!string.IsNullOrEmpty(dr["BL_WEB"].ToString()) && ValidateUtil.IsInt(dr["BL_WEB"].ToString()))
{
calculateComeFee = int.Parse(dr["BL_WEB"].ToString());
}
entity.CalculateComeFee = calculateComeFee;
int calculateReceiveFee = 0;
if (!string.IsNullOrEmpty(dr["TB_SER_WW"].ToString()) && ValidateUtil.IsInt(dr["TB_SER_WW"].ToString()))
{
calculateReceiveFee = int.Parse(dr["TB_SER_WW"].ToString());
}
entity.CalculateReceiveFee = calculateReceiveFee;;
if (!string.IsNullOrEmpty(dr["BL_NOT_INPUT"].ToString()) && dr["BL_NOT_INPUT"].ToString().Equals("1"))
{
entity.Enabled = 0;
}
else
{
entity.Enabled = 1;
}
if (!string.IsNullOrEmpty(dr["ORDER_BY"].ToString()))
{
entity.SortCode = int.Parse(dr["ORDER_BY"].ToString());
}
// 02：可以把读取到的数据能写入到用户中心的。
System.Console.WriteLine("同步：" + entity.FullName + " " + entity.Id.ToString() + "...");
result = organizeManager.UpdateObject(entity);
if (result == 0)
{
organizeManager.AddObject(entity);
}
//更新网点基础资料扩展表
BaseOrganizeExpressManager organizeExpressManager = new Business.BaseOrganizeExpressManager(this.DbHelper, this.UserInfo);
BaseOrganizeExpressEntity organizeExpressEntity = organizeExpressManager.GetObject(dr["ID"].ToString());
if (organizeExpressEntity == null)
{
organizeExpressEntity = new BaseOrganizeExpressEntity();
organizeExpressEntity.Id = int.Parse(dr["ID"].ToString());
}
organizeExpressEntity.Currency = dr["DEFAULT_CURRENCY"].ToString();
organizeExpressEntity.DefaultSendPlace = dr["DEFAULT_SEND_PLACE"].ToString();
int allow_ToPayment = 0;
if (!string.IsNullOrEmpty(dr["BL_ALLOW_TOPAYMENT"].ToString()) && ValidateUtil.IsInt(dr["BL_ALLOW_TOPAYMENT"].ToString()))
{
allow_ToPayment = int.Parse(dr["BL_ALLOW_TOPAYMENT"].ToString());
}
organizeExpressEntity.AllowToPayment = allow_ToPayment;
organizeExpressEntity.DispatchRange = dr["DISPATCH_RANGE"].ToString();
organizeExpressEntity.NotDispatchRange = dr["NOT_DISPATCH_RANGE"].ToString();
organizeExpressEntity.DispatchTimeLimit = dr["DISPATCH_TIME_LIMIT"].ToString();
int allowAgentMoney = 0;
if (!string.IsNullOrEmpty(dr["BL_ALLOW_AGENT_MONEY"].ToString()) && ValidateUtil.IsInt(dr["BL_ALLOW_AGENT_MONEY"].ToString()))
{
allowAgentMoney = int.Parse(dr["BL_ALLOW_AGENT_MONEY"].ToString());
}
organizeExpressEntity.AllowAgentMoney = allowAgentMoney;
organizeExpressEntity.PublicRemark = dr["PUBLIC_REMARK"].ToString();
organizeExpressEntity.PrivateRemark = dr["PRIVATE_REMARK"].ToString();
organizeExpressEntity.DispatchMoneyDesc = dr["DISPATCH_MONEY_DESC"].ToString();
int scanSelect = 0;
if (!string.IsNullOrEmpty(dr["BL_CALC_SITE"].ToString()) && ValidateUtil.IsInt(dr["BL_CALC_SITE"].ToString()))
{
scanSelect = int.Parse(dr["BL_CALC_SITE"].ToString());
}
organizeExpressEntity.ScanSelect = scanSelect;
Decimal dispatchRangeFee = 0;
if (!string.IsNullOrEmpty(dr["DISP_FEE1"].ToString()) && ValidateUtil.IsDouble(dr["DISP_FEE1"].ToString()))
{
dispatchRangeFee = Decimal.Parse(dr["DISP_FEE1"].ToString());
}
organizeExpressEntity.DispatchRangeFee = dispatchRangeFee;
Decimal dispatchOutRangeFee = 0;
if (!string.IsNullOrEmpty(dr["DISP_FEE2"].ToString()) && ValidateUtil.IsDouble(dr["DISP_FEE2"].ToString()))
{
dispatchOutRangeFee = Decimal.Parse(dr["DISP_FEE2"].ToString());
}
organizeExpressEntity.DispatchOutRangeFee = dispatchOutRangeFee;
Decimal agentMoneyLimited = 0;
if (!string.IsNullOrEmpty(dr["GOODS_PAYMENT_LIMITED"].ToString()) && ValidateUtil.IsDouble(dr["GOODS_PAYMENT_LIMITED"].ToString()))
{
agentMoneyLimited = Decimal.Parse(dr["GOODS_PAYMENT_LIMITED"].ToString());
}
organizeExpressEntity.AgentMoneyLimited = agentMoneyLimited;
Decimal sitePrior = 0;
if (!string.IsNullOrEmpty(dr["SITE_PRIOR"].ToString()) && ValidateUtil.IsDouble(dr["SITE_PRIOR"].ToString()))
{
sitePrior = Decimal.Parse(dr["SITE_PRIOR"].ToString());
}
organizeExpressEntity.SitePrior = sitePrior;
// 02001：可以把读取到的数据能写入到用户中心的网点基础资料扩展表。
System.Console.WriteLine("同步网点基础资料扩展表：" + entity.FullName + " " + entity.Id.ToString() + "...");
result = organizeExpressManager.Update(organizeExpressEntity);
if (result == 0)
{
organizeExpressManager.Add(organizeExpressEntity);
}
//更新省市县
//更新省份ID
commandText = @"UPDATE baseorganize SET provinceId = (SELECT Code FROM basearea t WHERE t.shortname = baseorganize.province) WHERE id = '" + entity.Id + "' ";
this.DbHelper.ExecuteNonQuery(commandText);
System.Console.WriteLine(commandText);
//更新城市ID，由于城市可能出现重复的情况，所以需要选择当前省份的城市
commandText = @"UPDATE baseorganize SET cityId = (SELECT Code FROM basearea t WHERE t.fullname = baseorganize.city and t.parentid = baseorganize.provinceid) WHERE id = '" + entity.Id + "' ";
this.DbHelper.ExecuteNonQuery(commandText);
System.Console.WriteLine(commandText);
//更新区县ID，由于区县可能出现重复的情况，所以需要选择当前城市的区县
commandText = @"UPDATE baseorganize SET districtId = (SELECT Code FROM basearea t WHERE t.fullname = baseorganize.district and t.parentid = baseorganize.cityid) WHERE id = '" + entity.Id + "' ";
this.DbHelper.ExecuteNonQuery(commandText);
System.Console.WriteLine(commandText);
//更新乡镇ID，由于乡镇可能出现重复的情况，所以需要选择当前区县的乡镇
commandText = @"UPDATE baseorganize SET streetid = (SELECT Code FROM basearea t WHERE t.fullname = baseorganize.street and t.parentid = baseorganize.districtId) WHERE id = '" + entity.Id + "' ";
this.DbHelper.ExecuteNonQuery(commandText);
System.Console.WriteLine(commandText);
commandText = @"UPDATE baseorganize SET parentId = (SELECT Id FROM baseorganize t WHERE t.fullname = baseorganize.parentname AND t.deletionstatecode = 0) WHERE id = '" + entity.Id + "' "; // AND t.enabled = 1 WHERE parentId IS NULL
this.DbHelper.ExecuteNonQuery(commandText);
System.Console.WriteLine(commandText);
commandText = @"UPDATE baseorganize SET CompanyId = (SELECT Id FROM baseorganize t WHERE t.fullname = baseorganize.CompanyName AND t.deletionstatecode = 0) WHERE CompanyId IS NULL "; // AND t.enabled = 1 id = '" + entity.Id + "' ";
this.DbHelper.ExecuteNonQuery(commandText);
System.Console.WriteLine(commandText);
commandText = @"UPDATE baseorganize SET CompanyCode = (SELECT Code FROM baseorganize t WHERE t.fullname = baseorganize.CompanyName AND t.deletionstatecode = 0) WHERE CompanyCode IS NULL "; // AND t.enabled = 1WHERE id = '" + entity.Id + "'
this.DbHelper.ExecuteNonQuery(commandText);
System.Console.WriteLine(commandText);
}
dr.Close();
System.Console.WriteLine("完整同步网点表...");
}
if (string.IsNullOrWhiteSpace(conditional))
{
// 填充 parentname
// select * from baseorganize where parentname is null
commandText = @"UPDATE baseorganize SET parentname = (SELECT fullname FROM baseorganize t WHERE t.id = baseorganize.parentId) WHERE parentname IS NULL AND id < 1000000";
this.DbHelper.ExecuteNonQuery(commandText);
System.Console.WriteLine(commandText);
// 填充 parentId
// select * from baseorganize where parentId is null
commandText = @"UPDATE baseorganize SET parentId = (SELECT Id FROM baseorganize t WHERE t.fullname = baseorganize.parentname AND t.fullname = baseorganize.parentname AND t.deletionstatecode = 0 AND t.enabled = 1 AND t.id < 1000000)"; // WHERE parentId IS NULL
// 100000 以下是基础数据的，100000 以上是通用权限管理系统的
// UPDATE baseorganize SET parentId = (SELECT Id FROM baseorganize t WHERE t.fullname = baseorganize.parentname) WHERE parentId < 100000
this.DbHelper.ExecuteNonQuery(commandText);
System.Console.WriteLine(commandText);
commandText = @"UPDATE baseorganize SET CompanyId = (SELECT Id FROM baseorganize t WHERE t.fullname = baseorganize.CompanyName AND t.deletionstatecode = 0 AND t.enabled = 1 AND t.id < 1000000)"; // WHERE CompanyId IS NULL
this.DbHelper.ExecuteNonQuery(commandText);
System.Console.WriteLine(commandText);
commandText = @"UPDATE baseorganize SET CompanyCode = (SELECT Code FROM baseorganize t WHERE t.fullname = baseorganize.CompanyName AND t.deletionstatecode = 0 AND t.enabled = 1 AND t.id < 1000000) "; // WHERE CompanyCode IS NULL
this.DbHelper.ExecuteNonQuery(commandText);
System.Console.WriteLine(commandText);
// 更新错误数据
commandText = @"UPDATE baseorganize SET parentId = null WHERE id = parentId";
this.DbHelper.ExecuteNonQuery(commandText);
System.Console.WriteLine(commandText);
// 设置员工的公司主键
commandText = @"UPDATE " + BaseUserEntity.TableName + " SET CompanyId = (SELECT MAX(Id) FROM baseorganize WHERE baseorganize.fullname = " + BaseUserEntity.TableName + ".companyname AND baseorganize.Id < 1000000) WHERE companyId IS NULL OR companyId = '' AND id < 1000000";
this.DbHelper.ExecuteNonQuery(commandText);
System.Console.WriteLine(commandText);
commandText = @"update baseorganize set baseorganize.city = (select basearea.fullname from basearea where basearea.id = baseorganize.cityid) WHERE cityid IS NOT NULL AND id < 1000000";
this.DbHelper.ExecuteNonQuery(commandText);
System.Console.WriteLine(commandText);
commandText = @"update baseorganize set baseorganize.district = (select basearea.fullname from basearea where basearea.id = baseorganize.districtid) WHERE districtid IS NOT NULL AND id < 1000000";
this.DbHelper.ExecuteNonQuery(commandText);
System.Console.WriteLine(commandText);
commandText = @"update baseorganize set baseorganize.street = (select basearea.fullname from basearea where basearea.id = baseorganize.streetid) WHERE streetid IS NOT NULL AND id < 1000000";
this.DbHelper.ExecuteNonQuery(commandText);
System.Console.WriteLine(commandText);
}
}
return(result);
}
private void SkinComboBoxShopID_SelectedIndexChanged(object sender, System.EventArgs e)
{
shopID = ValidateUtil.CheckEmptyValue(this.skinComboBoxShopID.SelectedValue);
guideComboBox1.Initialize(Common.GuideComboBoxInitializeType.All, shopID);
}
/// <summary>
/// 验证独特的参数集合，如果不通过则抛出对应异常
/// </summary>
/// <param name="connectionInfo">连接信息</param>
protected override void ValidateOnlyHaveParams(ConnectionInfo connectionInfo)
{
RabbitConnectionInfo rabbitConnectionInfo = connectionInfo as RabbitConnectionInfo;
ValidateUtil.ValidateNullOrEmpty(rabbitConnectionInfo.VirtualPath, "虚拟路径");
}
/// <summary>
/// 获取实体
/// </summary>
/// <param name="id">主键</param>
public BaseOrganizationScopeEntity GetEntity(string id)
{
return(ValidateUtil.IsInt(id) ? GetEntity(id.ToInt()) : null);
}
private void BaseButton_Search_Click(object sender, EventArgs e)
{
try
{
if (CommonGlobalUtil.EngineUnconnectioned(this))
{
return;
}
string orderID = string.IsNullOrEmpty(this.skinTextBox_OrderID.SkinTxt.Text) ? null : this.skinTextBox_OrderID.SkinTxt.Text;
string costumeID = string.IsNullOrEmpty(this.costumeTextBox1.SkinTxt.Text) ? null : this.costumeTextBox1.SkinTxt.Text;
string shopid = ValidateUtil.CheckEmptyValue(this.shopComboBox1.SelectedValue);
AllocateOrderState state = (AllocateOrderState)this.skinComboBox_State.SelectedValue;
AllocateOrderType type = (AllocateOrderType)this.skinComboType.SelectedValue;
string descShopId = ValidateUtil.CheckEmptyValue(this.ShopCmbGet.SelectedValue);
string SourceShopId = ValidateUtil.CheckEmptyValue(this.shopCmbSend.SelectedValue);
// AllocateOrderState boundState=(AllocateOrderState)skinComboBoxBoundState.SelectedValue;
/* if (boundState != AllocateOrderState.All)
* {
* state = boundState;
* }*/
/* pagePara = new AllocateOrderPagePara()
* {
* CostumeID = costumeID,
* AllocateOrderID = orderID,
* AllocateOrderState = state,
* IsOpenDate = this.isOpenDate,
* // SourceShopID = ValidateUtil.CheckEmptyValue(this.skinComboBox_SourceShop.SelectedValue),
* // DestShopID = ValidateUtil.CheckEmptyValue(this.skinComboBox_DestShop.SelectedValue),
*
* StartDate = new CJBasic.Date(this.dateTimePicker_Start.Value),
* EndDate = new CJBasic.Date(this.dateTimePicker_End.Value),
* PageIndex = 0,
* PageSize = this.dataGridViewPagingSumCtrl.PageSize
* };*/
/* if (pagePara.DestShopID == pagePara.SourceShopID)
* {
* ShowError("发货方与收货方不能相同！");
* return;
* }*/
// AllocateOrderPage listPage = null;
// listPage = CommonGlobalCache.ServerProxy.GetAllocateOrderPage(this.pagePara);
pagePara = new GetAllocateOrdersPara()
{
AllocateOrderID = orderID,
AllocateOrderState = state,
CostumeID = costumeID,
EndDate = new CJBasic.Date(this.dateTimePicker_End.Value),
StartDate = new CJBasic.Date(this.dateTimePicker_Start.Value),
ShopID = shopid,
Type = type,
PageIndex = 0,
PageSize = this.dataGridViewPagingSumCtrl.PageSize,
ReceiptState = (ReceiptState)skinCmbReceiptState.SelectedValue,
LockShop = isCheckOnlyCurShop,
DestShopID = descShopId,
SourceShopID = SourceShopId,
Remarks = ValidateUtil.CheckEmptyValue(this.txtRemark.SkinTxt.Text),
};
InteractResult <AllocateOrderPage> allOrderPage = CommonGlobalCache.ServerProxy.GetAllocateOrders(pagePara);
dataGridViewPagingSumCtrl.OrderPara = pagePara;
this.dataGridViewPagingSumCtrl.Initialize(allOrderPage.Data);
this.BindingAllocateOrderSource(allOrderPage.Data);
}
catch (Exception ee)
{
ShowError(ee);
}
finally
{
UnLockPage();
}
}
/// <summary>
/// 获取分页操作的查询条件
/// </summary>
/// <returns></returns>
protected virtual string GetPagerCondition()
{
string where = "";
//增加一个CustomedCondition条件，根据客户这个条件进行查询
string CustomedCondition = Request["CustomedCondition"] ?? "";
if (!string.IsNullOrWhiteSpace(CustomedCondition))
{
where = CustomedCondition;//直接使用条件
}
else
{
#region 根据数据库字段列，对所有可能的参数进行获值，然后构建查询条件
SearchCondition condition = new SearchCondition();
DataTable dt = BLLFactory <FileUpload> .Instance.GetFieldTypeList();
foreach (DataRow dr in dt.Rows)
{
string columnName = dr["ColumnName"].ToString();
string dataType = dr["DataType"].ToString();
//字段增加WHC_前缀字符，避免传递如URL这样的Request关键字冲突
string columnValue = Request["WHC_" + columnName] ?? "";
//对于数值型，如果是显示声明相等的，一般是外键引用，需要特殊处理
bool hasEqualValue = columnValue.StartsWith("=");
if (IsDateTime(dataType))
{
condition.AddDateCondition(columnName, columnValue);
}
else if (IsNumericType(dataType))
{
//如果数据库是数值类型，而传入的值是true或者false,那么代表数据库的参考值为1,0，需要进行转换
bool boolValue = false;
bool isBoolenValue = bool.TryParse(columnValue, out boolValue);
if (isBoolenValue)
{
condition.AddCondition(columnName, boolValue ? 1 : 0, SqlOperator.Equal);
}
else if (hasEqualValue)
{
columnValue = columnValue.Substring(columnValue.IndexOf("=") + 1);
condition.AddCondition(columnName, columnValue, SqlOperator.Equal);
}
else
{
condition.AddNumberCondition(columnName, columnValue);
}
}
else
{
if (ValidateUtil.IsNumeric(columnValue))
{
condition.AddCondition(columnName, columnValue, SqlOperator.Equal);
}
else
{
condition.AddCondition(columnName, columnValue, SqlOperator.Like);
}
}
}
#endregion
where = condition.BuildConditionSql().Replace("Where", "");
}
return(where);
}
/// <summary>
/// 获取实体
/// </summary>
/// <param name="id">主键</param>
public BaseSequenceEntity GetEntity(string id)
{
return(ValidateUtil.IsInt(id) ? GetEntity(id.ToInt()) : null);
}
/// <summary>
/// 文件上传
/// </summary>
/// <param name="FileName">文件名称包含后缀</param>
/// <param name="Filedata">Base64文件 字符串</param>
/// <returns></returns>
public ActionResult UploadifyFile(string FileName, string Filedata)
{
try
{
string virtualPath = string.Empty;
//没有文件上传，直接返回
if (string.IsNullOrEmpty(Filedata))
{
return(Error("文件不能空"));
}
if (!ValidateUtil.IsBase64String(Filedata))
{
return(Error("数据有误，不是Base64字符串"));
}
//获取文件完整文件名(包含绝对路径)
//文件存放路径格式：/Resource/ResourceFile/{userId}{data}/{guid}.{后缀名}
string FilePath = Config.GetValue("FilePath");
string userId = OperatorProvider.Provider.Current().LoginInfo.UserId;
string fileGuid = Guid.NewGuid().ToString();
string FileEextension = Path.GetExtension(FileName);
string uploadDate = DateTime.Now.ToString("yyyyMMdd");
string userPath = string.Format("{0}/{1}/{2}{3}", userId, uploadDate, fileGuid, FileEextension);
virtualPath = FilePath + userPath;
string fullFileName = this.Server.MapPath(virtualPath);
//创建文件夹
string path = Path.GetDirectoryName(fullFileName);
Directory.CreateDirectory(path);
if (!System.IO.File.Exists(fullFileName))
{
byte[] bytes = Convert.FromBase64String(Filedata);
for (int i = 0; i < bytes.Length; i++)
{
if (bytes[i] < 0)
{
bytes[i] = (byte)(bytes[i] + 256);
}
}
FileStream fs = new FileStream(fullFileName, FileMode.Create, FileAccess.Write);
fs.Write(bytes, 0, bytes.Length);
fs.Flush();
fs.Close();
}
#region 到文件服务器
try
{
FtpClient ftpClient = new FtpClient(Config.GetValue("ImgFtpUrl"), FilePath,
Config.GetValue("ImgFtpUserName"), Config.GetValue("ImgFtpPassword"));
//查看文件是否存在
if (!ftpClient.DirectoryExist(userId))
{
ftpClient.MakeDir(userId);
}
ftpClient.GotoDirectory(userId, false);
//查看文件是否存在
if (!ftpClient.DirectoryExist(uploadDate))
{
ftpClient.MakeDir(uploadDate);
}
ftpClient.GotoDirectory(uploadDate, false);
ftpClient.Upload(fullFileName);
System.IO.File.Delete(fullFileName);
}
catch (Exception e)
{
}
#endregion
return(Success(virtualPath));
}
catch (Exception ex)
{
return(Error(ex.Message));
}
}
private void skinComboBoxShopID_SelectedIndexChanged(object sender, EventArgs e)
{
shopID = ValidateUtil.CheckEmptyValue(this.skinComboBoxShopID.SelectedValue);
}
public override bool CheckInput()
{
bool result = true;//默认是可以通过
#region MyRegion
if (txtID.Text.Trim().Length == 0)
{
MessageDxUtil.ShowWarning(Const.MsgCheckInput + lblID.Text.Replace(Const.MsgCheckSign, string.Empty));
this.txtID.Focus();
result = false;
}
if (txtName.Text.Trim().Length == 0)
{
MessageDxUtil.ShowWarning(Const.MsgCheckInput + lblName.Text.Replace(Const.MsgCheckSign, string.Empty));
txtName.Focus();
result = false;
}
if (txtSeq.Text.Trim().Length == 0)
{
MessageDxUtil.ShowWarning(Const.MsgCheckInput + lblSeq.Text.Replace(Const.MsgCheckSign, string.Empty));
txtSeq.Focus();
result = false;
}
if (txtParent.Text.Trim().Length == 0)
{
MessageDxUtil.ShowWarning(Const.MsgCheckInput + lblParent.Text.Replace(Const.MsgCheckSign, string.Empty));
txtParent.Focus();
result = false;
}
string strId = txtID.Text;
if (result)
{
if (!ValidateUtil.IsNumeric(strId))
{
MessageDxUtil.ShowWarning(txtID.Text.Replace(Const.MsgCheckSign, string.Empty) + Const.MsgErrFormatByNum);
txtID.Focus();
result = false;
}
}
Int32 Id = Convert.ToInt32(strId);
if (result && Id == 0)
{
DictTypeInfo dictTypeInfo = BLLFactory <DictType> .Instance.FindById(Id);
if (dictTypeInfo != null)
{
MessageDxUtil.ShowTips(string.Format("已存在类别编号[{0}],类别名称[{1}]", dictTypeInfo.Id, dictTypeInfo.Name));
txtID.Focus();
result = false;
}
}
#endregion
return(result);
}
/// <summary>
/// 获取实体
/// </summary>
/// <param name="id">主键</param>
public BaseMessageFailedEntity GetEntity(string id)
{
return(ValidateUtil.IsInt(id) ? GetEntity(id.ToInt()) : null);
}
private void UpdateNewStore()
{
//还原所有颜色
foreach (DataGridViewRow item in dataGridView2.Rows)
{
SetNormalCellStyle(item);
}
//如果是同颜色同尺码，则不变
bool isTheSame = skinComboBox_Color.SelectedValue.ToString().Equals(skinComboBox_Color1.SelectedValue.ToString()) && skinComboBox_Size.SelectedValue.ToString().Equals(skinComboBox_Size1.SelectedValue.ToString());
//CommonGlobalUtil.Debug("isTheSame" + isTheSame);
if (isTheSame)
{
return;
}
//获取下调信息
CostumeStore orgStore = orgStores.Find(t => t.ColorName == ValidateUtil.CheckEmptyValue(skinComboBox_Color.SelectedValue));
CostumeStore store = newStores.Find(t => t.ColorName == ValidateUtil.CheckEmptyValue(skinComboBox_Color.SelectedValue));
DataGridViewColumn col = null;
switch (CostumeStoreHelper.GetCostumeSize(skinComboBox_Size.SelectedValue.ToString(), CommonGlobalCache.DefaultSizeGroup))
{
case CostumeSize.XS:
col = xSDataGridViewTextBoxColumn;
break;
case CostumeSize.S:
col = sDataGridViewTextBoxColumn;
break;
case CostumeSize.M:
col = mDataGridViewTextBoxColumn;
break;
case CostumeSize.L:
col = lDataGridViewTextBoxColumn;
break;
case CostumeSize.XL:
col = xLDataGridViewTextBoxColumn;
break;
case CostumeSize.XL2:
col = xL2DataGridViewTextBoxColumn;
break;
case CostumeSize.XL3:
col = xL3DataGridViewTextBoxColumn;
break;
case CostumeSize.XL4:
col = xL4DataGridViewTextBoxColumn;
break;
case CostumeSize.XL5:
col = xL5DataGridViewTextBoxColumn;
break;
case CostumeSize.XL6:
col = xL6DataGridViewTextBoxColumn;
break;
case CostumeSize.F:
col = fDataGridViewTextBoxColumn;
break;
default:
break;
}
//直接改界面值
DataGridViewColumn col2 = null;
switch (CostumeStoreHelper.GetCostumeSize(skinComboBox_Size1.SelectedValue.ToString(), CommonGlobalCache.DefaultSizeGroup))
{
case CostumeSize.XS:
col2 = xSDataGridViewTextBoxColumn2;
break;
case CostumeSize.S:
col2 = sDataGridViewTextBoxColumn2;
break;
case CostumeSize.M:
col2 = mDataGridViewTextBoxColumn2;
break;
case CostumeSize.L:
col2 = lDataGridViewTextBoxColumn2;
break;
case CostumeSize.XL:
col2 = xLDataGridViewTextBoxColumn2;
break;
case CostumeSize.XL2:
col2 = xL2DataGridViewTextBoxColumn2;
break;
case CostumeSize.XL3:
col2 = xL3DataGridViewTextBoxColumn2;
break;
case CostumeSize.XL4:
col2 = xL4DataGridViewTextBoxColumn2;
break;
case CostumeSize.XL5:
col2 = xL5DataGridViewTextBoxColumn2;
break;
case CostumeSize.XL6:
col2 = xL6DataGridViewTextBoxColumn2;
break;
case CostumeSize.F:
col2 = fDataGridViewTextBoxColumn2;
break;
default:
break;
}
//one row
for (int i = 0; i < dataGridView1.Rows.Count; i++)
{
// CommonGlobalUtil.Debug(""+dataGridView1.Rows.Count);
DataGridViewRow orgRow = dataGridView1.Rows[i];
DataGridViewRow row = dataGridView2.Rows[i];
CostumeStore newStore = (CostumeStore)row.DataBoundItem;
// CommonGlobalUtil.Debug("skinComboBox_Color.SelectedValue" + skinComboBox_Color.SelectedValue);
if (newStore.ColorName != ValidateUtil.CheckEmptyValue(skinComboBox_Color.SelectedValue))
{
continue;
}
// CommonGlobalUtil.Debug("col.Index:" + col.Index);
row.Cells[col.Index].Value = (int.Parse(orgRow.Cells[col.Index].Value.ToString()) - int.Parse(skinTextBox_MoneyCash.Text)).ToString();
SetAlertCellStyle(row.Cells[col.Index]);
}
//value 必须是通string类型
//获取上调信息
for (int i = 0; i < dataGridView1.Rows.Count; i++)
{
DataGridViewRow orgRow = dataGridView1.Rows[i];
DataGridViewRow row = dataGridView2.Rows[i];
CostumeStore newStore = (CostumeStore)row.DataBoundItem;
// CommonGlobalUtil.Debug("skinComboBox_Color1.SelectedValue" + skinComboBox_Color1.SelectedValue);
if (newStore.ColorName != ValidateUtil.CheckEmptyValue(skinComboBox_Color1.SelectedValue))
{
continue;
}
// CommonGlobalUtil.Debug("col.Index1:" + col2.Index);
row.Cells[col2.Index].Value = (int.Parse(orgRow.Cells[col2.Index].Value.ToString()) + int.Parse(skinTextBox_MoneyCash1.Text)).ToString();
SetAlertCellStyle(row.Cells[col2.Index]);
}
}
private void DownloadOrViewFile(string id, string name)
{
try
{
FileUploadInfo fileInfo = BLLFactory <FileUpload> .Instance.Download(id);
if (fileInfo != null && fileInfo.FileData != null)
{
string extension = fileInfo.FileExtend.ToLower();
bool isImage = ValidateUtil.IsImageFile(extension);
if (isImage)
{
FrmPicturePreview frm = new FrmPicturePreview();
System.Drawing.Bitmap bitmap = ImageHelper.BitmapFromBytes(fileInfo.FileData);
frm.ImageObj = bitmap;
frm.ShowDialog();
}
else
{
if (extension.Contains(".pdf"))
{
FrmPDFView dlg = new FrmPDFView();
dlg.Extension = extension;
dlg.Stream = FileUtil.BytesToStream(fileInfo.FileData);
dlg.ShowDialog();
}
else if (extension.Contains(".xls") || extension.Contains(".xlsx") || extension.Contains(".csv"))
{
FrmExcelView dlg = new FrmExcelView();
dlg.Extension = extension;
dlg.Stream = FileUtil.BytesToStream(fileInfo.FileData);
dlg.ShowDialog();
}
else if (extension.Contains(".doc") || extension.Contains(".docx") || extension.Contains(".rtf"))
{
FrmWordView dlg = new FrmWordView();
dlg.Extension = extension;
dlg.Stream = FileUtil.BytesToStream(fileInfo.FileData);
dlg.ShowDialog();
}
else
{
#region 非图片文件下载到本地
string saveFile = FileDialogHelper.SaveFile(name);
if (!string.IsNullOrEmpty(saveFile))
{
FileUtil.CreateFile(saveFile, fileInfo.FileData);
if (File.Exists(saveFile))
{
if (MessageDxUtil.ShowYesNoAndTips("文件下载成功，是否打开文件？") == System.Windows.Forms.DialogResult.Yes)
{
System.Diagnostics.Process.Start(saveFile);
}
}
}
#endregion
}
}
}
}
catch (Exception ex)
{
LogHelper.WriteLog(LogLevel.LOG_LEVEL_CRIT, ex, typeof(FrmAttachmentGroupView));
MessageDxUtil.ShowError("保存文件出现错误。具体如下：\r\n" + ex.Message);
}
}
private void skinComboBoxShopID_SelectedIndexChanged(object sender, EventArgs e)
{
skinTextBox_costumeID.ShopID = ValidateUtil.CheckEmptyValue(skinComboBoxShopID.SelectedValue);
shop = (Shop)skinComboBoxShopID.SelectedItem;
}
private void BaseButtonSaveAccount_Click(object sender, EventArgs e)
{
try
{
if (pfCustomer == null)
{
GlobalMessageBox.Show("款号不能为空！");
skinTextBoxID.Focus();
return;
}
else
if (String.IsNullOrEmpty(skinTextBoxID.Text))
{
GlobalMessageBox.Show("款号不能为空！");
skinTextBoxID.Focus();
return;
}
else
if (skinTextBoxID.Text.Contains("#"))
{
GlobalMessageBox.Show("款号不能使用“#”！");
skinTextBoxID.Focus();
return;
}
else
if (String.IsNullOrEmpty(skinTextBox_Name.Text))
{
GlobalMessageBox.Show("商品名称不能为空！");
skinTextBox_Name.Focus();
return;
}
CostumeColor color = colorComboBox1.SelectedItem as CostumeColor;
if (String.IsNullOrEmpty(color?.Name))
{
GlobalMessageBox.Show("颜色不能为空！");
colorComboBox1.Focus();
return;
}
PfCustomerStore detail = addValue[0];
detail.ColorName = ValidateUtil.CheckEmptyValue(color?.Name);
detail.CostumeID = skinTextBoxID.Text;
detail.CostumeName = skinTextBox_Name.Text;
detail.PfCustomerID = pfCustomer.ID;
detail.PfCustomerName = pfCustomer.Name;
detail.PfPrice = this.textBoxAmount.Value;
//Shop shop = (Shop)skinComboBoxShopID.SelectedItem;
//detail.ShopID = shop.ID;
//detail.ShopName = shop.Name;
//判断是否存在相同款号颜色，如果有则提示是否累加，确定就累加原来的，否的话则取消
if (curInboundDetailList.Exists(t => t.PfCustomerID == detail.PfCustomerID && t.CostumeID == detail.CostumeID && t.ColorName == detail.ColorName))
{
PfCustomerStore existDetail = curInboundDetailList.Find(t => t.PfCustomerID == detail.PfCustomerID && t.CostumeID == detail.CostumeID && t.ColorName == detail.ColorName);
dataGridViewPagingSumCtrl.ScrollToRowIndex(curInboundDetailList.IndexOf(existDetail));
if (GlobalMessageBox.Show("库存信息已存在，是否进行累加？", "确认", MessageBoxButtons.YesNo, MessageBoxIcon.Question) != DialogResult.Yes)
{
return;
}
existDetail.XS += detail.XS;
existDetail.S += detail.S;
existDetail.M += detail.M;
existDetail.L += detail.L;
existDetail.XL += detail.XL;
existDetail.XL2 += detail.XL2;
existDetail.XL3 += detail.XL3;
existDetail.XL4 += detail.XL4;
existDetail.XL5 += detail.XL5;
existDetail.XL6 += detail.XL6;
existDetail.F += detail.F;
existDetail.PfPrice = detail.PfPrice;
}
else
{
curInboundDetailList.Add(detail);
}
ResetAll();
this.BindingInboundDetailSource();
HighlightCostume(detail);
}
catch (Exception ee)
{
GlobalUtil.ShowError(ee);
}
}
/// <summary>
/// 下调变？有数据？添加一条，没有数据
/// </summary>
/// <param name="skinComboBoxColor"></param>
private void SetDataView()
{
if (currentSelectedItem != null)
{
String color = ValidateUtil.CheckEmptyValue(skinComboBox_Color.SelectedValue);
String color1 = ValidateUtil.CheckEmptyValue(skinComboBox_Color1.SelectedValue);
if (!(String.IsNullOrEmpty(color) || String.IsNullOrEmpty(color1)))
{
CostumeStore store = currentSelectedItem?.CostumeStoreList?.Find(t => t.ColorName == color);
CostumeStore newStore = new CostumeStore();
if (store != null)
{
ReflectionHelper.CopyProperty(store, newStore);
}
else
{
store = new CostumeStore();
store.ColorName = color;
store.CostumeColorName = color;
//newStore.CostumeID = currentSelectedItem.Costume.ID;
// newStore.ShopID= skinComboBoxShopID
newStore.CostumeColorName = color;
newStore.ColorName = color;
}
CostumeStore store1 = currentSelectedItem?.CostumeStoreList?.Find(t => t.ColorName == color1);
CostumeStore newStore1 = new CostumeStore();
if (store1 != null)
{
ReflectionHelper.CopyProperty(store1, newStore1);
}
else
{
store1 = new CostumeStore();
store1.CostumeColorName = color1;
store1.ColorName = color1;
newStore1.CostumeColorName = color1;
newStore1.ColorName = color1;
}
if (orgStores == null || orgStores.Count == 0)
{
//first time默认颜色相同，只显示一条
orgStores = new List <CostumeStore>();
newStores = new List <CostumeStore>();
}
orgStores.Clear();
newStores.Clear();
orgStores.Add(store);
newStores.Add(newStore);
if (store1 != store)
{
orgStores.Add(store1);
newStores.Add(newStore1);
}
// this.dataGridView1.DataSource = null;
dataGridViewPagingSumCtrl1.BindingDataSource(DataGridViewUtil.ListToBindingList(orgStores));
dataGridView1.Rows[0].HeaderCell.Value = "调整前";
dataGridViewPagingSumCtrl2.BindingDataSource(DataGridViewUtil.ListToBindingList(newStores));
dataGridView2.Rows[0].HeaderCell.Value = "调整后";
}
}
}
/// <summary>
/// 按条件分页高级查询(带记录状态Enabled和删除状态Deleted)
/// </summary>
/// <param name="systemCode">系统编码</param>
/// <param name="categoryCode">分类编码</param>
/// <param name="companyId">查看公司主键</param>
/// <param name="departmentId">查看部门主键</param>
/// <param name="roleId">角色编号</param>
/// <param name="roleIdExcluded">排除的角色编号</param>
/// <param name="moduleId">模块编号</param>
/// <param name="moduleIdExcluded">排除的模块编号</param>
/// <param name="parentId">父节点编号</param>
/// <param name="startTime">创建开始时间</param>
/// <param name="endTime">创建结束时间</param>
/// <param name="searchKey">查询关键字</param>
/// <param name="recordCount">记录数</param>
/// <param name="pageNo">当前页</param>
/// <param name="pageSize">每页显示</param>
/// <param name="sortExpression">排序字段</param>
/// <param name="sortDirection">排序方向</param>
/// <param name="showDisabled">是否显示无效记录</param>
/// <param name="showDeleted">是否显示已删除记录</param>
/// <returns>数据表</returns>
public DataTable GetDataTableByPage(string systemCode, string categoryCode, string companyId, string departmentId, string roleId, string roleIdExcluded, string moduleId, string moduleIdExcluded, string parentId, string startTime, string endTime, string searchKey, out int recordCount, int pageNo = 1, int pageSize = 20, string sortExpression = "CreateTime", string sortDirection = "DESC", bool showDisabled = true, bool showDeleted = true)
{
var sb = Pool.StringBuilder.Get().Append(" 1 = 1");
//是否显示无效记录
if (!showDisabled)
{
sb.Append(" AND " + BaseOrganizationEntity.CurrentTableName + "." + BaseOrganizationEntity.FieldEnabled + " = 1");
}
//是否显示已删除记录
if (!showDeleted)
{
sb.Append(" AND " + BaseOrganizationEntity.CurrentTableName + "." + BaseOrganizationEntity.FieldDeleted + " = 0");
}
//分类
if (!string.IsNullOrEmpty(categoryCode))
{
sb.Append(" AND " + BaseOrganizationEntity.CurrentTableName + "." + BaseOrganizationEntity.FieldCategoryCode + " = N'" + categoryCode + "'");
}
if (ValidateUtil.IsInt(companyId))
{
//只选择下一级
//sb.Append(" AND " + BaseOrganizationEntity.CurrentTableName + "." + BaseOrganizationEntity.FieldDepartmentId
// + " IN ( SELECT " + BaseOrganizationEntity.FieldId
// + " FROM " + BaseOrganizationEntity.CurrentTableName
// + " WHERE " + BaseOrganizationEntity.FieldId + " = " + departmentId + " OR " + BaseOrganizationEntity.FieldParentId + " = " + departmentId + ")";
//所有下级的都列出来
var ids = GetChildrensId(BaseOrganizationEntity.FieldId, departmentId, BaseOrganizationEntity.FieldParentId);
if (ids != null && ids.Length > 0)
{
sb.Append(" AND (" + BaseOrganizationEntity.CurrentTableName + "." + BaseOrganizationEntity.FieldCompanyId + " IN (" + StringUtil.ArrayToList(ids) + ")"
+ " OR " + BaseOrganizationEntity.CurrentTableName + "." + BaseOrganizationEntity.FieldId + " IN (" + StringUtil.ArrayToList(ids) + ")"
+ " OR " + BaseOrganizationEntity.CurrentTableName + "." + BaseOrganizationEntity.FieldId + " IN (" + StringUtil.ArrayToList(ids) + ")"
+ " OR " + BaseOrganizationEntity.CurrentTableName + "." + BaseOrganizationEntity.FieldId + " IN (" + StringUtil.ArrayToList(ids) + "))");
}
sb.Append(" AND (" + BaseOrganizationEntity.CurrentTableName + "." + BaseOrganizationEntity.FieldCompanyId + " = " + companyId + ")");
}
if (ValidateUtil.IsInt(departmentId))
{
sb.Append(" AND " + BaseOrganizationEntity.CurrentTableName + "." + BaseOrganizationEntity.FieldId + " = " + departmentId);
}
//是否显示已隐藏记录
//if (!showInvisible)
//{
// sb.Append(" AND " + BaseOrganizationEntity.CurrentTableName + "." + BaseOrganizationEntity.FieldIsVisible + " = 1 ";
//}
//角色
var tableNameRoleOrganization = UserInfo.SystemCode + "RoleOrganization";
if (!string.IsNullOrEmpty(systemCode))
{
tableNameRoleOrganization = systemCode + "RoleOrganization";
}
//指定角色
if (!string.IsNullOrEmpty(roleId) && ValidateUtil.IsNumeric(roleId))
{
sb.Append(" AND ( " + BaseOrganizationEntity.FieldId + " IN ");
sb.Append(" (SELECT DISTINCT " + BaseRoleOrganizationEntity.FieldOrganizationId);
sb.Append(" FROM " + tableNameRoleOrganization);
sb.Append(" WHERE " + BaseRoleOrganizationEntity.FieldRoleId + " = '" + roleId + "'");
sb.Append(" AND " + BaseRoleOrganizationEntity.FieldEnabled + " = 1");
sb.Append(" AND " + BaseRoleOrganizationEntity.FieldDeleted + " = 0)) ");
}
//排除指定角色
if (!string.IsNullOrEmpty(roleIdExcluded) && ValidateUtil.IsNumeric(roleIdExcluded))
{
sb.Append(" AND ( " + BaseOrganizationEntity.FieldId + " NOT IN ");
sb.Append(" (SELECT DISTINCT " + BaseRoleOrganizationEntity.FieldOrganizationId);
sb.Append(" FROM " + tableNameRoleOrganization);
sb.Append(" WHERE " + BaseRoleOrganizationEntity.FieldRoleId + " = '" + roleIdExcluded + "'");
sb.Append(" AND " + BaseRoleOrganizationEntity.FieldEnabled + " = 1");
sb.Append(" AND " + BaseRoleOrganizationEntity.FieldDeleted + " = 0)) ");
}
//用户菜单模块表
var tableNamePermission = UserInfo.SystemCode + "Permission";
if (!string.IsNullOrEmpty(systemCode))
{
tableNamePermission = systemCode + "Permission";
}
//指定的菜单模块
if (!string.IsNullOrEmpty(moduleId) && ValidateUtil.IsNumeric(moduleId))
{
sb.Append(" AND ( " + BaseOrganizationEntity.FieldId + " IN ");
sb.Append(" (SELECT DISTINCT " + BasePermissionEntity.FieldResourceId);
sb.Append(" FROM " + tableNamePermission);
sb.Append(" WHERE " + BasePermissionEntity.FieldPermissionId + " = '" + moduleId + "'");
sb.Append(" AND " + BasePermissionEntity.FieldResourceCategory + " = '" + BaseOrganizationEntity.CurrentTableName + "' ");
sb.Append(" AND " + BasePermissionEntity.FieldEnabled + " = 1");
sb.Append(" AND " + BasePermissionEntity.FieldDeleted + " = 0)) ");
}
//排除指定菜单模块
if (!string.IsNullOrEmpty(moduleIdExcluded) && ValidateUtil.IsNumeric(moduleIdExcluded))
{
sb.Append(" AND ( " + BaseOrganizationEntity.FieldId + " NOT IN ");
sb.Append(" (SELECT DISTINCT " + BasePermissionEntity.FieldResourceId);
sb.Append(" FROM " + tableNamePermission);
sb.Append(" WHERE " + BasePermissionEntity.FieldPermissionId + " = '" + moduleIdExcluded + "'");
sb.Append(" AND " + BasePermissionEntity.FieldResourceCategory + " = '" + BaseOrganizationEntity.CurrentTableName + "' ");
sb.Append(" AND " + BasePermissionEntity.FieldEnabled + " = 1");
sb.Append(" AND " + BasePermissionEntity.FieldDeleted + " = 0)) ");
}
//父级编号
if (!string.IsNullOrEmpty(parentId) && ValidateUtil.IsNumeric(parentId))
{
sb.Append(" AND ( ");
//本级
sb.Append(BaseOrganizationEntity.CurrentTableName + "." + BaseOrganizationEntity.FieldId + " = " + parentId);
//下级
sb.Append(" OR " + BaseOrganizationEntity.CurrentTableName + "." + BaseOrganizationEntity.FieldParentId + " = " + parentId);
//下下级
sb.Append(" OR " + BaseOrganizationEntity.CurrentTableName + "." + BaseOrganizationEntity.FieldParentId + " IN ");
sb.Append(" (SELECT " + BaseOrganizationEntity.CurrentTableName + "." + BaseOrganizationEntity.FieldId + " FROM " + BaseOrganizationEntity.CurrentTableName + " WHERE " + BaseOrganizationEntity.CurrentTableName + "." + BaseModuleEntity.FieldParentId + " = " + parentId + ") ");
//下下下级
sb.Append(" OR " + BaseOrganizationEntity.CurrentTableName + "." + BaseOrganizationEntity.FieldParentId + " IN ");
sb.Append(" (SELECT " + BaseOrganizationEntity.CurrentTableName + "." + BaseOrganizationEntity.FieldId + " FROM " + BaseOrganizationEntity.CurrentTableName + " WHERE " + BaseOrganizationEntity.CurrentTableName + "." + BaseModuleEntity.FieldParentId + " IN ");
sb.Append(" (SELECT " + BaseOrganizationEntity.CurrentTableName + "." + BaseOrganizationEntity.FieldId + " FROM " + BaseOrganizationEntity.CurrentTableName + " WHERE " + BaseOrganizationEntity.CurrentTableName + "." + BaseModuleEntity.FieldParentId + " = " + parentId + ") ");
sb.Append(" ) ");
//下下下下级，做个组织机构实际应用应该足够了
sb.Append(" OR " + BaseOrganizationEntity.CurrentTableName + "." + BaseOrganizationEntity.FieldParentId + " IN ");
sb.Append(" (SELECT " + BaseOrganizationEntity.CurrentTableName + "." + BaseOrganizationEntity.FieldId + " FROM " + BaseOrganizationEntity.CurrentTableName + " WHERE " + BaseOrganizationEntity.CurrentTableName + "." + BaseModuleEntity.FieldParentId + " IN ");
sb.Append(" (SELECT " + BaseOrganizationEntity.CurrentTableName + "." + BaseOrganizationEntity.FieldId + " FROM " + BaseOrganizationEntity.CurrentTableName + " WHERE " + BaseOrganizationEntity.CurrentTableName + "." + BaseModuleEntity.FieldParentId + " IN ");
sb.Append(" (SELECT " + BaseOrganizationEntity.CurrentTableName + "." + BaseOrganizationEntity.FieldId + " FROM " + BaseOrganizationEntity.CurrentTableName + " WHERE " + BaseOrganizationEntity.CurrentTableName + "." + BaseModuleEntity.FieldParentId + " = " + parentId + ") ");
sb.Append(" ) ");
sb.Append(" ) ");
//闭合
sb.Append(" ) ");
}
//创建时间
if (ValidateUtil.IsDateTime(startTime))
{
sb.Append(" AND " + BaseOrganizationEntity.FieldCreateTime + " >= '" + startTime + "'");
}
if (ValidateUtil.IsDateTime(endTime))
{
sb.Append(" AND " + BaseOrganizationEntity.FieldCreateTime + " <= DATEADD(s,-1,DATEADD(d,1,'" + endTime + "'))");
}
//关键词
if (!string.IsNullOrEmpty(searchKey))
{
searchKey = StringUtil.GetLikeSearchKey(dbHelper.SqlSafe(searchKey));
sb.Append(" AND (" + BaseOrganizationEntity.FieldName + " LIKE N'%" + searchKey + "%'");
sb.Append(" OR " + BaseOrganizationEntity.FieldCode + " LIKE N'%" + searchKey + "%'");
sb.Append(" OR " + BaseOrganizationEntity.FieldShortName + " LIKE N'%" + searchKey + "%'");
sb.Append(" OR " + BaseOrganizationEntity.FieldStandardName + " LIKE N'%" + searchKey + "%'");
sb.Append(" OR " + BaseOrganizationEntity.FieldDescription + " LIKE N'%" + searchKey + "%'");
sb.Append(" OR " + BaseOrganizationEntity.FieldQuickQuery + " LIKE N'%" + searchKey + "%'");
sb.Append(" OR " + BaseOrganizationEntity.FieldSimpleSpelling + " LIKE N'%" + searchKey + "%')");
}
sb.Replace(" 1 = 1 AND ", "");
return(GetDataTableByPage(out recordCount, pageNo, pageSize, sortExpression, sortDirection, CurrentTableName, sb.Put(), null, "*"));
}
private void BaseButtonAdd_Click(object sender, EventArgs e)
{
try
{
if (GlobalMessageBox.Show("是否确认操作？", "确认", MessageBoxButtons.YesNo, MessageBoxIcon.Question) != DialogResult.Yes)
{
return;
}
if (CommonGlobalUtil.EngineUnconnectioned(this))
{
return;
}
string id = IDHelper.GetID(OrderPrefix.ConfusedStoreAdjustRecord, shop.AutoCode);
ConfusedStoreAdjustRecord para = new ConfusedStoreAdjustRecord()
{
OrderID = id,
CostumeID = currentSelectedItem?.Costume?.ID,
ColorName1 = ValidateUtil.CheckEmptyValue(skinComboBox_Color.SelectedValue),
ColorName2 = ValidateUtil.CheckEmptyValue(skinComboBox_Color1.SelectedValue),
SizeName1 = CostumeStoreHelper.GetCostumeSize(ValidateUtil.CheckEmptyValue(skinComboBox_Size.SelectedValue), CommonGlobalCache.DefaultSizeGroup),
SizeName2 = CostumeStoreHelper.GetCostumeSize(ValidateUtil.CheckEmptyValue(skinComboBox_Size1.SelectedValue), CommonGlobalCache.DefaultSizeGroup),
Remarks = skinTextBox_Remark.Text,
CountPre1 = skinLabelStore,
CountPre2 = skinLabelStore1,
CountNow1 = skinLabelStore - int.Parse(skinTextBox_MoneyCash.Text),
CountNow2 = skinLabelStore1 + int.Parse(skinTextBox_MoneyCash1.Text),
ShopID = ValidateUtil.CheckEmptyValue(skinComboBoxShopID.SelectedValue),
OperatorUserID = userID,
};
if (String.IsNullOrEmpty(para.CostumeID))
{
GlobalMessageBox.Show("请选择款号！");
return;
}
if (para.ColorName1 == para.ColorName2 && para.SizeName1 == para.SizeName2)
{
GlobalMessageBox.Show("请选择不同颜色或者尺码！");
return;
}
if (para.CountPre1 == 0)
{
GlobalMessageBox.Show("库存为0，不能向下调整！");
return;
}
InteractResult result = CommonGlobalCache.ServerProxy.AddConfusedStoreAdjustRecord(para);
switch (result.ExeResult)
{
case ExeResult.Success:
GlobalMessageBox.Show("调整成功！");
//重新获取该款库存信息
this.skinTextBox_costumeID.Reload();
//this.TabPageClose(CurrentTabPage, SourceCtrlType);
break;
case ExeResult.Error:
GlobalMessageBox.Show("内部错误！");
break;
default:
break;
}
}
catch (Exception ex)
{
ShowError(ex);
}
finally
{
UnLockPage();
}
}
private void BindingSource()
{
// if (!String.IsNullOrEmpty(curDayReport.EMallShopID) && curDayReport.EMallShopID == CommonGlobalCache.CurrentShopID)
//{
this.skinToolTip1.SetToolTip(this.skinLabel_QuantityOfSale, "线下" + curDayReport.QuantityOfSale + "件，线上" + curDayReport.EmQuantityOfSale + "件");
skinLabel_QuantityOfSale.ForeColor = Color.Blue;
this.skinToolTip1.SetToolTip(this.skinLabel_QuantityOfRefund, "线下" + (curDayReport.QuantityOfRefund * -1) + "件，线上" + (curDayReport.EmQuantityOfRefund * -1) + "件");
skinLabel_QuantityOfRefund.ForeColor = Color.Blue;
// }
// this.skinLabel_State.Text = "状态：" + (this.curDayReport.ManualConfirm ? "已结存" : "未结存");
this.skinLabel_shop.Text = "店铺：" + CommonGlobalCache.GetShopName(curDayReport.ShopID);
this.skinLabel_Operator.Text = "操作人：" + CommonGlobalCache.GetUserName(curDayReport.AdminUserID);
this.skinLabelDate.Text = "日期：" + curDayReport.ReportDate;
this.skinLabel_SalesCount.Text = ValidateUtil.ZeroToEmpty(curDayReport.SalesCount.ToString(), reportShowZero);
this.skinLabel_RefundCount.Text = ValidateUtil.ZeroToEmpty(curDayReport.RefundCount.ToString(), reportShowZero);
skinLabel_NotConfirmedCount.Text = "未确认单据：" + ValidateUtil.ZeroToEmpty(curDayReport.NotConfirmedCount.ToString(), reportShowZero);
this.richTextBox_Remark.Text = curDayReport.Remarks;
///库存
this.skinLabel_PreTotalCount.Text = ValidateUtil.ZeroToEmpty(curDayReport.PreTotalCount.ToString(), reportShowZero);
skinLabel_PurchaseInCount.Text = ValidateUtil.ZeroToEmpty(curDayReport.PurchaseInCount.ToString(), reportShowZero);
skinLabel_AllocateInCount.Text = ValidateUtil.ZeroToEmpty(curDayReport.AllocateInCount.ToString(), reportShowZero);
skinLabel_CheckStoreLostCount.Text = ValidateUtil.ZeroToEmpty(curDayReport.CheckStoreLostCount.ToString(), reportShowZero);
skinLabel_CheckStoreWinCount.Text = ValidateUtil.ZeroToEmpty(curDayReport.CheckStoreWinCount.ToString(), reportShowZero);
skinLabel_AllocateOutCount.Text = ValidateUtil.ZeroToEmpty(curDayReport.AllocateOutCount.ToString(), reportShowZero);
skinLabel_returnCount.Text = ValidateUtil.ZeroToEmpty(curDayReport.ReturnCount.ToString(), reportShowZero);
// skinLabel_DiffAdjustCount.Text = ValidateUtil.ZeroToEmpty(curDayReport.DiffAdjustCount.ToString(), reportShowZero);
skinLabel_ScrapOutCount.Text = ValidateUtil.ZeroToEmpty(curDayReport.ScrapOutCount.ToString(), reportShowZero);
skinLabel_QuantityOfSale.Text = (curDayReport.QuantityOfSale + curDayReport.EmQuantityOfSale).ToString();
skinLabel_TotalCount.Text = ValidateUtil.ZeroToEmpty(curDayReport.TotalCount.ToString(), reportShowZero);
skinLabel_PreCash.Text = ValidateUtil.ZeroToEmpty(curDayReport.PreCash.ToString(), reportShowZero);
skinLabel_CashCurrent.Text = ValidateUtil.ZeroToEmpty(curDayReport.CashCurrent.ToString(), reportShowZero);
skinLabel_CashDeliverUp.Text = ValidateUtil.ZeroToEmpty(Math.Abs(curDayReport.CashDeliverUp).ToString(), reportShowZero);
skinLabel_CashOut.Text = ValidateUtil.ZeroToEmpty(Math.Abs(curDayReport.CashOut).ToString(), reportShowZero);
skinLabel_RechargeInCash.Text = ValidateUtil.ZeroToEmpty(curDayReport.RechargeInCash.ToString(), reportShowZero);
skinLabel_SalesInCash.Text = ValidateUtil.ZeroToEmpty(curDayReport.SalesInCash.ToString(), reportShowZero);
skinLabel_QuantityOfRefund.Text = ValidateUtil.ZeroToEmpty((curDayReport.QuantityOfRefund * -1 + curDayReport.EmQuantityOfRefund * -1).ToString(), reportShowZero);
skinLabel_RefundInCash.Text = ValidateUtil.ZeroToEmpty((curDayReport.RefundInCash * -1).ToString(), reportShowZero);
// skinLabel_Revenue.Text = curDayReport.Revenue.ToString();
skinLabel_CashInOthers.Text = ValidateUtil.ZeroToEmpty(curDayReport.CashInOthers.ToString(), reportShowZero);
skinLabelPdDeliver.Text = ValidateUtil.ZeroToEmpty(curDayReport.PfDeliveryCount.ToString(), reportShowZero);
skinLabelPfReturn.Text = ValidateUtil.ZeroToEmpty(curDayReport.PfReturnCount.ToString(), reportShowZero);
//if (CommonGlobalUtil.IsPfEnable() && curDayReport.ShopID == CommonGlobalCache.GeneralStoreShopID)
//{
// panelPf.Visible = true;
//}
//else {
// panelPf.Visible = false;
//}
DayReport[] reportDetails = new DayReport[] { curDayReport };
// this.dataGridView1.DataSource = reportDetails;
// this.dataGridView2.DataSource = reportDetails;
List <DayReport> reports = new List <DayReport>();
// reports.Add(curDayReport);
//充值
DayReport cz = new DayReport();
cz.SalesInAlipay = curDayReport.RechargeInAlipay;
cz.SalesInBankCard = curDayReport.RechargeInBankCard;
cz.SalesInCash = curDayReport.RechargeInCash;
cz.SalesInWeiXin = curDayReport.RechargeInWeiXin;
cz.TotalRecharge = curDayReport.TotalRecharge;
cz.SalesInGiftTicket = curDayReport.SalesInGiftTicket;
cz.SalesInMoneyOther = curDayReport.SalesInMoneyOther;
reports.Add(cz);
//收入
DayReport sr = new DayReport();
sr.SalesInAlipay = curDayReport.SalesInAlipay;
sr.SalesInBankCard = curDayReport.SalesInBankCard;
sr.SalesInCash = curDayReport.SalesInCash;
sr.SalesInWeiXin = curDayReport.SalesInWeiXin;
sr.SalesInVipBalance = curDayReport.SalesInVipBalance;
sr.SalesInVipIntegration = curDayReport.SalesInVipIntegration;
sr.TotalRecharge = curDayReport.SalesTotalMoney;
sr.SalesInGiftTicket = curDayReport.SalesInGiftTicket;
sr.SalesInMoneyOther = curDayReport.SalesInMoneyOther;
reports.Add(sr);
//退货
DayReport refund = new DayReport();
refund.SalesInCash = curDayReport.RefundInCash;
refund.SalesInVipBalance = curDayReport.RefundInVipBalance;
refund.SalesInVipIntegration = curDayReport.RefundInVipIntegration;
refund.TotalRecharge = curDayReport.RefundTotalMoney;
refund.SalesInBankCard = curDayReport.RefundInBankCard;
refund.SalesInWeiXin = curDayReport.RefundInWeiXin;
refund.SalesInAlipay = curDayReport.RefundInAlipay;
refund.SalesInMoneyOther = curDayReport.SalesInMoneyOther;
reports.Add(refund);
//小计
DayReport sum = new DayReport();
sum.SalesInCash = sr.SalesInCash + cz.SalesInCash + refund.SalesInCash;
sum.SalesInAlipay = sr.SalesInAlipay + cz.SalesInAlipay + refund.SalesInAlipay;
sum.SalesInBankCard = sr.SalesInBankCard + cz.SalesInBankCard + refund.SalesInBankCard;
sum.SalesInWeiXin = sr.SalesInWeiXin + cz.SalesInWeiXin + refund.SalesInWeiXin;
sum.SalesInVipBalance = sr.SalesInVipBalance + cz.SalesInVipBalance + refund.SalesInVipBalance;
sum.SalesInVipIntegration = sr.SalesInVipIntegration + cz.SalesInVipIntegration + refund.SalesInVipIntegration;
sum.TotalRecharge = sr.TotalRecharge + cz.TotalRecharge + refund.TotalRecharge;
sum.SalesInGiftTicket = sr.SalesInGiftTicket;
refund.SalesInMoneyOther = sr.SalesInMoneyOther + cz.SalesInMoneyOther + refund.SalesInMoneyOther;
reports.Add(sum);
yysr = sr;
czmx = cz;
total = sum;
this.dataGridView2.DataSource = reports;
skinLabel_Donate4Recharge.Text = "赠送金额：" + curDayReport.Donate4Recharge;
}
public DataRowEntity ProduceRow(TableEntity current, long n)
{
ValidateUtil.ValidateNotNull(current, "table");
return(ProduceRow(new ExecutionTable(current, n)));
}
