private string getOptionsValue(OptionValueField valueField, BizProcess.Data.Model.Dictionary dict) { string value = string.Empty; switch (valueField) { case OptionValueField.Code: value = dict.Code; break; case OptionValueField.ID: value = dict.ID.ToString(); break; case OptionValueField.Note: value = dict.Note; break; case OptionValueField.Other: value = dict.Other; break; case OptionValueField.Title: value = dict.Title; break; case OptionValueField.Value: value = dict.Value; break; } return(value); }
/// <summary> /// 将DataRedar转换为List /// </summary> private List <BizProcess.Data.Model.Dictionary> DataReaderToList(OracleDataReader dataReader) { List <BizProcess.Data.Model.Dictionary> List = new List <BizProcess.Data.Model.Dictionary>(); BizProcess.Data.Model.Dictionary model = null; while (dataReader.Read()) { model = new BizProcess.Data.Model.Dictionary(); model.ID = dataReader.GetString(0).ToGuid(); model.ParentID = dataReader.GetString(1).ToGuid(); model.Title = dataReader.GetString(2); if (!dataReader.IsDBNull(3)) { model.Code = dataReader.GetString(3); } if (!dataReader.IsDBNull(4)) { model.Value = dataReader.GetString(4); } if (!dataReader.IsDBNull(5)) { model.Note = dataReader.GetString(5); } if (!dataReader.IsDBNull(6)) { model.Other = dataReader.GetString(6); } model.Sort = dataReader.GetInt32(7); List.Add(model); } return(List); }
/// <summary> /// 更新记录 /// </summary> /// <param name="model">BizProcess.Data.Model.Dictionary实体类</param> public int Update(BizProcess.Data.Model.Dictionary model) { string sql = @"UPDATE Dictionary SET ParentID=:ParentID,Title=:Title,Code=:Code,Value=:Value,Note=:Note,Other=:Other,Sort=:Sort WHERE ID=:ID" ; OracleParameter[] parameters = new OracleParameter[] { new OracleParameter(":ParentID", OracleDbType.Char, 36) { Value = model.ParentID }, new OracleParameter(":Title", OracleDbType.NClob) { Value = model.Title }, model.Code == null ? new OracleParameter(":Code", OracleDbType.Varchar2, 500) { Value = DBNull.Value } : new OracleParameter(":Code", OracleDbType.Varchar2, 500) { Value = model.Code }, model.Value == null ? new OracleParameter(":Value", OracleDbType.Clob) { Value = DBNull.Value } : new OracleParameter(":Value", OracleDbType.Clob) { Value = model.Value }, model.Note == null ? new OracleParameter(":Note", OracleDbType.Clob) { Value = DBNull.Value } : new OracleParameter(":Note", OracleDbType.Clob) { Value = model.Note }, model.Other == null ? new OracleParameter(":Other", OracleDbType.Clob) { Value = DBNull.Value } : new OracleParameter(":Other", OracleDbType.Clob) { Value = model.Other }, new OracleParameter(":Sort", OracleDbType.Int32) { Value = model.Sort }, new OracleParameter(":ID", OracleDbType.Char, 36) { Value = model.ID } }; return(dbHelper.Execute(sql, parameters)); }
/// <summary> /// 添加记录 /// </summary> /// <param name="model">BizProcess.Data.Model.Dictionary实体类</param> /// <returns>操作所影响的行数</returns> public int Add(BizProcess.Data.Model.Dictionary model) { string sql = @"INSERT INTO Dictionary (ID,ParentID,Title,Code,Value,Note,Other,Sort) VALUES(:ID,:ParentID,:Title,:Code,:Value,:Note,:Other,:Sort)" ; OracleParameter[] parameters = new OracleParameter[] { new OracleParameter(":ID", OracleDbType.Char, 36) { Value = model.ID }, new OracleParameter(":ParentID", OracleDbType.Char, 36) { Value = model.ParentID }, new OracleParameter(":Title", OracleDbType.NClob) { Value = model.Title }, model.Code == null ? new OracleParameter(":Code", OracleDbType.Varchar2, 500) { Value = DBNull.Value } : new OracleParameter(":Code", OracleDbType.Varchar2, 500) { Value = model.Code }, model.Value == null ? new OracleParameter(":Value", OracleDbType.Clob) { Value = DBNull.Value } : new OracleParameter(":Value", OracleDbType.Clob) { Value = model.Value }, model.Note == null ? new OracleParameter(":Note", OracleDbType.Clob) { Value = DBNull.Value } : new OracleParameter(":Note", OracleDbType.Clob) { Value = model.Note }, model.Other == null ? new OracleParameter(":Other", OracleDbType.Clob) { Value = DBNull.Value } : new OracleParameter(":Other", OracleDbType.Clob) { Value = model.Other }, new OracleParameter(":Sort", OracleDbType.Int32) { Value = model.Sort } }; return(dbHelper.Execute(sql, parameters)); }
/// <summary> /// 更新记录 /// </summary> /// <param name="model">BizProcess.Data.Model.Dictionary实体类</param> public int Update(BizProcess.Data.Model.Dictionary model) { string sql = @"UPDATE Dictionary SET ParentID=@ParentID,Title=@Title,Code=@Code,Value=@Value,Note=@Note,Other=@Other,Sort=@Sort WHERE ID=@ID" ; SqlParameter[] parameters = new SqlParameter[] { new SqlParameter("@ParentID", SqlDbType.UniqueIdentifier, -1) { Value = model.ParentID }, new SqlParameter("@Title", SqlDbType.NVarChar, -1) { Value = model.Title }, model.Code == null ? new SqlParameter("@Code", SqlDbType.VarChar, 500) { Value = DBNull.Value } : new SqlParameter("@Code", SqlDbType.VarChar, 500) { Value = model.Code }, model.Value == null ? new SqlParameter("@Value", SqlDbType.VarChar, -1) { Value = DBNull.Value } : new SqlParameter("@Value", SqlDbType.VarChar, -1) { Value = model.Value }, model.Note == null ? new SqlParameter("@Note", SqlDbType.VarChar, -1) { Value = DBNull.Value } : new SqlParameter("@Note", SqlDbType.VarChar, -1) { Value = model.Note }, model.Other == null ? new SqlParameter("@Other", SqlDbType.VarChar, -1) { Value = DBNull.Value } : new SqlParameter("@Other", SqlDbType.VarChar, -1) { Value = model.Other }, new SqlParameter("@Sort", SqlDbType.Int, -1) { Value = model.Sort }, new SqlParameter("@ID", SqlDbType.UniqueIdentifier, -1) { Value = model.ID } }; return(dbHelper.Execute(sql, parameters)); }
/// <summary> /// 添加记录 /// </summary> /// <param name="model">BizProcess.Data.Model.Dictionary实体类</param> /// <returns>操作所影响的行数</returns> public int Add(BizProcess.Data.Model.Dictionary model) { string sql = @"INSERT INTO Dictionary (ID,ParentID,Title,Code,Value,Note,Other,Sort) VALUES(@ID,@ParentID,@Title,@Code,@Value,@Note,@Other,@Sort)" ; SqlParameter[] parameters = new SqlParameter[] { new SqlParameter("@ID", SqlDbType.UniqueIdentifier, -1) { Value = model.ID }, new SqlParameter("@ParentID", SqlDbType.UniqueIdentifier, -1) { Value = model.ParentID }, new SqlParameter("@Title", SqlDbType.NVarChar, -1) { Value = model.Title }, model.Code == null ? new SqlParameter("@Code", SqlDbType.VarChar, 500) { Value = DBNull.Value } : new SqlParameter("@Code", SqlDbType.VarChar, 500) { Value = model.Code }, model.Value == null ? new SqlParameter("@Value", SqlDbType.VarChar, -1) { Value = DBNull.Value } : new SqlParameter("@Value", SqlDbType.VarChar, -1) { Value = model.Value }, model.Note == null ? new SqlParameter("@Note", SqlDbType.VarChar, -1) { Value = DBNull.Value } : new SqlParameter("@Note", SqlDbType.VarChar, -1) { Value = model.Note }, model.Other == null ? new SqlParameter("@Other", SqlDbType.VarChar, -1) { Value = DBNull.Value } : new SqlParameter("@Other", SqlDbType.VarChar, -1) { Value = model.Other }, new SqlParameter("@Sort", SqlDbType.Int, -1) { Value = model.Sort } }; return(dbHelper.Execute(sql, parameters)); }
/// <summary> /// 得到一个字典项的上级节点数 /// </summary> /// <param name="dictList"></param> /// <param name="dict"></param> /// <returns></returns> private int getParentCount(List <BizProcess.Data.Model.Dictionary> dictList, BizProcess.Data.Model.Dictionary dict) { int parent = 0; BizProcess.Data.Model.Dictionary parentDict = dictList.Find(p => p.ID == dict.ParentID); while (parentDict != null) { parentDict = dictList.Find(p => p.ID == parentDict.ParentID); parent++; } return(parent); }
public ActionResult Body(FormCollection collection) { BizProcess.Platform.Dictionary bdict = new BizProcess.Platform.Dictionary(); BizProcess.Data.Model.Dictionary dict = null; string id = Request.QueryString["id"]; if (id.IsGuid()) { dict = bdict.Get(id.ToGuid()); } if (dict == null) { dict = bdict.GetRoot(); } if (collection != null) { string refreshID = dict.ParentID == Guid.Empty ? dict.ID.ToString() : dict.ParentID.ToString(); //删除 if (!Request.Form["Delete"].IsNullOrEmpty()) { int i = bdict.DeleteAndAllChilds(dict.ID); bdict.RefreshCache(); BizProcess.Platform.Log.Add("删除了数据字典及其下级共" + i.ToString() + "项", dict.Serialize(), BizProcess.Platform.Log.Types.数据字典); ViewBag.Script = "alert('删除成功!');parent.frames[0].reLoad('" + refreshID + "');window.location='Body?id=" + dict.ParentID.ToString() + "&appid=" + Request.QueryString["appid"] + "';"; return(View(dict)); } string title = Request.Form["Title"]; string code = Request.Form["Code"]; string values = Request.Form["Values"]; string note = Request.Form["Note"]; string other = Request.Form["Other"]; string oldXML = dict.Serialize(); dict.Code = code.IsNullOrEmpty() ? null : code.Trim(); dict.Note = note.IsNullOrEmpty() ? null : note.Trim(); dict.Other = other.IsNullOrEmpty() ? null : other.Trim(); dict.Title = title.Trim(); dict.Value = values.IsNullOrEmpty() ? null : values.Trim(); bdict.Update(dict); bdict.RefreshCache(); BizProcess.Platform.Log.Add("修改了数据字典项", "", BizProcess.Platform.Log.Types.数据字典, oldXML, dict.Serialize()); ViewBag.Script = "alert('保存成功!');parent.frames[0].reLoad('" + refreshID + "');"; } return(View(dict)); }
public ActionResult add1(FormCollection collection) { BizProcess.Data.Model.Dictionary dict = new BizProcess.Data.Model.Dictionary(); BizProcess.Platform.Dictionary bdict = new BizProcess.Platform.Dictionary(); string id = Request.QueryString["id"]; if (!id.IsGuid()) { var dictRoot = bdict.GetRoot(); id = dictRoot != null?dictRoot.ID.ToString() : ""; } if (!id.IsGuid()) { throw new Exception("未找到父级"); } if (collection != null) { string title = Request.Form["Title"]; string code = Request.Form["Code"]; string values = Request.Form["Values"]; string note = Request.Form["Note"]; string other = Request.Form["Other"]; dict.ID = Guid.NewGuid(); dict.Code = code.IsNullOrEmpty() ? null : code.Trim(); dict.Note = note.IsNullOrEmpty() ? null : note.Trim(); dict.Other = other.IsNullOrEmpty() ? null : other.Trim(); dict.ParentID = id.ToGuid(); dict.Sort = bdict.GetMaxSort(id.ToGuid()); dict.Title = title.Trim(); dict.Value = values.IsNullOrEmpty() ? null : values.Trim(); bdict.Add(dict); bdict.RefreshCache(); BizProcess.Platform.Log.Add("添加了数据字典项", dict.Serialize(), BizProcess.Platform.Log.Types.数据字典); ViewBag.Script = "alert('添加成功!');parent.frames[0].reLoad('" + id + "');"; } return(View(dict)); }
/// <summary> /// 更新 /// </summary> public int Update(BizProcess.Data.Model.Dictionary model) { return(dataDictionary.Update(model)); }
/// <summary> /// 新增 /// </summary> public int Add(BizProcess.Data.Model.Dictionary model) { return(dataDictionary.Add(model)); }