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