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_INSURANCE Load(IDbTransaction transaction, string id, out EntityObject_MCE_B_ASSETS assets_id, out EntityObject_MDM_D_DEPT insurance_unit)
{
if (LocalMode)
{
EntityObject_MCE_B_ASSETS_INSURANCE obj = new EntityObject_MCE_B_ASSETS_INSURANCE();
//平台自动生成代码
assets_id = new EntityObject_MCE_B_ASSETS();
insurance_unit = new EntityObject_MDM_D_DEPT();
obj.ID = id;
obj = HelperObject_MCE_B_ASSETS_INSURANCE.Get(obj, 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.INSURANCE_UNIT))
{
insurance_unit.ID = obj.INSURANCE_UNIT;
insurance_unit = HelperObject_MDM_D_DEPT.Get(insurance_unit, 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_ASSETS_OUTSTOCK_D Load(IDbTransaction transaction, string id, out EntityObject_COM_TYPE unit_id, out EntityObject_MDM_D_DEPT prd_id, out EntityObject_MCE_D_MCE_TYPE asset_type_id, out EntityObject_COM_TYPE economic_use_type_id, out EntityObject_MCE_B_ASSETS_OUTSTOCK base_id, out EntityObject_COM_TYPE country)
{
if (LocalMode)
{
EntityObject_MCE_B_ASSETS_OUTSTOCK_D obj = new EntityObject_MCE_B_ASSETS_OUTSTOCK_D();
//平台自动生成代码
unit_id = new EntityObject_COM_TYPE();
prd_id = new EntityObject_MDM_D_DEPT();
asset_type_id = new EntityObject_MCE_D_MCE_TYPE();
economic_use_type_id = new EntityObject_COM_TYPE();
base_id = new EntityObject_MCE_B_ASSETS_OUTSTOCK();
country = new EntityObject_COM_TYPE();
obj.ID = id;
obj = HelperObject_MCE_B_ASSETS_OUTSTOCK_D.Get(obj, 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.PRD_ID))
{
prd_id.ID = obj.PRD_ID;
prd_id = HelperObject_MDM_D_DEPT.Get(prd_id, transaction);
}
if (!string.IsNullOrEmpty(obj.ASSET_TYPE_ID))
{
asset_type_id.ID = obj.ASSET_TYPE_ID;
asset_type_id = HelperObject_MCE_D_MCE_TYPE.Get(asset_type_id, transaction);
}
if (!string.IsNullOrEmpty(obj.ECONOMIC_USE_TYPE_ID))
{
economic_use_type_id.ID = obj.ECONOMIC_USE_TYPE_ID;
economic_use_type_id = HelperObject_COM_TYPE.Get(economic_use_type_id, transaction);
}
if (!string.IsNullOrEmpty(obj.BASE_ID))
{
base_id.ID = obj.BASE_ID;
base_id = HelperObject_MCE_B_ASSETS_OUTSTOCK.Get(base_id, transaction);
}
if (!string.IsNullOrEmpty(obj.COUNTRY))
{
country.ID = obj.COUNTRY;
country = HelperObject_COM_TYPE.Get(country, 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_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_INSTOCK_D Load(string id, out EntityObject_COM_TYPE currency_id, out EntityObject_COM_TYPE country, out EntityObject_MDM_D_DEPT prd_id, out EntityObject_MCE_B_ASSETS_INSTOCK base_id, out EntityObject_MCE_D_MCE_TYPE asset_type_id, out EntityObject_MCE_D_DEPR_TYPE depr_type_id, out EntityObject_COM_TYPE unit_id, out EntityObject_COM_DEPART using_dept_id)
{
if (LocalMode)
{
EntityObject_MCE_B_ASSETS_INSTOCK_D obj = new EntityObject_MCE_B_ASSETS_INSTOCK_D();
//平台自动生成代码
currency_id = new EntityObject_COM_TYPE();
country = new EntityObject_COM_TYPE();
prd_id = new EntityObject_MDM_D_DEPT();
base_id = new EntityObject_MCE_B_ASSETS_INSTOCK();
asset_type_id = new EntityObject_MCE_D_MCE_TYPE();
depr_type_id = new EntityObject_MCE_D_DEPR_TYPE();
unit_id = new EntityObject_COM_TYPE();
using_dept_id = new EntityObject_COM_DEPART();
using (IDbConnection connection = IDALProvider.IDAL.PopConnection())
{
using (IDbTransaction transaction = connection.BeginTransaction())
{
try
{
obj = Load(transaction, id, out currency_id, out country, out prd_id, out base_id, out asset_type_id, out depr_type_id, out unit_id, out using_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_INSTOCK_D> smgr = new ServiceManager <ServiceContract_MCE_B_ASSETS_INSTOCK_D>(ServiceUri))
{
return(smgr.Service.Load(id, out currency_id, out country, out prd_id, out base_id, out asset_type_id, out depr_type_id, out unit_id, out using_dept_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_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_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_SALES_RETURN_D Load(IDbTransaction transaction, string id, out EntityObject_MDM_D_DEPT prd_id, out EntityObject_COM_TYPE unit_id, out EntityObject_MCE_D_MCE_TYPE asset_type_id, out EntityObject_MCE_B_SALES_RETURN base_id)
{
if (LocalMode)
{
EntityObject_MCE_B_SALES_RETURN_D obj = new EntityObject_MCE_B_SALES_RETURN_D();
//平台自动生成代码
prd_id = new EntityObject_MDM_D_DEPT();
unit_id = new EntityObject_COM_TYPE();
asset_type_id = new EntityObject_MCE_D_MCE_TYPE();
base_id = new EntityObject_MCE_B_SALES_RETURN();
obj.ID = id;
obj = HelperObject_MCE_B_SALES_RETURN_D.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.ASSET_TYPE_ID))
{
asset_type_id.ID = obj.ASSET_TYPE_ID;
asset_type_id = HelperObject_MCE_D_MCE_TYPE.Get(asset_type_id, transaction);
}
if (!string.IsNullOrEmpty(obj.BASE_ID))
{
base_id.ID = obj.BASE_ID;
base_id = HelperObject_MCE_B_SALES_RETURN.Get(base_id, transaction);
}
return(obj);
}
else
{
throw new InvalidConstraintException();
}
}
public EntityObject_MCE_B_ASSETS_INSTOCK Load(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();
using (IDbConnection connection = IDALProvider.IDAL.PopConnection())
{
using (IDbTransaction transaction = connection.BeginTransaction())
{
try
{
obj = Load(transaction, id, out dept_id, out warehouse_id, out user_id, out provider_id);
transaction.Commit();
}
catch (Exception expt)
{
transaction.Rollback();
Error(expt);
}
finally
{
IDALProvider.IDAL.PushConnection(connection);
}
}
}
return(obj);
}
else
{
using (ServiceManager <ServiceContract_MCE_B_ASSETS_INSTOCK> smgr = new ServiceManager <ServiceContract_MCE_B_ASSETS_INSTOCK>(ServiceUri))
{
return(smgr.Service.Load(id, out dept_id, out warehouse_id, out user_id, out provider_id));
}
}
}
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_INSURANCE Load(string id, out EntityObject_MCE_B_ASSETS assets_id, out EntityObject_MDM_D_DEPT insurance_unit)
{
if (LocalMode)
{
EntityObject_MCE_B_ASSETS_INSURANCE obj = new EntityObject_MCE_B_ASSETS_INSURANCE();
//平台自动生成代码
assets_id = new EntityObject_MCE_B_ASSETS();
insurance_unit = new EntityObject_MDM_D_DEPT();
using (IDbConnection connection = IDALProvider.IDAL.PopConnection())
{
using (IDbTransaction transaction = connection.BeginTransaction())
{
try
{
obj = Load(transaction, id, out assets_id, out insurance_unit);
transaction.Commit();
}
catch (Exception expt)
{
transaction.Rollback();
Error(expt);
}
finally
{
IDALProvider.IDAL.PushConnection(connection);
}
}
}
return(obj);
}
else
{
using (ServiceManager <ServiceContract_MCE_B_ASSETS_INSURANCE> smgr = new ServiceManager <ServiceContract_MCE_B_ASSETS_INSURANCE>(ServiceUri))
{
return(smgr.Service.Load(id, out assets_id, out insurance_unit));
}
}
}
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 BizLogicMsg CancelPrvAudit(List <string> idList)
{
if (LocalMode)
{
BizLogicMsg msg = new BizLogicMsg();
using (IDbConnection connection = IDALProvider.IDAL.PopConnection())
{
using (IDbTransaction transaction = connection.BeginTransaction())
{
try
{
string strUserID = Ipedf.Web.BizLogic.SystemLogic.Proxy.CurrentUser.ID;
string strUserName = Ipedf.Web.BizLogic.SystemLogic.Proxy.CurrentUser.NAME;
foreach (string strID in idList)
{
CauseObject_MDM_D_DEPT p = new CauseObject_MDM_D_DEPT();
p.REF_ID = strID;
DisplayObject_MDM_D_DEPT[] list_MDM_D_DEPT = BizLogicObject_MDM_D_DEPT.Proxy.Query(p);
if (list_MDM_D_DEPT != null && list_MDM_D_DEPT.Length > 0)
{
string strPrvID = list_MDM_D_DEPT[0].ID;
EntityObject_MDM_D_DEPT entity = new EntityObject_MDM_D_DEPT();
entity.ID = strPrvID;
entity = BizLogicObject_MDM_D_DEPT.Proxy.Get(entity);
if (entity != null)
{
entity.AUDIT_STATE = "COM_1002_02";
entity.AUDIT_TIME = DateTime.Now;
entity.AUDIT_USER_ID = strUserID;
BizLogicObject_MDM_D_DEPT.Proxy.Update(entity);
}
}
if (!msg.Succeed)
{
throw new Exception(msg.Message);
}
}
transaction.Commit();
string strJson = JsonConvert.SerializeObject(idList);
Ipedf.Hrp.BizLogic.PRV_MCE_Web_Service.PRV_Web_Service service = new Ipedf.Hrp.BizLogic.PRV_MCE_Web_Service.PRV_Web_Service();
if (System.Configuration.ConfigurationManager.AppSettings["PrvMceWebServiceAddress"] != null)
{
string strServiceURL = System.Configuration.ConfigurationManager.AppSettings["PrvMceWebServiceAddress"];
service.Url = strServiceURL;
}
service.SetPrvAuditStatus(strJson, "COM_1002_02", strUserID, strUserName);
}
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_D_MCE_TYPE> smgr = new ServiceManager <ServiceContract_MCE_D_MCE_TYPE>(ServiceUri))
{
return(smgr.Service.CancelPrvAudit(idList));
}
}
}
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;
OrderByParameter orderBy = new OrderByParameter();
orderBy.Asc = false;
orderBy.OrderBy = "CREATE_TIME";
PagingParamter pager = new PagingParamter();
pager.PageSize = string.IsNullOrEmpty(request["limit"]) ? 10 : int.Parse(request["limit"].ToString());
pager.PageIndex = string.IsNullOrEmpty(request["offset"]) ? 0 : (int.Parse(request["offset"].ToString()) <= 0) ? 0 : int.Parse(request["offset"].ToString()) - 1;
CauseObject_PRV_B_ASSET p = new CauseObject_PRV_B_ASSET();
StringBuilder strCondition = new StringBuilder();
strCondition.Append(" and PRV_B_ASSET.STATE > -1 ");
if (!string.IsNullOrEmpty(request["state"]))
{
p.STATE = int.Parse(request["state"].ToString());
}
if (!string.IsNullOrEmpty(request["prv"]))
{
p.PRV_ID = request["prv"].ToString();
}
if (!string.IsNullOrEmpty(request["refprv"]))
{
EntityObject_MDM_D_DEPT entityDept = new EntityObject_MDM_D_DEPT();
entityDept.ID = request["refprv"];
entityDept = BizLogicObject_MDM_D_DEPT.Proxy.Get(entityDept);
if (entityDept != null)
{
p.PRV_ID = entityDept.REF_ID;
}
}
if (!string.IsNullOrEmpty(request["typeid"]))
{
p.TYPE_ID = request["typeid"].ToString();
}
if (!string.IsNullOrEmpty(request["name"]))
{
p.NAME = "%" + request["name"].ToString().Trim() + "%";
}
if (!string.IsNullOrEmpty(request["prd"]))//生产厂家
{
strCondition.Append(" and PRV_D_DEPT_PRD_ID.NAME like '%" + request["prd"].ToString().Trim() + "%'");
}
if (!string.IsNullOrEmpty(strCondition.ToString()))
{
p.SetCustomCondition(strCondition.ToString());
}
string strOrder = JsonConvert.SerializeObject(orderBy);
string strPage = JsonConvert.SerializeObject(pager);
string strCause = JsonConvert.SerializeObject(p);
PRV_MCE_Web_Service.PRV_Web_Service service = new PRV_MCE_Web_Service.PRV_Web_Service();
if (System.Configuration.ConfigurationManager.AppSettings["PrvMceWebServiceAddress"] != null)
{
string strServiceURL = System.Configuration.ConfigurationManager.AppSettings["PrvMceWebServiceAddress"];
service.Url = strServiceURL;
}
string strJson = service.GetPrvAssetInfo(strCause, strPage, strOrder);
JSON_PAGER list = JsonConvert.DeserializeObject <JSON_PAGER>(strJson);
jsonMsg.Succeed = 1;
jsonMsg.Message = list;
}
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_INSTOCK_D Load(IDbTransaction transaction, string id, out EntityObject_COM_TYPE currency_id, out EntityObject_COM_TYPE country, out EntityObject_MDM_D_DEPT prd_id, out EntityObject_MCE_B_ASSETS_INSTOCK base_id, out EntityObject_MCE_D_MCE_TYPE asset_type_id, out EntityObject_MCE_D_DEPR_TYPE depr_type_id, out EntityObject_COM_TYPE unit_id, out EntityObject_COM_DEPART using_dept_id)
{
if (LocalMode)
{
EntityObject_MCE_B_ASSETS_INSTOCK_D obj = new EntityObject_MCE_B_ASSETS_INSTOCK_D();
//平台自动生成代码
currency_id = new EntityObject_COM_TYPE();
country = new EntityObject_COM_TYPE();
prd_id = new EntityObject_MDM_D_DEPT();
base_id = new EntityObject_MCE_B_ASSETS_INSTOCK();
asset_type_id = new EntityObject_MCE_D_MCE_TYPE();
depr_type_id = new EntityObject_MCE_D_DEPR_TYPE();
unit_id = new EntityObject_COM_TYPE();
using_dept_id = new EntityObject_COM_DEPART();
obj.ID = id;
obj = HelperObject_MCE_B_ASSETS_INSTOCK_D.Get(obj, 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.COUNTRY))
{
country.ID = obj.COUNTRY;
country = HelperObject_COM_TYPE.Get(country, 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.BASE_ID))
{
base_id.ID = obj.BASE_ID;
base_id = HelperObject_MCE_B_ASSETS_INSTOCK.Get(base_id, transaction);
}
if (!string.IsNullOrEmpty(obj.ASSET_TYPE_ID))
{
asset_type_id.ID = obj.ASSET_TYPE_ID;
asset_type_id = HelperObject_MCE_D_MCE_TYPE.Get(asset_type_id, transaction);
}
if (!string.IsNullOrEmpty(obj.DEPR_TYPE_ID))
{
depr_type_id.ID = obj.DEPR_TYPE_ID;
depr_type_id = HelperObject_MCE_D_DEPR_TYPE.Get(depr_type_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.USING_DEPT_ID))
{
using_dept_id.ID = obj.USING_DEPT_ID;
using_dept_id = HelperObject_COM_DEPART.Get(using_dept_id, transaction);
}
return(obj);
}
else
{
throw new InvalidConstraintException();
}
}
