SearchUserResponse IAdminUserService.GetSearchUsersBy(UsersSearchRequest req)
{
var resp = new SearchUserResponse();
IEnumerable <User> users = new List <User>();
IList <Func <User, bool> > ps = new List <Func <User, bool> >();
try
{
DealWithContainsUserName(req, ps);
DealWithEqualsUserStateId(req, ps);
var numberOfResultsPrePage = ApplicationSettingsFactory.GetApplicationSettings().NumberOfResultsPrePage;//获取每页记录数
users = _userDAL.FindBy(ps, req.CurrentPageIndex, numberOfResultsPrePage);
if (HasNoSearchResult(users))
{
resp.Message = NoRecordsMessage;
}
else
{
resp.TotalResultCount = _userDAL.GetCountByContains(ps);
resp.Users = users.ConvertToUsersInfoViewList();
resp.Succeed = true;
}
}
catch (Exception ex)
{
resp.Message = "搜索用户列表信息发生错误";
Log(ex);
}
return(resp);
}
private void BindDropDownData()
{
SearchUsersRequest requestUser = new SearchUsersRequest(
SearchUsersType.All, false, " FirstName ", " ASC ");
requestUser.IsSunnet = true;
requestUser.IsActive = true;
SearchUserResponse responseuser = userApp.SearchUsers(requestUser);
ddlOwner.DataSource = responseuser.ResultList.FindAll(r => r.Office == "CN");
ddlOwner.DataBind();
ddlApprover.DataSource = responseuser.ResultList.FindAll(r => r.Role == RolesEnum.ADMIN);
ddlApprover.DataBind();
ListItem liApprover = ddlApprover.Items.FindByValue(Config.SealApprover.ToString());
if (liApprover == null)
{
UsersEntity usersEntity = userApp.GetUser(Config.SealApprover);
ddlApprover.Items.Insert(0, new ListItem()
{
Value = usersEntity.UserID.ToString(), Text = usersEntity.FirstName
});
}
}
private void InitControls()
{
DateTime date = DateTime.Now.AddMonths(-1);
ProjectApplication projApp = new ProjectApplication();
List <ProjectDetailDTO> list = projApp.GetAllProjects();
list.BindDropdown <ProjectDetailDTO>(ddlProject, "Title", "ID", "All", "0");
ddlTickets.Items.Add(new ListItem("All", "0"));
UserApplication userApp = new UserApplication();
SearchUsersRequest requestUser = new SearchUsersRequest(
SearchUsersType.All, false, " FirstName ", " ASC ");
requestUser.IsSunnet = true;
SearchUserResponse responseuser = userApp.SearchUsers(requestUser);
ddlUsers.Items.Add(new ListItem("All", "0"));
foreach (UsersEntity user in responseuser.ResultList)
{
ddlUsers.Items.Add(new ListItem(string.Format("{0} {1}", user.FirstName, user.LastName)
, user.ID.ToString()));
}
}
/// <summary>
/// 初始化搜索 条件
/// </summary>
private void InitSearchControls()
{
DateTime date = DateTime.Now.AddMonths(-1);
ProjectApplication projApp = new ProjectApplication();
List <ProjectDetailDTO> listAll = projApp.GetAllProjects().Where(c => c.Title == "0_PTO").ToList();
listAll.BindDropdown <ProjectDetailDTO>(ddlProject, "Title", "ID", "All", "0");
SearchUsersRequest requestUser = new SearchUsersRequest(
SearchUsersType.All, false, " FirstName ", " ASC ");
requestUser.IsSunnet = true;
var selfid = Convert.ToInt32(ConfigurationManager.AppSettings["PTOVIEWSELF"]);
if (list.Where(t => t.ModuleID == allid).Count() > 0)
{
SearchUserResponse responseuser = userApp.SearchUsers(requestUser);
ddlUsers.Items.Add(new ListItem("All", "0"));
foreach (UsersEntity user in responseuser.ResultList)
{
ddlUsers.Items.Add(new ListItem(string.Format("{0} {1}", user.FirstName, user.LastName)
, user.ID.ToString()));
}
}
else
{
ddlUsers.Items.Add(new ListItem(string.Format("{0} {1}", UserInfo.FirstName, UserInfo.LastName)
, UserInfo.ID.ToString()));
}
}
private void InitClientUsers()
{
SearchUsersRequest searchUserRequest = new SearchUsersRequest(
SearchUsersType.Project, false, " FirstName ", " ASC ");
searchUserRequest.ProjectID = ProjectID;
SearchUserResponse response = userApp.SearchUsers(searchUserRequest);
var listUsers = response.ResultList.FindAll(x => x.Role == RolesEnum.CLIENT && x.UserID != UserInfo.UserID);
var listTicketUsers = ticketApp.GetListUsersByTicketId(TicketID);
var tmpList = listUsers.Select(x => new
{
x.ID,
ProjectID = ProjectID,
x.FirstName,
x.LastName,
x.FirstAndLastName,
x.LastNameAndFirst,
Writed = hasWaitingStatus && listTicketUsers.Any(r => r.UserID == x.ID) &&
listTicketUsers.Find(r => r.UserID == x.ID).TicketStatus == UserTicketStatus.Normal,
Selected = listTicketUsers.Any(r => r.UserID == x.ID) &&
listTicketUsers.Find(r => r.UserID == x.ID).TicketStatus != UserTicketStatus.Normal,
Update = listTicketUsers.Any(r => r.UserID == x.ID) ? listTicketUsers.Find(r => r.UserID == x.ID).TUID : 0,
x.Role
}).ToList();
rptClient.DataSource = tmpList;
rptClient.DataBind();
rptClient2.DataSource = tmpList;
rptClient2.DataBind();
}
private void InitSearchControls()
{
DateTime date = DateTime.Now.AddMonths(-1);
//txtStartDate.Text = new DateTime(date.Year, date.Month, 1).ToString("MM/dd/yyyy");
//txtEndDate.Text = new DateTime(date.Year, date.Month, DateTime.DaysInMonth(date.Year, date.Month)).ToString("MM/dd/yyyy");
ProjectApplication projApp = new ProjectApplication();
List <ProjectDetailDTO> listAll = projApp.GetUserProjects(UserInfo);
listAll.BindDropdown <ProjectDetailDTO>(ddlProject, "Title", "ID", "All", "0");
UserApplication userApp = new UserApplication();
SearchUsersRequest requestUser = new SearchUsersRequest(
SearchUsersType.All, false, " FirstName ", " ASC ");
requestUser.IsSunnet = true;
SearchUserResponse responseuser = userApp.SearchUsers(requestUser);
ddlUsers.Items.Add(new ListItem("All", "0"));
foreach (UsersEntity user in responseuser.ResultList)
{
ddlUsers.Items.Add(new ListItem(string.Format("{0} {1}", user.FirstName, user.LastName)
, user.ID.ToString()));
}
}
private void BindUsers()
{
UserApplication userApp = new UserApplication();
SearchUsersRequest requestUser = new SearchUsersRequest(
SearchUsersType.All, false, " FirstName ", " ASC ");
requestUser.IsSunnet = true;
requestUser.IsActive = true;
SearchUserResponse responseuser = userApp.SearchUsers(requestUser);
ddlUsers.Items.Add(new ListItem("All", "0"));
switch (UserInfo.Role)
{
case RolesEnum.ADMIN:
case RolesEnum.Sales:
case RolesEnum.PM:
foreach (UsersEntity user in responseuser.ResultList)
{
ddlUsers.Items.Add(new ListItem(string.Format("{0} {1}", user.FirstName, user.LastName)
, user.ID.ToString()));
}
break;
case RolesEnum.Leader:
case RolesEnum.QA:
case RolesEnum.DEV:
foreach (UsersEntity user in responseuser.ResultList.FindAll(r => r.Role == RolesEnum.Leader ||
r.Role == RolesEnum.QA || r.Role == RolesEnum.DEV))
{
ddlUsers.Items.Add(new ListItem(string.Format("{0} {1}", user.FirstName, user.LastName)
, user.ID.ToString()));
}
break;
}
}
public SearchUserResponse Get(SearchUserRequest request)
{
SearchUserResponse response = new SearchUserResponse();
response.Users = PlacesToVisitRepository.SearchUsersByUserDetails(request.SearchQuery);
return(response);
}
public SearchUserResponse SearchUsers(SearchUsersRequest request)
{
this.ClearBrokenRuleMessages();
SearchUserResponse response = mgr.SearchUsers(request);
this.AddBrokenRuleMessages(mgr.BrokenRuleMessages);
return(response);
}
public SunNet.PMNew.Entity.UserModel.SearchUserResponse SearchUsers(SearchUsersRequest request)
{
mgr.ClearBrokenRuleMessages();
SearchUserResponse response = mgr.SearchUsers(request);
if (mgr.BrokenRuleMessages.Count > 0)
{
this.BrokenRuleMessages = mgr.BrokenRuleMessages;
}
return(response);
}
public SearchUserResponse SearchUsers(SearchUsersRequest request)
{
this.ClearBrokenRuleMessages();
SearchUserResponse response = CompanyUserAdapter.SearchUsers(request);
if (response == null)
{
this.AddBrokenRuleMessage();
}
return(response);
}
private List <UsersEntity> GetAllCompanyUsers()
{
int id = QS("id", 0);
SearchUsersRequest searchUserRequest = new SearchUsersRequest(
SearchUsersType.CompanyByProject, false, " FirstName ", " ASC ");
searchUserRequest.ProjectID = id;
SearchUserResponse response = projApp.GetProjectUsers(searchUserRequest);
return(response.ResultList);
}
private List <UsersEntity> GetAllSunnetUsers()
{
int id = QS("id", 0);
SearchUsersRequest searchUserRequest = new SearchUsersRequest(
SearchUsersType.All, false, " FirstName ", " ASC ");
searchUserRequest.IsSunnet = true;
SearchUserResponse response = projApp.GetProjectUsers(searchUserRequest);
return(response.ResultList);
}
private void InitPM()
{
SearchUsersRequest searchUsersRequest = new SearchUsersRequest(
SearchUsersType.Role, false, " FirstName ", " ASC ");
searchUsersRequest.Role = RolesEnum.PM;
SearchUserResponse response = projApp.GetProjectUsers(searchUsersRequest);
foreach (UsersEntity user in response.ResultList)
{
ddlPM.Items.Add(new ListItem(string.Format("{0} {1}", user.FirstName, user.LastName), user.UserID.ToString()));
}
}
private bool QueryISClient(string userid)
{
SearchUsersRequest searchUserRequest = new SearchUsersRequest(
SearchUsersType.SingleInstance, false, " FirstName ", " ASC ");
searchUserRequest.UserID = int.Parse(userid);
SearchUserResponse response = projApp.GetProjectUsers(searchUserRequest);
if (response.ResultList != null && response.ResultList.Count > 0)
{
return(response.ResultList[0].Role == RolesEnum.CLIENT);
}
return(false);
}
private void InitUsers()
{
SearchUsersRequest request = new SearchUsersRequest(
SearchUsersType.All, false, " FirstName ", " ASC ");
request.IsSunnet = true;
SearchUserResponse response = userApp.SearchUsers(request);
ddlUser.DataSource = response.ResultList;
ddlUser.DataBind(delegate(UsersEntity user, string status)
{
return(user.Status == status);
});
ddlUser.SelectItem(QS("user"));
}
private void InitInternalUserBind()
{
SearchUsersRequest request = new SearchUsersRequest(
SearchUsersType.All, false, " FirstName ", " ASC ");
request.IsSunnet = true;
SearchUserResponse response = userApp.SearchUsers(request);
ddlAssignUser.DataSource = response.ResultList.FindAll(u => u.UserID == userEntity.UserID);
ddlAssignUser.DataBind(delegate(UsersEntity user, string status)
{
return(user.Status == status);
});
}
private void InitEsUserBind()
{
SearchUsersRequest request = new SearchUsersRequest(
SearchUsersType.Project, false, " FirstName ", " ASC ");
int tid = QS("tid", 0);
GetProjectIdAndUserIDResponse responseProject = ticketApp.GetProjectIdAndUserID(tid);//get pid
request.ProjectID = responseProject.ProjectId;
response = userApp.SearchUsers(request);
ddlEs.DataTextField = "FirstName";
ddlEs.DataValueField = "UserID";
SetDefaultValueForDropdownList <UsersEntity>(ddlEs,
response.ResultList.FindAll(x => (x.Role != RolesEnum.CLIENT && x.Role != RolesEnum.Sales && x.Role != RolesEnum.Supervisor)));
}
public void searchFriendRequestCompleted(BaseHttpRequest request, BaseResponse response)
{
if (response != null && response.status != BaseResponse.ERROR)
{
SearchUserResponse searchUserResponse = response as SearchUserResponse;
this.searchUserResultList.Clear();
if (searchUserResponse.data != null)
{
this.searchUserResultList.AddRange(searchUserResponse.data);
}
if (searchFriendRequestCompletedDelegate != null)
{
this.searchFriendRequestCompletedDelegate(this.searchUserResultList);
}
}
ComLoading.Close();
}
private void InitDEVSQAUser()
{
UserApplication userApp = new UserApplication();
SearchUsersRequest requestUser = new SearchUsersRequest(
SearchUsersType.All, false, " FirstName ", " ASC ");
requestUser.IsSunnet = true;
SearchUserResponse responseuser = userApp.SearchUsers(requestUser);
ddlUsers.Items.Add(new ListItem("Please Select", "-1"));
foreach (UsersEntity user in responseuser.ResultList)
{
if (user.Role == RolesEnum.DEV || user.Role == RolesEnum.QA)
{
ddlUsers.Items.Add(new ListItem(string.Format("{0} {1}", user.FirstName, user.LastName)
, user.ID.ToString()));
}
}
}
private void InitControl()
{
SearchUsersRequest request = new SearchUsersRequest(SearchUsersType.List
, true, OrderBy, OrderDirection);
request.Status = ddlStatus.SelectedValue;
request.CompanyID = int.Parse(ddlCompany.SelectedValue);
request.Keywords = txtKeyword.Text.NoHTML();
request.CurrentPage = CurrentPageIndex;
request.PageCount = UsersPage.PageSize;
SearchUserResponse response = userApp.SearchUsers(request);
rptUsers.DataSource = response.ResultList;
rptUsers.DataBind();
UsersPage.RecordCount = response.ResultCount;
}
private void InitUsers()
{
SearchUsersRequest request = new SearchUsersRequest(
SearchUsersType.Company, false, " FirstName ", " ASC ");
request.CompanyID = CompanyID;
SearchUserResponse response = companyApp.SearchUsers(request);
if (response.ResultList.Count <= 0)
{
trNoUser.Visible = true;
}
else
{
rptUsers.DataSource = response.ResultList;
rptUsers.DataBind();
trNoUser.Visible = false;
}
}
public void ProcessRequest(HttpContext context)
{
string type = context.Request.QueryString["RequestType"];
int requestID = int.Parse(context.Request.QueryString["RequestID"]);
WorkflowAction action = (WorkflowAction)Enum.Parse(typeof(WorkflowAction), context.Request.QueryString["Action"]);
List <UsersEntity> lstUser = new List <UsersEntity>();
// Get some entity
SealsApplication sealApp = new SealsApplication();
SealRequestsEntity sealRequestEntity = sealApp.GetSealRequests(requestID);
UserApplication userApp = new UserApplication();
if (action == WorkflowAction.Deny || action == WorkflowAction.FinishProcess)
{
lstUser.Add(userApp.GetUser(sealRequestEntity.RequestedBy));
}
else if (action == WorkflowAction.Cancel || action == WorkflowAction.Complete || action == WorkflowAction.Pending || action == WorkflowAction.Save)
{
}
else if (type == "Seal")
{
// Get Seal entity list
List <SealUnionRequestsEntity> listSealUnionReq = sealApp.GetSealUnionRequestsList(requestID);
List <SealsEntity> listSeal = new List <SealsEntity>();
foreach (SealUnionRequestsEntity ent in listSealUnionReq)
{
SealsEntity sealEntity = sealApp.GetList().Find(r => r.ID == ent.SealID);
listSeal.Add(sealEntity);
}
if (action == WorkflowAction.Submit)
{
foreach (SealsEntity ent in listSeal)
{
lstUser.Add(userApp.GetUser(ent.Approver));
}
}
else if (action == WorkflowAction.Approve)
{
foreach (SealsEntity ent in listSeal)
{
lstUser.Add(userApp.GetUser(ent.Owner));
}
}
else
{
SearchUsersRequest requestUser = new SearchUsersRequest(SearchUsersType.All, false, " FirstName ", " ASC ");
requestUser.IsSunnet = true;
SearchUserResponse responseuser = userApp.SearchUsers(requestUser);
lstUser = responseuser.ResultList.FindAll(r => r.ID != UserInfo.ID && r.Status == "ACTIVE");
}
}
else
{
SearchUsersRequest requestUser = new SearchUsersRequest(SearchUsersType.All, false, " FirstName ", " ASC ");
requestUser.IsSunnet = true;
SearchUserResponse responseuser = userApp.SearchUsers(requestUser);
lstUser = responseuser.ResultList.FindAll(r => r.ID != UserInfo.ID && r.Status == "ACTIVE");//(r.Role == RolesEnum.PM || r.Role== RolesEnum.Sales) &&
}
lstUser = lstUser.Distinct().ToList();
Dictionary <string, object> result = new Dictionary <string, object>();
result.Add("list", lstUser);
context.Response.Write(Newtonsoft.Json.JsonConvert.SerializeObject(result));
context.Response.End();
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
var list = new List <ListItem>()
{
new ListItem("Lading")
{
Selected = false
},
new ListItem("A", "1")
{
Selected = false
},
new ListItem("B", "2")
{
Selected = false
},
new ListItem("C", "3")
{
Selected = false
},
new ListItem("D", "4")
{
Selected = false
},
new ListItem("E", "5")
{
Selected = false
},
new ListItem("Rome")
{
Selected = false
},
new ListItem("I", "1")
{
Selected = false
},
new ListItem("II", "2")
{
Selected = false
},
new ListItem("III", "3")
{
Selected = false
},
new ListItem("IV", "4")
{
Selected = false
},
new ListItem("V", "5")
{
Selected = false
}
};
ExtendedDropdownList1.OptionGroupValues = "Lading,Rome";
ExtendedDropdownList1.DataSource = list;
ExtendedDropdownList1.DataBind();
SearchUsersRequest request = new SearchUsersRequest(
SearchUsersType.List, false, " FirstName ", " ASC ");
//request.IsActive = true;
//request.IsSunnet = true;
SearchUserResponse response = userApp.SearchUsers(request);
//ddlUsers.DataTextField = "FirstAndLastName";
//ddlUsers.DataValueField = "UserID";
ddlUsers.DataSource = response.ResultList;
Func <UsersEntity, string, bool> userByRole = delegate(UsersEntity user, string status)
{
return(user.Role.ToString() == status);
};
ddlUsers.DataBind(userByRole);
ddlUsers.SelectedValue = "120";
//ddlUsers2.DataTextField = "FirstAndLastName";
//ddlUsers2.DataValueField = "UserID";
ddlUsers2.DataSource = response.ResultList;
Func <UsersEntity, string, bool> userByStatus = delegate(UsersEntity user, string status)
{
return(user.Status == status);
};
ddlUsers2.DataBind(userByStatus);
ddlUsers2.SelectedValue = "120";
ddlUsers2.DefaultSelectText = "User is required";
//ddlUsers3.DataTextField = "FirstAndLastName";
//ddlUsers3.DataValueField = "UserID";
ddlUsers3.DataSource = response.ResultList.FindAll(x => x.Status == "ACTIVE");
ddlUsers3.DataBind(userByStatus);
ddlUsers3.SelectedValue = "120";
Button1_Click(null, null);
}
}
public SearchUserResponse SearchUsers(SearchUsersRequest request)
{
int start = request.CurrentPage * request.PageCount + 1 - request.PageCount;
int end = request.CurrentPage * request.PageCount;
string strSelCount = " SELECT COUNT(1) FROM [Users] u ";
if (request.OrderExpression.ToLower().Equals("status"))
{
request.OrderExpression = " u.Status ";
}
string strOrderby = string.Format(" {0} {1} ", request.OrderExpression, request.OrderDirection);
string strSelAttrs = " SELECT u.*,c.CompanyName FROM [Users] u left join Companys c on u.CompanyID=c.ComID ";
string strSelAttrsOrderBy = string.Format(@" Order BY {0} ", strOrderby);
string strSelPageModel = string.Format(@"SELECT * FROM(
SELECT ROW_NUMBER() OVER(
Order BY {0}) as INDEX_ID,u.*,c.CompanyName FROM [Users] u left join Companys c on u.CompanyID=c.ComID ", strOrderby);
string strWherePageModel = @") NEW_TB WHERE INDEX_ID BETWEEN @Strat AND @End;";
StringBuilder strWhere = new StringBuilder();
strWhere.Append(" WHERE IsDelete=0 ");
switch (request.SearchType)
{
case SearchUsersType.All:
if (request.IsSunnet)
{
strWhere.Append(" AND [UserType] = 'SUNNET'");
}
if (request.IsClient)
{
strWhere.Append(" AND [UserType] = 'CLIENT'");
}
//if (!string.IsNullOrEmpty(request.Status) && request.Status.ToUpper() != "ALL")
//{
// strWhere.Append(" AND u.Status=@Status ");
//}
strWhere.Append(" AND u.Status='ACTIVE'");
break;
case SearchUsersType.List:
strWhere.Append(" AND ( UserName like @Keywords OR FirstName like @Keywords OR LastName like @Keywords )");
if (request.CompanyID != 0)
{
strWhere.AppendFormat(" AND (CompanyID={0})", request.CompanyID);
}
if (!string.IsNullOrEmpty(request.Status) && request.Status.ToUpper() != "All".ToUpper())
{
strWhere.Append(" AND u.Status=@Status ");
}
break;
case SearchUsersType.Company:
strWhere.Append(" AND u.Status='ACTIVE'");
strWhere.Append(" AND u.CompanyID =@CompanyID");
break;
case SearchUsersType.CompanyByProject:
strWhere.Append(" AND u.Status='ACTIVE'");
strWhere.Append(" AND u.CompanyID IN (SELECT CompanyID FROM Projects WHERE ProjectID = @ProjectID )");
break;
case SearchUsersType.Project:
strWhere.Append(" AND u.Status='ACTIVE'");
strWhere.Append(" AND u.UserID IN (SELECT UserID FROM ProjectUsers WHERE ProjectID = @ProjectID)");
break;
case SearchUsersType.Role:
strWhere.Append(" AND u.RoleID =@RoleID ");
strWhere.Append(" AND u.Status='ACTIVE'");
break;
case SearchUsersType.Ticket:
strWhere.Append(" AND u.UserID in ( SELECT [UserID] FROM [TicketUsers] WHERE [TicketID]=@TicketID)");
break;
default: break;
}
StringBuilder strSql = new StringBuilder();
if (request.IsPageModel)
{
strSql.Append(strSelCount);
strSql.Append(strWhere);
strSql.Append(";");
strSql.Append(strSelPageModel);
strSql.Append(strWhere);
strSql.Append(strWherePageModel);
}
else
{
strSql.Append(strSelAttrs);
strSql.Append(strWhere);
strSql.Append(strSelAttrsOrderBy);
strSql.Append(";");
}
SearchUserResponse response = new SearchUserResponse();
List <UsersEntity> list;
Database db = DatabaseFactory.CreateDatabase();
using (DbCommand dbCommand = db.GetSqlStringCommand(strSql.ToString()))
{
try
{
db.AddInParameter(dbCommand, "UserID", DbType.Int32, request.UserID);
db.AddInParameter(dbCommand, "Keywords", DbType.String, string.Format("%{0}%", request.Keywords.FilterSqlString()));
db.AddInParameter(dbCommand, "Status", DbType.String, request.Status);
db.AddInParameter(dbCommand, "CompanyID", DbType.Int32, request.CompanyID);
db.AddInParameter(dbCommand, "ProjectID", DbType.Int32, request.ProjectID);
db.AddInParameter(dbCommand, "RoleID", DbType.Int32, (int)request.Role);
db.AddInParameter(dbCommand, "TicketID", DbType.Int32, request.TicketID);
db.AddInParameter(dbCommand, "Strat", DbType.Int32, start);
db.AddInParameter(dbCommand, "End", DbType.Int32, end);
using (IDataReader dataReader = db.ExecuteReader(dbCommand))
{
list = new List <UsersEntity>();
if (request.IsPageModel)
{
if (dataReader.Read())
{
response.ResultCount = dataReader.GetInt32(0);
dataReader.NextResult();
}
}
while (dataReader.Read())
{
list.Add(UsersEntity.ReaderBind(dataReader));
}
response.ResultList = list;
}
}
catch (Exception ex)
{
WebLogAgent.Write(string.Format("[SQLText:{0},{1}Messages:\r\n{2}]",
strSql.ToString(),
base.FormatParameters(dbCommand.Parameters),
ex.Message));
}
}
return(response);
}
