public static QueryResponseDTO <List <ShoppingCartModel> > GetShoppingCartInfo(ShoppingCartDTO dto)
{
QueryResponseDTO <List <ShoppingCartModel> > responseDTO = new QueryResponseDTO <List <ShoppingCartModel> >();
CustomDataCommand dataCommand = DataCommandManager.CreateCustomDataCommandFromConfig("GetShoppingCartInfo");
using (DynamicQuerySqlBuilder sqlBuilder = new DynamicQuerySqlBuilder(
dataCommand.CommandText, dataCommand, dto.PagingInfo, "ID ASC"))
{
if (null != dto)
{
if (!string.IsNullOrEmpty(dto.UserID))
{
sqlBuilder.ConditionConstructor
.AddCondition(QueryConditionRelationType.AND, "UserID", DbType.AnsiString, "@UserID", QueryConditionOperatorType.Equal, dto.UserID);
}
if (!string.IsNullOrEmpty(dto.SellerID))
{
sqlBuilder.ConditionConstructor
.AddCondition(QueryConditionRelationType.AND, "SellerID", DbType.AnsiString, "@SellerID", QueryConditionOperatorType.Equal, dto.SellerID);
}
}
//QueryData
dataCommand.CommandText = sqlBuilder.BuildQuerySql();
var result = dataCommand.ExecuteEntityList <ShoppingCartModel>();
responseDTO.ResultEntity = result;
}
responseDTO.TotalCount = dto.PagingInfo.TotalCount;
responseDTO.Code = ResponseStaticModel.Code.OK;
responseDTO.Message = ResponseStaticModel.Message.OK;
return(responseDTO);
}
/// <summary>
/// GetUserInfo
/// </summary>
/// <param name="dto"></param>
/// <returns></returns>
public static QueryResponseDTO <List <ProductModel> > GetProductInfo(ProductDTO dto)
{
QueryResponseDTO <List <ProductModel> > responseDTO = new QueryResponseDTO <List <ProductModel> >();
CustomDataCommand dataCommand = DataCommandManager.CreateCustomDataCommandFromConfig("GetProductInfo");
using (DynamicQuerySqlBuilder sqlBuilder = new DynamicQuerySqlBuilder(
dataCommand.CommandText, dataCommand, dto.PagingInfo, "ID ASC"))
{
if (null != dto)
{
if (!string.IsNullOrEmpty(dto.ProductID))
{
sqlBuilder.ConditionConstructor
.AddCondition(QueryConditionRelationType.AND, "ProductID", DbType.AnsiString, "@ProductID", QueryConditionOperatorType.Equal, dto.ProductID);
}
if (dto.Stock > 0)
{
sqlBuilder.ConditionConstructor
.AddCondition(QueryConditionRelationType.AND, "Stock", DbType.Int32, "@Stock", QueryConditionOperatorType.MoreThanOrEqual, dto.Stock);
}
if (!string.IsNullOrEmpty(dto.CategoryID))
{
sqlBuilder.ConditionConstructor
.AddCondition(QueryConditionRelationType.AND, "CategoryID", DbType.AnsiString, "@CategoryID", QueryConditionOperatorType.Equal, dto.CategoryID);
}
sqlBuilder.ConditionConstructor
.AddCondition(QueryConditionRelationType.AND, "IsPublish", DbType.Boolean, "@IsPublish", QueryConditionOperatorType.Equal, dto.IsPublish);
if (dto.OriginalPrice > 0)
{
sqlBuilder.ConditionConstructor
.AddCondition(QueryConditionRelationType.AND, "OriginalPrice", DbType.AnsiString, "@OriginalPrice", QueryConditionOperatorType.MoreThanOrEqual, dto.OriginalPrice);
}
if (dto.LastEditDate != null)
{
sqlBuilder.ConditionConstructor
.AddCondition(QueryConditionRelationType.AND, "LastEditDate", DbType.DateTime, "@LastEditDate", QueryConditionOperatorType.MoreThanOrEqual, dto.LastEditDate);
}
if (dto.Discount > 0)
{
sqlBuilder.ConditionConstructor
.AddCondition(QueryConditionRelationType.AND, "Discount", DbType.Int32, "@Discount", QueryConditionOperatorType.MoreThanOrEqual, dto.Discount);
}
}
//QueryData
dataCommand.CommandText = sqlBuilder.BuildQuerySql();
var result = dataCommand.ExecuteEntityList <ProductModel>();
responseDTO.ResultEntity = result;
}
responseDTO.TotalCount = dto.PagingInfo.TotalCount;
responseDTO.Code = ResponseStaticModel.Code.OK;
responseDTO.Message = ResponseStaticModel.Message.OK;
return(responseDTO);
}
public static QueryResponseDTO <List <TransactionHistoryModel> > GetTransactionInfo(TransactionDTO dto)
{
QueryResponseDTO <List <TransactionHistoryModel> > responseDTO = new QueryResponseDTO <List <TransactionHistoryModel> >();
CustomDataCommand dataCommand = DataCommandManager.CreateCustomDataCommandFromConfig("GetTransactionInfo");
using (DynamicQuerySqlBuilder sqlBuilder = new DynamicQuerySqlBuilder(
dataCommand.CommandText, dataCommand, dto.PagingInfo, "ID ASC"))
{
if (null != dto)
{
if (!string.IsNullOrEmpty(dto.TransactionNumber))
{
sqlBuilder.ConditionConstructor
.AddCondition(QueryConditionRelationType.AND, "TransactionNumber", DbType.AnsiString, "@TransactionNumber", QueryConditionOperatorType.Equal, dto.TransactionNumber);
}
if (!string.IsNullOrEmpty(dto.FromUser))
{
sqlBuilder.ConditionConstructor
.AddCondition(QueryConditionRelationType.AND, "FromUser", DbType.AnsiString, "@FromUser", QueryConditionOperatorType.Equal, dto.FromUser);
}
if (!string.IsNullOrEmpty(dto.ToUser))
{
sqlBuilder.ConditionConstructor
.AddCondition(QueryConditionRelationType.AND, "ToUser", DbType.AnsiString, "@ToUser", QueryConditionOperatorType.Equal, dto.ToUser);
}
if (dto.State > 0)
{
sqlBuilder.ConditionConstructor
.AddCondition(QueryConditionRelationType.AND, "State", DbType.Int32, "@State", QueryConditionOperatorType.Equal, dto.State);
}
if (dto.Status > 0)
{
sqlBuilder.ConditionConstructor
.AddCondition(QueryConditionRelationType.AND, "Status", DbType.Int32, "@Status", QueryConditionOperatorType.Equal, dto.Status);
}
if (dto.Number > 0)
{
sqlBuilder.ConditionConstructor
.AddCondition(QueryConditionRelationType.AND, "Number", DbType.Int32, "@Number", QueryConditionOperatorType.Equal, dto.Number);
}
}
//QueryData
dataCommand.CommandText = sqlBuilder.BuildQuerySql();
var result = dataCommand.ExecuteEntityList <TransactionHistoryModel>();
responseDTO.ResultEntity = result;
}
responseDTO.TotalCount = dto.PagingInfo.TotalCount;
responseDTO.Code = ResponseStaticModel.Code.OK;
responseDTO.Message = ResponseStaticModel.Message.OK;
return(responseDTO);
}
public static QueryResponseDTO <bool> DeletePostHistoryInfo(PostDTO dto)
{
QueryResponseDTO <bool> response = new QueryResponseDTO <bool>();
response.ResultEntity = false;
CustomDataCommand dataCommand = DataCommandManager.CreateCustomDataCommandFromConfig("RemovePostHistoryInfo");
using (DynamicQuerySqlBuilder sqlBuilder = new DynamicQuerySqlBuilder(
dataCommand.CommandText, dataCommand, dto.PagingInfo, "ID ASC"))
{
if (null != dto)
{
if (!string.IsNullOrEmpty(dto.PostID))
{
sqlBuilder.ConditionConstructor
.AddCondition(QueryConditionRelationType.AND, "PostID", DbType.AnsiString, "@PostID", QueryConditionOperatorType.Equal, dto.PostID);
}
if (dto.PostCost > 0)
{
sqlBuilder.ConditionConstructor
.AddCondition(QueryConditionRelationType.AND, "PostCost", DbType.Int32, "@PostCost", QueryConditionOperatorType.LessThanOrEqual, dto.PostCost);
}
if (dto.PostSpeed > 0)
{
sqlBuilder.ConditionConstructor
.AddCondition(QueryConditionRelationType.AND, "PostSpeed", DbType.Int32, "@PostSpeed", QueryConditionOperatorType.MoreThanOrEqual, dto.PostSpeed);
}
if (dto.PostStart > 0)
{
sqlBuilder.ConditionConstructor
.AddCondition(QueryConditionRelationType.AND, "PostStart", DbType.Int32, "@PostStart", QueryConditionOperatorType.LessThanOrEqual, dto.PostStart);
}
}
//QueryData
dataCommand.CommandText = sqlBuilder.BuildQuerySql();
var updateRows = dataCommand.ExecuteNonQuery();
if (updateRows > 0)
{
response.ResultEntity = true;
response.Code = ResponseStaticModel.Code.OK;
response.Message = ResponseStaticModel.Message.OK;
}
else
{
response.ResultEntity = false;
response.Code = ResponseStaticModel.Code.FAILED;
response.Message = ResponseStaticModel.Message.FAILED;
}
}
return(response);
}
/// <summary>
/// GetUserInfo
/// </summary>
/// <param name="dto"></param>
/// <returns></returns>
public static QueryResponseDTO <List <PostHistoryModel> > GetPostHistoryInfo(PostDTO dto)
{
QueryResponseDTO <List <PostHistoryModel> > responseDTO = new QueryResponseDTO <List <PostHistoryModel> >();
CustomDataCommand dataCommand = DataCommandManager.CreateCustomDataCommandFromConfig("GetPostHistoryInfo");
using (DynamicQuerySqlBuilder sqlBuilder = new DynamicQuerySqlBuilder(
dataCommand.CommandText, dataCommand, dto.PagingInfo, "ID ASC"))
{
if (null != dto)
{
if (!string.IsNullOrEmpty(dto.PostID))
{
sqlBuilder.ConditionConstructor
.AddCondition(QueryConditionRelationType.AND, "PostID", DbType.AnsiString, "@PostID", QueryConditionOperatorType.Equal, dto.PostID);
}
if (dto.PostCost > 0)
{
sqlBuilder.ConditionConstructor
.AddCondition(QueryConditionRelationType.AND, "PostCost", DbType.Int32, "@PostCost", QueryConditionOperatorType.LessThanOrEqual, dto.PostCost);
}
if (dto.PostSpeed > 0)
{
sqlBuilder.ConditionConstructor
.AddCondition(QueryConditionRelationType.AND, "PostSpeed", DbType.Int32, "@PostSpeed", QueryConditionOperatorType.MoreThanOrEqual, dto.PostSpeed);
}
if (dto.PostStart > 0)
{
sqlBuilder.ConditionConstructor
.AddCondition(QueryConditionRelationType.AND, "PostStart", DbType.Int32, "@PostStart", QueryConditionOperatorType.LessThanOrEqual, dto.PostStart);
}
}
//QueryData
dataCommand.CommandText = sqlBuilder.BuildQuerySql();
var result = dataCommand.ExecuteEntityList <PostHistoryModel>();
responseDTO.ResultEntity = result;
}
responseDTO.TotalCount = dto.PagingInfo.TotalCount;
responseDTO.Code = ResponseStaticModel.Code.OK;
responseDTO.Message = ResponseStaticModel.Message.OK;
return(responseDTO);
}
public static QueryResponseDTO <bool> AlterReviewVote(ReviewDTO dto)
{
QueryResponseDTO <bool> response = new QueryResponseDTO <bool>();
response.ResultEntity = false;
DataCommand dataCommand = null;
if (dto.VoteFaour)
{
//vote favour
dataCommand = DataCommandManager.GetDataCommand("FavourReview");
}
else
{
//vote oppose
dataCommand = DataCommandManager.GetDataCommand("OpposeReview");
}
var updateRows = 0;
updateRows = dataCommand.ExecuteNonQuery(dto);
if (updateRows <= 0)
{
response.ResultEntity = false;
response.Code = ResponseStaticModel.Code.FAILED;
response.Message = ResponseStaticModel.Message.FAILED;
}
dataCommand = DataCommandManager.GetDataCommand("UpdateVoteReviewUser");
updateRows = dataCommand.ExecuteNonQuery(dto);
if (updateRows > 0)
{
response.ResultEntity = true;
response.Code = ResponseStaticModel.Code.OK;
response.Message = ResponseStaticModel.Message.OK;
}
else
{
response.ResultEntity = false;
response.Code = ResponseStaticModel.Code.FAILED;
response.Message = ResponseStaticModel.Message.FAILED;
}
return(response);
}
public static QueryResponseDTO <bool> AddShoppingCartInfo(ShoppingCartDTO dto)
{
QueryResponseDTO <bool> response = new QueryResponseDTO <bool>();
response.ResultEntity = false;
var dataCommand = DataCommandManager.GetDataCommand("AddShoppingCartInfo");
var updateRows = dataCommand.ExecuteNonQuery(dto);
if (updateRows > 0)
{
response.ResultEntity = true;
response.Code = ResponseStaticModel.Code.OK;
response.Message = ResponseStaticModel.Message.OK;
}
else
{
response.ResultEntity = false;
response.Code = ResponseStaticModel.Code.FAILED;
response.Message = ResponseStaticModel.Message.FAILED;
}
return(response);
}
private static QueryResponseDTO <bool> AlterUserInfo(UserDTO dto, string commandName)
{
QueryResponseDTO <bool> response = new QueryResponseDTO <bool>();
response.ResultEntity = false;
var dataCommand = DataCommandManager.GetDataCommand(commandName);
var updateRows = dataCommand.ExecuteNonQuery(dto);
if (updateRows > 0)
{
response.ResultEntity = true;
response.Code = ResponseStaticModel.Code.OK;
response.Message = ResponseStaticModel.Message.OK;
}
else
{
response.ResultEntity = false;
response.Code = ResponseStaticModel.Code.FAILED;
response.Message = ResponseStaticModel.Message.FAILED;
}
return(response);
}
public static QueryResponseDTO <bool> AlterProductStock(List <ProductModel> model)
{
QueryResponseDTO <bool> response = new QueryResponseDTO <bool>();
response.ResultEntity = false;
var dataCommand = DataCommandManager.GetDataCommand("AlterProductStock");
var updateRows = dataCommand.ExecuteNonQuery(model);
if (updateRows > 0)
{
response.ResultEntity = true;
response.Code = ResponseStaticModel.Code.OK;
response.Message = ResponseStaticModel.Message.OK;
}
else
{
response.ResultEntity = false;
response.Code = ResponseStaticModel.Code.FAILED;
response.Message = ResponseStaticModel.Message.FAILED;
}
return(response);
}
public static QueryResponseDTO <bool> DeleteReviewInfo(ReviewDTO dto)
{
QueryResponseDTO <bool> response = new QueryResponseDTO <bool>();
response.ResultEntity = false;
CustomDataCommand dataCommand = DataCommandManager.CreateCustomDataCommandFromConfig("RemoveReviewInfo");
using (DynamicQuerySqlBuilder sqlBuilder = new DynamicQuerySqlBuilder(
dataCommand.CommandText, dataCommand, dto.PagingInfo, "ID ASC"))
{
if (null != dto)
{
if (!string.IsNullOrEmpty(dto.UserID))
{
sqlBuilder.ConditionConstructor
.AddCondition(QueryConditionRelationType.AND, "UserID", DbType.AnsiString, "@UserID", QueryConditionOperatorType.Equal, dto.UserID);
}
if (!string.IsNullOrEmpty(dto.ReviewID))
{
sqlBuilder.ConditionConstructor
.AddCondition(QueryConditionRelationType.AND, "ReviewID", DbType.AnsiString, "@ReviewID", QueryConditionOperatorType.Equal, dto.ReviewID);
}
if (!string.IsNullOrEmpty(dto.ProductOROrderID))
{
sqlBuilder.ConditionConstructor
.AddCondition(QueryConditionRelationType.AND, "ProductOROrderID", DbType.AnsiString, "@ProductOROrderID", QueryConditionOperatorType.Equal, dto.ProductOROrderID);
}
if (null != dto.ReviewDate)
{
sqlBuilder.ConditionConstructor
.AddCondition(QueryConditionRelationType.AND, "ReviewDate", DbType.DateTime, "@ReviewDate", QueryConditionOperatorType.Equal, dto.ReviewDate);
}
if (dto.Score > 0)
{
sqlBuilder.ConditionConstructor
.AddCondition(QueryConditionRelationType.AND, "Score", DbType.Int32, "@Score", QueryConditionOperatorType.Equal, dto.Score);
}
if (dto.FavourCount > 0)
{
sqlBuilder.ConditionConstructor
.AddCondition(QueryConditionRelationType.AND, "FavourCount", DbType.Int32, "@FavourCount", QueryConditionOperatorType.Equal, dto.FavourCount);
}
if (dto.OpposeCount > 0)
{
sqlBuilder.ConditionConstructor
.AddCondition(QueryConditionRelationType.AND, "OpposeCount", DbType.Int32, "@OpposeCount", QueryConditionOperatorType.Equal, dto.OpposeCount);
}
sqlBuilder.ConditionConstructor
.AddCondition(QueryConditionRelationType.AND, "CheckPassed", DbType.Boolean, "@CheckPassed", QueryConditionOperatorType.Equal, dto.CheckPassed);
}
//QueryData
dataCommand.CommandText = sqlBuilder.BuildQuerySql();
var updateRows = dataCommand.ExecuteNonQuery();
if (updateRows > 0)
{
response.ResultEntity = true;
response.Code = ResponseStaticModel.Code.OK;
response.Message = ResponseStaticModel.Message.OK;
}
else
{
response.ResultEntity = false;
response.Code = ResponseStaticModel.Code.FAILED;
response.Message = ResponseStaticModel.Message.FAILED;
}
}
return(response);
}
public static QueryResponseDTO <List <ReviewModel> > GetReviewInfo(ReviewDTO dto)
{
QueryResponseDTO <List <ReviewModel> > responseDTO = new QueryResponseDTO <List <ReviewModel> >();
CustomDataCommand dataCommand = DataCommandManager.CreateCustomDataCommandFromConfig("GetReviewInfo");
using (DynamicQuerySqlBuilder sqlBuilder = new DynamicQuerySqlBuilder(
dataCommand.CommandText, dataCommand, dto.PagingInfo, "ID ASC"))
{
if (null != dto)
{
if (!string.IsNullOrEmpty(dto.UserID))
{
sqlBuilder.ConditionConstructor
.AddCondition(QueryConditionRelationType.AND, "UserID", DbType.AnsiString, "@UserID", QueryConditionOperatorType.Equal, dto.UserID);
}
if (!string.IsNullOrEmpty(dto.ReviewID))
{
sqlBuilder.ConditionConstructor
.AddCondition(QueryConditionRelationType.AND, "ReviewID", DbType.AnsiString, "@ReviewID", QueryConditionOperatorType.Equal, dto.ReviewID);
}
if (!string.IsNullOrEmpty(dto.ProductOROrderID))
{
sqlBuilder.ConditionConstructor
.AddCondition(QueryConditionRelationType.AND, "ProductOROrderID", DbType.AnsiString, "@ProductOROrderID", QueryConditionOperatorType.Equal, dto.ProductOROrderID);
}
if (null != dto.ReviewDate)
{
sqlBuilder.ConditionConstructor
.AddCondition(QueryConditionRelationType.AND, "ReviewDate", DbType.DateTime, "@ReviewDate", QueryConditionOperatorType.Equal, dto.ReviewDate);
}
if (dto.Score > 0)
{
sqlBuilder.ConditionConstructor
.AddCondition(QueryConditionRelationType.AND, "Score", DbType.Int32, "@Score", QueryConditionOperatorType.Equal, dto.Score);
}
if (dto.FavourCount > 0)
{
sqlBuilder.ConditionConstructor
.AddCondition(QueryConditionRelationType.AND, "FavourCount", DbType.Int32, "@FavourCount", QueryConditionOperatorType.Equal, dto.FavourCount);
}
if (dto.OpposeCount > 0)
{
sqlBuilder.ConditionConstructor
.AddCondition(QueryConditionRelationType.AND, "OpposeCount", DbType.Int32, "@OpposeCount", QueryConditionOperatorType.Equal, dto.OpposeCount);
}
sqlBuilder.ConditionConstructor
.AddCondition(QueryConditionRelationType.AND, "CheckPassed", DbType.Boolean, "@CheckPassed", QueryConditionOperatorType.Equal, dto.CheckPassed);
}
//QueryData
dataCommand.CommandText = sqlBuilder.BuildQuerySql();
var result = dataCommand.ExecuteEntityList <ReviewModel>();
responseDTO.ResultEntity = result;
}
responseDTO.TotalCount = dto.PagingInfo.TotalCount;
responseDTO.Code = ResponseStaticModel.Code.OK;
responseDTO.Message = ResponseStaticModel.Message.OK;
return(responseDTO);
}
public static QueryResponseDTO <bool> DeleteProductInfo(ProductDTO dto)
{
QueryResponseDTO <bool> response = new QueryResponseDTO <bool>();
response.ResultEntity = false;
CustomDataCommand dataCommand = DataCommandManager.CreateCustomDataCommandFromConfig("RemoveProductInfo");
foreach (var model in dto.ProductModel)
{
using (DynamicQuerySqlBuilder sqlBuilder = new DynamicQuerySqlBuilder(
dataCommand.CommandText, dataCommand, dto.PagingInfo, "ID ASC"))
{
if (null != dto)
{
if (!string.IsNullOrEmpty(model.ProductID))
{
sqlBuilder.ConditionConstructor
.AddCondition(QueryConditionRelationType.AND, "ProductID", DbType.AnsiString, "@ProductID", QueryConditionOperatorType.Equal, model.ProductID);
}
if (model.Stock > 0)
{
sqlBuilder.ConditionConstructor
.AddCondition(QueryConditionRelationType.AND, "Stock", DbType.Int32, "@Stock", QueryConditionOperatorType.MoreThanOrEqual, model.Stock);
}
if (!string.IsNullOrEmpty(model.CategoryID))
{
sqlBuilder.ConditionConstructor
.AddCondition(QueryConditionRelationType.AND, "CategoryID", DbType.AnsiString, "@CategoryID", QueryConditionOperatorType.Equal, model.CategoryID);
}
sqlBuilder.ConditionConstructor
.AddCondition(QueryConditionRelationType.AND, "IsPublish", DbType.Boolean, "@IsPublish", QueryConditionOperatorType.Equal, model.IsPublish);
if (model.OriginalPrice > 0)
{
sqlBuilder.ConditionConstructor
.AddCondition(QueryConditionRelationType.AND, "OriginalPrice", DbType.AnsiString, "@OriginalPrice", QueryConditionOperatorType.MoreThanOrEqual, model.OriginalPrice);
}
if (dto.LastEditDate != null)
{
sqlBuilder.ConditionConstructor
.AddCondition(QueryConditionRelationType.AND, "LastEditDate", DbType.DateTime, "@LastEditDate", QueryConditionOperatorType.MoreThanOrEqual, model.LastEditDate);
}
if (model.Discount > 0)
{
sqlBuilder.ConditionConstructor
.AddCondition(QueryConditionRelationType.AND, "Discount", DbType.Int32, "@Discount", QueryConditionOperatorType.MoreThanOrEqual, model.Discount);
}
}
//QueryData
dataCommand.CommandText = sqlBuilder.BuildQuerySql();
var updateRows = dataCommand.ExecuteNonQuery();
if (updateRows > 0)
{
response.ResultEntity = true;
response.Code = ResponseStaticModel.Code.OK;
response.Message = ResponseStaticModel.Message.OK;
}
else
{
response.ResultEntity = false;
response.Code = ResponseStaticModel.Code.FAILED;
response.Message = ResponseStaticModel.Message.FAILED;
}
}
}
return(response);
}
public static QueryResponseDTO <bool> DeleteTransactionInfo(TransactionDTO dto)
{
QueryResponseDTO <bool> response = new QueryResponseDTO <bool>();
response.ResultEntity = false;
CustomDataCommand dataCommand = DataCommandManager.CreateCustomDataCommandFromConfig("RemoveTransactionInfo");
using (DynamicQuerySqlBuilder sqlBuilder = new DynamicQuerySqlBuilder(
dataCommand.CommandText, dataCommand, dto.PagingInfo, "ID ASC"))
{
if (null != dto)
{
if (!string.IsNullOrEmpty(dto.TransactionNumber))
{
sqlBuilder.ConditionConstructor
.AddCondition(QueryConditionRelationType.AND, "TransactionNumber", DbType.AnsiString, "@TransactionNumber", QueryConditionOperatorType.Equal, dto.TransactionNumber);
}
if (!string.IsNullOrEmpty(dto.FromUser))
{
sqlBuilder.ConditionConstructor
.AddCondition(QueryConditionRelationType.AND, "FromUser", DbType.AnsiString, "@FromUser", QueryConditionOperatorType.Equal, dto.FromUser);
}
if (!string.IsNullOrEmpty(dto.ToUser))
{
sqlBuilder.ConditionConstructor
.AddCondition(QueryConditionRelationType.AND, "ToUser", DbType.AnsiString, "@ToUser", QueryConditionOperatorType.Equal, dto.ToUser);
}
if (dto.State > 0)
{
sqlBuilder.ConditionConstructor
.AddCondition(QueryConditionRelationType.AND, "State", DbType.Int32, "@State", QueryConditionOperatorType.Equal, dto.State);
}
if (dto.Status > 0)
{
sqlBuilder.ConditionConstructor
.AddCondition(QueryConditionRelationType.AND, "Status", DbType.Int32, "@Status", QueryConditionOperatorType.Equal, dto.Status);
}
if (dto.Number > 0)
{
sqlBuilder.ConditionConstructor
.AddCondition(QueryConditionRelationType.AND, "Number", DbType.Int32, "@Number", QueryConditionOperatorType.Equal, dto.Number);
}
}
//QueryData
dataCommand.CommandText = sqlBuilder.BuildQuerySql();
var updateRows = dataCommand.ExecuteNonQuery();
if (updateRows > 0)
{
response.ResultEntity = true;
response.Code = ResponseStaticModel.Code.OK;
response.Message = ResponseStaticModel.Message.OK;
}
else
{
response.ResultEntity = false;
response.Code = ResponseStaticModel.Code.FAILED;
response.Message = ResponseStaticModel.Message.FAILED;
}
}
return(response);
}
