public List <dynamic> GetDictionaryByCategory(DictionaryCategory model)
{
using (UnitOfWork dal = BaseInfo._container.Resolve <UnitOfWork>())
{
var conditions = ExpandHelper.True <DictionaryCategory>().And(a => a.Enabled == true);
if (model.ID != 0)
{
conditions = conditions.And(a => a.ID == model.ID);
}
if (!string.IsNullOrEmpty(model.Category))
{
conditions = conditions.And(a => a.Category == model.Category);
}
var dc = dal.GetRepository <DictionaryCategory>().Get(filter: conditions, includeProperties: "DicValueList").FirstOrDefault();
var diction = dc.DicValueList.Select(a => new
{
id = a.ID,
text = a.DicValue
}).ToList <dynamic>();
return(diction);
}
}
public void AddDic(DictionaryCategory model)
{
using (UnitOfWork dal = new UnitOfWork(ConnectDB.DataBase()))
{
dal.GetRepository <DictionaryCategory>().Insert(model);
dal.Save();
}
}
public void AddDic(DictionaryCategory model)
{
using (UnitOfWork dal = BaseInfo._container.Resolve <UnitOfWork>())
{
dal.GetRepository <DictionaryCategory>().Insert(model);
dal.Save();
}
}
public void AddDic(DictionaryCategory model)
{
using (UnitOfWork dal = new UnitOfWork(new CoreDbContext()))
{
dal.GetRepository <DictionaryCategory>().Insert(model);
dal.Save();
}
}
public TranslationWithCode(
string arg0,
string arg1,
DictionaryCategory arg2
)
{
Field0 = arg0;
Field1 = arg1;
Field2 = arg2;
}
public void ModifyDic(DictionaryCategory model)
{
using (UnitOfWork dal = new UnitOfWork(ConnectDB.DataBase()))
{
dal.GetRepository <DictionaryCategory>().UpdateSup(model, new List <string>()
{
"CreateTime", "Enabled"
}, false);
dal.Save();
}
}
public void ModifyDic(DictionaryCategory model)
{
using (UnitOfWork dal = BaseInfo._container.Resolve <UnitOfWork>())
{
dal.GetRepository <DictionaryCategory>().UpdateSup(model, new List <string>()
{
"CreateTime", "Enabled"
}, false);
dal.Save();
}
}
public static List <DictionaryInfo> QueryAll(DictionaryCategory category)
{
const string sql = @"
SELECT A.CODE AS Code,A.NAME AS Name,A.OWNER AS Owner,A.CATEGORY AS Category
FROM T_DICTIONARY_INFO AS A WITH(NOLOCK)
WHERE 1 = 1
AND A.CATEGORY = @Category
ORDER BY A.CODE
";
return(Dapper.Query <DictionaryInfo>(sql, new { Category = category.ToString() }));
}
public static List<DictionaryInfo> QueryAll(DictionaryCategory category)
{
const string sql = @"
SELECT A.CODE AS Code,A.NAME AS Name,A.OWNER AS Owner,A.CATEGORY AS Category
FROM T_DICTIONARY_INFO AS A WITH(NOLOCK)
WHERE 1 = 1
AND A.CATEGORY = @Category
ORDER BY A.CODE
";
return Dapper.Query<DictionaryInfo>(sql, new { Category = category.ToString() });
}
public void AddCategory(string name, string description)
{
using (var db = new DictServiceEntities())
{
var category = new DictionaryCategory()
{
Name = name,
Description = description
};
db.DictionaryCategories.Add(category);
db.SaveChanges();
}
}
public ActionResult OperationDicategory(DictionaryCategory model)
{
if (model.ID == 0)
{
model.Create_Time = DateTime.Now;
model.Enabled = true;
db.Insert(model);
}
else
{
model.Update_Time = DateTime.Now;
db.Update(model);
}
return(Json(new ResultEntity {
result = true
}));
}
public ActionResult OperationDicategory(DictionaryCategory model)
{
if (model.ID == 0)
{
model.CreateTime = DateTime.Now;
model.Enabled = true;
this.DicCategory.AddDic(model);
}
else
{
model.UpdateTime = DateTime.Now;
this.DicCategory.ModifyDic(model);
}
return(Json(new ResultEntity {
result = true
}));
}
public static List <DictionaryInfo> QueryAll(DictionaryCategory category, string owner)
{
return(string.IsNullOrEmpty(owner)
? DictionaryInfoDal.QueryAll(category)
: DictionaryInfoDal.QueryAll(category, owner));
}
public static List<DictionaryInfo> QueryAll(DictionaryCategory category, string owner)
{
return string.IsNullOrEmpty(owner)
? DictionaryInfoDal.QueryAll(category)
: DictionaryInfoDal.QueryAll(category, owner);
}
public ActionResult SelectBinding(DictionaryCategory model)
{
var result = this.DicCategory.GetDictionaryByCategory(model);
return(JsonResult(result));
}
public static List <DictionaryInfo> QueryAll(DictionaryCategory category)
{
return(DictionaryInfoDal.QueryAll(category));
}
public static List<DictionaryInfo> QueryAll(DictionaryCategory category)
{
return DictionaryInfoDal.QueryAll(category);
}
