private void ReSetDictIndexList()
{
_dictIndexList.Clear();
for (int i = 0; i < dataSet.Tables[Text].Rows.Count; i++)
{
if (string.IsNullOrEmpty(txtPinYing.Text))
{
_dictIndexList.Add(i);
}
else
{
string itemName = "";
if (dataSet.Tables[Text].Rows[i]["ITEM_NAME"] != System.DBNull.Value)
{
itemName = dataSet.Tables[Text].Rows[i]["ITEM_NAME"].ToString();
if (!string.IsNullOrEmpty(itemName))
{
itemName = StringManage.GetPYString(itemName);
}
}
if (itemName.ToLower().Contains(txtPinYing.Text.ToLower()))
{
_dictIndexList.Add(i);
}
}
}
}
/// <summary>
///
/// </summary>
/// <param name="OrganizationCode"></param>
/// <param name="UserType"></param>
/// <param name="Page"></param>
/// <param name="Size"></param>
/// <returns></returns>
public PagedList <RelationUserInfoDto> GetRelationUsers(string OrganizationCode, int UserType, int Page, int Size)
{
var type = typeof(TRelationUserOrganization);
var typeU = typeof(TUser);
var typeO = typeof(TOrganization);
var typeR = typeof(TRelationOrganization);
string RelationOrganizationCode = this.DapperRepository.QueryFirstOrDefault <string>(
$@"select [RelationOrganizationCode] from {typeR.PropName()} where [OrganizationCode]=@OrganizationCode",
new { OrganizationCode });
string sqlCount = $@"select count(*) from {type.PropName()} where [OrganizationCode]=@OrganizationCode and [UserType]=@UserType";
int Offset = (Page - 1) * Size;
string sql = $@"select t1.*,
t2.*,
t4.[Name] as [OrganizationName],
t5.[Name] as [DepartmentName],
t6.[Name] as [PositionName]
from
(select [Id] as [RelationId],[OrganizationId],[DepartmentId],[PositionId],[OrganizationCode],[DepartmentCode],[PositionCode],[UserType],[UserId]
from {type.PropName()} where [OrganizationCode]=@OrganizationCode and [UserType]=@UserType) t1
left join {typeU.PropName()} t2 on t1.[UserId]=t2.[Id]
left join (select [OrganizationId],[DepartmentId],[PositionId],[UserId] from {type.PropName()} where [UserType]=0 and [OrganizationCode]=@RelationOrganizationCode) t3 on t1.[UserId]=t3.[UserId]
left join {typeO.PropName()} t4 on t3.[OrganizationId]=t4.[Id]
left join {typeO.PropName()} t5 on t3.[DepartmentId]=t5.[Id]
left join {typeO.PropName()} t6 on t3.[PositionId]=t6.[Id]
order by t1.[UserId]
limit {Size} offset {Offset}";
int count = this.DapperRepository.QueryFirstOrDefault <int>(sqlCount, new { OrganizationCode, UserType });
var data = this.DapperRepository.QueryOriCommand <RelationUserInfoView>(sql, true, new { OrganizationCode, UserType, RelationOrganizationCode }).ToList();
return(new PagedList <RelationUserInfoDto> {
Index = Page, Size = Size, DataList = StringManage.UserViewToUserDto(data), Total = count
});
}
/// <summary>
///
/// </summary>
/// <param name="passwordDto"></param>
/// <param name="userId"></param>
/// <returns></returns>
public int UpdatePassword(UserUpdatePasswordNewDto passwordDto, string userId)
{
PagedList <UserInfoDto> pagedList = GetUsersOfInfo(new UserQueryPageDto
{
UserQuery = new UserQueryDto
{
Id = userId,
Password = passwordDto.OldPassword,
State = 1
},
Page = 1,
Size = 1
});
if (pagedList.Total == 0)
{
return(-1);
}
TUserUpdatePassword updatePassword = new TUserUpdatePassword {
Id = userId,
Password = StringManage.EncryptPassword(passwordDto.NewPassword),
UpdateTime = DateTime.Now
};
return(IocUnity.Get <RepositoryUser>().Update(updatePassword));
}
public CustomSelectionListItem(int index, string displayText, List <string> rowArray)
{
_index = index;
_displayText = displayText;
_inputCode = StringManage.GetPYString(displayText).ToLower();
_rowArray = rowArray;
}
private static void popupMenu_KeyPress(object sender, KeyPressEventArgs e)
{
ContextMenuStrip popupMenu = sender as ContextMenuStrip;
if (popupMenu == null)
{
return;
}
int height = popupMenu.Height;
if (((int)e.KeyChar) == 32)
{
if (_filtString.Length > 0)
{
_filtString = _filtString.Remove(_filtString.Length - 1);
}
}
else
{
_filtString = _filtString + e.KeyChar;
}
foreach (ToolStripItem item in popupMenu.Items)
{
if (StringManage.GetPYString(item.Text).ToLower().Contains(_filtString.ToLower()))
{
item.Visible = true;
}
else
{
item.Visible = false;
}
}
popupMenu.Show(_point);
}
public CustomSelectionListItem(int index, string displayText, List <string> rowArray, string inputCode)
{
_index = index;
_displayText = displayText;
_inputCode = string.IsNullOrEmpty(inputCode) ? StringManage.GetPYString(displayText).ToLower() : inputCode;
_rowArray = rowArray;
}
/// <summary>
///
/// </summary>
/// <param name="userQueryDto"></param>
/// <returns></returns>
public PagedList <UserInfoDto> GetUsersOfInfo(UserQueryPageDto userQueryDto)
{
var q = Dynamic.Core.Runtime.SerializationUtility.ObjectToJson(userQueryDto);
string password = userQueryDto.UserQuery.Password;
if (userQueryDto.UserQuery.Password != null)
{
userQueryDto.UserQuery.Password = StringManage.EncryptPassword(password);
}
int?userType = userQueryDto.UserQuery.UserType;
userQueryDto.UserQuery.UserType = null;
var data = IocUnity.Get <RepositoryUser>().QueryInfo(userQueryDto.UserQuery, userQueryDto.Page, userQueryDto.Size);
var d = Dynamic.Core.Runtime.SerializationUtility.ObjectToJson(data);
if (userQueryDto.UserQuery.Password != null && data.DataList.Count == 0)
{
userQueryDto.UserQuery.Password = SecurityHelper.Md5(password);
data = IocUnity.Get <RepositoryUser>().QueryInfo(userQueryDto.UserQuery, userQueryDto.Page, userQueryDto.Size);
}
if (userQueryDto.UserQuery.Password != null && data.DataList.Count == 0)
{
userQueryDto.UserQuery.Password = SecurityHelper.Encrypt(password);
data = IocUnity.Get <RepositoryUser>().QueryInfo(userQueryDto.UserQuery, userQueryDto.Page, userQueryDto.Size);
}
if (userType != null && (userType == (int)UserTypeEnum.Factory || userType == (int)UserTypeEnum.Dealer) && data.DataList != null && data.DataList.Count == 1)
{
IocUnity.Get <RepositoryUser>().VerifyUser(data.DataList[0].Id, (int)userType);
}
return(data);
}
/// <summary>
///
/// </summary>
/// <param name="passwordDto"></param>
/// <returns></returns>
public int UpdatePassword(UserUpdatePasswordDto passwordDto)
{
TUserUpdatePassword updatePassword = passwordDto.MapTo <TUserUpdatePassword>();
updatePassword.Id = passwordDto.UserId;
updatePassword.UpdateTime = DateTime.Now;
updatePassword.Password = StringManage.EncryptPassword(updatePassword.Password);
return(IocUnity.Get <RepositoryUser>().Update(updatePassword));
}
public virtual List <MED_EVENT_DICT> GetEventDictList()
{
List <MED_EVENT_DICT> eventDictList = dapper.Set <MED_EVENT_DICT>().Select();
foreach (var item in eventDictList)
{
item.EventNamePY = StringManage.GetPYString(item.EVENT_ITEM_NAME);
}
return(eventDictList);
}
public virtual List <MED_MONITOR_FUNCTION_CODE> GetMonitorFuctionCodeList()
{
List <MED_MONITOR_FUNCTION_CODE> codeList = dapper.Set <MED_MONITOR_FUNCTION_CODE>().Select();
foreach (var item in codeList)
{
item.INPUT_CODE = StringManage.GetPYString(item.ITEM_NAME);
}
return(codeList);
}
/// <summary>
///
/// </summary>
/// <param name="UserId"></param>
/// <returns></returns>
public IList <RoleDto> GetUserPositionRoles(string UserId)
{
var type = typeof(TRelationUserOrganization);
var typeRp = typeof(TRelationPositionRole);
var typeR = typeof(TRole);
string sql = $@"select t3.* from (select [PositionId] from {type.PropName()} where [UserId]=@UserId) t1 left join {typeRp.PropName()}
t2 on t1.[PositionId]=t2.[PositionId] left join {typeR.PropName()} t3 on t2.[RoleId]=t3.[Id]";
var data = this.DapperRepository.QueryOriCommand <RoleDto>(sql, true, new { UserId }).ToList();
return(StringManage.RemoveNull(data));
}
public IList <MED_PRICE_LIST> GetPriceList(string itemClass)
{
DapperContext context = new DapperContext("ChargeConnString");
bool flag = string.IsNullOrEmpty(itemClass);
List <MED_PRICE_LIST> priceList = context.Set <MED_PRICE_LIST>().Select(d => flag || d.ITEM_CLASS.Contains(itemClass));
foreach (MED_PRICE_LIST row in priceList)
{
row.INPUT_CODE = StringManage.GetPYString(row.ITEM_NAME);
}
return(priceList);
}
public virtual List <MED_VALUATION_ITEM_LIST> GetValuationItemList()
{
List <MED_VALUATION_ITEM_LIST> dataList = dapper.Set <MED_VALUATION_ITEM_LIST>().Select();
if (dataList != null)
{
foreach (MED_VALUATION_ITEM_LIST row in dataList)
{
row.INPUT_CODE = StringManage.GetPYString(row.ITEM_NAME);
}
}
return(dataList);
}
public virtual List <MED_ANESTHESIA_DICT> GetAnesthesiaDictList()
{
List <MED_ANESTHESIA_DICT> dataList = dapper.Set <MED_ANESTHESIA_DICT>().Select();
if (dataList != null && dataList.Count > 0)
{
foreach (var item in dataList)
{
if (string.IsNullOrEmpty(item.INPUT_CODE))
{
item.INPUT_CODE = StringManage.GetPYString(item.ANAESTHESIA_CODE);
}
}
}
return(dataList);
}
public virtual List <MED_BILL_ITEM_CLASS_DICT> GetBillItemClassDictList()
{
List <MED_BILL_ITEM_CLASS_DICT> dataList = dapper.Set <MED_BILL_ITEM_CLASS_DICT>().Select();
if (dataList != null && dataList.Count > 0)
{
foreach (var item in dataList)
{
if (string.IsNullOrEmpty(item.INPUT_CODE))
{
item.INPUT_CODE = StringManage.GetPYString(item.BILL_CLASS_NAME);
}
}
}
return(dataList);
}
public virtual List <MED_DIAGNOSIS_DICT> GetDiagnosisDictList()
{
List <MED_DIAGNOSIS_DICT> dataList = dapper.Set <MED_DIAGNOSIS_DICT>().Select();
if (dataList != null && dataList.Count > 0)
{
foreach (var item in dataList)
{
if (string.IsNullOrEmpty(item.INPUT_CODE))
{
item.INPUT_CODE = StringManage.GetPYString(item.DIAGNOSIS_NAME);
}
}
}
return(dataList);
}
public virtual List <MED_HIS_USERS> GetHisUsersList(string UserJob)
{
List <MED_HIS_USERS> dataList = dapper.Set <MED_HIS_USERS>().Select(x => x.USER_JOB == UserJob);
if (dataList != null && dataList.Count > 0)
{
foreach (var item in dataList)
{
if (string.IsNullOrEmpty(item.INPUT_CODE))
{
item.INPUT_CODE = StringManage.GetPYString(item.USER_NAME);
}
}
}
return(dataList);
}
public virtual List <MED_OPERATION_DICT> GetOperationDictList()
{
List <MED_OPERATION_DICT> dataList = dapper.Set <MED_OPERATION_DICT>().Select();
if (dataList != null && dataList.Count > 0)
{
foreach (var item in dataList)
{
if (string.IsNullOrEmpty(item.INPUT_CODE))
{
item.INPUT_CODE = StringManage.GetPYString(item.OPER_NAME);
}
}
}
return(dataList);
}
private static DataTable TransTable(DataTable source, string ddd)
{
source.Columns.Add("aabbccdd");
source.Columns.Add("globalIndex");
for (int i = 0; i < source.Rows.Count; i++)
{
DataRow row = source.Rows[i];
if (row[ddd] != System.DBNull.Value && !string.IsNullOrEmpty(row[ddd].ToString()))
{
row["aabbccdd"] = StringManage.GetPYString(row[ddd].ToString()).ToLower();
}
else
{
row["aabbccdd"] = "";
}
row["globalIndex"] = i;
}
return(source);
}
public virtual List <MED_BILL_TEMPLET_MASTER> GetTempletMaster()
{
List <MED_BILL_TEMPLET_MASTER> dataList = new List <MED_BILL_TEMPLET_MASTER>();
List <MED_ANES_BILL_TEMPLET> templetList = GetBillTempletList();
foreach (MED_ANES_BILL_TEMPLET row in templetList)
{
MED_BILL_TEMPLET_MASTER bill = dataList.Where(x => x.TEMPLET == row.TEMPLET).FirstOrDefault();
if (bill == null)
{
bill = new MED_BILL_TEMPLET_MASTER();
bill.TEMPLET = row.TEMPLET;
bill.TEMPLET_CLASS = row.TEMPLET_CLASS;
bill.INPUT_CODE = StringManage.GetPYString(bill.TEMPLET);
dataList.Add(bill);
}
}
return(dataList);
}
public void GetLeftStringTest()
{
string leftString = StringManage.GetLeftString("kjshdfuiyh223的客服接口", 10);
string RightString = StringManage.GetRightString("kjshdfuiyh223的客服接口", 10);
}
/// <summary>
/// 添加用户
/// </summary>
/// <param name="vUser">用户信息</param>
/// <returns></returns>
public string AddUser(UserAddDto vUser)
{
vUser = StringManage.EmptyStringSetNull(vUser);
if (vUser.Password != null && !vUser.IsNoEncryptPassword)
{
vUser.Password = StringManage.EncryptPassword(vUser.Password);
}
if (vUser.UserType == 1)
{
vUser.OrganizationIds = new List <UserPositionDto>();
vUser.OrganizationIds.Add(new UserPositionDto
{
OrganizationId = IocUnity.Get <RepositoryOrganization>().GetOrganizationId("非机构", vUser.SystemCode, "APP"),
OrganizationName = "APP"
});
}
else if (vUser.UserType == 2 || vUser.UserType == 4)
{
vUser.OrganizationIds = new List <UserPositionDto>();
vUser.OrganizationIds.Add(new UserPositionDto
{
OrganizationId = IocUnity.Get <RepositoryOrganization>().GetOrganizationId("非机构", vUser.SystemCode, "微信"),
OrganizationName = "微信"
});
}
else if (vUser.UserType == 3)
{
vUser.OrganizationIds = new List <UserPositionDto>();
vUser.OrganizationIds.Add(new UserPositionDto
{
OrganizationId = IocUnity.Get <RepositoryOrganization>().GetOrganizationId("非机构", vUser.SystemCode, "QQ"),
OrganizationName = "QQ"
});
}
vUser.OrganizationIds = CompleteUserPositionDto(vUser.OrganizationIds);
TUser user = AutoMapperExtensions.MapTo <TUser>(vUser);
Dictionary <string, object> keyValuePairs = new Dictionary <string, object>();
if (vUser.ExtendAttribution != null)
{
foreach (KeyValueItem keyValue in vUser.ExtendAttribution)
{
keyValuePairs.Add(keyValue.Key, keyValue.Value);
}
}
user.ExtendAttribution = SerializationUtility.ObjectToJson(keyValuePairs);
if (string.IsNullOrEmpty(user.Id))
{
user.Id = IdentityHelper.NewSequentialGuid().ToString("N");
}
if (string.IsNullOrEmpty(user.SystemId) && !string.IsNullOrEmpty(user.SystemCode))
{
user.SystemId = IocUnity.Get <RepositorySystem>().GetId(user.SystemCode);
}
if (!string.IsNullOrEmpty(user.SystemId) && string.IsNullOrEmpty(user.SystemCode))
{
user.SystemCode = IocUnity.Get <RepositorySystem>().GetCode(user.SystemId);
}
IList <TRelationUserOrganization> relationUserPositions = new List <TRelationUserOrganization>();
if (vUser.OrganizationIds != null)
{
foreach (UserPositionDto od in vUser.OrganizationIds)
{
TRelationUserOrganization relationUserOrganization = AutoMapperExtensions.MapTo <TRelationUserOrganization>(od);
relationUserOrganization.Id = IdentityHelper.NewSequentialGuid().ToString("N");
relationUserOrganization.UserId = user.Id;
if (!string.IsNullOrEmpty(relationUserOrganization.OrganizationId) && !string.IsNullOrEmpty(relationUserOrganization.DepartmentId) && !string.IsNullOrEmpty(relationUserOrganization.PositionId))
{
relationUserOrganization.OrganizationIdO = relationUserOrganization.PositionId;
}
else if (!string.IsNullOrEmpty(relationUserOrganization.OrganizationId) && !string.IsNullOrEmpty(relationUserOrganization.DepartmentId) && string.IsNullOrEmpty(relationUserOrganization.PositionId))
{
relationUserOrganization.OrganizationIdO = relationUserOrganization.DepartmentId;
}
else if (!string.IsNullOrEmpty(relationUserOrganization.OrganizationId) && string.IsNullOrEmpty(relationUserOrganization.DepartmentId) && string.IsNullOrEmpty(relationUserOrganization.PositionId))
{
relationUserOrganization.OrganizationIdO = relationUserOrganization.OrganizationId;
}
else if (!string.IsNullOrEmpty(relationUserOrganization.OrganizationId) && string.IsNullOrEmpty(relationUserOrganization.DepartmentId) && !string.IsNullOrEmpty(relationUserOrganization.PositionId))
{
relationUserOrganization.OrganizationIdO = relationUserOrganization.PositionId;
}
relationUserPositions.Add(relationUserOrganization);
}
}
IocUnity.Get <RepositoryUser>().DapperRepository.ExcuteTransaction(tranc =>
{
IocUnity.Get <RepositoryUser>().Insert(user);
IocUnity.Get <RepositoryRelationUserOrganization>().Insert(relationUserPositions);
});
return(user.Id);
}
/// <summary>
///
/// </summary>
/// <param name="userUpdateDto"></param>
/// <returns></returns>
public int UpdateUser(UserUpdateDto userUpdateDto)
{
userUpdateDto = StringManage.EmptyStringSetNull(userUpdateDto);
if (userUpdateDto.UserType == 1)
{
userUpdateDto.OrganizationIds = new List <UserPositionDto>
{
new UserPositionDto
{
OrganizationId = IocUnity.Get <RepositoryOrganization>().GetOrganizationId("非机构",
IocUnity.Get <RepositoryUser>().GetUserSystemCode(userUpdateDto.Id), "APP"),
OrganizationName = "APP"
}
};
}
else if (userUpdateDto.UserType == 2)
{
userUpdateDto.OrganizationIds = new List <UserPositionDto>
{
new UserPositionDto
{
OrganizationId = IocUnity.Get <RepositoryOrganization>().GetOrganizationId("非机构",
IocUnity.Get <RepositoryUser>().GetUserSystemCode(userUpdateDto.Id), "微信"),
OrganizationName = "微信"
}
};
}
else if (userUpdateDto.UserType == 3)
{
userUpdateDto.OrganizationIds = new List <UserPositionDto>
{
new UserPositionDto
{
OrganizationId = IocUnity.Get <RepositoryOrganization>().GetOrganizationId("非机构",
IocUnity.Get <RepositoryUser>().GetUserSystemCode(userUpdateDto.Id), "QQ"),
OrganizationName = "QQ"
}
};
}
userUpdateDto.OrganizationIds = CompleteUserPositionDto(userUpdateDto.OrganizationIds);
TUserUpdate user = userUpdateDto.MapTo <TUserUpdate>();
Dictionary <string, object> keyValuePairs = new Dictionary <string, object>();
if (userUpdateDto.ExtendAttribution != null)
{
foreach (KeyValueItem keyValue in userUpdateDto.ExtendAttribution)
{
keyValuePairs.Add(keyValue.Key, keyValue.Value);
}
}
user.ExtendAttribution = SerializationUtility.ObjectToJson(keyValuePairs);
IList <TRelationUserOrganization> relationUserPositions = new List <TRelationUserOrganization>();
if (userUpdateDto.OrganizationIds != null)
{
foreach (UserPositionDto od in userUpdateDto.OrganizationIds)
{
TRelationUserOrganization relationUserOrganization = od.MapTo <TRelationUserOrganization>();
relationUserOrganization.Id = IdentityHelper.NewSequentialGuid().ToString("N");
relationUserOrganization.UserId = user.Id;
if (relationUserOrganization.OrganizationId != null && relationUserOrganization.DepartmentId != null && relationUserOrganization.PositionId != null)
{
relationUserOrganization.OrganizationIdO = relationUserOrganization.PositionId;
}
else if (relationUserOrganization.OrganizationId != null && relationUserOrganization.DepartmentId != null && relationUserOrganization.PositionId == null)
{
relationUserOrganization.OrganizationIdO = relationUserOrganization.DepartmentId;
}
else if (relationUserOrganization.OrganizationId != null && relationUserOrganization.DepartmentId == null && relationUserOrganization.PositionId == null)
{
relationUserOrganization.OrganizationIdO = relationUserOrganization.OrganizationId;
}
relationUserPositions.Add(relationUserOrganization);
}
}
int count = 0;
IocUnity.Get <RepositoryUser>().DapperRepository.ExcuteTransaction(tranc =>
{
IocUnity.Get <RepositoryRelationUserOrganization>().DeleteUserOrganization(userUpdateDto.Id);
IocUnity.Get <RepositoryRelationUserOrganization>().Insert(relationUserPositions);
count = IocUnity.Get <RepositoryUser>().UpdateUser(user);
});
return(count);
}
/// <summary>
///
/// </summary>
/// <param name="RelationCode"></param>
/// <param name="Page"></param>
/// <param name="Size"></param>
/// <param name="Name"></param>
/// <param name="TypeId"></param>
/// <param name="where"></param>
/// <param name="RelationTypeId"></param>
/// <returns></returns>
public PagedList <RelationOrganizationDetailDto> GetRelationOrganizations(string RelationCode, string Name, int Page, int Size, string TypeId, string RelationTypeId, string where)
{
var typeR = typeof(TRelationOrganization);
var type = typeof(TOrganization);
var typeP = typeof(TOrganizationType);
string condition = "";
if (Name.IsNotNullOrEmpty())
{
condition += $" and t2.[Name] like '%{Name}%'";
}
if (TypeId.IsNotNullOrEmpty())
{
condition += $" and t2.[TypeId]='{TypeId}'";
}
if (RelationTypeId.IsNotNullOrEmpty() && RelationCode.IsNullOrEmpty())
{
condition += $" and t5.[TypeId]='{RelationTypeId}'";
}
condition = StringManage.RemovePrefix(condition, " and");
if (condition.IsNotNullOrEmpty())
{
condition = "where " + condition;
}
if (where.IsNotNullOrEmpty() && condition.IsNullOrEmpty())
{
where = StringManage.RemovePrefix(where, " and");
condition = "where " + where;
}
else if (where.IsNotNullOrEmpty() && condition.IsNotNullOrEmpty())
{
condition = condition + where;
}
if (Page == 0 && Size == 0)
{
if (RelationCode.IsNotNullOrEmpty())
{
string sql = $@"select t1.[Id] as [RelationId],t2.*,t3.[IsRelevancy],t4.[Name] as [ParentName] from (select [Id],[OrganizationId] from
{typeR.PropName()} where [RelationAreaCode]=@RelationCode or ([RelationOrganizationCode]=@RelationCode and [RelationAreaCode] is null)) t1 left join
{type.PropName()} t2
on t1.[OrganizationId]=t2.[Id] left join {typeP.PropName()} t3 on t2.[TypeId]=t3.[Id]
left join {type.PropName()} t4 on t2.[ParentId]=t4.[Id] {condition}";
var r = this.DapperRepository.QueryOriCommand <RelationOrganizationDetailDto>(sql, true, new { RelationCode }).ToList();
sql = $@"select tt2.* from (select distinct t1.[RelationAreaId] from (select [OrganizationId],[RelationAreaId] from
{typeR.PropName()} where [RelationOrganizationCode]=@RelationCode and [RelationAreaCode] is not null) t1 left join {type.PropName()} t2
on t1.[OrganizationId]=t2.[Id] where t2.[TypeId]=@TypeId) t left join {type.PropName()} tt2
on t.[RelationAreaId]=tt2.[Id]";
var r2 = this.DapperRepository.QueryOriCommand <RelationOrganizationDetailDto>(sql, true, new { RelationCode, TypeId }).ToList();
r.AddRange(r2);
return(new PagedList <RelationOrganizationDetailDto> {
DataList = r
});
}
else if (RelationCode.IsNullOrEmpty() && RelationTypeId.IsNotNullOrEmpty())
{
string sql = $@"select t1.[Id] as [RelationId],t2.*,t3.[IsRelevancy],t4.[Name] as [ParentName] from {typeR.PropName()} t1 left join
{type.PropName()} t2
on t1.[OrganizationId]=t2.[Id] left join {typeP.PropName()} t3 on t2.[TypeId]=t3.[Id]
left join {type.PropName()} t4 on t2.[ParentId]=t4.[Id]
left join {type.PropName()} t5 on t1.[RelationOrganizationId]=t2.[Id] {condition}";
var r = this.DapperRepository.QueryOriCommand <RelationOrganizationDetailDto>(sql, true, new { RelationTypeId }).ToList();
return(new PagedList <RelationOrganizationDetailDto> {
DataList = r
});
}
}
else
{
if (RelationCode.IsNotNullOrEmpty())
{
string sql = $@"select t1.[Id] as [RelationId],t2.*,t3.[IsRelevancy],t4.[Name] as [ParentName] from (select [Id],[OrganizationId] from
{typeR.PropName()} where [RelationAreaCode]=@RelationCode or [RelationOrganizationCode]=@RelationCode) t1 left join
{type.PropName()} t2
on t1.[OrganizationId]=t2.[Id]
left join {typeP.PropName()} t3 on t2.[TypeId]=t3.[Id]
left join {type.PropName()} t4 on t2.[ParentId]=t4.[Id]
{condition}";
var data = this.DapperRepository.PagedList <RelationOrganizationDetailDto>(sql, Page, Size, new { RelationCode }) as PagedList <RelationOrganizationDetailDto>;
return(data);
}
else if (RelationCode.IsNullOrEmpty() && RelationTypeId.IsNotNullOrEmpty())
{
string sql = $@"select t1.[Id] as [RelationId],t2.*,t3.[IsRelevancy],t4.[Name] as [ParentName] from {typeR.PropName()} t1 left join
{type.PropName()} t2
on t1.[OrganizationId]=t2.[Id]
left join {typeP.PropName()} t3 on t2.[TypeId]=t3.[Id]
left join {type.PropName()} t4 on t2.[ParentId]=t4.[Id]
left join {type.PropName()} t5 on t1.[RelationOrganizationId]=t5.[Id]
{condition}";
var data = this.DapperRepository.PagedList <RelationOrganizationDetailDto>(sql, Page, Size, new { RelationTypeId }) as PagedList <RelationOrganizationDetailDto>;
return(data);
}
}
return(null);
}
