public bool updateAccountItemTaxRateSetting(long id, Dictionary <string, object> dic)
{
bool ret = false;
using (NaNaEntities db = new NaNaEntities()) {
AccountItemTaxRateSetting a = db.AccountItemTaxRateSetting.AsQueryable().First(x => x.id == id);
if (a != null)
{
Type cl = a.GetType();
foreach (var obj in dic)
{
if (cl.GetProperty(obj.Key) != null)
{
cl.GetProperty(obj.Key).SetValue(a, obj.Value);
}
}
db.SaveChanges();
ret = true;
}
}
return(ret);
}
public bool updateFormFieldSetting(string id, Dictionary <string, object> dicObj)
{
bool ret = false;
using (NaNaEntities db = new NaNaEntities()) {
Guid guid_id = Guid.Parse(id);
FormFieldsSetting f = db.FormFieldsSetting.AsQueryable().FirstOrDefault(x => x.id == guid_id);
if (f == null)
{
return(false);
}
Type cl = f.GetType();
foreach (var obj in dicObj)
{
if (cl.GetProperty(obj.Key) != null)
{
cl.GetProperty(obj.Key).SetValue(f, obj.Value);
}
}
db.SaveChanges();
ret = true;
}
return(ret);
}
public bool updateERACategoryDynamicField(long id, Dictionary <string, object> dicObj)
{
bool ret = false;
using (NaNaEntities db = new NaNaEntities()) {
ERACategoryDynamicField e = db.ERACategoryDynamicField.AsQueryable().FirstOrDefault(x => x.Id == id);
//不存在此資料
if (e == null)
{
return(false);
}
Type cl = e.GetType();
foreach (var obj in dicObj)
{
if (cl.GetProperty(obj.Key) != null)
{
cl.GetProperty(obj.Key).SetValue(e, obj.Value);
}
}
db.SaveChanges();
ret = true;
}
return(ret);
}
/// <summary>
/// 修改油資補助金額
/// </summary>
public bool updateOilTransportationSubsidy(long id, Dictionary <string, object> dic)
{
bool ret = false;
using (NaNaEntities db = new NaNaEntities()) {
OilTransportationSubsidy o = db.OilTransportationSubsidy.AsQueryable().FirstOrDefault(x => x.id == id);
//不存在此資料
if (o == null)
{
return(false);
}
Type cl = o.GetType();
foreach (var obj in dic)
{
if (cl.GetProperty(obj.Key) != null)
{
cl.GetProperty(obj.Key).SetValue(o, obj.Value);
}
}
db.SaveChanges();
ret = true;
}
return(ret);
}
public FormFieldsSetting addFormFieldSetting(FormFieldsSetting f)
{
FormFieldsSetting ret = null;
using (NaNaEntities db = new NaNaEntities()) {
ret = db.FormFieldsSetting.Add(f);
db.SaveChanges();
}
return(ret);
}
public ERACategoryDynamicField addERACategoryDynamicField(ERACategoryDynamicField e)
{
ERACategoryDynamicField ret = null;
using (NaNaEntities db = new NaNaEntities()) {
ret = db.ERACategoryDynamicField.Add(e);
db.SaveChanges();
}
return(ret);
}
public ERADynamicFieldSetting addERADynamicFieldSetting(ERADynamicFieldSetting e)
{
ERADynamicFieldSetting ret = null;
using (NaNaEntities db = new NaNaEntities()) {
ret = db.ERADynamicFieldSetting.Add(e);
db.SaveChanges();
}
return(ret);
}
public AccountItemTaxRateSetting addAccountItemTaxRateSetting(AccountItemTaxRateSetting a)
{
AccountItemTaxRateSetting ret = null;
using (NaNaEntities db = new NaNaEntities()) {
ret = db.AccountItemTaxRateSetting.Add(a);
db.SaveChanges();
}
return(ret);
}
//ERAPermissionForInf
public ERAPermissionForInf addERAPermissionForInf(ERAPermissionForInf e)
{
ERAPermissionForInf ret = null;
using (NaNaEntities db = new NaNaEntities()) {
ret = db.ERAPermissionForInf.Add(e);
db.SaveChanges();
}
return(ret);
}
public EmployeeTransportationSetting addEmployeeTransportationSetting(EmployeeTransportationSetting e)
{
EmployeeTransportationSetting ret = null;
using (NaNaEntities db = new NaNaEntities()) {
ret = db.EmployeeTransportationSetting.Add(e);
db.SaveChanges();
}
return(ret);
}
/// <summary>
/// 新增油資補助金額
/// </summary>
public OilTransportationSubsidy addOilTransportationSubsidy(OilTransportationSubsidy o)
{
OilTransportationSubsidy ret = null;
using (NaNaEntities db = new NaNaEntities()) {
ret = db.OilTransportationSubsidy.Add(o);
db.SaveChanges();
}
return(ret);
}
/// <summary>
/// 刪除油價設定檔
/// </summary>
public bool deleteOilTransportationSubsidy(long id)
{
bool ret = false;
using (NaNaEntities db = new NaNaEntities()) {
OilTransportationSubsidy o = db.OilTransportationSubsidy.AsQueryable().FirstOrDefault(x => x.id == id);
//不存在此資料
if (o == null)
{
return(false);
}
db.OilTransportationSubsidy.Remove(o);
db.SaveChanges();
ret = true;
}
return(ret);
}
public bool deleteAccountItemTaxRateSetting(long id)
{
bool ret = false;
using (NaNaEntities db = new NaNaEntities()) {
AccountItemTaxRateSetting a = db.AccountItemTaxRateSetting.FirstOrDefault(x => x.id == id);
if (a == null)
{
return(false);
}
db.AccountItemTaxRateSetting.Remove(a);
db.SaveChanges();
ret = true;
}
return(ret);
}
