//新增或修改財務項目
public String addSubject(FormCollection form)
{
logger.Info("form:" + form.Count);
string msg = "";
//懶得把Form綁FIN_SUBJECT 直接先把Form 值填滿
FIN_SUBJECT s = new FIN_SUBJECT();
if (null != form.Get("subject_id").Trim() && form.Get("subject_id").Trim() != "")
{
s.FIN_SUBJECT_ID = form.Get("subject_id").Trim();
}
else
{
s.FIN_SUBJECT_ID = form.Get("new_subject_id").Trim();
}
s.SUBJECT_NAME = form.Get("subject_name").Trim();
s.CATEGORY = form.Get("categorys").Trim();
int i = service.addNewSubject(s);
if (i == 0)
{
msg = service.message;
}
else
{
msg = "項目更新成功";
}
logger.Info("Request:SUBJECT_ID=" + s.FIN_SUBJECT_ID);
return(msg);
}
public FIN_SUBJECT getSubjectItem(string itemid)
{
logger.Debug("get finacial subject item by id=" + itemid);
FIN_SUBJECT sitem = null;
using (var context = new topmepEntities())
{
//條件篩選
sitem = context.FIN_SUBJECT.SqlQuery("SELECT * FROM FIN_SUBJECT WHERE FIN_SUBJECT_ID=@itemid",
new SqlParameter("itemid", itemid)).First();
}
return(sitem);
}
//新增財務項目資料
public int addNewSubject(FIN_SUBJECT s)
{
int i = 0;
using (var context = new topmepEntities())
{
try
{
context.FIN_SUBJECT.AddOrUpdate(s);
i = context.SaveChanges();
}
catch (Exception e)
{
logger.Error("add new subject id fail:" + e.ToString());
logger.Error(e.StackTrace);
message = e.Message;
}
}
return(i);
}
