public virtual async Task <ResponseApi> Get()
{
ResponseApi ResponseApi = ResponseApi.CreateSuccess(GetLanguage());
ResponseApi.Data = this.Query().ToList();
return(await Task.FromResult <ResponseApi>(ResponseApi));
}
public virtual ResponseApi Add([FromForm] T obj)
{
if (Request.ContentType.Contains("application/json"))
{
using (System.IO.StreamReader reader = new System.IO.StreamReader(Request.Body))
{
// Ref(ref obj, reader.ReadToEnd());
Ref(ref obj, reader.ReadToEndAsync().Result);//类库影响
}
}
else if (Request.ContentType.Contains("text/xml"))
{
using System.IO.StreamReader reader = new System.IO.StreamReader(Request.Body);
Type t = typeof(T);
XmlSerializer serializer = new XmlSerializer(t);
obj = serializer.Deserialize(reader) as T;
}
//if (!ModelState.IsValid)
//{
// return ResponseApi.Fail();
//}
obj.CreateDate = DateTime.Now;
this.Repository.Insert(obj);
return(ResponseApi.CreateSuccess());
}
protected override ResponseApi Edited(ModuleInfo obj)
{
base.Repository.Update(it => it.Id == obj.Id, it => new ModuleInfo()
{
Name = obj.Name, Href = obj.Href, Parent = obj.Parent, UpdateDate = DateTime.Now
});
return(ResponseApi.CreateSuccess());
}
protected override ResponseApi Edited(BringUpContentInfo obj)
{
this.Repository.Update(it => it.Id == obj.Id, it => new BringUpContentInfo()
{
UpdateDate = DateTime.Now, Name = obj.Name, Content = obj.Content, Unit = obj.Unit, Place = obj.Place, StartDate = obj.StartDate, EndDate = obj.EndDate
});
return(ResponseApi.CreateSuccess());
}
public virtual async Task <ResponseApi> Category()
{
ResponseApi responseApi = ResponseApi.CreateSuccess(GetLanguage());
var data = base.Repository.Find(it => it.Enable.HasValue && it.Enable.Value).Select(it => new { Icon = it.Icon, Id = it.Id });
responseApi.Data = data;
return(await Task.FromResult <ResponseApi>(responseApi));
}
protected override ResponseApi Edited(UserInfo obj)
{
this.Repository.Update(it => it.Id == obj.Id, it => new UserInfo()
{
UpdateDate = DateTime.Now, Role = obj.Role, Password = obj.Password
});
return(ResponseApi.CreateSuccess());
}
protected override ResponseApi Edited(AccountItemInfo obj)
{
base.Repository.Update(it => it.Id == obj.Id, it => new AccountItemInfo()
{
Name = obj.Name, Type = obj.Type, Utit = obj.Utit, UpdateDate = DateTime.Now
});
return(ResponseApi.CreateSuccess());
}
public virtual async Task <ResponseApi> Menu()
{
ResponseApi responseApi = ResponseApi.CreateSuccess(GetLanguage());
var data = GetDynamics();
responseApi.Data = ParseData(data);
return(await Task.FromResult <ResponseApi>(responseApi));
}
protected override ResponseApi Edited(RoleInfo obj)
{
base.Repository.Update(it => it.Id == obj.Id, it => new RoleInfo()
{
Name = obj.Name, UpdateDate = DateTime.Now
});
return(ResponseApi.CreateSuccess());
}
private async Task <ResponseApi> GetCategory(string name)
{
ResponseApi responseApi = ResponseApi.CreateSuccess(GetLanguage());
string sql = $"select c.id Id,c.name Name,c.english_name EnglishName from category_info c inner join basic_category_info b on b.id=c.category_id and lower(b.english_name)='{name}' group by id";
var data = (((BaseEfRepository <CategoryInfo>)base.Repository).DbContext as Company.Domain.CompanyDbContext).Database.GetDbConnection().Query(sql);
responseApi.Data = data;
return(await Task.FromResult <ResponseApi>(responseApi));
}
protected virtual ResponseApi Edited(T obj)
{
var old = this.Repository.FindSingle(it => it.Id == obj.Id);
obj.CreateDate = old.CreateDate;
obj.UpdateDate = DateTime.Now;
this.Repository.Update(obj);
return(ResponseApi.CreateSuccess());
}
public virtual async Task <ResponseApi> MenuCategory()
{
ResponseApi responseApi = ResponseApi.CreateSuccess(GetLanguage());
//var data = base.Repository.Find(null).Include(it => it.Menus).Select(it => new CategoryInfo()
//{
// Id = it.Id,
// Name = it.Name,
// EnglishName = it.EnglishName,
// Menus = (from it1 in it.Menus select new MenuInfo() { Id = it1.Id, Name = it1.Name, EnglishName = it1.EnglishName }).ToList()
//}).ToList();
//List<CategoryInfo> temp = new List<CategoryInfo>(data.Count);
//for (int i = 0; i < data.Count; i++)
//{
// if (data[i].Menus == null||!data[i].Menus.Any())
// {
// continue;
// }
// else
// {
// temp.Add(data[i]);
// }
//}
//responseApi.Data = temp;
var context = (((BaseEfRepository <CategoryInfo>)base.Repository).DbContext as Company.Domain.CompanyDbContext);
var data = context.Menus
.Join(context.Categories, it => it.Category.Id, it => it.Id, (it, it1) => new
{
CategoryInfo = new CategoryInfo()
{
Id = it1.Id,
Name = it1.Name,
EnglishName = it1.EnglishName
},
MenuInfo = new MenuInfo()
{
Id = it.Id, Name = it.Name, EnglishName = it.EnglishName
}
}).ToList();
responseApi.Data = data;
List <CategoryInfo> temp = new List <CategoryInfo>(data.Count);
foreach (var item in data)
{
var it = temp.Find(it => it.Id == item.CategoryInfo.Id);
if (it == null)
{
it = item.CategoryInfo;
it.Menus = new List <MenuInfo>();
temp.Add(it);
}
it.Menus.Add(item.MenuInfo);
}
responseApi.Data = temp;
return(await Task.FromResult <ResponseApi>(responseApi));
}
protected override ResponseApi Edited(PersonInfo obj)
{
this.Repository.Update(it => it.Id == obj.Id, it => new PersonInfo()
{
UpdateDate = DateTime.Now, Address = obj.Address, ComputerGrate = obj.ComputerGrate, Email = obj.Email,
GraduateDate = obj.GraduateDate, GraduateSchool = obj.GraduateSchool, Handset = obj.Handset, Likes = obj.Likes, OnesStrongSuit = obj.OnesStrongSuit, PartyMemberDate = obj.PartyMemberDate,
Postlacode = obj.Postlacode, QQ = obj.QQ, SecondSchoolAge = obj.SecondSchoolAge, SecondSpeciaity = obj.SecondSpeciaity, Telphone = obj.Telphone, User = obj.User
});
return(ResponseApi.CreateSuccess());
}
public ResponseApi Category()
{
var data = base.Query().Include(it => it.Image).Select(it => new WorkInfo()
{
Id = it.Id, Src = it.Image.Name
}).ToList();
var result = ResponseApi.CreateSuccess();
result.Data = data;
return(result);
}
public ResponseApi Category()
{
var data = base.Query(it => !it.Work.Id.HasValue).Select(it => new WorkCategoryInfo()
{
Id = it.Id,
Name = it.Name,
EnglishName = it.EnglishName
});
var result = ResponseApi.CreateSuccess();
result.Data = data;
return(result);
}
public virtual async Task <ResponseApi> Category()
{
ResponseApi responseApi = ResponseApi.CreateSuccess(GetLanguage());
var data = base.Repository.Find(null).Select(it => new AdminRoleInfo()
{
Id = it.Id,
Name = it.Name,
EnglishName = it.EnglishName
});
responseApi.Data = data;
return(await Task.FromResult <ResponseApi>(responseApi));
}
public ResponseApi Category()
{
var data = base.Query(it => it.Parent.Id == it.Id || it.Parent == null).Select(it => new NavInfo()
{
Id = it.Id,
Name = it.Name,
EnglishName = it.EnglishName
});
var result = ResponseApi.CreateSuccess();
result.Data = data;
return(result);
}
public ResponseApi Total()
{
ResponseApi response = ResponseApi.CreateSuccess();
string sql = ToSql();
StringBuilder builder = new StringBuilder(500);
string[] strs = new string[] {
"about_info", "about", "关于",
"admin_info", "admin", "管理员",
"admin_role_info", "admin_role", "管理员角色",
"basic_category_info", "basic_category", "基本分类",
"category_info", "category", "分类",
"company_info", "company", "公司",
"image_info", "img", "图片",
"main_info", "main", "公司主体",
"media_info", "media", "媒体",
"menu_info", "menu", "菜单",
"nav_info", "nav", "导航",
"service_info", "service", "我们的服务",
"skill_info", "skill", "我们的技能",
"skin_info", "skin", "皮肤",
"social_info", "social", "社交",
"team_info", "team", "团队",
"team_source_info", "team_source", "团队来源",
"testimonial_person_info", "testimonial_person", "感言个人",
"theme_info", "theme", "主题",
"user_info", "user1", "用户",
"work_category_info", "work_category", "作品来源",
"work_info", "work", "作品",
};
string[] names = new string[strs.Length / 3];
for (int i = 0; i < strs.Length / 3; i++)
{
int j = i * 3;
names[i] = strs[j + 2];
string sqlformat = string.Format(sql, strs[j], strs[j + 1] /*,strs[j+2]*/);
builder.Append(sqlformat);
if (i != names.Length - 1)
{
builder.Append(" UNION ALL ");
}
}
string totalSql = builder.ToString();
var data = (((BaseEfRepository <AdminInfo>)base.Repository).DbContext as Company.Domain.CompanyDbContext).Database.GetDbConnection().Query(totalSql);
response.Data = new { data, name = names };
return(response);
}
public virtual ResponseApi Delete([FromForm] DelEntry delEntry)
{
if (Request.ContentType.Contains("application/json"))
{
using (System.IO.StreamReader reader = new System.IO.StreamReader(Request.Body))
{
// Ref(ref obj, reader.ReadToEnd());
Ref(ref delEntry, reader.ReadToEndAsync().Result);//类库影响
}
}
Expression <Func <T, bool> > where = null;
if (delEntry.Id.HasValue)
{
where = where.Or(it => it.Id == delEntry.Id.Value);
}
else if (delEntry.Ids != null && delEntry.Ids.Length > 0)
{
//多条件不支持 删除操作
//NHibernate.ISession session = HttpContext.RequestServices.GetService<NHibernate.ISession>();
//NHibernate.ICriteria criteria= session.CreateCriteria<T>();
//NHibernate.Criterion.AbstractCriterion abstractCriterion=null;
//bug
foreach (var item in delEntry.Ids)
{
// where = where.Or(it => it.Id == item);
this.Repository.Delete(it => it.Id == item);
//if(abstractCriterion==null)
//{
// abstractCriterion = NHibernate.Criterion.Expression.IdEq(item);
//}
//else
//{
// abstractCriterion |= NHibernate.Criterion.Expression.IdEq(item);
//}
}
//criteria.Add(abstractCriterion);
return(ResponseApi.CreateSuccess());
}
else
{
return(ResponseApi.CreateFail());
}
this.Repository.Delete(where);
return(ResponseApi.CreateSuccess());
}
public override ResponseApi Add([FromForm] RecordInfo obj)
{
if (Request.ContentType.Contains("application/json"))
{
using (System.IO.StreamReader reader = new System.IO.StreamReader(Request.Body))
{
// Ref(ref obj, reader.ReadToEnd());
Ref(ref obj, reader.ReadToEndAsync().Result);//类库影响
}
}
else if (Request.ContentType.Contains("text/xml"))
{
using System.IO.StreamReader reader = new System.IO.StreamReader(Request.Body);
Type t = typeof(RecordInfo);
XmlSerializer serializer = new XmlSerializer(t);
obj = serializer.Deserialize(reader) as RecordInfo;
}
//if (!ModelState.IsValid)
//{
// return ResponseApi.Fail();
//}
if (Request.Form.Files.Count != 1)
{
return(ResponseApi.Create(Language.Chinese, Code.UploadFileFail));
}
var file = Request.Form.Files[0];
if (file.Name.ToLower() != "photo")
{
return(ResponseApi.Create(Language.Chinese, Code.UploadFileFail));
}
using Stream stream = file.OpenReadStream();
byte[] buffer = new byte[stream.Length];
stream.Read(buffer, 0, buffer.Length);
FileHelper.WriteFile(Program.UploadImg + "\\" + file.FileName, buffer);
obj.Photo = "imgs\\" + file.FileName;
obj.CreateDate = DateTime.Now;
this.Repository.Insert(obj);
return(ResponseApi.CreateSuccess());
}
public ResponseApi Ratifier()
{
var data = base.Repository.Find(null).Select(it => new { it.Id, it.Name }).ToList();
return(ResponseApi.CreateSuccess().SetData(data));
}
public ResponseApi Category()
{
var data = base.Repository.Find(it => it.Parent.Id > 0).Select(it => new { it.Id, it.Name }).ToList();
return(ResponseApi.CreateSuccess().SetData(data));
}
public ResponseApi Category()
{
var data = base.Repository.Find(null).Select(it => new { it.Id, it.Account }).ToList();
return(ResponseApi.CreateSuccess().SetData(data));
}
public virtual ResponseApi Get()
{
var data = this.Repository.Find(null).ToList();
return(ResponseApi.CreateSuccess().SetData(data));
}