/// <summary>
/// 获取单个代码集表
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public ReturnBody <CodeSetsEntity> GetSingleCodeSets(QueryCodeSetsModel model)
{
ExceptionInfoEntity exception = WipLogHelper.GetExceptionInfo <QueryCodeSetsModel>(namespaceName, "GetSingleCodeSets", model);
try
{
#region 验证
if (model == null || string.IsNullOrEmpty(model.code))
{
exception.exceptionMsg = ResMsg.PARAMETERNOEMPTY;
return(BLLHelpler.GetReturnBody <CodeSetsEntity>(ResCode.PARAMETERNOEMPTY, exception.exceptionMsg, exception));
}
#endregion
var retModel = codeSetsBLL.GetModel(model.code.ToString());
if (retModel == null)
{
exception.exceptionMsg = "没有找到数据";
return(BLLHelpler.GetReturnBody <CodeSetsEntity>(ResCode.FAILURE, exception.exceptionMsg, exception));
}
return(BLLHelpler.GetReturnBody <CodeSetsEntity>(ResCode.SUCCESS, ResMsg.SUCCESS, retModel));
}
catch (Exception ex)
{
WipLogHelper.GetExceptionInfoForError(ex, ref exception);
return(BLLHelpler.GetReturnBody <CodeSetsEntity>(ResCode.FAILURE, ResMsg.FAILURE, exception));
}
}
/// <summary>
/// 获得代码集表数据列表(分页)
/// </summary>
/// <param name="strOrderBy">排序字段</param>
/// <param name="strWhere">查询条件</param>
/// <param name="model">分页实体数据</param>
/// <returns>代码集表列表DataSet</returns>
public DataSet GetListForPage(string strOrderBy, string strWhere, QueryCodeSetsModel model)
{
SqlParameter[] parameters =
{
new SqlParameter("@strOrderBy", SqlDbType.NVarChar, 50),
new SqlParameter("@strWhere", SqlDbType.NVarChar, 500),
new SqlParameter("@pageIndex", SqlDbType.Int),
new SqlParameter("@pageSize", SqlDbType.Int),
};
parameters[0].Value = strOrderBy;
parameters[1].Value = strWhere;
parameters[2].Value = model.pageIndex;
parameters[3].Value = model.pageSize;
return(SQLServerHelper.RunProcedure("uspWip_GetCodeSetsPageList", parameters, "pagetable"));
}
/// <summary>
/// 禁启用代码集表
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public ReturnBody <bool> EnableCodeSets(QueryCodeSetsModel model)
{
ExceptionInfoEntity exception = WipLogHelper.GetExceptionInfo <QueryCodeSetsModel>(namespaceName, "EnableCodeSets", model);
try
{
#region 验证
if (model == null || string.IsNullOrEmpty(model.code))
{
exception.exceptionMsg = ResMsg.PARAMETERNOEMPTY;
return(BLLHelpler.GetReturnBody <bool>(ResCode.PARAMETERNOEMPTY, exception.exceptionMsg, exception));
}
#endregion
string lastModifier = JwtHelp.GetCurUserName();
var result = codeSetsBLL.Enable(model.code.ToString(), model.delFlag, lastModifier);
return(BLLHelpler.GetReturnBody <bool>(ResCode.SUCCESS, ResMsg.SUCCESS, result));
}
catch (Exception ex)
{
WipLogHelper.GetExceptionInfoForError(ex, ref exception);
return(BLLHelpler.GetReturnBody <bool>(ResCode.FAILURE, ResMsg.FAILURE, exception));
}
}
/// <summary>
/// 获取代码集表列表（分页）
/// </summary>
/// <returns></returns>
public ReturnBody <PageResultModel <CodeSetsEntity> > GetCodeSetsList(QueryCodeSetsModel queryModel)
{
var strOrderBy = " codeSets.lastModifyTime DESC";
var strWhere = "";
ExceptionInfoEntity exception = WipLogHelper.GetExceptionInfo <QueryCodeSetsModel>(namespaceName, "GetCodeSetsList", queryModel);
try
{
if (queryModel != null)
{
if (!string.IsNullOrEmpty(queryModel.code))
{
strWhere += " codeSets.code LIKE '%" + queryModel.code + "%',";
}
if (!string.IsNullOrEmpty(queryModel.name))
{
strWhere += " codeSets.name LIKE '%" + queryModel.name + "%',";
}
if (!string.IsNullOrEmpty(queryModel.delFlag))
{
strWhere += " codeSets.delFlag ='" + queryModel.delFlag + "',";
}
if (!string.IsNullOrEmpty(strWhere))
{
strWhere = strWhere.Substring(0, strWhere.Length - 1);
}
}
PageResultModel <CodeSetsEntity> list = codeSetsBLL.GetModelListForPage(strOrderBy, strWhere, queryModel);
return(BLLHelpler.GetReturnBody <PageResultModel <CodeSetsEntity> >(ResCode.SUCCESS, ResMsg.SUCCESS, list));
}
catch (Exception ex)
{
WipLogHelper.GetExceptionInfoForError(ex, ref exception);
return(BLLHelpler.GetReturnBody <PageResultModel <CodeSetsEntity> >(ResCode.FAILURE, ResMsg.FAILURE, exception));
}
}
/// <summary>
/// 获得代码集表数据列表(分页)
/// </summary>
/// <param name="strOrderBy">排序字段</param>
/// <param name="strWhere">查询条件</param>
/// <param name="model">分页数据</param>
/// <returns>代码集表分页数据</returns>
public PageResultModel <CodeSetsEntity> GetModelListForPage(string strOrderBy, string strWhere, QueryCodeSetsModel model)
{
DataSet ds = codeSetsDAL.GetListForPage(strOrderBy, strWhere, model);
List <CodeSetsEntity> list = DataTableToList(ds.Tables[0]);
int total = codeSetsDAL.GetRecordCount(strWhere);
PageResultModel <CodeSetsEntity> result = new PageResultModel <CodeSetsEntity>();
result.total = total;
result.rows = list;
return(result);
}
public string GetSingleCodeSets0(QueryCodeSetsModel model)
{
return("ok");
}
