public EntityObject_MCE_B_ASSETS_DEPR Load(IDbTransaction transaction, string id, out EntityObject_COM_DEPART dept_id, out EntityObject_COM_USER user_id)
{
if (LocalMode)
{
EntityObject_MCE_B_ASSETS_DEPR obj = new EntityObject_MCE_B_ASSETS_DEPR();
//平台自动生成代码
dept_id = new EntityObject_COM_DEPART();
user_id = new EntityObject_COM_USER();
obj.ID = id;
obj = HelperObject_MCE_B_ASSETS_DEPR.Get(obj, transaction);
if (!string.IsNullOrEmpty(obj.DEPT_ID))
{
dept_id.ID = obj.DEPT_ID;
dept_id = HelperObject_COM_DEPART.Get(dept_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 EntityObject_MCE_B_ASSETS_METER_CHECK Load(IDbTransaction transaction, string id, out EntityObject_MDM_D_DEPT prd_id, out EntityObject_COM_TYPE unit_id, out EntityObject_MCE_B_ASSETS_METER_TYPE meter_type, out EntityObject_COM_USER head_user_id, out EntityObject_COM_USER audit_user_id, out EntityObject_COM_DEPART using_dept_id, out EntityObject_MCE_B_ASSETS assets_id)
{
if (LocalMode)
{
EntityObject_MCE_B_ASSETS_METER_CHECK obj = new EntityObject_MCE_B_ASSETS_METER_CHECK();
//平台自动生成代码
prd_id = new EntityObject_MDM_D_DEPT();
unit_id = new EntityObject_COM_TYPE();
meter_type = new EntityObject_MCE_B_ASSETS_METER_TYPE();
head_user_id = new EntityObject_COM_USER();
audit_user_id = new EntityObject_COM_USER();
using_dept_id = new EntityObject_COM_DEPART();
assets_id = new EntityObject_MCE_B_ASSETS();
obj.ID = id;
obj = HelperObject_MCE_B_ASSETS_METER_CHECK.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.UNIT_ID))
{
unit_id.ID = obj.UNIT_ID;
unit_id = HelperObject_COM_TYPE.Get(unit_id, transaction);
}
if (!string.IsNullOrEmpty(obj.METER_TYPE))
{
meter_type.ID = obj.METER_TYPE;
meter_type = HelperObject_MCE_B_ASSETS_METER_TYPE.Get(meter_type, transaction);
}
if (!string.IsNullOrEmpty(obj.HEAD_USER_ID))
{
head_user_id.ID = obj.HEAD_USER_ID;
head_user_id = HelperObject_COM_USER.Get(head_user_id, transaction);
}
if (!string.IsNullOrEmpty(obj.AUDIT_USER_ID))
{
audit_user_id.ID = obj.AUDIT_USER_ID;
audit_user_id = HelperObject_COM_USER.Get(audit_user_id, 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.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 EntityObject_MCE_B_ASSETS_WRITE_OFF Load(IDbTransaction transaction, string id, out EntityObject_COM_USER identity_user_id, out EntityObject_COM_TYPE write_off_type_id, out EntityObject_COM_DEPART dept_id, out EntityObject_COM_TYPE write_off_cause_id, out EntityObject_COM_USER audit_user_id, out EntityObject_MCE_B_ASSETS assets_id, out EntityObject_COM_USER user_id)
{
if (LocalMode)
{
EntityObject_MCE_B_ASSETS_WRITE_OFF obj = new EntityObject_MCE_B_ASSETS_WRITE_OFF();
//平台自动生成代码
identity_user_id = new EntityObject_COM_USER();
write_off_type_id = new EntityObject_COM_TYPE();
dept_id = new EntityObject_COM_DEPART();
write_off_cause_id = new EntityObject_COM_TYPE();
audit_user_id = new EntityObject_COM_USER();
assets_id = new EntityObject_MCE_B_ASSETS();
user_id = new EntityObject_COM_USER();
obj.ID = id;
obj = HelperObject_MCE_B_ASSETS_WRITE_OFF.Get(obj, transaction);
if (!string.IsNullOrEmpty(obj.IDENTITY_USER_ID))
{
identity_user_id.ID = obj.IDENTITY_USER_ID;
identity_user_id = HelperObject_COM_USER.Get(identity_user_id, transaction);
}
if (!string.IsNullOrEmpty(obj.WRITE_OFF_TYPE_ID))
{
write_off_type_id.ID = obj.WRITE_OFF_TYPE_ID;
write_off_type_id = HelperObject_COM_TYPE.Get(write_off_type_id, transaction);
}
if (!string.IsNullOrEmpty(obj.DEPT_ID))
{
dept_id.ID = obj.DEPT_ID;
dept_id = HelperObject_COM_DEPART.Get(dept_id, transaction);
}
if (!string.IsNullOrEmpty(obj.WRITE_OFF_CAUSE_ID))
{
write_off_cause_id.ID = obj.WRITE_OFF_CAUSE_ID;
write_off_cause_id = HelperObject_COM_TYPE.Get(write_off_cause_id, transaction);
}
if (!string.IsNullOrEmpty(obj.AUDIT_USER_ID))
{
audit_user_id.ID = obj.AUDIT_USER_ID;
audit_user_id = HelperObject_COM_USER.Get(audit_user_id, transaction);
}
if (!string.IsNullOrEmpty(obj.ASSETS_ID))
{
assets_id.ID = obj.ASSETS_ID;
assets_id = HelperObject_MCE_B_ASSETS.Get(assets_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 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 EntityObject_MCE_B_ASSETS_CONTRACT Load(IDbTransaction transaction, string id, out EntityObject_COM_USER input_person, out EntityObject_MCE_B_ASSETS assets_id, out EntityObject_COM_TYPE type_id, out EntityObject_MDM_D_DEPT second_party, out EntityObject_COM_DEPART first_party, out EntityObject_COM_USER archivist)
{
if (LocalMode)
{
EntityObject_MCE_B_ASSETS_CONTRACT obj = new EntityObject_MCE_B_ASSETS_CONTRACT();
//平台自动生成代码
input_person = new EntityObject_COM_USER();
assets_id = new EntityObject_MCE_B_ASSETS();
type_id = new EntityObject_COM_TYPE();
second_party = new EntityObject_MDM_D_DEPT();
first_party = new EntityObject_COM_DEPART();
archivist = new EntityObject_COM_USER();
obj.ID = id;
obj = HelperObject_MCE_B_ASSETS_CONTRACT.Get(obj, transaction);
if (!string.IsNullOrEmpty(obj.INPUT_PERSON))
{
input_person.ID = obj.INPUT_PERSON;
input_person = HelperObject_COM_USER.Get(input_person, transaction);
}
if (!string.IsNullOrEmpty(obj.ASSETS_ID))
{
assets_id.ID = obj.ASSETS_ID;
assets_id = HelperObject_MCE_B_ASSETS.Get(assets_id, transaction);
}
if (!string.IsNullOrEmpty(obj.TYPE_ID))
{
type_id.ID = obj.TYPE_ID;
type_id = HelperObject_COM_TYPE.Get(type_id, transaction);
}
if (!string.IsNullOrEmpty(obj.SECOND_PARTY))
{
second_party.ID = obj.SECOND_PARTY;
second_party = HelperObject_MDM_D_DEPT.Get(second_party, transaction);
}
if (!string.IsNullOrEmpty(obj.FIRST_PARTY))
{
first_party.ID = obj.FIRST_PARTY;
first_party = HelperObject_COM_DEPART.Get(first_party, transaction);
}
if (!string.IsNullOrEmpty(obj.ARCHIVIST))
{
archivist.ID = obj.ARCHIVIST;
archivist = HelperObject_COM_USER.Get(archivist, transaction);
}
return(obj);
}
else
{
throw new InvalidConstraintException();
}
}
public EntityObject_MCE_B_AOG Load(IDbTransaction transaction, string id, out EntityObject_COM_DEPART use_dept_id, out EntityObject_COM_USER use_user_id, out EntityObject_MDM_D_DEPT provider_id, out EntityObject_COM_USER install_user_id, out EntityObject_MDM_D_DEPT dealer_id, out EntityObject_COM_USER purcharse_person_id)
{
if (LocalMode)
{
EntityObject_MCE_B_AOG obj = new EntityObject_MCE_B_AOG();
//平台自动生成代码
use_dept_id = new EntityObject_COM_DEPART();
use_user_id = new EntityObject_COM_USER();
provider_id = new EntityObject_MDM_D_DEPT();
install_user_id = new EntityObject_COM_USER();
dealer_id = new EntityObject_MDM_D_DEPT();
purcharse_person_id = new EntityObject_COM_USER();
obj.ID = id;
obj = HelperObject_MCE_B_AOG.Get(obj, transaction);
if (!string.IsNullOrEmpty(obj.USE_DEPT_ID))
{
use_dept_id.ID = obj.USE_DEPT_ID;
use_dept_id = HelperObject_COM_DEPART.Get(use_dept_id, transaction);
}
if (!string.IsNullOrEmpty(obj.USE_USER_ID))
{
use_user_id.ID = obj.USE_USER_ID;
use_user_id = HelperObject_COM_USER.Get(use_user_id, transaction);
}
if (!string.IsNullOrEmpty(obj.PROVIDER_ID))
{
provider_id.ID = obj.PROVIDER_ID;
provider_id = HelperObject_MDM_D_DEPT.Get(provider_id, transaction);
}
if (!string.IsNullOrEmpty(obj.INSTALL_USER_ID))
{
install_user_id.ID = obj.INSTALL_USER_ID;
install_user_id = HelperObject_COM_USER.Get(install_user_id, transaction);
}
if (!string.IsNullOrEmpty(obj.DEALER_ID))
{
dealer_id.ID = obj.DEALER_ID;
dealer_id = HelperObject_MDM_D_DEPT.Get(dealer_id, transaction);
}
if (!string.IsNullOrEmpty(obj.PURCHARSE_PERSON_ID))
{
purcharse_person_id.ID = obj.PURCHARSE_PERSON_ID;
purcharse_person_id = HelperObject_COM_USER.Get(purcharse_person_id, transaction);
}
return(obj);
}
else
{
throw new InvalidConstraintException();
}
}
public EntityObject_MCE_B_ASSETS_OUTSTOCK Load(IDbTransaction transaction, string id, out EntityObject_COM_USER create_user_id, out EntityObject_COM_DEPART using_dept_id, out EntityObject_COM_USER user_id, out EntityObject_COM_USER using_user_id, out EntityObject_COM_DEPART dept_id, out EntityObject_MDM_D_STOCK stock_id)
{
if (LocalMode)
{
EntityObject_MCE_B_ASSETS_OUTSTOCK obj = new EntityObject_MCE_B_ASSETS_OUTSTOCK();
//平台自动生成代码
create_user_id = new EntityObject_COM_USER();
using_dept_id = new EntityObject_COM_DEPART();
user_id = new EntityObject_COM_USER();
using_user_id = new EntityObject_COM_USER();
dept_id = new EntityObject_COM_DEPART();
stock_id = new EntityObject_MDM_D_STOCK();
obj.ID = id;
obj = HelperObject_MCE_B_ASSETS_OUTSTOCK.Get(obj, transaction);
if (!string.IsNullOrEmpty(obj.CREATE_USER_ID))
{
create_user_id.ID = obj.CREATE_USER_ID;
create_user_id = HelperObject_COM_USER.Get(create_user_id, 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.USER_ID))
{
user_id.ID = obj.USER_ID;
user_id = HelperObject_COM_USER.Get(user_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.DEPT_ID))
{
dept_id.ID = obj.DEPT_ID;
dept_id = HelperObject_COM_DEPART.Get(dept_id, transaction);
}
if (!string.IsNullOrEmpty(obj.STOCK_ID))
{
stock_id.ID = obj.STOCK_ID;
stock_id = HelperObject_MDM_D_STOCK.Get(stock_id, transaction);
}
return(obj);
}
else
{
throw new InvalidConstraintException();
}
}
public EntityObject_MCE_B_ASSETS_MT_APPLY Load(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();
using (IDbConnection connection = IDALProvider.IDAL.PopConnection())
{
using (IDbTransaction transaction = connection.BeginTransaction())
{
try
{
obj = Load(transaction, id, out prd_id, out apply_user_id, out mtn_type_id, out apply_dept_id, out using_user_id, out repair_result, out assets_type_id, out emergency_degree, out using_dept_id, out fault_type, out assets_id);
transaction.Commit();
}
catch (Exception expt)
{
transaction.Rollback();
Error(expt);
}
finally
{
IDALProvider.IDAL.PushConnection(connection);
}
}
}
return(obj);
}
else
{
using (ServiceManager <ServiceContract_MCE_B_ASSETS_MT_APPLY> smgr = new ServiceManager <ServiceContract_MCE_B_ASSETS_MT_APPLY>(ServiceUri))
{
return(smgr.Service.Load(id, out prd_id, out apply_user_id, out mtn_type_id, out apply_dept_id, out using_user_id, out repair_result, out assets_type_id, out emergency_degree, out using_dept_id, out fault_type, out assets_id));
}
}
}
public EntityObject_MCE_B_ASSETS_ROLL Load(IDbTransaction transaction, string id, out EntityObject_COM_TYPE roll_property, out EntityObject_COM_USER create_user_id, out EntityObject_COM_TYPE savelimit, out EntityObject_COM_TYPE roll_type, out EntityObject_COM_TYPE plan_type)
{
if (LocalMode)
{
EntityObject_MCE_B_ASSETS_ROLL obj = new EntityObject_MCE_B_ASSETS_ROLL();
//平台自动生成代码
roll_property = new EntityObject_COM_TYPE();
create_user_id = new EntityObject_COM_USER();
savelimit = new EntityObject_COM_TYPE();
roll_type = new EntityObject_COM_TYPE();
plan_type = new EntityObject_COM_TYPE();
obj.ID = id;
obj = HelperObject_MCE_B_ASSETS_ROLL.Get(obj, transaction);
if (!string.IsNullOrEmpty(obj.ROLL_PROPERTY))
{
roll_property.ID = obj.ROLL_PROPERTY;
roll_property = HelperObject_COM_TYPE.Get(roll_property, transaction);
}
if (!string.IsNullOrEmpty(obj.CREATE_USER_ID))
{
create_user_id.ID = obj.CREATE_USER_ID;
create_user_id = HelperObject_COM_USER.Get(create_user_id, transaction);
}
if (!string.IsNullOrEmpty(obj.SAVELIMIT))
{
savelimit.ID = obj.SAVELIMIT;
savelimit = HelperObject_COM_TYPE.Get(savelimit, transaction);
}
if (!string.IsNullOrEmpty(obj.ROLL_TYPE))
{
roll_type.ID = obj.ROLL_TYPE;
roll_type = HelperObject_COM_TYPE.Get(roll_type, transaction);
}
if (!string.IsNullOrEmpty(obj.PLAN_TYPE))
{
plan_type.ID = obj.PLAN_TYPE;
plan_type = HelperObject_COM_TYPE.Get(plan_type, transaction);
}
return(obj);
}
else
{
throw new InvalidConstraintException();
}
}
public EntityObject_MCE_B_ASSETS_WRITE_OFF Load(string id, out EntityObject_COM_USER identity_user_id, out EntityObject_COM_TYPE write_off_type_id, out EntityObject_COM_DEPART dept_id, out EntityObject_COM_TYPE write_off_cause_id, out EntityObject_COM_USER audit_user_id, out EntityObject_MCE_B_ASSETS assets_id, out EntityObject_COM_USER user_id)
{
if (LocalMode)
{
EntityObject_MCE_B_ASSETS_WRITE_OFF obj = new EntityObject_MCE_B_ASSETS_WRITE_OFF();
//平台自动生成代码
identity_user_id = new EntityObject_COM_USER();
write_off_type_id = new EntityObject_COM_TYPE();
dept_id = new EntityObject_COM_DEPART();
write_off_cause_id = new EntityObject_COM_TYPE();
audit_user_id = new EntityObject_COM_USER();
assets_id = new EntityObject_MCE_B_ASSETS();
user_id = new EntityObject_COM_USER();
using (IDbConnection connection = IDALProvider.IDAL.PopConnection())
{
using (IDbTransaction transaction = connection.BeginTransaction())
{
try
{
obj = Load(transaction, id, out identity_user_id, out write_off_type_id, out dept_id, out write_off_cause_id, out audit_user_id, out assets_id, out user_id);
transaction.Commit();
}
catch (Exception expt)
{
transaction.Rollback();
Error(expt);
}
finally
{
IDALProvider.IDAL.PushConnection(connection);
}
}
}
return(obj);
}
else
{
using (ServiceManager <ServiceContract_MCE_B_ASSETS_WRITE_OFF> smgr = new ServiceManager <ServiceContract_MCE_B_ASSETS_WRITE_OFF>(ServiceUri))
{
return(smgr.Service.Load(id, out identity_user_id, out write_off_type_id, out dept_id, out write_off_cause_id, out audit_user_id, out assets_id, out user_id));
}
}
}
public EntityObject_MCE_B_ASSETS_METER_CHECK Load(string id, out EntityObject_MDM_D_DEPT prd_id, out EntityObject_COM_TYPE unit_id, out EntityObject_MCE_B_ASSETS_METER_TYPE meter_type, out EntityObject_COM_USER head_user_id, out EntityObject_COM_USER audit_user_id, out EntityObject_COM_DEPART using_dept_id, out EntityObject_MCE_B_ASSETS assets_id)
{
if (LocalMode)
{
EntityObject_MCE_B_ASSETS_METER_CHECK obj = new EntityObject_MCE_B_ASSETS_METER_CHECK();
//平台自动生成代码
prd_id = new EntityObject_MDM_D_DEPT();
unit_id = new EntityObject_COM_TYPE();
meter_type = new EntityObject_MCE_B_ASSETS_METER_TYPE();
head_user_id = new EntityObject_COM_USER();
audit_user_id = new EntityObject_COM_USER();
using_dept_id = new EntityObject_COM_DEPART();
assets_id = new EntityObject_MCE_B_ASSETS();
using (IDbConnection connection = IDALProvider.IDAL.PopConnection())
{
using (IDbTransaction transaction = connection.BeginTransaction())
{
try
{
obj = Load(transaction, id, out prd_id, out unit_id, out meter_type, out head_user_id, out audit_user_id, out using_dept_id, out assets_id);
transaction.Commit();
}
catch (Exception expt)
{
transaction.Rollback();
Error(expt);
}
finally
{
IDALProvider.IDAL.PushConnection(connection);
}
}
}
return(obj);
}
else
{
using (ServiceManager <ServiceContract_MCE_B_ASSETS_METER_CHECK> smgr = new ServiceManager <ServiceContract_MCE_B_ASSETS_METER_CHECK>(ServiceUri))
{
return(smgr.Service.Load(id, out prd_id, out unit_id, out meter_type, out head_user_id, out audit_user_id, out using_dept_id, out assets_id));
}
}
}
public EntityObject_MCE_B_ASSETS_CONTRACT Load(string id, out EntityObject_COM_USER input_person, out EntityObject_MCE_B_ASSETS assets_id, out EntityObject_COM_TYPE type_id, out EntityObject_MDM_D_DEPT second_party, out EntityObject_COM_DEPART first_party, out EntityObject_COM_USER archivist)
{
if (LocalMode)
{
EntityObject_MCE_B_ASSETS_CONTRACT obj = new EntityObject_MCE_B_ASSETS_CONTRACT();
//平台自动生成代码
input_person = new EntityObject_COM_USER();
assets_id = new EntityObject_MCE_B_ASSETS();
type_id = new EntityObject_COM_TYPE();
second_party = new EntityObject_MDM_D_DEPT();
first_party = new EntityObject_COM_DEPART();
archivist = new EntityObject_COM_USER();
using (IDbConnection connection = IDALProvider.IDAL.PopConnection())
{
using (IDbTransaction transaction = connection.BeginTransaction())
{
try
{
obj = Load(transaction, id, out input_person, out assets_id, out type_id, out second_party, out first_party, out archivist);
transaction.Commit();
}
catch (Exception expt)
{
transaction.Rollback();
Error(expt);
}
finally
{
IDALProvider.IDAL.PushConnection(connection);
}
}
}
return(obj);
}
else
{
using (ServiceManager <ServiceContract_MCE_B_ASSETS_CONTRACT> smgr = new ServiceManager <ServiceContract_MCE_B_ASSETS_CONTRACT>(ServiceUri))
{
return(smgr.Service.Load(id, out input_person, out assets_id, out type_id, out second_party, out first_party, out archivist));
}
}
}
public EntityObject_MCE_B_ASSETS_OUTSTOCK Load(string id, out EntityObject_COM_USER create_user_id, out EntityObject_COM_DEPART using_dept_id, out EntityObject_COM_USER user_id, out EntityObject_COM_USER using_user_id, out EntityObject_COM_DEPART dept_id, out EntityObject_MDM_D_STOCK stock_id)
{
if (LocalMode)
{
EntityObject_MCE_B_ASSETS_OUTSTOCK obj = new EntityObject_MCE_B_ASSETS_OUTSTOCK();
//平台自动生成代码
create_user_id = new EntityObject_COM_USER();
using_dept_id = new EntityObject_COM_DEPART();
user_id = new EntityObject_COM_USER();
using_user_id = new EntityObject_COM_USER();
dept_id = new EntityObject_COM_DEPART();
stock_id = new EntityObject_MDM_D_STOCK();
using (IDbConnection connection = IDALProvider.IDAL.PopConnection())
{
using (IDbTransaction transaction = connection.BeginTransaction())
{
try
{
obj = Load(transaction, id, out create_user_id, out using_dept_id, out user_id, out using_user_id, out dept_id, out stock_id);
transaction.Commit();
}
catch (Exception expt)
{
transaction.Rollback();
Error(expt);
}
finally
{
IDALProvider.IDAL.PushConnection(connection);
}
}
}
return(obj);
}
else
{
using (ServiceManager <ServiceContract_MCE_B_ASSETS_OUTSTOCK> smgr = new ServiceManager <ServiceContract_MCE_B_ASSETS_OUTSTOCK>(ServiceUri))
{
return(smgr.Service.Load(id, out create_user_id, out using_dept_id, out user_id, out using_user_id, out dept_id, out stock_id));
}
}
}
public EntityObject_MCE_B_AOG Load(string id, out EntityObject_COM_DEPART use_dept_id, out EntityObject_COM_USER use_user_id, out EntityObject_MDM_D_DEPT provider_id, out EntityObject_COM_USER install_user_id, out EntityObject_MDM_D_DEPT dealer_id, out EntityObject_COM_USER purcharse_person_id)
{
if (LocalMode)
{
EntityObject_MCE_B_AOG obj = new EntityObject_MCE_B_AOG();
//平台自动生成代码
use_dept_id = new EntityObject_COM_DEPART();
use_user_id = new EntityObject_COM_USER();
provider_id = new EntityObject_MDM_D_DEPT();
install_user_id = new EntityObject_COM_USER();
dealer_id = new EntityObject_MDM_D_DEPT();
purcharse_person_id = new EntityObject_COM_USER();
using (IDbConnection connection = IDALProvider.IDAL.PopConnection())
{
using (IDbTransaction transaction = connection.BeginTransaction())
{
try
{
obj = Load(transaction, id, out use_dept_id, out use_user_id, out provider_id, out install_user_id, out dealer_id, out purcharse_person_id);
transaction.Commit();
}
catch (Exception expt)
{
transaction.Rollback();
Error(expt);
}
finally
{
IDALProvider.IDAL.PushConnection(connection);
}
}
}
return(obj);
}
else
{
using (ServiceManager <ServiceContract_MCE_B_AOG> smgr = new ServiceManager <ServiceContract_MCE_B_AOG>(ServiceUri))
{
return(smgr.Service.Load(id, out use_dept_id, out use_user_id, out provider_id, out install_user_id, out dealer_id, out purcharse_person_id));
}
}
}
public EntityObject_MCE_B_ASSETS_ROLL Load(string id, out EntityObject_COM_TYPE roll_property, out EntityObject_COM_USER create_user_id, out EntityObject_COM_TYPE savelimit, out EntityObject_COM_TYPE roll_type, out EntityObject_COM_TYPE plan_type)
{
if (LocalMode)
{
EntityObject_MCE_B_ASSETS_ROLL obj = new EntityObject_MCE_B_ASSETS_ROLL();
//平台自动生成代码
roll_property = new EntityObject_COM_TYPE();
create_user_id = new EntityObject_COM_USER();
savelimit = new EntityObject_COM_TYPE();
roll_type = new EntityObject_COM_TYPE();
plan_type = new EntityObject_COM_TYPE();
using (IDbConnection connection = IDALProvider.IDAL.PopConnection())
{
using (IDbTransaction transaction = connection.BeginTransaction())
{
try
{
obj = Load(transaction, id, out roll_property, out create_user_id, out savelimit, out roll_type, out plan_type);
transaction.Commit();
}
catch (Exception expt)
{
transaction.Rollback();
Error(expt);
}
finally
{
IDALProvider.IDAL.PushConnection(connection);
}
}
}
return(obj);
}
else
{
using (ServiceManager <ServiceContract_MCE_B_ASSETS_ROLL> smgr = new ServiceManager <ServiceContract_MCE_B_ASSETS_ROLL>(ServiceUri))
{
return(smgr.Service.Load(id, out roll_property, out create_user_id, out savelimit, out roll_type, out plan_type));
}
}
}
public EntityObject_MCE_B_ASSETS_INSTOCK Load(IDbTransaction transaction, string id, out EntityObject_COM_DEPART dept_id, out EntityObject_MDM_D_STOCK warehouse_id, out EntityObject_COM_USER user_id, out EntityObject_MDM_D_DEPT provider_id)
{
if (LocalMode)
{
EntityObject_MCE_B_ASSETS_INSTOCK obj = new EntityObject_MCE_B_ASSETS_INSTOCK();
//平台自动生成代码
dept_id = new EntityObject_COM_DEPART();
warehouse_id = new EntityObject_MDM_D_STOCK();
user_id = new EntityObject_COM_USER();
provider_id = new EntityObject_MDM_D_DEPT();
obj.ID = id;
obj = HelperObject_MCE_B_ASSETS_INSTOCK.Get(obj, transaction);
if (!string.IsNullOrEmpty(obj.DEPT_ID))
{
dept_id.ID = obj.DEPT_ID;
dept_id = HelperObject_COM_DEPART.Get(dept_id, transaction);
}
if (!string.IsNullOrEmpty(obj.WAREHOUSE_ID))
{
warehouse_id.ID = obj.WAREHOUSE_ID;
warehouse_id = HelperObject_MDM_D_STOCK.Get(warehouse_id, transaction);
}
if (!string.IsNullOrEmpty(obj.USER_ID))
{
user_id.ID = obj.USER_ID;
user_id = HelperObject_COM_USER.Get(user_id, transaction);
}
if (!string.IsNullOrEmpty(obj.PROVIDER_ID))
{
provider_id.ID = obj.PROVIDER_ID;
provider_id = HelperObject_MDM_D_DEPT.Get(provider_id, transaction);
}
return(obj);
}
else
{
throw new InvalidConstraintException();
}
}
public EntityObject_MCE_B_ASSETS_PURCHASE_PLAN Load(string id, out EntityObject_COM_USER apply_user_id, out EntityObject_COM_DEPART purchase_dept_id, out EntityObject_COM_TYPE currency_id, out EntityObject_COM_DEPART apply_dept_id)
{
if (LocalMode)
{
EntityObject_MCE_B_ASSETS_PURCHASE_PLAN obj = new EntityObject_MCE_B_ASSETS_PURCHASE_PLAN();
//平台自动生成代码
apply_user_id = new EntityObject_COM_USER();
purchase_dept_id = new EntityObject_COM_DEPART();
currency_id = new EntityObject_COM_TYPE();
apply_dept_id = new EntityObject_COM_DEPART();
using (IDbConnection connection = IDALProvider.IDAL.PopConnection())
{
using (IDbTransaction transaction = connection.BeginTransaction())
{
try
{
obj = Load(transaction, id, out apply_user_id, out purchase_dept_id, out currency_id, out apply_dept_id);
transaction.Commit();
}
catch (Exception expt)
{
transaction.Rollback();
Error(expt);
}
finally
{
IDALProvider.IDAL.PushConnection(connection);
}
}
}
return(obj);
}
else
{
using (ServiceManager <ServiceContract_MCE_B_ASSETS_PURCHASE_PLAN> smgr = new ServiceManager <ServiceContract_MCE_B_ASSETS_PURCHASE_PLAN>(ServiceUri))
{
return(smgr.Service.Load(id, out apply_user_id, out purchase_dept_id, out currency_id, out apply_dept_id));
}
}
}
public EntityObject_MCE_B_ASSETS_PURCHASE_PLAN Load(IDbTransaction transaction, string id, out EntityObject_COM_USER apply_user_id, out EntityObject_COM_DEPART purchase_dept_id, out EntityObject_COM_TYPE currency_id, out EntityObject_COM_DEPART apply_dept_id)
{
if (LocalMode)
{
EntityObject_MCE_B_ASSETS_PURCHASE_PLAN obj = new EntityObject_MCE_B_ASSETS_PURCHASE_PLAN();
//平台自动生成代码
apply_user_id = new EntityObject_COM_USER();
purchase_dept_id = new EntityObject_COM_DEPART();
currency_id = new EntityObject_COM_TYPE();
apply_dept_id = new EntityObject_COM_DEPART();
obj.ID = id;
obj = HelperObject_MCE_B_ASSETS_PURCHASE_PLAN.Get(obj, 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.PURCHASE_DEPT_ID))
{
purchase_dept_id.ID = obj.PURCHASE_DEPT_ID;
purchase_dept_id = HelperObject_COM_DEPART.Get(purchase_dept_id, transaction);
}
if (!string.IsNullOrEmpty(obj.CURRENCY_ID))
{
currency_id.ID = obj.CURRENCY_ID;
currency_id = HelperObject_COM_TYPE.Get(currency_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);
}
return(obj);
}
else
{
throw new InvalidConstraintException();
}
}
public EntityObject_MCE_B_ASSETS_MT_EXEC Load(string id, out EntityObject_COM_USER apply_user_id, out EntityObject_MDM_D_DEPT mtn_company_id, out EntityObject_COM_TYPE mtn_type_id)
{
if (LocalMode)
{
EntityObject_MCE_B_ASSETS_MT_EXEC obj = new EntityObject_MCE_B_ASSETS_MT_EXEC();
//平台自动生成代码
apply_user_id = new EntityObject_COM_USER();
mtn_company_id = new EntityObject_MDM_D_DEPT();
mtn_type_id = new EntityObject_COM_TYPE();
using (IDbConnection connection = IDALProvider.IDAL.PopConnection())
{
using (IDbTransaction transaction = connection.BeginTransaction())
{
try
{
obj = Load(transaction, id, out apply_user_id, out mtn_company_id, out mtn_type_id);
transaction.Commit();
}
catch (Exception expt)
{
transaction.Rollback();
Error(expt);
}
finally
{
IDALProvider.IDAL.PushConnection(connection);
}
}
}
return(obj);
}
else
{
using (ServiceManager <ServiceContract_MCE_B_ASSETS_MT_EXEC> smgr = new ServiceManager <ServiceContract_MCE_B_ASSETS_MT_EXEC>(ServiceUri))
{
return(smgr.Service.Load(id, out apply_user_id, out mtn_company_id, out mtn_type_id));
}
}
}
public EntityObject_MCE_B_ASSETS_MT_APPLY_EN Load(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();
using (IDbConnection connection = IDALProvider.IDAL.PopConnection())
{
using (IDbTransaction transaction = connection.BeginTransaction())
{
try
{
obj = Load(transaction, id, out base_id, out user_id);
transaction.Commit();
}
catch (Exception expt)
{
transaction.Rollback();
Error(expt);
}
finally
{
IDALProvider.IDAL.PushConnection(connection);
}
}
}
return(obj);
}
else
{
using (ServiceManager <ServiceContract_MCE_B_ASSETS_MT_APPLY_EN> smgr = new ServiceManager <ServiceContract_MCE_B_ASSETS_MT_APPLY_EN>(ServiceUri))
{
return(smgr.Service.Load(id, out base_id, out user_id));
}
}
}
public EntityObject_MCE_B_ASSETS_MT_EXEC Load(IDbTransaction transaction, string id, out EntityObject_COM_USER apply_user_id, out EntityObject_MDM_D_DEPT mtn_company_id, out EntityObject_COM_TYPE mtn_type_id)
{
if (LocalMode)
{
EntityObject_MCE_B_ASSETS_MT_EXEC obj = new EntityObject_MCE_B_ASSETS_MT_EXEC();
//平台自动生成代码
apply_user_id = new EntityObject_COM_USER();
mtn_company_id = new EntityObject_MDM_D_DEPT();
mtn_type_id = new EntityObject_COM_TYPE();
obj.ID = id;
obj = HelperObject_MCE_B_ASSETS_MT_EXEC.Get(obj, 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_COMPANY_ID))
{
mtn_company_id.ID = obj.MTN_COMPANY_ID;
mtn_company_id = HelperObject_MDM_D_DEPT.Get(mtn_company_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);
}
return(obj);
}
else
{
throw new InvalidConstraintException();
}
}
public EntityObject_MCE_B_SALES_RETURN Load(IDbTransaction transaction, string id, out EntityObject_MDM_D_DEPT provider_id, out EntityObject_MDM_D_STOCK stock_id, out EntityObject_COM_USER user_id)
{
if (LocalMode)
{
EntityObject_MCE_B_SALES_RETURN obj = new EntityObject_MCE_B_SALES_RETURN();
//平台自动生成代码
provider_id = new EntityObject_MDM_D_DEPT();
stock_id = new EntityObject_MDM_D_STOCK();
user_id = new EntityObject_COM_USER();
obj.ID = id;
obj = HelperObject_MCE_B_SALES_RETURN.Get(obj, transaction);
if (!string.IsNullOrEmpty(obj.PROVIDER_ID))
{
provider_id.ID = obj.PROVIDER_ID;
provider_id = HelperObject_MDM_D_DEPT.Get(provider_id, transaction);
}
if (!string.IsNullOrEmpty(obj.STOCK_ID))
{
stock_id.ID = obj.STOCK_ID;
stock_id = HelperObject_MDM_D_STOCK.Get(stock_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 void ProcessRequest(HttpContext context)
{
//允许跨域
context.Response.AddHeader("Access-Control-Allow-Origin", "*");
JSON_MSG jsonMsg = new JSON_MSG();
try
{
context.Response.ContentType = "text/plain";
HttpRequest request = context.Request;
if (string.IsNullOrEmpty(request["id"]))
{
throw new Exception("参数错误.");
}
CauseObject_MCE_B_ASSETS_CONTRACT p = new CauseObject_MCE_B_ASSETS_CONTRACT();
p.ID = request["id"].ToString();
DisplayObject_MCE_B_ASSETS_CONTRACT[] listHead = BizLogicObject_MCE_B_ASSETS_CONTRACT.Proxy.Query(p);
JSON_PAGER_Contract jsonPager = new JSON_PAGER_Contract();
if (listHead == null)
{
throw new Exception("获取列表信息失败.");
}
jsonPager.head = listHead[0];
OrderByParameter orderBy = new OrderByParameter();
orderBy.Asc = true;
orderBy.OrderBy = "ASSETS_CODE";
CauseObject_MCE_B_ASSETS pd = new CauseObject_MCE_B_ASSETS();
pd.SetCustomCondition(" and MCE_B_ASSETS.ID in(select asset_id from MCE_B_ASSETS_CONTRACT_D where base_id='" + request["id"].ToString() + "')");
DisplayObject_MCE_B_ASSETS[] listDetail = BizLogicObject_MCE_B_ASSETS.Proxy.Query(pd, null, orderBy);
jsonPager.total = listDetail.Length;
jsonPager.rows = listDetail;
OrderByParameter orderByPay = new OrderByParameter();
orderByPay.Asc = true;
orderByPay.OrderBy = "PERIODS";
CauseObject_MCE_B_ASSETS_CONTRACT_PAY p_Pay = new CauseObject_MCE_B_ASSETS_CONTRACT_PAY();
p_Pay.BASE_ID = request["id"];
DisplayObject_MCE_B_ASSETS_CONTRACT_PAY[] listPay = BizLogicObject_MCE_B_ASSETS_CONTRACT_PAY.Proxy.Query(p_Pay, null, orderByPay);
jsonPager.payRows = listPay;
OrderByParameter orderByAttach = new OrderByParameter();
orderByAttach.Asc = false;
orderByAttach.OrderBy = "CREATE_TIME";
CauseObject_COM_FILE pCOM_FILE = new CauseObject_COM_FILE();
pCOM_FILE.REF_TAB_ID = request["id"];
pCOM_FILE.REF_TAB_NAME = "MCE_B_ASSETS_CONTRACT";
List <JsonMCEMT_APPLY_MTN_ATTACH> list = new List <JsonMCEMT_APPLY_MTN_ATTACH>();
DisplayObject_COM_FILE[] listAttach = BizLogicObject_COM_FILE.Proxy.Query(pCOM_FILE, null, orderByAttach);
if (listAttach != null && listAttach.Length > 0)
{
foreach (DisplayObject_COM_FILE item in listAttach)
{
JsonMCEMT_APPLY_MTN_ATTACH attach = new JsonMCEMT_APPLY_MTN_ATTACH();
attach.ID = item.ID;
attach.CLIENT_NAME = item.CLIENT_NAME;
attach.SERVER_NAME = item.SERVER_NAME;
attach.CREATE_USER_ID = item.CREATE_USER_ID;
if (!string.IsNullOrEmpty(attach.CREATE_USER_ID))
{
EntityObject_COM_USER entity = new EntityObject_COM_USER();
entity.ID = attach.CREATE_USER_ID;
entity = BizLogicObject_COM_USER.Proxy.Get(entity);
if (entity != null)
{
attach.CREATE_USER_ID_NAME = entity.NAME;
}
}
attach.CREATE_TIME = item.CREATE_TIME;
list.Add(attach);
}
}
jsonPager.attach = list;
jsonMsg.Succeed = 1;
jsonMsg.Message = jsonPager;
}
catch (Exception ex)
{
jsonMsg.Succeed = 0;
jsonMsg.Message = ex.Message;
}
finally
{
IsoDateTimeConverter timeConverter = new IsoDateTimeConverter {
DateTimeFormat = "yyyy'-'MM'-'dd HH':'mm"
};
string strMsg = JsonConvert.SerializeObject(jsonMsg, Formatting.Indented, timeConverter);
strMsg = strMsg.Replace("0001-01-01 00:00", "");
context.Response.Write(strMsg);
context.Response.End();
}
}
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 void ProcessRequest(HttpContext context)
{
context.Response.AddHeader("Access-Control-Allow-Origin", "*");
JSON_MSG jsonMsg = new JSON_MSG();
try
{
context.Response.ContentType = "text/plain";
HttpRequest request = context.Request;
CauseObject_MCE_B_ASSETS_MT_EXEC p = new CauseObject_MCE_B_ASSETS_MT_EXEC();
p.ID = request["id"].ToString();
DisplayObject_MCE_B_ASSETS_MT_EXEC[] listHead = BizLogicObject_MCE_B_ASSETS_MT_EXEC.Proxy.Query(p);
JSON_PAGER_MT_EXEC jsonPager = new JSON_PAGER_MT_EXEC();
if (listHead == null)
{
throw new Exception("获取列表信息失败.");
}
if (listHead[0].STATE <= 1 && listHead[0].ACTUAL_EXEC_DATE < DateTime.Now.AddYears(-100))
{
listHead[0].ACTUAL_EXEC_DATE = DateTime.Now;
}
jsonPager.head = listHead[0];
OrderByParameter orderBy = new OrderByParameter();
orderBy.Asc = true;
orderBy.OrderBy = "ASSETS_NAME";
CauseObject_MCE_B_ASSETS_MT_EXEC_D pd = new CauseObject_MCE_B_ASSETS_MT_EXEC_D();
pd.BASE_ID = request["id"].ToString();
DisplayObject_MCE_B_ASSETS_MT_EXEC_D[] listDetail = BizLogicObject_MCE_B_ASSETS_MT_EXEC_D.Proxy.Query(pd, null, orderBy);
OrderByParameter orderByAttach = new OrderByParameter();
orderByAttach.Asc = false;
orderByAttach.OrderBy = "CREATE_TIME";
CauseObject_COM_FILE pCOM_FILE = new CauseObject_COM_FILE();
pCOM_FILE.REF_TAB_ID = request["id"];
pCOM_FILE.REF_TAB_NAME = "MCE_B_ASSETS_MT_EXEC";
List <JsonMCEMT_APPLY_MTN_ATTACH> list = new List <JsonMCEMT_APPLY_MTN_ATTACH>();
DisplayObject_COM_FILE[] listAttach = BizLogicObject_COM_FILE.Proxy.Query(pCOM_FILE, null, orderByAttach);
if (listAttach != null && listAttach.Length > 0)
{
foreach (DisplayObject_COM_FILE item in listAttach)
{
JsonMCEMT_APPLY_MTN_ATTACH attach = new JsonMCEMT_APPLY_MTN_ATTACH();
attach.ID = item.ID;
attach.CLIENT_NAME = item.CLIENT_NAME;
attach.SERVER_NAME = item.SERVER_NAME;
attach.CREATE_USER_ID = item.CREATE_USER_ID;
if (!string.IsNullOrEmpty(attach.CREATE_USER_ID))
{
EntityObject_COM_USER entity = new EntityObject_COM_USER();
entity.ID = attach.CREATE_USER_ID;
entity = BizLogicObject_COM_USER.Proxy.Get(entity);
if (entity != null)
{
attach.CREATE_USER_ID_NAME = entity.NAME;
}
}
attach.CREATE_TIME = item.CREATE_TIME;
list.Add(attach);
}
}
jsonPager.attach = list;
jsonPager.total = listDetail.Length;
jsonPager.rows = listDetail;
jsonMsg.Succeed = 1;
jsonMsg.Message = jsonPager;
}
catch (Exception ex)
{
jsonMsg.Succeed = 0;
jsonMsg.Message = ex.Message;
}
finally
{
IsoDateTimeConverter timeConverter = new IsoDateTimeConverter {
DateTimeFormat = "yyyy'-'MM'-'dd HH':'mm"
};
string strMsg = JsonConvert.SerializeObject(jsonMsg, Formatting.Indented, timeConverter);
context.Response.Write(strMsg);
context.Response.End();
}
}
