public ActionResult Save() { CapitalRequiremenDto CapitalRequiremenDto = new CapitalRequiremenDto(); TryUpdateModel <CapitalRequiremenDto>(CapitalRequiremenDto); service.CapitalrequirementSave(CapitalRequiremenDto, UserInfo.UserId); return(Json("")); }
public void CapitalrequirementSave(CapitalRequiremenDto dto, string userId) { if (dto.DepartmentCode == null) { dto.DepartmentCode = ""; } if (dto.ExpendType == null) { dto.ExpendType = ""; } if (dto.ExpendPattern == null) { dto.ExpendPattern = ""; } SqlParameter[] para = new SqlParameter[] { new SqlParameter("@Id", dto.CapitalRequirementId), new SqlParameter("@ProjectId", dto.ProjectId), new SqlParameter("@DepartmentCode", dto.DepartmentCode), new SqlParameter("@ExpendType", dto.ExpendType), new SqlParameter("@ExpendPattern", dto.ExpendPattern), new SqlParameter("@UserId", userId) }; db.Database.ExecuteSqlCommand("EXEC up_CapitalRequirement_S @Id,@ProjectId,@DepartmentCode,@ExpendType,@ExpendPattern,@UserId", para); }