public DataTableModel<LogContentExtendedModel> GetAll()
{
var list = LogBLO.Current.GetAllLogIP();
var result = new DataTableModel<LogContentExtendedModel>();
result.Data = list;
return result;
}
public DataTableModel<IPAddressPoolExtendedModel> GetAvailableIP()
{
var ips = IPAddressPoolBLO.Current.GetAvailableIPs();
var result = new DataTableModel<IPAddressPoolExtendedModel>();
result.Data = ips;
return result;
}
public DataTableModel<LocationViewModel> GetAll()
{
var locations = LocationBLO.Current.GetAllLocation();
var result = new DataTableModel<LocationViewModel>();
result.Data = locations;
return result;
}
public DataTableModel<LogUsedIPExtendModel> GetUsedIP()
{
var list = LogBLO.Current.GetLogUsedIP();
var result = new DataTableModel<LogUsedIPExtendModel>();
result.Data = list;
return result;
}
public DataTableModel<RackOfCustomerExtendedModel> GetRackOfCustomer(string customer)
{
var racks = RackOfCustomerBLO.Current.GetAllRackOfCustomer(customer);
var result = new DataTableModel<RackOfCustomerExtendedModel>();
result.Data = racks;
return result;
}
public DataTableModel<LocationViewModel> GetLocationForChange(string code)
{
var server = ServerBLO.Current.GetServerByCode(code, Constants.StatusCode.SERVER_RUNNING);
var locations = LocationBLO.Current.GetChangeLocation(server);
var result = new DataTableModel<LocationViewModel>();
result.Data = locations;
return result;
}
public ActionResult UserList(DataTableModel dt, UserModel condition)
{
if (ModelState.IsValid)
{
using (UserService service = new UserService())
{
int total_row = 0;
var dataList = service.SearchUserList(dt, condition, out total_row);
int order = 1;
int totalRowCount = dataList.Count();
int lastItem = dt.iDisplayLength + dt.iDisplayStart;
var result = Json(
new
{
sEcho = dt.sEcho,
iTotalRecords = total_row,
iTotalDisplayRecords = total_row,
aaData = (from i in dataList
select new object[]
{
i.ID,
order++,
i.Email != null ? HttpUtility.HtmlEncode(i.Email) : String.Empty,
i.UserName != null ? HttpUtility.HtmlEncode(i.UserName) : String.Empty,
i.DistrictName != null ? HttpUtility.HtmlEncode(i.DistrictName) : String.Empty,
i.Receive_Address != null ? HttpUtility.HtmlEncode(i.Receive_Address) : String.Empty,
i.Phone != null ? HttpUtility.HtmlEncode(i.Phone) : String.Empty,
i.CreatedDate != null ? i.CreatedDate.Value.ToString("dd/MM/yyyy") : String.Empty,
i.Status == true? "Đã kích hoạt" : "Chưa kích hoạt",
i.del_flg
})
});
SaveRestoreData(condition);
result.MaxJsonLength = Int32.MaxValue;
return(result);
}
}
else
{
var ErrorMessages = ModelState.Where(x => x.Value.Errors.Count > 0).Select(x => new { x.Key, x.Value.Errors }).ToArray();
}
return(new EmptyResult());
}
public void ExtractData()
{
EventMgr.Instance.TriggerEvent(GlobalEvent.DATA_LOAD_PROGRESS, "数据资源初始化...开始...", 3, 0);
tableMap = ResourcesMgr.Instance.LoadResource <DataTableMap>(DataPath + "DataTableMap.asset");
tableMap.Init();
m_DataDic.Add("DataTableMap", tableMap);
tableModel = ResourcesMgr.Instance.LoadResource <DataTableModel>(DataPath + "DataTableModel.asset");
tableModel.Init();
m_DataDic.Add("DataTableModel", tableModel);
tableMonster = ResourcesMgr.Instance.LoadResource <DataTableMonster>(DataPath + "DataTableMonster.asset");
tableMonster.Init();
m_DataDic.Add("DataTableMonster", tableMonster);
tableMonsterRefresh = ResourcesMgr.Instance.LoadResource <DataTableMonsterRefresh>(DataPath + "DataTableMonsterRefresh.asset");
tableMonsterRefresh.Init();
m_DataDic.Add("DataTableMonsterRefresh", tableMonsterRefresh);
tableNpc = ResourcesMgr.Instance.LoadResource <DataTableNpc>(DataPath + "DataTableNpc.asset");
tableNpc.Init();
m_DataDic.Add("DataTableNpc", tableNpc);
tableTransfer = ResourcesMgr.Instance.LoadResource <DataTableTransfer>(DataPath + "DataTableTransfer.asset");
tableTransfer.Init();
m_DataDic.Add("DataTableTransfer", tableTransfer);
EventMgr.Instance.TriggerEvent(GlobalEvent.DATA_LOAD_PROGRESS, "数据资源初始化中...", 3, 30);
EventMgr.Instance.TriggerEvent(GlobalEvent.DATA_LOAD_PROGRESS, "数据资源初始化中...", 3, 60);
tableUI = ResourcesMgr.Instance.LoadResource <DataTableUi>(DataPath + "DataTableUi.asset");
tableUI.Init();
m_DataDic.Add("DataTableUi", tableUI);
EventMgr.Instance.TriggerEvent(GlobalEvent.DATA_LOAD_PROGRESS, "数据资源初始化中...", 3, 90);
EventMgr.Instance.TriggerEvent(DataConst.DATA_LOAD_COMPLETE);
EventMgr.Instance.TriggerEvent(GlobalEvent.DATA_LOAD_PROGRESS, "数据资源初始化完成!!!", 3, 100);
}
void OnEnable()
{
selectTypeDic.Add(0, "Null");
selectTypeDic.Add(1, "PlayerBorn");
selectTypeDic.Add(2, "Monster");
selectTypeDic.Add(3, "MonsterRefresh");
selectTypeDic.Add(4, "Npc");
selectTypeDic.Add(5, "Transfer");
_scriptEditPath = EditorPrefs.GetString(SAVE_EDIT_PATH, _scriptEditPath);
_scriptClientPath = EditorPrefs.GetString(SAVE_CLIENT_PATH, _scriptClientPath);
tableMap = UnityEditor.AssetDatabase.LoadAssetAtPath <ScriptableObject>("Assets/Resources/Data/DataTableMap.asset") as DataTableMap;
tableMap.Init();
tableMapDic = tableMap.GetInfo();
tableMonster = UnityEditor.AssetDatabase.LoadAssetAtPath <ScriptableObject>("Assets/Resources/Data/DataTableMonster.asset") as DataTableMonster;
tableMonster.Init();
tableMonsterDic = tableMonster.GetInfo();
tableMonsterRefresh = UnityEditor.AssetDatabase.LoadAssetAtPath <ScriptableObject>("Assets/Resources/Data/DataTableMonsterRefresh.asset") as DataTableMonsterRefresh;
tableMonsterRefresh.Init();
tableMonsterRefreshDic = tableMonsterRefresh.GetInfo();
tableNpc = UnityEditor.AssetDatabase.LoadAssetAtPath <ScriptableObject>("Assets/Resources/Data/DataTableNpc.asset") as DataTableNpc;
tableNpc.Init();
tableNpcDic = tableNpc.GetInfo();
tableTransfer = UnityEditor.AssetDatabase.LoadAssetAtPath <ScriptableObject>("Assets/Resources/Data/DataTableTransfer.asset") as DataTableTransfer;
tableTransfer.Init();
tableTransferDic = tableTransfer.GetInfo();
tableModel = UnityEditor.AssetDatabase.LoadAssetAtPath <ScriptableObject>("Assets/Resources/Data/DataTableModel.asset") as DataTableModel;
tableModel.Init();
//ScriptableObject tempObj = UnityEditor.AssetDatabase.LoadAssetAtPath<ScriptableObject>("Assets/Resources/Data/DataTableUi.asset");
//DataTableUi testAsset = tempObj as DataTableUi;
//foreach (UiExcel gd in testAsset.DataList)
//{
// Debug.Log(gd.id);
// Debug.Log(gd.name);
//}
//testAsset.Init();
//UiExcel tempData = testAsset.GetInfoById(1);
//Debug.Log(tempData.id);
}
public IEnumerable <ProductModel> SearchProductList(DataTableModel dt, ProductModel model, out int total_row)
{
var lstProduct = (from pro in da.Product
join cate in da.Product_Category on pro.CategoryID equals cate.ID
join user in da.TblUser on pro.CreatedBy equals user.ID
from userB in da.TblUser.Where(i => i.ID == pro.ModifiedBy).DefaultIfEmpty()
//join userB in da.User.DefaultIfEmpty on pro.ModifiedBy equals userB.ID
where (pro.del_flg == model.del_flg && (!String.IsNullOrEmpty(model.Name) == true ? pro.Name.Contains(model.Name) : 1 == 1))
where (model.Status.HasValue ? pro.Status == model.Status : 1 == 1)
where (model.CategoryID > 0 ? pro.CategoryID == model.CategoryID : 1 == 1)
where (model.PriceBefore > 0 ? pro.PriceBefore == model.PriceBefore : 1 == 1)
where (model.Price > 0 ? pro.Price == model.Price : 1 == 1)
where (model.FromDate.HasValue ? pro.CreatedDate >= model.FromDate : 1 == 1)
where (model.ToDate.HasValue ? pro.CreatedDate <= model.ToDate : 1 == 1)
select new ProductModel
{
ID = pro.ID,
CategoryID = pro.CategoryID,
CATEGORY_NAME = cate.Name,
Name = pro.Name,
MetaTitle = pro.MetaTitle,
Detail = pro.Detail,
Image = pro.Image,
PriceBefore = pro.PriceBefore,
Price = pro.Price,
Promotion = pro.Promotion,
Quantity = pro.Quantity,
Discount = pro.Discount,
Is_Hot = pro.Is_Hot,
Unit = pro.Unit,
TopHot = pro.TopHot,
del_flg = pro.del_flg,
Status = cate.Status,
CreatedDate = pro.CreatedDate,
CreateName = user.UserName,
ModifiedDate = pro.ModifiedDate,
ModifiedName = userB.UserName
});
total_row = lstProduct.Count();
lstProduct = lstProduct.OrderByDescending(i => i.ModifiedDate).ThenByDescending(i => i.CreatedDate).Skip(dt.iDisplayStart).Take(dt.iDisplayLength);
return(lstProduct);
}
public void FormatDataTable(DataTableModel <ProductoFilterModel, int> dataTableModel)
{
for (int i = 0; i < dataTableModel.order.Count; i++)
{
var columnIndex = dataTableModel.order[0].column;
var columnDir = dataTableModel.order[0].dir.ToUpper();
var column = dataTableModel.columns[columnIndex].data;
dataTableModel.orderBy = (" [" + column + "] " + columnDir + " ");
}
string WhereModel = "WHERE P.prdc_bflag_estado IN(1,2)";
if (dataTableModel.filter.descripcionSearch != null)
{
WhereModel += " AND P.prdc_vdescripcion LIKE '%" + dataTableModel.filter.descripcionSearch + "%'";
}
dataTableModel.whereFilter = WhereModel;
}
public IActionResult Listar(DataTableModel <MaquinariaFilterDto> dataTableModel)
{
var jsonResponse = new JsonResponseDto()
{
Type = Constante.Error
};
try
{
FormatDataTable(dataTableModel);
var jsonResponseDto = new JsonResponseDto()
{
Type = Constante.Error
};
var paginationParameter = new PaginationParameter
{
Start = dataTableModel.start,
AmountRows = dataTableModel.length,
WhereFilter = dataTableModel.whereFilter,
OrderBy = dataTableModel.orderBy
};
List <MaquinariaPaginationDto> lstCampania = _Maquinaria.PaginadoMaquinaria(paginationParameter, dataTableModel.filter);
if (!string.IsNullOrWhiteSpace(dataTableModel.filter.DigitalizacionSearch))
{
lstCampania = lstCampania.Where(p => p.Digitalizacion == dataTableModel.filter.DigitalizacionSearch).ToList();
}
var tipo_empresa = GetTipoEmpresa();
var idEmpresa = GetEmpresa();
dataTableModel.data = lstCampania;
if (lstCampania.Count > 0)
{
dataTableModel.recordsTotal = lstCampania[0].Cantidad;
dataTableModel.recordsFiltered = dataTableModel.recordsTotal;
}
}
catch (Exception ex)
{
_logger.LogError(ex.Message);
jsonResponse.Mensaje = ex.Message;
}
return(Json(dataTableModel));
}
/// <summary>
/// Select list have status all
/// </summary>
/// <param name="dt"></param>
/// <param name="model"></param>
/// <returns></returns>
public IEnumerable <OrderShipModel> SearchOrderShipListTotal(DataTableModel dt, AdminOrderList model)
{
StringBuilder sql = new StringBuilder();
DateTime fromDate = new DateTime();
DateTime toDate = new DateTime();
sql.Append(@"
SELECT A. *
FROM TblOrder A
WHERE
A.USER_ID = @USER_ID
AND A.DEL_FLG = @DEL_FLG");
if (!string.IsNullOrEmpty(model.ORDER_STATUS_LIST))
{
sql.Append(" AND A.ORDER_STATUS IN ('" + model.ORDER_STATUS_LIST + "')");
}
if (!string.IsNullOrEmpty(model.TEXT_SEARCH))
{
sql.Append(" AND (A.SHIP_CODE LIKE @TEXT_SEARCH ESCAPE '|' ) OR ( A.RECEIVED_NAME LIKE @TEXT_SEARCH ESCAPE '|') OR ( A.RECEIVED_PHONE LIKE @TEXT_SEARCH ESCAPE '|') ");
}
if (!string.IsNullOrEmpty(model.FROM_DATE))
{
fromDate = DateTime.ParseExact(model.FROM_DATE, "dd/MM/yyyy", CultureInfo.InvariantCulture);
sql.Append(" AND CAST(A.CREATE_DATE AS DATE) >= @FROM_DATE ");
}
if (!string.IsNullOrEmpty(model.TO_DATE))
{
toDate = DateTime.ParseExact(model.TO_DATE, "dd/MM/yyyy", CultureInfo.InvariantCulture);
sql.Append(" AND CAST(A.CREATE_DATE AS DATE) <= @TO_DATE ");
}
sql.Append(" ORDER BY CREATE_DATE DESC, SHIP_CODE DESC, RECEIVED_NAME ASC");
var dataList = base.Query <OrderShipModel>(sql.ToString(),
new
{
USER_ID = CmnEntityModel.USER_ID,
DEL_FLG = DeleteFlag.NON_DELETE,
TEXT_SEARCH = '%' + UtilityServices.UtilityServices.replaceWildcardCharacters(model.TEXT_SEARCH) + '%',
TO_DATE = toDate,
FROM_DATE = fromDate
}).ToList();
return(dataList);
}
private void OrgForm_Load(object sender, EventArgs e)
{
Location = Owner.Location;
Size = Owner.Size;
OrgGridView.AllowUserToAddRows = false;
OrgGridView.AllowUserToDeleteRows = false;
OrgGridView.ReadOnly = true;
OrganizationsData = new DataTableModel <Organization>(null);
OrgGridView.DataSource = OrganizationsData.GetDataTable();
foreach (DataGridViewColumn col in OrgGridView.Columns)
{
col.HeaderText = OrganizationsData.GetDataTable().Columns[col.HeaderText].Caption;
}
OrgGridView.Columns[0].Visible = false;
}
public async Task <DataTables <ReviewDTO> > GetReviewsAsync(DataTableModel model)
{
var query = new GetReviewsQuery
{
PageSize = model.PageSize,
PageIndex = model.PageIndex,
OrderBy = model.OrderBy,
Draw = model.Draw,
Keyword = model.Keyword,
SortDirection = model.SortDirection,
};
query.SetContext(User.Identity);
var plist = await ReviewDF.GetReviewsAsync(query).ConfigureAwait(false);
return(new DataTables <ReviewDTO>(query.Draw, plist));
}
public DataTableModel <Account> GetAll(string role)
{
var result = new DataTableModel <Account>();
if (role == "Manager")
{
var accounts = AccountBLO.Current.GetAll();
result.Data = accounts;
}
else if (role == "Staff" || role == "Shift Head")
{
var accounts = AccountBLO.Current.GetAll().Where(x => x.Role == "Customer").ToList();
result.Data = accounts;
}
return(result);
}
public IEnumerable <Slide> SearchSlideList(DataTableModel dt, Slide model, out int total_row)
{
var list = da.Slide.Where(i => i.del_flg == model.del_flg).ToList();
if (model.Type > 0)
{
list = list.Where(i => i.Type == model.Type).ToList();
}
if (model.Status.HasValue)
{
list = list.Where(i => i.Status == model.Status).ToList();
}
total_row = list.Count();
list = list.OrderBy(i => i.DisplayOrder).ThenByDescending(i => i.ModifiedDate).ToList();
return(list);
}
public async Task <IActionResult> GetPageData(UrlParameter param, QueryBase queryBase)
{
Expression <Func <Sys_MenuDto, bool> > queryExp = item => item.Id > 0;
var searchKey = queryBase.SearchKey;
if (searchKey.Ext_IsNotEmpty())
{
if (searchKey.Contains("SubSystemId"))
{
var sysId = searchKey.Split('|')[1].Ext_ToInt32();
queryExp = x => x.SubSystemId.Contains(sysId.ToString());
}
else
{
queryExp = x => x.Name.Contains(searchKey);
}
}
var result = await _menuService.GetPageDataAsync(queryBase, queryExp, queryBase.OrderBy, queryBase.OrderDir);
var allMenu = (await _menuService.GetListAsync(item => item.Id > 0))
.data.ToDictionary(item => item.Id, item => item.Name);
var data = new DataTableModel
{
draw = queryBase.Draw,
recordsTotal = result.recordsTotal,
recordsFiltered = result.recordsTotal,
data = result.data.Select(d => new
{
rowNum = ++queryBase.Start,
name = d.Name,
parentId = d.ParentId,
parentName = allMenu.ContainsKey(d.ParentId) ? allMenu[d.ParentId] : "无",
id = d.Id.ToString(),
createDateTime = d.CreateDateTime.ToString(),
type = d.TypeName,
url = d.Url,
order = d.ListOrder,
icon = d.Icon
})
};
return(Json(data));
}
private void FormatReporteDigitalizacionDataTable(DataTableModel <ReporteFilterDto> dataTableModel)
{
for (int i = 0; i < dataTableModel.order.Count; i++)
{
var columnIndex = dataTableModel.order[0].column;
var columnDir = dataTableModel.order[0].dir.ToUpper();
var column = dataTableModel.columns[columnIndex].data;
dataTableModel.orderBy = (" [" + column + "] " + columnDir + " ");
}
dataTableModel.whereFilter = "WHERE P.Estado != '' ";
if (dataTableModel.filter != null)
{
if (GetPerfil() != "SUPERUSUARIO")
{
var IdEmpresa = GetEmpresaPadre();
dataTableModel.whereFilter += (" AND P.IdEmpresa ='" + IdEmpresa + "'");
dataTableModel.whereFilter += (" OR P.IdPadre ='" + IdEmpresa + "'");
dataTableModel.whereFilter += (" OR P.IdPadreSubcontratista ='" + IdEmpresa + "'");
}
else
{
if (!string.IsNullOrWhiteSpace(dataTableModel.filter.IdEmpresaSearch))
{
dataTableModel.whereFilter += (" AND P.IdEmpresa ='" + dataTableModel.filter.IdEmpresaSearch + "'");
}
}
if (!string.IsNullOrWhiteSpace(dataTableModel.filter.NombreSearch))
{
dataTableModel.whereFilter += (" AND UPPER(P.Nombre) LIKE '%'+'" + dataTableModel.filter.NombreSearch.ToUpper() + "'+'%'");
}
if (dataTableModel.filter.EntidadSearch != "0")
{
dataTableModel.whereFilter += (" AND P.Entidad ='" + dataTableModel.filter.EntidadSearch + "'");
}
if (dataTableModel.filter.IdCategoriaSearch != "0")
{
dataTableModel.whereFilter += (" AND P.IdCategoria ='" + dataTableModel.filter.IdCategoriaSearch + "'");
}
}
}
public ActionResult NewsList(DataTableModel dt, NewsModel condition)
{
if (ModelState.IsValid)
{
using (NewsService service = new NewsService())
{
int total_row = 0;
var dataList = service.SearchNewsList(dt, condition, out total_row);
int order = 1;
int lastItem = dt.iDisplayLength + dt.iDisplayStart;
var result = Json(
new
{
sEcho = dt.sEcho,
iTotalRecords = total_row,
iTotalDisplayRecords = total_row,
aaData = (from i in dataList
select new object[]
{
i.ID,
order++,
HttpUtility.HtmlEncode(i.Name),
i.Status == true? "Hiển thị" : "Ẩn",
i.CreatedDate != null ? i.CreatedDate.Value.ToString("dd/MM/yyyy") : String.Empty,
i.CreateName,
i.ModifiedDate != null ? i.ModifiedDate.Value.ToString("dd/MM/yyyy") : String.Empty,
i.ModifiedName,
i.del_flg
})
});
SaveRestoreData(condition);
result.MaxJsonLength = Int32.MaxValue;
return(result);
}
}
else
{
var ErrorMessages = ModelState.Where(x => x.Value.Errors.Count > 0).Select(x => new { x.Key, x.Value.Errors }).ToArray();
}
return(new EmptyResult());
}
public IEnumerable <MstCity> SearchCityList(DataTableModel dt, CityModel model, out int total_row)
{
StringBuilder sql = new StringBuilder();
sql.Append(@"
SELECT *
FROM MstCity
WHERE
DEL_FLG = @DEL_FLG ");
if (!string.IsNullOrEmpty(model.CITY_NAME))
{
sql.Append(" AND (CITY_NAME LIKE @CITY_NAME)");
}
int lower = dt.iDisplayStart + 1;
int upper = dt.iDisplayStart + dt.iDisplayLength;
PagingHelper.SQLParts parts;
PagingHelper.SplitSQL(sql.ToString(), out parts);
string sqlpage = PagingHelper.BuildPageQuery(lower, dt.iDisplayLength, parts);
string sqlcount = parts.sqlCount;
var dataList = base.Query <MstCity>(sqlpage,
new
{
DEL_FLG = model.DEL_FLG,
CITY_NAME = '%' + model.CITY_NAME + '%',
pageindex = lower,
pagesize = upper
}).ToList();
total_row = base.Query <int>(sqlcount,
new
{
DEL_FLG = model.DEL_FLG,
CITY_NAME = '%' + model.CITY_NAME + '%',
pageindex = lower,
pagesize = upper
}).FirstOrDefault();
return(dataList);
}
public ActionResult List(DataTableModel dt, TownModel condition)
{
if (ModelState.IsValid)
{
using (ManageTownService service = new ManageTownService())
{
int total_row = 0;
var dataList = service.SearchTownList(dt, condition, out total_row);
int order = 1;
int totalRowCount = dataList.Count();
int lastItem = dt.iDisplayLength + dt.iDisplayStart;
var result = Json(
new
{
sEcho = dt.sEcho,
iTotalRecords = total_row,
iTotalDisplayRecords = total_row,
aaData = (from i in dataList
select new object[]
{
i.CITY_CD,
i.DISTRICT_CD,
order++,
i.CITY_NAME != null ? HttpUtility.HtmlEncode(i.CITY_NAME) : String.Empty,
i.DISTRICT_NAME != null ? HttpUtility.HtmlEncode(i.DISTRICT_NAME) : String.Empty,
i.TOWN_CD,
i.TOWN_NAME != null ? HttpUtility.HtmlEncode(i.TOWN_NAME) : String.Empty,
i.STATUS == "1"? "Hiển thị" : "Ẩn",
i.DEL_FLG
})
});
result.MaxJsonLength = Int32.MaxValue;
return(result);
}
}
else
{
var ErrorMessages = ModelState.Where(x => x.Value.Errors.Count > 0).Select(x => new { x.Key, x.Value.Errors }).ToArray();
}
return(new EmptyResult());
}
public async Task <IActionResult> GetNotMyRoles(QueryBase queryBase, Sys_RoleDto dto)
{
var roles = await _userService.GetNotUserRoles(dto.Id);
var strData = roles.data.Select(d => new
{
id = d.Id,
rolename = d.Name
});
var result = new DataTableModel
{
draw = queryBase.Draw,
recordsTotal = roles.recordsTotal,
recordsFiltered = roles.recordsTotal,
data = strData
};
return(Json(result));
}
public override Task WriteToStreamAsync(Type type, object value, Stream writeStream, System.Net.Http.HttpContent content, System.Net.TransportContext transportContext)
{
return(Task.Factory.StartNew(() =>
{
if (type == typeof(DataTableModel))
{
DataTableModel model = value as DataTableModel;
IJsonSerializer serializer = Container.Get <IJsonSerializer>();
using (var writer = new StreamWriter(writeStream))
{
writer.Write(serializer.Serialize(model, SerializationMode.Compact, ValueHandlingMode.Include));
writer.Flush();
writer.Close();
}
}
}));
}
public async Task <DataTables <ProductItemDTO> > GetItemsAsync(DataTableModel model, string asin)
{
var query = new GetProductItemsQuery
{
PageSize = model.PageSize,
PageIndex = model.PageIndex,
OrderBy = model.OrderBy,
Draw = model.Draw,
Keyword = model.Keyword,
ASIN = asin,
SortDirection = model.SortDirection,
};
query.SetContext(User.Identity);
var plist = await ProductItemDF.GetItemsAsync(query).ConfigureAwait(false);
return(new DataTables <ProductItemDTO>(query.Draw, plist));
}
public async Task <IActionResult> GetPageData(QueryBase queryBase)
{
Expression <Func <Sys_TableColumnDto, bool> > queryExp = item => item.Id > 0;
var searchKey = queryBase.SearchKey;
if (searchKey.Ext_IsNotEmpty())
{
if (searchKey.Contains("TableId")) //如果是查找指定表下的列 前台格式为 TableId|Id值
{
var tableId = searchKey.Split('|')[1].Ext_ToInt32();
queryExp = x => x.TableId == tableId;
}
else
{
queryExp = x => (x.Description.Contains(searchKey) || x.Name.Contains(searchKey));
}
}
var allTable = (await _tableListService.GetListAsync(item => item.Id > 0))
.data.ToDictionary(item => item.Id, item => item.Name);
var dto = await _tableColumnService.GetPageDataAsync(queryBase, queryExp, queryBase.OrderBy, queryBase.OrderDir);
var data = new DataTableModel
{
draw = queryBase.Draw,
recordsTotal = dto.recordsTotal,
recordsFiltered = dto.recordsTotal,
data = dto.data.Select(d => new
{
rowNum = ++queryBase.Start,
name = d.Name,
description = d.Description,
id = d.Id.ToString(),
tableName = allTable.ContainsKey(d.TableId) ? allTable[d.TableId] : "无",
dataType = d.DataType,
addVisible = d.AddVisible == 1 ? "是" : "否",
editVisible = d.EditVisible == 1 ? "是" : "否",
listVisible = d.ListVisible == 1 ? "是" : "否",
searchVisible = d.SearchVisible == 1 ? "是" : "否",
})
};
return(Json(data));
}
public ActionResult SlideList(DataTableModel dt, Slide condition)
{
if (ModelState.IsValid)
{
using (SlideService service = new SlideService())
{
int total_row = 0;
var dataList = service.SearchSlideList(dt, condition, out total_row);
int order = 1;
int lastItem = dt.iDisplayLength + dt.iDisplayStart;
var result = Json(
new
{
sEcho = dt.sEcho,
iTotalRecords = total_row,
iTotalDisplayRecords = total_row,
aaData = (from i in dataList
select new object[]
{
i.ID,
order++,
i.Type == 1 ? "Slide Top": "Slide Left",
i.DisplayOrder,
i.Status == true? "Hiển thị" : "Ẩn",
i.CreatedDate != null ? i.CreatedDate.Value.ToString("dd/MM/yyyy") : String.Empty,
i.ModifiedDate != null ? i.ModifiedDate.Value.ToString("dd/MM/yyyy") : String.Empty,
i.del_flg
})
});
result.MaxJsonLength = Int32.MaxValue;
return(result);
}
}
else
{
var ErrorMessages = ModelState.Where(x => x.Value.Errors.Count > 0).Select(x => new { x.Key, x.Value.Errors }).ToArray();
}
return(new EmptyResult());
}
public async Task <ActionResult> DataGrid(DataTableSearchModel model)
{
if (model == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
GridSearchRestltDTO <Role> data =
await roleService.FindByCriteriaAsync(model.Search.Value, model.Start, model.Length);
DataTableModel <Role> result = new DataTableModel <Role>
{
Data = data.Items,
DecordsFiltered = data.FilteredResultsCount,
RecordsTotal = data.TotalResultsCount,
Draw = model.Draw
};
return(new JsonCustomResult(result));
}
public IEnumerable <ProductCategoryModel> SearchProductCategoryList(DataTableModel dt, ProductCategoryModel model, out int total_row)
{
var lstCategory = (from cate in da.Product_Category
join user in da.TblUser on cate.CreatedBy equals user.ID
where (cate.del_flg == model.del_flg && (!String.IsNullOrEmpty(model.Name) == true ? cate.Name.Contains(model.Name) : 1 == 1))
select new ProductCategoryModel
{
Name = cate.Name,
ID = cate.ID,
DisplayOrder = cate.DisplayOrder,
Status = cate.Status,
CreateName = user.UserName
});
total_row = lstCategory.Count();
lstCategory = lstCategory.OrderBy(i => i.DisplayOrder).Skip(dt.iDisplayStart).Take(dt.iDisplayLength);
return(lstCategory);
}
public DataTableModel<Account> GetAll(string role)
{
var result = new DataTableModel<Account>();
if (role == "Manager")
{
var accounts = AccountBLO.Current.GetAll();
result.Data = accounts;
}else if (role == "Staff" || role == "Shift Head")
{
var accounts = AccountBLO.Current.GetAll().Where(x => x.Role == "Customer").ToList();
result.Data = accounts;
}
return result;
}
public JsonResult Post([FromBody] DataTableRequest m)
{
var results = _service.InvalidLinks();
List <ReportsExt> filter;
// Do the sorting first
if (m.direction == "asc")
{
filter = results.AsQueryable().OrderBy(m.columnName + " ascending").ToList();
}
else
{
filter = results.AsQueryable().OrderBy(m.columnName + " descending").ToList();
}
// Look for any that match the string
if (!string.IsNullOrEmpty(m.search))
{
filter = filter.Where(x => x.AttemptCount.ToString().Contains(m.search) ||
(x.DateLastChecked == null ? false : x.DateLastChecked.ToString().Contains(m.search)) ||
(x.DateLastFound == null ? false : x.DateLastFound.ToString().Contains(m.search)) ||
x.Id.ToString().Contains(m.search) ||
x.Link.ToString().Contains(m.search) ||
(x.Source == null ? false : x.Source.Contains(m.search)) ||
(x.Url == null ? false : x.Url.Contains(m.search))).ToList();
}
var filterCount = filter.Count;
filter = filter.Skip(m.start).Take(m.length).ToList();
var model = new DataTableModel <ReportsExt>
{
data = filter,
draw = m.draw,
recordsFiltered = filterCount,
recordsTotal = filter.Count < m.length ? filter.Count : m.length
};
return(Json(model));
}
public IActionResult Listar(DataTableModel <ModeloFilterDto> dataTableModel)
{
var jsonResponse = new JsonResponseDto()
{
Type = Constante.Error
};
try
{
FormatDataTable(dataTableModel);
var jsonResponseDto = new JsonResponseDto()
{
Type = Constante.Error
};
var paginationParameter = new PaginationParameter
{
Start = dataTableModel.start,
AmountRows = dataTableModel.length,
WhereFilter = dataTableModel.whereFilter,
OrderBy = dataTableModel.orderBy
};
List <ModeloPaginationDto> lstCampania = _Modelo.PaginadoModelo(paginationParameter);
dataTableModel.data = lstCampania;
if (lstCampania.Count > 0)
{
dataTableModel.recordsTotal = lstCampania[0].Cantidad;
dataTableModel.recordsFiltered = dataTableModel.recordsTotal;
}
}
catch (Exception ex)
{
_logger.LogError(ex.Message);
Log.Error(ex.Message.ToString());
jsonResponse.Mensaje = ex.Message;
}
return(Json(dataTableModel));
}
public IActionResult ListarReporteDocumentos(DataTableModel <ReporteFilterDto> dataTableModel)
{
var jsonResponse = new JsonResponseDto()
{
Type = Constante.Error
};
try
{
FormatReporteDocumentoDataTable(dataTableModel);
var jsonResponseDto = new JsonResponseDto()
{
Type = Constante.Error
};
var paginationParameter = new PaginationParameter
{
Start = dataTableModel.start,
AmountRows = dataTableModel.length,
WhereFilter = dataTableModel.whereFilter,
OrderBy = dataTableModel.orderBy
};
paginationParameter.Parameters = dataTableModel.filter.EntidadSearch;
List <ReporteDocumentosDto> lstDocumentos = _reportes.ReporteDocumentos(paginationParameter);
dataTableModel.data = lstDocumentos;
if (lstDocumentos.Count > 0)
{
dataTableModel.recordsTotal = lstDocumentos[0].Cantidad;
dataTableModel.recordsFiltered = dataTableModel.recordsTotal;
}
}
catch (Exception ex)
{
_logger.LogError(ex.Message);
jsonResponse.Mensaje = ex.Message;
}
return(Json(dataTableModel));
}
private void FormatDataTable(DataTableModel <OpcionFilterDto> dataTableModel)
{
for (int i = 0; i < dataTableModel.order.Count; i++)
{
var columnIndex = dataTableModel.order[0].column;
var columnDir = dataTableModel.order[0].dir.ToUpper();
var column = dataTableModel.columns[columnIndex].data;
dataTableModel.orderBy = (" [" + column + "] " + columnDir + " ");
}
dataTableModel.whereFilter = "WHERE P.Estado != '' ";
if (dataTableModel.filter != null)
{
if (!string.IsNullOrWhiteSpace(dataTableModel.filter.NombreSearch))
{
dataTableModel.whereFilter += (" AND UPPER(P.Nombre) LIKE '%'+'" + dataTableModel.filter.NombreSearch.ToUpper() + "'+'%'");
}
}
}
public ActionResult LoadNew(EntranceTableData data)
{
if (data.UseSequentialSearch)
{
return(this.LoadNewSubsequental(data));
}
if (data.Validation())
{
return(Content(string.Format("<b class=\"message_error\">Internal error. '{0}'</b>", data.ErrorMessage)));
}
EntranceTableManager entranceTableManager = new EntranceTableManager();
DataTableModel model = new DataTableModel(entranceTableManager,
(!data.AndroidClientSession.HasValue ?
entranceTableManager.QueryNew(data) :
entranceTableManager.QueryNewAndroidSession(data)));
return(View(string.Format("~/Views/Database/{0}.cshtml", data.ReturnView), model));
}
public DataTableModel<LocationViewModel> GetLocationForAssign(string code)
{
var server = ServerBLO.Current.GetServerByCode(code, Constants.StatusCode.SERVER_WAITING);
if (server == null)
{
server = server = ServerBLO.Current.GetServerByCode(code, Constants.StatusCode.SERVER_RUNNING);
}
var locationserver = LocationBLO.Current.GetLocationOfServer(code);
var locations = new List<LocationViewModel>();
var locations1 = new List<LocationViewModel>();
if (locationserver.Count == 0)
{
locations = LocationBLO.Current.GetNewLocation(server);
if (locations.Count == 0)
{
if (RackOfCustomerDAO.Current.GetRackOfCustomer(server).Count > 0)
{
locations1 = LocationBLO.Current.GetNewLocation1(server);
}
}
}
else
{
locations = LocationBLO.Current.GetChangeLocation(server);
if (locations.Count == 0)
{
if (RackOfCustomerDAO.Current.GetRackOfCustomer(server).Count > 0)
{
locations1 = LocationBLO.Current.GetChangeLocation1(server);
}
}
}
var result = new DataTableModel<LocationViewModel>();
var result1 = new List<LocationViewModel>();
result1.AddRange(locations);
result1.AddRange(locations1);
result.Data = result1;
return result;
}
public JsonResult GetActivityDetails(DataTableModel <PaymentActivityDetailModel> model, int ID)
{
try
{
using (DataService db = new DataService())
{
var contex = db.Context.ActivityDetails.Where(x => x.PaymentActivityID == ID).AsQueryable();
//search
//if (!(string.IsNullOrEmpty(model.sSearch) || string.IsNullOrWhiteSpace(model.sSearch)))
//{
// contex = contex.Where(x => x.Name.Contains(model.sSearch));
//}
//toplam kayıt sayısı
model.iTotalDisplayRecords = contex.Count();
contex.OrderBy(x => x.ID);
//paging
if (model.iDisplayLength > 0)
{
contex = contex.OrderBy(x => x.ID).Skip(model.iDisplayStart).Take(model.iDisplayLength);
}
//select
model.aaData = contex.Select(x => new PaymentActivityDetailModel()
{
ID = x.ID,
PaymentDate = x.PaymentDate,
Amount = x.Amount,
Description = x.Description
}).ToArray();
}
}
catch (Exception ex)
{
}
return(Json(model, JsonRequestBehavior.AllowGet));
}
public ActionResult List(DataTableModel dt, TblMenuContent condition)
{
if (ModelState.IsValid)
{
using (MenuService service = new MenuService())
{
int total_row = 0;
var dataList = service.SearchMenuList(dt, condition, out total_row);
int order = 1;
int lastItem = dt.iDisplayLength + dt.iDisplayStart;
var result = Json(
new
{
sEcho = dt.sEcho,
iTotalRecords = total_row,
iTotalDisplayRecords = total_row,
aaData = (from i in dataList
select new object[]
{
i.ID,
order++,
MenuCode.Items[i.MenuCd].ToString(),
i.Status == true? "Hiển thị" : "Ẩn",
i.del_flg
})
});
SaveRestoreData(condition);
result.MaxJsonLength = Int32.MaxValue;
return(result);
}
}
else
{
var ErrorMessages = ModelState.Where(x => x.Value.Errors.Count > 0).Select(x => new { x.Key, x.Value.Errors }).ToArray();
}
return(new EmptyResult());
}
