public int SaveSubject(MSubject subject) { MCompany com = _company.GetCompanyWithCurrentUser(); string sql = string.Format("select * from [Finance_SubjectsRecord] where [SubjectCode] = {0} and [CompanyId] = '{1}'", subject.SubjectCode, com.CompanyId.ToString()); DataTable dt = _dbHelper.ExecuteDataTable(sql); DataRow dr; if (dt.Rows.Count == 0) { dr = dt.NewRow(); dr["SubjectCode"] = subject.SubjectCode; dr["CompanyId"] = com.CompanyId; subject.SubjectState = 1; dt.Rows.Add(dr); } else { dr = dt.Rows[0]; } if (subject.ParentSubjectCode.HasValue) { dr["ParentSubjectCode"] = subject.ParentSubjectCode; } else { dr["ParentSubjectCode"] = DBNull.Value; } dr["Level"] = SubjectLevel(subject.SubjectCode); dr["SubjectName"] = subject.SubjectName; dr["SubjectCategory"] = subject.SubjectCategory; dr["BalanceDirection"] = subject.BalanceDirection; dr["BeginBalance"] = subject.BeginBalance; dr["EndBalance"] = subject.EndBalance; dr["SubjectState"] = subject.SubjectState; dr["NamePath"] = dr["NamePath"].ToString() + "," + subject.SubjectName; dr["CodePath"] = dr["CodePath"].ToString() + "," + subject.SubjectCode; int res = _dbHelper.UpdateDatatable(dt, sql); return(res); }
public IHttpActionResult SaveSubject([FromBody] MSubject subject) { return(Ok(_subjectService.SaveSubject(subject))); }
public IHttpActionResult GetSubjectByCode([FromBody] MSubject subject) { return(Ok(_subjectService.GetSubjectByCode(subject.SubjectCode))); }