/// <summary> /// 新增组织部门 /// </summary> /// <param name="data">组织结构实体数据集</param> /// <param name="nOpStaffId">操作员工编码</param> /// <param name="strOpStaffName">操作员工姓名</param> /// <param name="strErrText">出错信息</param> /// <returns>成功返回True,否则返回False</returns> public bool InsertOrganization(Organization data, long nOpStaffId, string strOpStaffName, out string strErrText) { try { using (TransactionScope transScope = new TransactionScope(TransactionScopeOption.Required, new TimeSpan(2, 0, 0))) { using (OrganizationDAO dao = new OrganizationDAO()) { if (!dao.InsertOrganization(data, nOpStaffId, strOpStaffName, out strErrText)) return false; } transScope.Complete(); } return true; } catch (Exception e) { strErrText = e.Message; return false; } }
/// <summary> /// 新增组织部门 /// </summary> /// <param name="data">组织结构实体数据集</param> /// <param name="nOpStaffId">操作员工编码</param> /// <param name="strOpStaffName">操作员工姓名</param> /// <param name="strErrText">出错信息</param> /// <returns>成功返回True,否则返回False</returns> public bool InsertOrganization(Organization data, long nOpStaffId, string strOpStaffName, out string strErrText) { //创建存储过程参数 SqlParameter[] Params = { MakeParam(NAME_PARAM, SqlDbType.NVarChar, 50, ParameterDirection.Input, (object)data.Name), MakeParam(PARENTID_PARAM, SqlDbType.BigInt, 8, ParameterDirection.Input, (object)data.ParentId), MakeParam(COUNTRYNAME_PARAM, SqlDbType.NVarChar, 20, ParameterDirection.Input, (object)data.CountryName), MakeParam(PROVINCENAME_PARAM, SqlDbType.NVarChar, 20, ParameterDirection.Input, (object)data.ProvinceName), MakeParam(CITYNAME_PARAM, SqlDbType.NVarChar, 20, ParameterDirection.Input, (object)data.CityName), MakeParam(ADDRESS_PARAM, SqlDbType.NVarChar, 50, ParameterDirection.Input, (object)data.Address), MakeParam(POSTALCODE_PARAM, SqlDbType.NVarChar, 10, ParameterDirection.Input, (object)data.PostalCode), MakeParam(REMARK_PARAM, SqlDbType.NVarChar, 100, ParameterDirection.Input, (object)data.Remark), MakeParam(OPSTAFFID_PARAM, SqlDbType.BigInt, 8, ParameterDirection.Input, (object)nOpStaffId), MakeParam(OPSTAFFNAME_PARAM, SqlDbType.NVarChar, 50, ParameterDirection.Input, (object)strOpStaffName) }; if (Execute("InsertOrganization", Params, out strErrText) >= 0) return true; else return false; }
public ActionResult NewOrganization(OrganizationViewModel model) { if (ModelState.IsValid) { //创建数据 Organization data = new Organization(); data.Name = model.Name; data.ParentId = model.ParentId; data.CountryName = model.CountryName ?? string.Empty; data.ProvinceName = model.StateName ?? string.Empty; data.CityName = model.CityName ?? string.Empty; data.Address = model.Address ?? string.Empty; data.PostalCode = model.PostalCode ?? string.Empty; data.Remark = model.Remark ?? string.Empty; //保存数据 string strErrText; OrganizationSystem organ = new OrganizationSystem(); if (organ.InsertOrganization(data, LoginAccountId, LoginStaffName, out strErrText)) { return Json(string.Empty); } else { return Json(strErrText); } } return View(model); }