public List <SysDicEntity> GetSearch(string keyString, string sort, string order, int offset, int pageSize, out int total)
{
int pageCount = 0;
string querySql = string.Format("select * from SysDic(nolock) where valid = 'T' and (code like '%{0}%' or name like '%{0}%') ", keyString);
DataTable dt = SplitPage.SqlSplitPage(querySql, string.Format("order by {0} {1}", sort, order), null, offset / pageSize, pageSize, out pageCount, out total);
List <SysDicEntity> list = new List <SysDicEntity>();
foreach (DataRow dr in dt.Rows)
{
SysDicEntity entity = new SysDicEntity();
entity.ID = Ext.ToInt(dr["ID"]);
entity.Code = Ext.ToString(dr["Code"]);
entity.Name = Ext.ToString(dr["Name"]);
entity.ParentCode = Ext.ToString(dr["ParentCode"]);
entity.Type = Ext.ToString(dr["Type"]);
entity.Value = Ext.ToString(dr["Value"]);
entity.SortValue = Ext.ToInt(dr["SortValue"]);
entity.Description = Ext.ToString(dr["Description"]);
entity.IsDisplay = Ext.ToString(dr["IsDisplay"]);
entity.CreateTime = Ext.ToDate(dr["CreateTime"]);
entity.CreateBy = Ext.ToString(dr["CreateBy"]);
entity.UpdateTime = Ext.ToDate(dr["UpdateTime"]);
entity.UpdateBy = Ext.ToString(dr["UpdateBy"]);
list.Add(entity);
}
return(list);
}
public string PutDic(SysDicEntity entity)
{
try
{
//DictionaryViewModel model = JsonConvert.DeserializeObject<DictionaryViewModel>(jsonString.ToString());
if (entity == null)
{
return("error");
}
SysDicManager manager = new SysDicManager();
entity.IsDisplay = "T";
entity.CreateTime = DateTime.Now;
entity.CreateTime = DateTime.Now;
manager.Update(entity);
return("success");
}
catch (Exception e)
{
return(e.ToString());
}
}
public string DicsSaveChanges(string jsonString, string action)
{
try
{
SysDicEntity entity = JsonConvert.DeserializeObject <SysDicEntity>(jsonString);
SysDicManager dm = new SysDicManager();
if (action == "add")
{
entity.IsDisplay = "T";
entity.CreateBy = SessionHelper.CurrentUser.Code;
entity.UpdateBy = SessionHelper.CurrentUser.Code;
dm.Insert(entity);
}
else
{
SysDicEntity oldEntity = dm.GetDicByID(entity.ID);
oldEntity.Name = entity.Name;
oldEntity.ParentCode = entity.ParentCode;
oldEntity.Value = entity.Value;
oldEntity.Type = entity.Type;
oldEntity.UpdateBy = SessionHelper.CurrentUser.Code;
oldEntity.UpdateTime = DateTime.Now;
dm.Update(oldEntity);
}
return("success");
}
catch (Exception e)
{
return(e.ToString());
}
}
public string DeleteDic(int id)
{
try
{
//DictionaryViewModel model = JsonConvert.DeserializeObject<DictionaryViewModel>(jsonString.ToString());
SysDicManager manager = new SysDicManager();
SysDicEntity entity = manager.GetDicByID(id);
if (entity != null)
{
entity.Valid = "F";
entity.CreateTime = DateTime.Now;
entity.CreateTime = DateTime.Now;
manager.Update(entity);
}
return("success");
}
catch (Exception e)
{
return(e.ToString());
}
}
public void Update(SysDicEntity entity)
{
entity.UpdateTime = DateTime.Now;
IDbSession session = SessionFactory.CreateSession();
try
{
session.BeginTrans();
Repository.Update <SysDicEntity>(session.Connection, entity, session.Transaction);
session.Commit();
}
catch (System.Exception)
{
session.Rollback();
throw;
}
finally
{
session.Dispose();
}
}