public bool Update(SystemDictionary model, List <string> fileds, string sqlWhere) { StringBuilder strSql = new StringBuilder(); strSql.AppendFormat("update {0} set ", model.GetType().Name); List <string> filedsList = new List <string>(); List <SqlParameter> sqlParameter = new List <SqlParameter>(); SqlParameter Param = new SqlParameter("@ID", SqlDbType.Int, 4); if (string.IsNullOrEmpty(sqlWhere)) { Param.Value = model.ID; sqlParameter.Add(Param); } foreach (string filed in fileds) { filedsList.Add(string.Format("{0}=@{0}", filed)); Param = new SqlParameter(string.Format("@{0}", filed), model.GetType().GetProperty(filed).GetValue(model, null)); sqlParameter.Add(Param); } strSql.AppendFormat("{0}", string.Join(",", filedsList.ToArray())); if (string.IsNullOrEmpty(sqlWhere)) { strSql.Append(" where ID=@ID "); } else { strSql.AppendFormat(" where 1=1 and {0} ", sqlWhere); } SqlParameter[] parameters = sqlParameter.ToArray(); return(sqlhelper.ExecNon(strSql.ToString(), parameters) > 0 ? true : false); }
private int DoConvert(string sourceFile, string destFile) { string source = File.ReadAllText(sourceFile); string[] lines = source.Split('\n'); SystemDictionary dict = new SystemDictionary(); dict.Id = "АДА"; foreach (string line in lines) { string[] parts = line.Split('\t'); if (parts.Length < 2) { continue; } Word w = new Word { TextEn = parts[0], TextRu = parts[1] }; dict.Add(w); } string jsonData = (dict as ISimpleJsonSerializable).ToJsonString(); File.WriteAllText(destFile, jsonData); return(dict.Count); }
public JsonResult addEditSystemDic(SystemDictionary model, int opType) { JsonResult result = null; try { BaseResultDto <string> resultDto = new BaseResultDto <string>(); //添加或者修改 if (opType == 1) { //修改 resultDto = HttpHelper.CreatHelper().DoPostObject <BaseResultDto <string> >(string.Format("{0}SysSetting/UpdateDic", this.WebApiUrl), model); } else if (opType == 2) { //添加 resultDto = HttpHelper.CreatHelper().DoPostObject <BaseResultDto <string> >(string.Format("{0}SysSetting/AddDic", this.WebApiUrl), model); } result = Json(new { status = resultDto.ErrorCode, message = resultDto.ErrorMsg }, JsonRequestBehavior.AllowGet); } catch (Exception ex) { result = Json(new { status = -1, message = ex.Message }, JsonRequestBehavior.AllowGet); } return(result); }
public IEnumerable <SystemDictionary> Query() { string sql = "SELECT [TYPE],[ID],[NAME],[VALUE],[REMARK] FROM [T_SystemDictionary] ORDER BY TYPE"; using (var dbOperator = new DbOperator(Provider, ConnectionString)) { using (var reader = dbOperator.ExecuteReader(sql)) { var result = new List <SystemDictionary>(); SystemDictionary dictionary = null; while (reader.Read()) { SystemDictionaryType currentType = (SystemDictionaryType)reader.GetInt32(0); if (null == dictionary || dictionary.Type != currentType) { dictionary = new SystemDictionary(currentType); result.Add(dictionary); } dictionary.AddItem(new SystemDictionaryItem( reader.GetGuid(1), reader.IsDBNull(2) ? string.Empty : reader.GetString(2), reader.IsDBNull(3) ? string.Empty : reader.GetString(3), reader.IsDBNull(4) ? string.Empty : reader.GetString(4))); } return(result); } } }
public async Task <IActionResult> Edit(NullableIdInput input) { SystemDictionary dictionary = new SystemDictionary(); if (!input.Id.IsNullOrEmptyGuid()) { dictionary = await _systemDictionaryLogic.GetById(input.Id); } return(View(dictionary)); }
public BaseResultDto <string> AddDic(SystemDictionary model) { BaseResultDto <string> resultDto = new BaseResultDto <string>(); try { resultDto.ErrorCode = helper.Add <SystemDictionary>(model); resultDto.ErrorMsg = "添加成功"; } catch (Exception ex) { resultDto.ErrorCode = -1; resultDto.ErrorMsg = ex.Message; } return(resultDto); }
/// <summary> /// 得到一个对象实体 /// </summary> public SystemDictionary GetModel(string where) { StringBuilder strSql = new StringBuilder(); strSql.Append("select ID, DicKey, DicValue, DicType "); strSql.Append(" from SystemDictionary "); strSql.Append(" where "); strSql.Append(where); var dt = sqlhelper.GetTable(strSql.ToString()); SystemDictionary model = null; if (dt.Rows.Count > 0) { model = Mapper.DynamicMap <IDataReader, List <SystemDictionary> >(dt.CreateDataReader()).FirstOrDefault(); } return(model); }
/// <summary> /// 添加 /// </summary> /// <param name="requestModel"></param> /// <returns></returns> public BusinessBaseViewModel <string> Insert(AddSystemDictionaryRequestModel requestModel) { var res = new BusinessBaseViewModel <string>() { Status = ResponseStatus.Fail }; if (requestModel.IsNull()) { res.ErrorMessage = "参数错误"; return(res); } if (requestModel.Name.IsNullOrWhiteSpace()) { res.ErrorMessage = "字典名称不能为空"; return(res); } var entity = _systemDictionaryRepository.FirstOrDefault(x => x.ParentId == requestModel.ParentId && x.Name == requestModel.Name); if (entity != null) { res.ErrorMessage = $"字典名称[{requestModel.Name}]已存在,不能重复添加"; return(res); } var model = new SystemDictionary() { Name = requestModel.Name, Value = requestModel.Value, ParentId = requestModel.ParentId, Sort = requestModel.Sort, Remark = requestModel.Remark, CreateTime = DateTime.Now, ModifyTime = DateTime.Now }; _systemDictionaryRepository.Insert(model); _systemDictionaryRepository.SaveChanges(); res.Status = ResponseStatus.Success; return(res); }
/// <summary> /// 增加一条数据 /// </summary> public int Add(SystemDictionary model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into SystemDictionary("); strSql.Append("DicKey,DicValue,DicType"); strSql.Append(") values ("); strSql.Append("@DicKey,@DicValue,@DicType"); strSql.Append(") "); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@DicKey", SqlDbType.VarChar, 200), new SqlParameter("@DicValue", SqlDbType.VarChar, 8000), new SqlParameter("@DicType", SqlDbType.VarChar, 20) }; parameters[0].Value = model.DicKey; parameters[1].Value = model.DicValue; parameters[2].Value = model.DicType; return(sqlhelper.ExecNon(strSql.ToString(), parameters)); }
public BaseResultDto <string> UpdateDic(SystemDictionary model) { BaseResultDto <string> resultDto = new BaseResultDto <string>(); try { //要修改的字段数据 List <string> fileds = new List <string>(); fileds.Add("DicKey"); fileds.Add("DicValue"); fileds.Add("DicType"); resultDto.ErrorCode = helper.Update <SystemDictionary>(model, fileds) ? 1 : 0; resultDto.ErrorMsg = "修改成功"; } catch (Exception ex) { resultDto.ErrorCode = -1; resultDto.ErrorMsg = ex.Message; } return(resultDto); }
public IActionResult SaveKeyvalue(int?id, string key, string value) { var recode = new SystemDictionary(); if (id == null) { recode = new SystemDictionary() { AddTime = DateTime.Now, IsSystem = false, KeyName = key, Value = value, SystemDictionarytype = SystemDictionarytype.String }; APPCommon.AppConfig.SystemDictionaries.Add(recode); var result = m_codeService.InsertCode <SystemDictionary>(recode); } else { //var sd = new SystemDictionary();// { AddTime = DateTime.Now, IsSystem = false, KeyName = key, Value = value, SystemDictionarytype = SystemDictionarytype.String }; recode = m_codeService.GetSimpleCode <SystemDictionary>(new { Id = id }).FirstOrDefault(); if (recode == null) { recode = new SystemDictionary() { AddTime = DateTime.Now, IsSystem = false, KeyName = key, Value = value, SystemDictionarytype = SystemDictionarytype.String }; APPCommon.AppConfig.SystemDictionaries.Add(recode); var result = m_codeService.InsertCode <SystemDictionary>(recode); } else { recode.KeyName = key; recode.Value = value; m_codeService.UpdateSimpleCode(recode); var sindex = APPCommon.AppConfig.SystemDictionaries.FindIndex(p => p.Id == recode.Id); APPCommon.AppConfig.SystemDictionaries[sindex].KeyName = key; APPCommon.AppConfig.SystemDictionaries[sindex].Value = value; } } return(new JsonResult(new { result = recode })); }
public override ActionResult Index() { var model = SystemDictionary.GetAll().Select(r => new Tuple <Guid, string, string>(r.Id, r.Key, r.Value)).ToList(); return(PartialView("_Index", model)); }
public async Task <JsonResult> SaveDictionary(SystemDictionary dictionary) { return(Json(await _dictionaryLogic.SaveDictionary(dictionary))); }
public async Task <JsonResult> SaveSystemDictionary(SystemDictionary input) { return(Json(await _systemDictionaryLogic.SaveSystemDictionary(input))); }
public async Task <JsonResult> SaveDictionary(SystemDictionary dictionary) { dictionary.CreateUserId = _currentUser.UserId; dictionary.CreateUserName = _currentUser.Name; return(Json(await _dictionaryLogic.SaveDictionary(dictionary))); }
public static IEnumerable <SystemDictionaryKV> Get(string type) { return(SystemDictionary.Get(type)); }
public static Dictionary <string, List <SystemDictionaryKV> > GetMany(string types) { return(SystemDictionary.GetMany(types.Split(',', '|', ' '))); }