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);
}
