public ActionResult GetGroup(DataTablesReqModel <List <NotifyAssignedViewModel> > data)
{
var _user = ((PtcIdentity)this.User.Identity).currentUser;
if (_user.CompCd == "")
{
_user.CompCd = "711";
}
DataTablesRespModel result = new DataTablesRespModel(data.draw);
try
{
Conditions <DataBase.TTechnicianGroup> conGroup = new Conditions <DataBase.TTechnicianGroup>();
conGroup.And(x => x.CompCd == _user.CompCd); //公司別
conGroup.And(x => x.VendorCd == _user.VenderCd); //廠商
var Data = _TTechnicianGroupRepo.GetList(conGroup);
PagedList <TtechnicianGroup> meta = new PagedList <TtechnicianGroup>(Data);
result.data = meta.Select(x => new NotifyAssignedViewModel(x).colData).ToArray();
result.TotalCount(conGroup.TotalCount);
}
catch (Exception ex)
{
_logger.Error(ex);
if (ex.InnerException != null)
{
_logger.Error(ex.InnerException.Message);
if (ex.InnerException.InnerException != null)
{
_logger.Error(ex.InnerException.InnerException.Message);
}
}
result.error = ex.Message;
}
return(Json(result));
}
public ActionResult GetListBySingle(DataTablesReqModel <TassetsViewModel> data)
{
DataTablesRespModel result = new DataTablesRespModel(data.draw);
try
{
if (data == null)
{
throw new ArgumentNullException($"no input data");
}
Conditions <DataBase.TASSETS> con = new Conditions <DataBase.TASSETS>
(data.length, (data.start / data.length));
TassetsViewModel model = data.criteria;
model?.GetProperties()?
.Select(x => x.Avatar <AvatarAttribute>(model))
.Where(x => x.Key != null)
.ForEach(g => con.ConvertToFilter(g.Key.SubstituteName,
g.Key.ExpressionType,
g.Key.PredicateType,
g.Value));
data.order?.ForEach(x =>
{
con.Order(x.dir, data.columns[x.column].name);
});
PagedList <Tassets> meta = new PagedList <Tassets>(_baseRepo.GetList(con), (data.start / data.length), data.length);
result.data = meta.Select(x => new TassetsResultViewModel(x).colData)
.ToArray();
result.TotalCount(meta.TotalCount);
}
catch (Exception ex)
{
_logger.Error(ex);
result.error = ex.Message;
}
return(Json(result));
}
public ActionResult GetTechnician(DataTablesReqModel <List <ChangeAssignedViewModel> > data)
{
var _user = ((PtcIdentity)this.User.Identity).currentUser;
if (_user.CompCd == "")
{
_user.CompCd = "711";
}
DataTablesRespModel result = new DataTablesRespModel(data.draw);
try
{
Conditions <DataBase.TVenderTechnician> conTechnician = new Conditions <DataBase.TVenderTechnician>();
conTechnician.And(x => x.Comp_Cd == _user.CompCd); //公司別
conTechnician.And(x => x.Vender_Cd == _user.VenderCd); //廠商
conTechnician.And(x => x.Enable == true); //狀態：啟用
var Data = _TvenderTechnicianRepo.GetList(conTechnician);
PagedList <TvenderTechnician> meta = new PagedList <TvenderTechnician>(Data);
result.data = meta.Select(x => new ChangeAssignedViewModel(x).colData).ToArray();
result.TotalCount(conTechnician.TotalCount);
}
catch (Exception ex)
{
_logger.Error(ex);
if (ex.InnerException != null)
{
_logger.Error(ex.InnerException.Message);
if (ex.InnerException.InnerException != null)
{
_logger.Error(ex.InnerException.InnerException.Message);
}
}
result.error = ex.Message;
}
return(Json(result));
}
public ActionResult Getcallog(DataTablesReqModel <List <ChangeAssignedViewModel> > data)
{
var _user = ((PtcIdentity)this.User.Identity).currentUser;
if (_user.CompCd == "")
{
_user.CompCd = "711";
}
DataTablesRespModel result = new DataTablesRespModel(data.draw);
try
{
#region 取得所有區域
Conditions <DataBase.TZOCODE> conZo = new Conditions <DataBase.TZOCODE>();
conZo.And(x => x.Comp_Cd == _user.CompCd); //公司別
var Zo = _TzocodeRepo.GetList(conZo).ToList();
#endregion
#region 取得未完修案件
Conditions <DataBase.VW_MobileCallogNoFinish> conCallog = new Conditions <DataBase.VW_MobileCallogNoFinish>();
conCallog.And(x => x.Comp_Cd == _user.CompCd); //公司別
conCallog.And(x => x.Vender_Cd == _user.VenderCd); //廠商
conCallog.And(x => x.Close_Sts == (byte)CloseSts.process); //剛立案
conCallog.And(x => x.TimePoint >= (byte)TimePoint.Accepted); //timepoint>=2
conCallog.And(x => x.TimePoint < (byte)TimePoint.Finish); //timepoint<4
data.order?.ForEach(x =>
{
if (data.columns[x.column].name == "Zo_Name")
{
conCallog.Order(x.dir, "Z_O");
}
else if (data.columns[x.column].name == "Do_Name")
{
conCallog.Order(x.dir, "D_O");
}
else
{
conCallog.Order(x.dir, data.columns[x.column].name);
}
});
var Data = _VWMobileCallogNoFinishRepo.GetList(conCallog);
#endregion
int PageIndex = (data.start / data.length);
PagedList <MobileCallogSearch> meta = new PagedList <MobileCallogSearch>(Data, PageIndex, data.length);
result.data = meta.Select(x => new ChangeAssignedViewModel(x,
Zo.Where(y => y.ZoCd == x.Zo && y.DoCd == "").Select(z => z.ZoName).FirstOrDefault(),
Zo.Where(y => y.ZoCd == x.Zo && y.DoCd == x.Do).Select(z => z.DoName).FirstOrDefault()).colData).ToArray();
result.TotalCount(conCallog.TotalCount);
}
catch (Exception ex)
{
_logger.Error(ex);
if (ex.InnerException != null)
{
_logger.Error(ex.InnerException.Message);
if (ex.InnerException.InnerException != null)
{
_logger.Error(ex.InnerException.InnerException.Message);
}
}
result.error = ex.Message;
}
return(Json(result));
}
public ActionResult GetList(DataTablesReqModel <List <TassetsViewModel> > data)
{
List <TassetsViewModel> models = data.criteria;
DataTablesRespModel result = new DataTablesRespModel(data.draw);
try
{
Conditions <DataBase.TASSETS> con = new Conditions <DataBase.TASSETS>
(data.length, (data.start / data.length));
models?.ForEach(model =>
{
var component = new List <Expression <Func <DataBase.TASSETS, Boolean> > >();
model.GetProperties()?
.Select(x => x.Avatar <AvatarAttribute>(model))
.Where(x => x.Key != null)
.ForEach(g =>
{
component.Add(con.CombinationExpression(
g.Key.SubstituteName,
g.Key.ExpressionType,
g.Value));
});
con.ConvertToMultiFilter(component);
});
data.order?.ForEach(x =>
{
con.Order(x.dir, data.columns[x.column].name);
});
#region DataRange
var _user = (this.User.Identity as AspnetMvc.Models.PtcIdentity).currentUser;
con.And(x => x.Comp_Cd == _user.CompCd);
#endregion
PagedList <Tassets> meta = new PagedList <Tassets>(_baseRepo.GetList(con), (data.start / data.length), data.length);
result.data = meta.Select(x => new TassetsResultViewModel(x).colData)
.ToArray();
result.TotalCount(meta.TotalCount);
}
catch (AutoMapper.AutoMapperMappingException ex)
{
_logger.Error(ex);
result.error = ex.InnerException.Message;
}
catch (Exception ex)
{
_logger.Error(ex);
result.error = ex.Message;
}
return(Json(result));
}
public ActionResult SearchMemberAuth(DataTablesReqModel <List <MemberSetSearchViewModel> > data)
{
List <MemberSetSearchViewModel> models = data.criteria;
DataTablesRespModel result = new DataTablesRespModel(data.draw);
try
{
Conditions <DataBase.TUSRMST> con = new Conditions <DataBase.TUSRMST>(data.length, (data.start / data.length));
models?.ForEach(model =>
{
var component = new List <Expression <Func <DataBase.TUSRMST, Boolean> > >();
model.GetProperties()?
.Select(x => x.Avatar <AvatarAttribute>(model))
.Where(x => x.Key != null)
.ForEach(g =>
{
component.Add(con.CombinationExpression(
g.Key.SubstituteName,
g.Key.ExpressionType,
g.Value));
});
con.ConvertToMultiFilter(component);
});
data.order?.ForEach(x =>
{
con.Order(x.dir, data.columns[x.column].name);
});
//con.Include(x => x.TSYSROL);
con.Include(x => x.TUSRDTL);
#region DataRange
var _user = (this.User.Identity as AspnetMvc.Models.PtcIdentity).currentUser;
//con.And(x => x.Comp_Cd == _user.CompCd);
#endregion
var list = _tusrmstRepo.GetList(con);
PagedList <UserBase> meta = new PagedList <UserBase>(list);
result.data = list.Select(x => new MemberSetResultViewModel(x))
.Select(g => new string[] {
g.CompCd,
g.UserID,
g.UserName,
g.RoleName,
})
.ToArray();
result.TotalCount(con.TotalCount);
}
catch (Exception ex)
{
_logger.Error(ex);
result.error = ex.Message;
}
return(Json(result));
}
public ActionResult GetList(DataTablesReqModel <List <TechnicianViewModel> > data)
{
List <TechnicianViewModel> models = data.criteria;
DataTablesRespModel result = new DataTablesRespModel(data.draw);
try
{
if (data.criteria == null)
{
throw new Exception("沒有條件，無法查詢");
}
Conditions <DataBase.TVenderTechnician> con = new Conditions <DataBase.TVenderTechnician>(data.length, (data.start / data.length));
models?.ForEach(model =>
{
var component = new List <Expression <Func <DataBase.TVenderTechnician, Boolean> > >();
model.GetProperties()?
.Select(x => x.Avatar <AvatarAttribute>(model))
.Where(x => x.Key != null)
.ForEach(g =>
{
component.Add(con.CombinationExpression(
g.Key.SubstituteName,
g.Key.ExpressionType,
g.Value));
});
con.ConvertToMultiFilter(component);
});
data.order?.ForEach(x =>
{
con.Order(x.dir, data.columns[x.column].name);
});
#region DataRange
var _user = (this.User.Identity as PtcIdentity).currentUser;
con.And(x => x.Comp_Cd == _user.CompCd);
if (_user.DataRange?.VendorCd != null)
{
con.And(x => _user.DataRange.VendorCd.Contains(x.Vender_Cd));
}
#endregion
var list = _technicianRepo.GetList(con);
int PageIndex = (data.start / data.length);
PagedList <TvenderTechnician> meta = new PagedList <TvenderTechnician>(list, PageIndex, data.length);
result.data = meta.Select(x => new TechnicianResultViewModel(x).colData)
.ToArray();
result.TotalCount(con.TotalCount);
}
catch (Exception ex)
{
_logger.Error(ex);
if (ex.InnerException != null)
{
_logger.Error(ex.InnerException.Message);
if (ex.InnerException.InnerException != null)
{
_logger.Error(ex.InnerException.InnerException.Message);
}
}
result.error = ex.Message;
}
return(Json(result));
}