/// <summary> /// 添加记录 /// </summary> /// <param name="model">BizProcess.Data.Model.WorkGroup实体类</param> /// <returns>操作所影响的行数</returns> public int Add(BizProcess.Data.Model.WorkGroup model) { string sql = @"INSERT INTO WorkGroup (ID,Name,Members,Note) VALUES(:ID,:Name,:Members,:Note)" ; OracleParameter[] parameters = new OracleParameter[] { new OracleParameter(":ID", OracleDbType.Char, 36) { Value = model.ID }, new OracleParameter(":Name", OracleDbType.NVarchar2, 1000) { Value = model.Name }, new OracleParameter(":Members", OracleDbType.Varchar2) { Value = model.Members }, model.Note == null ? new OracleParameter(":Note", OracleDbType.NClob) { Value = DBNull.Value } : new OracleParameter(":Note", OracleDbType.NClob) { Value = model.Note } }; return(dbHelper.Execute(sql, parameters)); }
/// <summary> /// 更新记录 /// </summary> /// <param name="model">BizProcess.Data.Model.WorkGroup实体类</param> public int Update(BizProcess.Data.Model.WorkGroup model) { string sql = @"UPDATE WorkGroup SET Name=:Name,Members=:Members,Note=:Note WHERE ID=:ID" ; OracleParameter[] parameters = new OracleParameter[] { new OracleParameter(":Name", OracleDbType.NVarchar2, 1000) { Value = model.Name }, new OracleParameter(":Members", OracleDbType.Varchar2) { Value = model.Members }, model.Note == null ? new OracleParameter(":Note", OracleDbType.NClob) { Value = DBNull.Value } : new OracleParameter(":Note", OracleDbType.NClob) { Value = model.Note }, new OracleParameter(":ID", OracleDbType.Char, 36) { Value = model.ID } }; return(dbHelper.Execute(sql, parameters)); }
public ActionResult WorkGroupAdd(FormCollection collection) { BizProcess.Platform.WorkGroup bwg = new BizProcess.Platform.WorkGroup(); string name = string.Empty; string members = string.Empty; string note = string.Empty; if (collection != null) { name = Request.Form["Name"]; members = Request.Form["Members"]; note = Request.Form["Note"]; BizProcess.Data.Model.WorkGroup wg = new BizProcess.Data.Model.WorkGroup(); wg.ID = Guid.NewGuid(); wg.Name = name.Trim(); wg.Members = members; if (!note.IsNullOrEmpty()) { wg.Note = note; } bwg.Add(wg); string query = Request.Url.Query; BizProcess.Platform.Log.Add("添加了工作组", wg.Serialize(), BizProcess.Platform.Log.Types.组织机构); ViewBag.Script = "parent.frames[0].treecng('1');alert('添加成功!');window.location = 'WorkGroup' + '" + query + "';"; } return(View()); }
/// <summary> /// 更新记录 /// </summary> /// <param name="model">BizProcess.Data.Model.WorkGroup实体类</param> public int Update(BizProcess.Data.Model.WorkGroup model) { string sql = @"UPDATE WorkGroup SET Name=@Name,Members=@Members,Note=@Note WHERE ID=@ID" ; SqlParameter[] parameters = new SqlParameter[] { new SqlParameter("@Name", SqlDbType.NVarChar, 1000) { Value = model.Name }, new SqlParameter("@Members", SqlDbType.VarChar, -1) { Value = model.Members }, model.Note == null ? new SqlParameter("@Note", SqlDbType.NVarChar, -1) { Value = DBNull.Value } : new SqlParameter("@Note", SqlDbType.NVarChar, -1) { Value = model.Note }, new SqlParameter("@ID", SqlDbType.UniqueIdentifier, -1) { Value = model.ID } }; return(dbHelper.Execute(sql, parameters)); }
/// <summary> /// 添加记录 /// </summary> /// <param name="model">BizProcess.Data.Model.WorkGroup实体类</param> /// <returns>操作所影响的行数</returns> public int Add(BizProcess.Data.Model.WorkGroup model) { string sql = @"INSERT INTO WorkGroup (ID,Name,Members,Note) VALUES(@ID,@Name,@Members,@Note)" ; SqlParameter[] parameters = new SqlParameter[] { new SqlParameter("@ID", SqlDbType.UniqueIdentifier, -1) { Value = model.ID }, new SqlParameter("@Name", SqlDbType.NVarChar, 1000) { Value = model.Name }, new SqlParameter("@Members", SqlDbType.VarChar, -1) { Value = model.Members }, model.Note == null ? new SqlParameter("@Note", SqlDbType.NVarChar, -1) { Value = DBNull.Value } : new SqlParameter("@Note", SqlDbType.NVarChar, -1) { Value = model.Note } }; return(dbHelper.Execute(sql, parameters)); }
private void addWorkGroupUsers(List <BizProcess.Data.Model.Users> userList, BizProcess.Data.Model.WorkGroup wg) { if (wg == null || wg.Members.IsNullOrEmpty()) { return; } string[] idArray = wg.Members.Split(new char[] { ',' }, StringSplitOptions.RemoveEmptyEntries); Users busers = new Users(); WorkGroup bwg = new WorkGroup(); foreach (var id in idArray) { if (id.StartsWith(Users.PREFIX))//人员 { userList.Add(busers.Get(Users.RemovePrefix(id).ToGuid())); } else if (id.IsGuid())//机构 { userList.AddRange(GetAllUsers(id.ToGuid())); } else if (id.StartsWith(WorkGroup.PREFIX))//工作组 { addWorkGroupUsers(userList, bwg.Get(WorkGroup.RemovePrefix(id).ToGuid())); } } }
/// <summary> /// 得到工作组下的人员名称字符串 /// </summary> /// <param name="wg">工作组实体</param> /// <param name="split"></param> /// <returns></returns> public string GetUsersNames(BizProcess.Data.Model.WorkGroup wg, char split = ',') { if (wg == null || wg.Members.IsNullOrEmpty()) { return(""); } return(GetUsersNames(wg.Members, split)); }
public ActionResult WorkGroup(FormCollection collection) { string id = Request.QueryString["id"]; Guid wid; BizProcess.Platform.WorkGroup bwg = new BizProcess.Platform.WorkGroup(); BizProcess.Data.Model.WorkGroup wg = null; string name = string.Empty; string members = string.Empty; string note = string.Empty; string users = string.Empty; if (!id.IsGuid(out wid) || wid == Guid.Empty) { Response.End(); } wg = bwg.Get(wid); if (wg != null) { name = wg.Name; members = wg.Members; note = wg.Note; users = bwg.GetUsersNames(wg.Members, '、'); } if (!Request.Form["Save"].IsNullOrEmpty() && collection != null && wg != null) { string oldxml = wg.Serialize(); name = Request.Form["Name"]; members = Request.Form["Members"]; note = Request.Form["Note"]; wg.Name = name.Trim(); wg.Members = members; if (!note.IsNullOrEmpty()) { wg.Note = note; } bwg.Update(wg); users = bwg.GetUsersNames(wg.Members, '、'); string query = Request.Url.Query; BizProcess.Platform.Log.Add("修改了工作组", "修改了工作组", BizProcess.Platform.Log.Types.组织机构, oldxml, wg.Serialize()); ViewBag.Script = "alert('保存成功!');"; } //删除 if (!Request.Form["DeleteBut"].IsNullOrEmpty() && collection != null && wg != null) { string oldxml = wg.Serialize(); bwg.Delete(wg.ID); string query = Request.Url.Query; BizProcess.Platform.Log.Add("删除了工作组", oldxml, BizProcess.Platform.Log.Types.组织机构); ViewBag.Script = "parent.frames[0].treecng('1');alert('删除成功!');window.location = 'Empty' + '" + query + "';"; } return(View(wg)); }
/// <summary> /// 将DataRedar转换为List /// </summary> private List <BizProcess.Data.Model.WorkGroup> DataReaderToList(OracleDataReader dataReader) { List <BizProcess.Data.Model.WorkGroup> List = new List <BizProcess.Data.Model.WorkGroup>(); BizProcess.Data.Model.WorkGroup model = null; while (dataReader.Read()) { model = new BizProcess.Data.Model.WorkGroup(); model.ID = dataReader.GetString(0).ToGuid(); model.Name = dataReader.GetString(1); model.Members = dataReader.GetString(2); if (!dataReader.IsDBNull(3)) { model.Note = dataReader.GetString(3); } List.Add(model); } return(List); }
/// <summary> /// 更新 /// </summary> public int Update(BizProcess.Data.Model.WorkGroup model) { return(dataWorkGroup.Update(model)); }
/// <summary> /// 新增 /// </summary> public int Add(BizProcess.Data.Model.WorkGroup model) { return(dataWorkGroup.Add(model)); }