public EntityObject_MCE_B_ASSETS_MT_APPLY_EN Load(IDbTransaction transaction, string id, out EntityObject_MCE_B_ASSETS_MT_APPLY base_id, out EntityObject_COM_USER user_id)
{
if (LocalMode)
{
EntityObject_MCE_B_ASSETS_MT_APPLY_EN obj = new EntityObject_MCE_B_ASSETS_MT_APPLY_EN();
//平台自动生成代码
base_id = new EntityObject_MCE_B_ASSETS_MT_APPLY();
user_id = new EntityObject_COM_USER();
obj.ID = id;
obj = HelperObject_MCE_B_ASSETS_MT_APPLY_EN.Get(obj, transaction);
if (!string.IsNullOrEmpty(obj.BASE_ID))
{
base_id.ID = obj.BASE_ID;
base_id = HelperObject_MCE_B_ASSETS_MT_APPLY.Get(base_id, transaction);
}
if (!string.IsNullOrEmpty(obj.USER_ID))
{
user_id.ID = obj.USER_ID;
user_id = HelperObject_COM_USER.Get(user_id, transaction);
}
return(obj);
}
else
{
throw new InvalidConstraintException();
}
}
public BizLogicMsg Audit_Ext(List <string> listID)
{
if (LocalMode)
{
BizLogicMsg msg = new BizLogicMsg();
using (IDbConnection connection = IDALProvider.IDAL.PopConnection())
{
using (IDbTransaction transaction = connection.BeginTransaction())
{
try
{
foreach (string strID in listID)
{
EntityObject_MCE_B_ASSETS_MT_APPLY obj = new EntityObject_MCE_B_ASSETS_MT_APPLY();
obj.ID = strID;
obj = HelperObject_MCE_B_ASSETS_MT_APPLY.Get(obj);
if (obj != null)
{
if (obj.STATE == 3 || obj.STATE == 4)
{
throw new Exception("已经审核的数据不能再审核.");
}
obj.STATE = 3;
obj.AUDIT_TIME = DateTime.Now;
obj.AUDIT_USER_ID = Ipedf.Web.BizLogic.SystemLogic.Proxy.CurrentUser.ID;
HelperObject_MCE_B_ASSETS_MT_APPLY.Update(obj, transaction);
}
}
//平台自动生成代码
transaction.Commit();
}
catch (Exception expt)
{
transaction.Rollback();
msg = new BizLogicMsg(false, expt.Message);
Error(expt);
}
finally
{
IDALProvider.IDAL.PushConnection(connection);
}
}
}
return(msg);
}
else
{
using (ServiceManager <ServiceContract_MCE_B_ASSETS_MT_APPLY> smgr = new ServiceManager <ServiceContract_MCE_B_ASSETS_MT_APPLY>(ServiceUri))
{
return(smgr.Service.Audit_Ext(listID));
}
}
}
public BizLogicMsg CommitUpdate(EntityObject_MCE_B_ASSETS_MT_APPLY updateBaseEntity, EntityObject_[] saveDetailEntities, EntityObject_[] updateDetailEntities, EntityObject_[] deleteDetailEntities)
{
if (LocalMode)
{
BizLogicMsg msg = new BizLogicMsg();
using (IDbConnection connection = IDALProvider.IDAL.PopConnection())
{
using (IDbTransaction transaction = connection.BeginTransaction())
{
try
{
SystemLogic.Proxy.AuditEdit(updateBaseEntity);
HelperObject_MCE_B_ASSETS_MT_APPLY.Update(updateBaseEntity, transaction);
//平台自动生成代码
foreach (EntityObject_ obj in saveDetailEntities)
{
obj. = updateBaseEntity.ID;
SystemLogic.Proxy.AuditAdd(obj);
HelperObject_.Save(obj, transaction);
}
foreach (EntityObject_ obj in updateDetailEntities)
{
SystemLogic.Proxy.AuditEdit(obj);
HelperObject_.Update(obj, transaction);
}
foreach (EntityObject_ obj in deleteDetailEntities)
{
HelperObject_.Delete(obj, transaction);
}
PostSave(updateBaseEntity, transaction);
transaction.Commit();
}
catch (Exception expt)
{
transaction.Rollback();
msg = new BizLogicMsg(false, expt.Message);
Error(expt);
}
finally
{
IDALProvider.IDAL.PushConnection(connection);
}
}
}
return(msg);
}
else
{
using (ServiceManager <ServiceContract_MCE_B_ASSETS_MT_APPLY> smgr = new ServiceManager <ServiceContract_MCE_B_ASSETS_MT_APPLY>(ServiceUri))
{
return(smgr.Service.CommitUpdate(updateBaseEntity, saveDetailEntities, updateDetailEntities, deleteDetailEntities));
}
}
}
public BizLogicMsg Delete_Ext(List <string> listID)
{
if (LocalMode)
{
BizLogicMsg msg = new BizLogicMsg();
using (IDbConnection connection = IDALProvider.IDAL.PopConnection())
{
using (IDbTransaction transaction = connection.BeginTransaction())
{
try
{
foreach (string strID in listID)
{
EntityObject_MCE_B_ASSETS_MT_APPLY obj = new EntityObject_MCE_B_ASSETS_MT_APPLY();
obj.ID = strID;
obj = HelperObject_MCE_B_ASSETS_MT_APPLY.Get(obj);
if (obj != null)
{
if (obj.STATE >= 2)
{
throw new Exception("已经提交的数据不能删除.");
}
HelperObject_MCE_B_ASSETS_MT_APPLY.Delete(obj, transaction);
}
}
//平台自动生成代码
transaction.Commit();
}
catch (Exception expt)
{
transaction.Rollback();
msg = new BizLogicMsg(false, expt.Message);
Error(expt);
}
finally
{
IDALProvider.IDAL.PushConnection(connection);
}
}
}
return(msg);
}
else
{
using (ServiceManager <ServiceContract_MCE_B_ASSETS_MT_APPLY> smgr = new ServiceManager <ServiceContract_MCE_B_ASSETS_MT_APPLY>(ServiceUri))
{
return(smgr.Service.Delete_Ext(listID));
}
}
}
public int DeleteByTrans2(CauseObject_MCE_B_ASSETS_MT_APPLY cause, IDbTransaction transaction)
{
if (LocalMode)
{
return(HelperObject_MCE_B_ASSETS_MT_APPLY.Delete(cause, transaction));
//平台自动生成代码
}
else
{
throw new InvalidConstraintException();
}
}
public int UpdateByTrans(EntityObject_MCE_B_ASSETS_MT_APPLY obj, IDbTransaction transaction)
{
if (LocalMode)
{
SystemLogic.Proxy.AuditEdit(obj);
return(HelperObject_MCE_B_ASSETS_MT_APPLY.Update(obj, transaction));
//平台自动生成代码
}
else
{
throw new InvalidConstraintException();
}
}
public int SaveByTrans(EntityObject_MCE_B_ASSETS_MT_APPLY obj, IDbTransaction transaction)
{
if (LocalMode)
{
SystemLogic.Proxy.AuditAdd(obj);
int amount = HelperObject_MCE_B_ASSETS_MT_APPLY.Save(obj, transaction);
//平台自动生成代码
return(amount);
}
else
{
throw new InvalidConstraintException();
}
}
public DisplayObject_MCE_B_ASSETS_MT_APPLY[] List()
{
if (LocalMode)
{
//平台自动生成代码
return(HelperObject_MCE_B_ASSETS_MT_APPLY.List());
}
else
{
using (ServiceManager <ServiceContract_MCE_B_ASSETS_MT_APPLY> smgr = new ServiceManager <ServiceContract_MCE_B_ASSETS_MT_APPLY>(ServiceUri))
{
return(smgr.Service.List());
}
}
}
public EntityObject_MCE_B_ASSETS_MT_APPLY Get(EntityObject_MCE_B_ASSETS_MT_APPLY obj)
{
if (LocalMode)
{
//平台自动生成代码
return(HelperObject_MCE_B_ASSETS_MT_APPLY.Get(obj));
}
else
{
using (ServiceManager <ServiceContract_MCE_B_ASSETS_MT_APPLY> smgr = new ServiceManager <ServiceContract_MCE_B_ASSETS_MT_APPLY>(ServiceUri))
{
return(smgr.Service.Get(obj));
}
}
}
public BizLogicMsg UndoAudit(EntityObject_MCE_B_ASSETS_MT_APPLY obj)
{
if (LocalMode)
{
BizLogicMsg msg = new BizLogicMsg();
using (IDbConnection connection = IDALProvider.IDAL.PopConnection())
{
using (IDbTransaction transaction = connection.BeginTransaction())
{
try
{
SystemLogic.Proxy.AuditUndoAudit(obj);
int amount = HelperObject_MCE_B_ASSETS_MT_APPLY.Update(obj, transaction);
//平台自动生成代码
PostUndoAudit(obj, transaction);
//执行撤回操作
msg = SystemLogic.Proxy.BillUndoAudit(obj, transaction);
if (!msg.Succeed)
{
throw new Exception(msg.Message);
}
transaction.Commit();
}
catch (Exception expt)
{
SystemLogic.Proxy.AuditState(obj, Ipedf.Common.数据状态.已审核);
transaction.Rollback();
msg = new BizLogicMsg(false, expt.Message);
Error(expt);
}
finally
{
IDALProvider.IDAL.PushConnection(connection);
}
}
}
return(msg);
}
else
{
using (ServiceManager <ServiceContract_MCE_B_ASSETS_MT_APPLY> smgr = new ServiceManager <ServiceContract_MCE_B_ASSETS_MT_APPLY>(ServiceUri))
{
return(smgr.Service.UndoAudit(obj));
}
}
}
public BizLogicMsg BatchUpdate(EntityObject_MCE_B_ASSETS_MT_APPLY[] objs)
{
if (LocalMode)
{
BizLogicMsg msg = new BizLogicMsg();
using (IDbConnection connection = IDALProvider.IDAL.PopConnection())
{
using (IDbTransaction transaction = connection.BeginTransaction())
{
try
{
foreach (EntityObject_MCE_B_ASSETS_MT_APPLY obj in objs)
{
SystemLogic.Proxy.AuditEdit(obj);
}
int amount = 0;
//平台自动生成代码
foreach (EntityObject_MCE_B_ASSETS_MT_APPLY obj in objs)
{
amount += HelperObject_MCE_B_ASSETS_MT_APPLY.Update(obj, transaction);
}
transaction.Commit();
}
catch (Exception expt)
{
transaction.Rollback();
msg = new BizLogicMsg(false, expt.Message);
Error(expt);
}
finally
{
IDALProvider.IDAL.PushConnection(connection);
}
}
}
return(msg);
}
else
{
using (ServiceManager <ServiceContract_MCE_B_ASSETS_MT_APPLY> smgr = new ServiceManager <ServiceContract_MCE_B_ASSETS_MT_APPLY>(ServiceUri))
{
return(smgr.Service.BatchUpdate(objs));
}
}
}
public DisplayObject_MCE_B_ASSETS_MT_APPLY[] Query(CauseObject_MCE_B_ASSETS_MT_APPLY cause, PagingParamter paging, OrderByParameter order)
{
if (LocalMode)
{
SystemLogic.Proxy.AuditQuery(cause);
//平台自动生成代码
return(HelperObject_MCE_B_ASSETS_MT_APPLY.Query(cause, paging, order));
}
else
{
using (ServiceManager <ServiceContract_MCE_B_ASSETS_MT_APPLY> smgr = new ServiceManager <ServiceContract_MCE_B_ASSETS_MT_APPLY>(ServiceUri))
{
return(smgr.Service.Query(cause, paging, order));
}
}
}
public BizLogicMsg CommitDelete(EntityObject_MCE_B_ASSETS_MT_APPLY deleteBaseEntity)
{
if (LocalMode)
{
BizLogicMsg msg = new BizLogicMsg();
using (IDbConnection connection = IDALProvider.IDAL.PopConnection())
{
using (IDbTransaction transaction = connection.BeginTransaction())
{
try
{
//平台自动生成代码
CauseObject_ p = new CauseObject_();
p. = deleteBaseEntity.ID;
HelperObject_.Delete(p, transaction);
HelperObject_MCE_B_ASSETS_MT_APPLY.Delete(deleteBaseEntity, transaction);
transaction.Commit();
}
catch (Exception expt)
{
transaction.Rollback();
msg = new BizLogicMsg(false, expt.Message);
Error(expt);
}
finally
{
IDALProvider.IDAL.PushConnection(connection);
}
}
}
return(msg);
}
else
{
using (ServiceManager <ServiceContract_MCE_B_ASSETS_MT_APPLY> smgr = new ServiceManager <ServiceContract_MCE_B_ASSETS_MT_APPLY>(ServiceUri))
{
return(smgr.Service.CommitDelete(deleteBaseEntity));
}
}
}
public BizLogicMsg Delete(CauseObject_MCE_B_ASSETS_MT_APPLY cause)
{
if (LocalMode)
{
BizLogicMsg msg = new BizLogicMsg();
using (IDbConnection connection = IDALProvider.IDAL.PopConnection())
{
using (IDbTransaction transaction = connection.BeginTransaction())
{
try
{
int amount = HelperObject_MCE_B_ASSETS_MT_APPLY.Delete(cause, transaction);
//平台自动生成代码
transaction.Commit();
}
catch (Exception expt)
{
transaction.Rollback();
msg = new BizLogicMsg(false, expt.Message);
Error(expt);
}
finally
{
IDALProvider.IDAL.PushConnection(connection);
}
}
}
return(msg);
}
else
{
using (ServiceManager <ServiceContract_MCE_B_ASSETS_MT_APPLY> smgr = new ServiceManager <ServiceContract_MCE_B_ASSETS_MT_APPLY>(ServiceUri))
{
return(smgr.Service.Delete(cause));
}
}
}
public EntityObject_MCE_B_ASSETS_MT_APPLY Load(IDbTransaction transaction, string id, out EntityObject_MDM_D_DEPT prd_id, out EntityObject_COM_USER apply_user_id, out EntityObject_COM_TYPE mtn_type_id, out EntityObject_COM_DEPART apply_dept_id, out EntityObject_COM_USER using_user_id, out EntityObject_COM_TYPE repair_result, out EntityObject_MCE_D_MCE_TYPE assets_type_id, out EntityObject_COM_TYPE emergency_degree, out EntityObject_COM_DEPART using_dept_id, out EntityObject_COM_TYPE fault_type, out EntityObject_MCE_B_ASSETS assets_id)
{
if (LocalMode)
{
EntityObject_MCE_B_ASSETS_MT_APPLY obj = new EntityObject_MCE_B_ASSETS_MT_APPLY();
//平台自动生成代码
prd_id = new EntityObject_MDM_D_DEPT();
apply_user_id = new EntityObject_COM_USER();
mtn_type_id = new EntityObject_COM_TYPE();
apply_dept_id = new EntityObject_COM_DEPART();
using_user_id = new EntityObject_COM_USER();
repair_result = new EntityObject_COM_TYPE();
assets_type_id = new EntityObject_MCE_D_MCE_TYPE();
emergency_degree = new EntityObject_COM_TYPE();
using_dept_id = new EntityObject_COM_DEPART();
fault_type = new EntityObject_COM_TYPE();
assets_id = new EntityObject_MCE_B_ASSETS();
obj.ID = id;
obj = HelperObject_MCE_B_ASSETS_MT_APPLY.Get(obj, transaction);
if (!string.IsNullOrEmpty(obj.PRD_ID))
{
prd_id.ID = obj.PRD_ID;
prd_id = HelperObject_MDM_D_DEPT.Get(prd_id, transaction);
}
if (!string.IsNullOrEmpty(obj.APPLY_USER_ID))
{
apply_user_id.ID = obj.APPLY_USER_ID;
apply_user_id = HelperObject_COM_USER.Get(apply_user_id, transaction);
}
if (!string.IsNullOrEmpty(obj.MTN_TYPE_ID))
{
mtn_type_id.ID = obj.MTN_TYPE_ID;
mtn_type_id = HelperObject_COM_TYPE.Get(mtn_type_id, transaction);
}
if (!string.IsNullOrEmpty(obj.APPLY_DEPT_ID))
{
apply_dept_id.ID = obj.APPLY_DEPT_ID;
apply_dept_id = HelperObject_COM_DEPART.Get(apply_dept_id, transaction);
}
if (!string.IsNullOrEmpty(obj.USING_USER_ID))
{
using_user_id.ID = obj.USING_USER_ID;
using_user_id = HelperObject_COM_USER.Get(using_user_id, transaction);
}
if (!string.IsNullOrEmpty(obj.REPAIR_RESULT))
{
repair_result.ID = obj.REPAIR_RESULT;
repair_result = HelperObject_COM_TYPE.Get(repair_result, transaction);
}
if (!string.IsNullOrEmpty(obj.ASSETS_TYPE_ID))
{
assets_type_id.ID = obj.ASSETS_TYPE_ID;
assets_type_id = HelperObject_MCE_D_MCE_TYPE.Get(assets_type_id, transaction);
}
if (!string.IsNullOrEmpty(obj.EMERGENCY_DEGREE))
{
emergency_degree.ID = obj.EMERGENCY_DEGREE;
emergency_degree = HelperObject_COM_TYPE.Get(emergency_degree, transaction);
}
if (!string.IsNullOrEmpty(obj.USING_DEPT_ID))
{
using_dept_id.ID = obj.USING_DEPT_ID;
using_dept_id = HelperObject_COM_DEPART.Get(using_dept_id, transaction);
}
if (!string.IsNullOrEmpty(obj.FAULT_TYPE))
{
fault_type.ID = obj.FAULT_TYPE;
fault_type = HelperObject_COM_TYPE.Get(fault_type, transaction);
}
if (!string.IsNullOrEmpty(obj.ASSETS_ID))
{
assets_id.ID = obj.ASSETS_ID;
assets_id = HelperObject_MCE_B_ASSETS.Get(assets_id, transaction);
}
return(obj);
}
else
{
throw new InvalidConstraintException();
}
}
public BizLogicMsg Save_Ext(JsonMCE_MT_APPLY json)
{
if (LocalMode)
{
BizLogicMsg msg = new BizLogicMsg();
using (IDbConnection connection = IDALProvider.IDAL.PopConnection())
{
using (IDbTransaction transaction = connection.BeginTransaction())
{
try
{
EntityObject_MCE_B_ASSETS_MT_APPLY entity = new EntityObject_MCE_B_ASSETS_MT_APPLY();
if (!string.IsNullOrEmpty(json.ID))
{
entity.ID = json.ID;
entity = HelperObject_MCE_B_ASSETS_MT_APPLY.Get(entity);
if (entity == null)
{
throw new Exception("获取数据出错.");
}
}
entity.CODE = json.CODE;
entity.APPLY_DEPT_ID = json.APPLY_DEPT_ID;
entity.APPLY_USER_ID = json.APPLY_USER_ID;
entity.ASSETS_ID = json.ASSETS_ID;
entity.ASSETS_CODE = json.ASSETS_CODE;
entity.SPEC = json.SPEC;
entity.ASSETS_TYPE_ID = json.ASSETS_TYPE_ID;
entity.PRD_ID = json.PRD_ID;
entity.MTN_TYPE_ID = json.MTN_TYPE_ID;
entity.FAULT_TYPE = json.FAULT_TYPE;
entity.EMERGENCY_DEGREE = json.EMERGENCY_DEGREE;
entity.REPAIR_RESULT = json.REPAIR_RESULT;
if (!string.IsNullOrEmpty(json.CREATE_DATE))
{
entity.CREATE_DATE = DateTime.Parse(json.CREATE_DATE);
}
entity.APPLY_USER_PHONE = json.APPLY_USER_PHONE;
if (!string.IsNullOrEmpty(json.COMPLETE_TIME))
{
entity.COMPLETE_TIME = DateTime.Parse(json.COMPLETE_TIME);
}
entity.MTN_ENGINEER = json.MTN_ENGINEER;
if (!string.IsNullOrEmpty(json.MTN_TOTAL_HOURS))
{
entity.MTN_TOTAL_HOURS = decimal.Parse(json.MTN_TOTAL_HOURS);
}
if (!string.IsNullOrEmpty(json.MAINTAIN_MONEY))
{
entity.MAINTAIN_MONEY = decimal.Parse(json.MAINTAIN_MONEY);
}
entity.INVOICE_CODE = json.INVOICE_CODE;
entity.FAULT_DESC = json.FAULT_DESC;
entity.FAULT_ANALYSIS = json.FAULT_ANALYSIS;
entity.FAULT_SOLUTION = json.FAULT_SOLUTION;
if (string.IsNullOrEmpty(entity.ID))
{
entity.STATE = 1;
entity.CREATE_TIME = DateTime.Now;
entity.CREATE_USER_ID = Ipedf.Web.BizLogic.SystemLogic.Proxy.CurrentUser.ID;
int amount = HelperObject_MCE_B_ASSETS_MT_APPLY.Save(entity, transaction);
}
else
{
entity.MODIFY_TIME = DateTime.Now;
entity.MODIFY_USER_ID = Ipedf.Web.BizLogic.SystemLogic.Proxy.CurrentUser.ID;
int amount = HelperObject_MCE_B_ASSETS_MT_APPLY.Update(entity, transaction);
CauseObject_COM_FILE pCOM_FILE = new CauseObject_COM_FILE();
pCOM_FILE.REF_TAB_ID = entity.ID;
pCOM_FILE.REF_TAB_NAME = "MCE_B_ASSETS_MT_APPLY";
HelperObject_COM_FILE.Delete(pCOM_FILE, transaction);
}
if (json.listAttach != null && json.listAttach.Count > 0)
{
foreach (JsonMCEMT_APPLY_MTN_ATTACH item in json.listAttach)
{
Ipedf.Web.Entity.EntityObject_COM_FILE entityPicFile = new Ipedf.Web.Entity.EntityObject_COM_FILE();
entityPicFile.REF_TAB_NAME = "MCE_B_ASSETS_MT_APPLY";
entityPicFile.CLIENT_NAME = item.CLIENT_NAME;
entityPicFile.STATE = 1;
entityPicFile.CREATE_TIME = item.CREATE_TIME;
entityPicFile.CREATE_USER_ID = Ipedf.Web.BizLogic.SystemLogic.Proxy.CurrentUser.ID;
entityPicFile.REF_TAB_ID = entity.ID;
entityPicFile.SERVER_NAME = item.SERVER_NAME;
entityPicFile.IS_IMPORT = 0;
Ipedf.Web.DataAccess.HelperObject_COM_FILE.Save(entityPicFile, transaction);
}
}
msg.Message = entity.ID;
transaction.Commit();
}
catch (Exception expt)
{
transaction.Rollback();
msg = new BizLogicMsg(false, expt.Message);
Error(expt);
}
finally
{
IDALProvider.IDAL.PushConnection(connection);
}
}
}
return(msg);
}
else
{
using (ServiceManager <ServiceContract_MCE_B_ASSETS_MT_APPLY> smgr = new ServiceManager <ServiceContract_MCE_B_ASSETS_MT_APPLY>(ServiceUri))
{
return(smgr.Service.Save_Ext(json));
}
}
}
