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_CAPITAL_ALLOT Load(IDbTransaction transaction, string id, out EntityObject_COM_TYPE capital_source_type_id, out EntityObject_MCE_B_ASSETS assets_id)
{
if (LocalMode)
{
EntityObject_MCE_B_ASSETS_CAPITAL_ALLOT obj = new EntityObject_MCE_B_ASSETS_CAPITAL_ALLOT();
//平台自动生成代码
capital_source_type_id = new EntityObject_COM_TYPE();
assets_id = new EntityObject_MCE_B_ASSETS();
obj.ID = id;
obj = HelperObject_MCE_B_ASSETS_CAPITAL_ALLOT.Get(obj, transaction);
if (!string.IsNullOrEmpty(obj.CAPITAL_SOURCE_TYPE_ID))
{
capital_source_type_id.ID = obj.CAPITAL_SOURCE_TYPE_ID;
capital_source_type_id = HelperObject_COM_TYPE.Get(capital_source_type_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_D Load(IDbTransaction transaction, string id, out EntityObject_MCE_B_ASSETS asset_id, out EntityObject_MCE_B_ASSETS_WRITE_OFF base_id)
{
if (LocalMode)
{
EntityObject_MCE_B_ASSETS_WRITE_OFF_D obj = new EntityObject_MCE_B_ASSETS_WRITE_OFF_D();
//平台自动生成代码
asset_id = new EntityObject_MCE_B_ASSETS();
base_id = new EntityObject_MCE_B_ASSETS_WRITE_OFF();
obj.ID = id;
obj = HelperObject_MCE_B_ASSETS_WRITE_OFF_D.Get(obj, transaction);
if (!string.IsNullOrEmpty(obj.ASSET_ID))
{
asset_id.ID = obj.ASSET_ID;
asset_id = HelperObject_MCE_B_ASSETS.Get(asset_id, transaction);
}
if (!string.IsNullOrEmpty(obj.BASE_ID))
{
base_id.ID = obj.BASE_ID;
base_id = HelperObject_MCE_B_ASSETS_WRITE_OFF.Get(base_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_ROLLEQUIP Load(IDbTransaction transaction, string id, out EntityObject_MCE_B_ASSETS_ROLL roll_id, out EntityObject_MCE_B_ASSETS assets_id)
{
if (LocalMode)
{
EntityObject_MCE_B_ASSETS_ROLLEQUIP obj = new EntityObject_MCE_B_ASSETS_ROLLEQUIP();
//平台自动生成代码
roll_id = new EntityObject_MCE_B_ASSETS_ROLL();
assets_id = new EntityObject_MCE_B_ASSETS();
obj.ID = id;
obj = HelperObject_MCE_B_ASSETS_ROLLEQUIP.Get(obj, transaction);
if (!string.IsNullOrEmpty(obj.ROLL_ID))
{
roll_id.ID = obj.ROLL_ID;
roll_id = HelperObject_MCE_B_ASSETS_ROLL.Get(roll_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 BizLogicMsg Delete_Ext(List <string> listID)
{
if (LocalMode)
{
BizLogicMsg msg = new BizLogicMsg();
using (IDbConnection connection = IDALProvider.IDAL.PopConnection())
{
using (IDbTransaction transaction = connection.BeginTransaction())
{
try
{
if (listID != null && listID.Count > 0)
{
foreach (string strID in listID)
{
EntityObject_MCE_B_ASSETS obj = new EntityObject_MCE_B_ASSETS();
obj.ID = strID;
obj = HelperObject_MCE_B_ASSETS.Get(obj);
if (obj != null)
{
if (obj.STATE == 3 || obj.STATE == 4)
{
throw new Exception("已经审核的资产卡片不能删除.");
}
HelperObject_MCE_B_ASSETS.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> smgr = new ServiceManager <ServiceContract_MCE_B_ASSETS>(ServiceUri))
{
return(smgr.Service.Audit_Ext(listID));
}
}
}
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_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_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_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_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_MT_EXEC_D Load(string id, out EntityObject_MCE_B_ASSETS_MT_EXEC base_id, out EntityObject_MCE_B_ASSETS assets_id, out EntityObject_COM_DEPART dept_id, out EntityObject_MCE_B_ASSETS_MT_ITEM item_id)
{
if (LocalMode)
{
EntityObject_MCE_B_ASSETS_MT_EXEC_D obj = new EntityObject_MCE_B_ASSETS_MT_EXEC_D();
//平台自动生成代码
base_id = new EntityObject_MCE_B_ASSETS_MT_EXEC();
assets_id = new EntityObject_MCE_B_ASSETS();
dept_id = new EntityObject_COM_DEPART();
item_id = new EntityObject_MCE_B_ASSETS_MT_ITEM();
using (IDbConnection connection = IDALProvider.IDAL.PopConnection())
{
using (IDbTransaction transaction = connection.BeginTransaction())
{
try
{
obj = Load(transaction, id, out base_id, out assets_id, out dept_id, out item_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_D> smgr = new ServiceManager <ServiceContract_MCE_B_ASSETS_MT_EXEC_D>(ServiceUri))
{
return(smgr.Service.Load(id, out base_id, out assets_id, out dept_id, out item_id));
}
}
}
public EntityObject_MCE_B_ASSETS_IMPORTATION Load(IDbTransaction transaction, string id, out EntityObject_MCE_B_ASSETS assets_id, out EntityObject_COM_TYPE currency_id, out EntityObject_COM_TYPE foreign_currency_source_id, out EntityObject_COM_TYPE country_id)
{
if (LocalMode)
{
EntityObject_MCE_B_ASSETS_IMPORTATION obj = new EntityObject_MCE_B_ASSETS_IMPORTATION();
//平台自动生成代码
assets_id = new EntityObject_MCE_B_ASSETS();
currency_id = new EntityObject_COM_TYPE();
foreign_currency_source_id = new EntityObject_COM_TYPE();
country_id = new EntityObject_COM_TYPE();
obj.ID = id;
obj = HelperObject_MCE_B_ASSETS_IMPORTATION.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.CURRENCY_ID))
{
currency_id.ID = obj.CURRENCY_ID;
currency_id = HelperObject_COM_TYPE.Get(currency_id, transaction);
}
if (!string.IsNullOrEmpty(obj.FOREIGN_CURRENCY_SOURCE_ID))
{
foreign_currency_source_id.ID = obj.FOREIGN_CURRENCY_SOURCE_ID;
foreign_currency_source_id = HelperObject_COM_TYPE.Get(foreign_currency_source_id, transaction);
}
if (!string.IsNullOrEmpty(obj.COUNTRY_ID))
{
country_id.ID = obj.COUNTRY_ID;
country_id = HelperObject_COM_TYPE.Get(country_id, transaction);
}
return(obj);
}
else
{
throw new InvalidConstraintException();
}
}
public EntityObject_MCE_B_ASSETS_IMPORTATION Load(string id, out EntityObject_MCE_B_ASSETS assets_id, out EntityObject_COM_TYPE currency_id, out EntityObject_COM_TYPE foreign_currency_source_id, out EntityObject_COM_TYPE country_id)
{
if (LocalMode)
{
EntityObject_MCE_B_ASSETS_IMPORTATION obj = new EntityObject_MCE_B_ASSETS_IMPORTATION();
//平台自动生成代码
assets_id = new EntityObject_MCE_B_ASSETS();
currency_id = new EntityObject_COM_TYPE();
foreign_currency_source_id = new EntityObject_COM_TYPE();
country_id = new EntityObject_COM_TYPE();
using (IDbConnection connection = IDALProvider.IDAL.PopConnection())
{
using (IDbTransaction transaction = connection.BeginTransaction())
{
try
{
obj = Load(transaction, id, out assets_id, out currency_id, out foreign_currency_source_id, out country_id);
transaction.Commit();
}
catch (Exception expt)
{
transaction.Rollback();
Error(expt);
}
finally
{
IDALProvider.IDAL.PushConnection(connection);
}
}
}
return(obj);
}
else
{
using (ServiceManager <ServiceContract_MCE_B_ASSETS_IMPORTATION> smgr = new ServiceManager <ServiceContract_MCE_B_ASSETS_IMPORTATION>(ServiceUri))
{
return(smgr.Service.Load(id, out assets_id, out currency_id, out foreign_currency_source_id, out country_id));
}
}
}
public EntityObject_MCE_B_ASSETS_MT_EXEC_D Load(IDbTransaction transaction, string id, out EntityObject_MCE_B_ASSETS_MT_EXEC base_id, out EntityObject_MCE_B_ASSETS assets_id, out EntityObject_COM_DEPART dept_id, out EntityObject_MCE_B_ASSETS_MT_ITEM item_id)
{
if (LocalMode)
{
EntityObject_MCE_B_ASSETS_MT_EXEC_D obj = new EntityObject_MCE_B_ASSETS_MT_EXEC_D();
//平台自动生成代码
base_id = new EntityObject_MCE_B_ASSETS_MT_EXEC();
assets_id = new EntityObject_MCE_B_ASSETS();
dept_id = new EntityObject_COM_DEPART();
item_id = new EntityObject_MCE_B_ASSETS_MT_ITEM();
obj.ID = id;
obj = HelperObject_MCE_B_ASSETS_MT_EXEC_D.Get(obj, transaction);
if (!string.IsNullOrEmpty(obj.BASE_ID))
{
base_id.ID = obj.BASE_ID;
base_id = HelperObject_MCE_B_ASSETS_MT_EXEC.Get(base_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.DEPT_ID))
{
dept_id.ID = obj.DEPT_ID;
dept_id = HelperObject_COM_DEPART.Get(dept_id, transaction);
}
if (!string.IsNullOrEmpty(obj.ITEM_ID))
{
item_id.ID = obj.ITEM_ID;
item_id = HelperObject_MCE_B_ASSETS_MT_ITEM.Get(item_id, transaction);
}
return(obj);
}
else
{
throw new InvalidConstraintException();
}
}
public EntityObject_MCE_B_ASSETS_CHECK_D Load(string id, out EntityObject_COM_DEPART using_dept_id, out EntityObject_COM_TYPE new_assets_state, out EntityObject_MCE_B_ASSETS assets_id, out EntityObject_COM_TYPE old_assets_state)
{
if (LocalMode)
{
EntityObject_MCE_B_ASSETS_CHECK_D obj = new EntityObject_MCE_B_ASSETS_CHECK_D();
//平台自动生成代码
using_dept_id = new EntityObject_COM_DEPART();
new_assets_state = new EntityObject_COM_TYPE();
assets_id = new EntityObject_MCE_B_ASSETS();
old_assets_state = new EntityObject_COM_TYPE();
using (IDbConnection connection = IDALProvider.IDAL.PopConnection())
{
using (IDbTransaction transaction = connection.BeginTransaction())
{
try
{
obj = Load(transaction, id, out using_dept_id, out new_assets_state, out assets_id, out old_assets_state);
transaction.Commit();
}
catch (Exception expt)
{
transaction.Rollback();
Error(expt);
}
finally
{
IDALProvider.IDAL.PushConnection(connection);
}
}
}
return(obj);
}
else
{
using (ServiceManager <ServiceContract_MCE_B_ASSETS_CHECK_D> smgr = new ServiceManager <ServiceContract_MCE_B_ASSETS_CHECK_D>(ServiceUri))
{
return(smgr.Service.Load(id, out using_dept_id, out new_assets_state, out assets_id, out old_assets_state));
}
}
}
public EntityObject_MCE_B_ASSETS_CHECK_D Load(IDbTransaction transaction, string id, out EntityObject_COM_DEPART using_dept_id, out EntityObject_COM_TYPE new_assets_state, out EntityObject_MCE_B_ASSETS assets_id, out EntityObject_COM_TYPE old_assets_state)
{
if (LocalMode)
{
EntityObject_MCE_B_ASSETS_CHECK_D obj = new EntityObject_MCE_B_ASSETS_CHECK_D();
//平台自动生成代码
using_dept_id = new EntityObject_COM_DEPART();
new_assets_state = new EntityObject_COM_TYPE();
assets_id = new EntityObject_MCE_B_ASSETS();
old_assets_state = new EntityObject_COM_TYPE();
obj.ID = id;
obj = HelperObject_MCE_B_ASSETS_CHECK_D.Get(obj, 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.NEW_ASSETS_STATE))
{
new_assets_state.ID = obj.NEW_ASSETS_STATE;
new_assets_state = HelperObject_COM_TYPE.Get(new_assets_state, 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.OLD_ASSETS_STATE))
{
old_assets_state.ID = obj.OLD_ASSETS_STATE;
old_assets_state = HelperObject_COM_TYPE.Get(old_assets_state, transaction);
}
return(obj);
}
else
{
throw new InvalidConstraintException();
}
}
public EntityObject_MCE_B_ASSETS_ROLLEQUIP Load(string id, out EntityObject_MCE_B_ASSETS_ROLL roll_id, out EntityObject_MCE_B_ASSETS assets_id)
{
if (LocalMode)
{
EntityObject_MCE_B_ASSETS_ROLLEQUIP obj = new EntityObject_MCE_B_ASSETS_ROLLEQUIP();
//平台自动生成代码
roll_id = new EntityObject_MCE_B_ASSETS_ROLL();
assets_id = new EntityObject_MCE_B_ASSETS();
using (IDbConnection connection = IDALProvider.IDAL.PopConnection())
{
using (IDbTransaction transaction = connection.BeginTransaction())
{
try
{
obj = Load(transaction, id, out roll_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_ROLLEQUIP> smgr = new ServiceManager <ServiceContract_MCE_B_ASSETS_ROLLEQUIP>(ServiceUri))
{
return(smgr.Service.Load(id, out roll_id, out assets_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_CAPITAL_ALLOT Load(string id, out EntityObject_COM_TYPE capital_source_type_id, out EntityObject_MCE_B_ASSETS assets_id)
{
if (LocalMode)
{
EntityObject_MCE_B_ASSETS_CAPITAL_ALLOT obj = new EntityObject_MCE_B_ASSETS_CAPITAL_ALLOT();
//平台自动生成代码
capital_source_type_id = 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 capital_source_type_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_CAPITAL_ALLOT> smgr = new ServiceManager <ServiceContract_MCE_B_ASSETS_CAPITAL_ALLOT>(ServiceUri))
{
return(smgr.Service.Load(id, out capital_source_type_id, out assets_id));
}
}
}
private string GectAssetsAffixCode(string assets_id)
{
string strAffixCode = "";
string strCode = "";
EntityObject_MCE_B_ASSETS obj = new EntityObject_MCE_B_ASSETS();
if (!string.IsNullOrEmpty(assets_id))
{
obj.ID = assets_id;
obj = HelperObject_MCE_B_ASSETS.Get(obj);
if (obj != null)
{
strCode = obj.ASSETS_CODE;
}
}
int code = 1;
var cause = new CauseObject_MCE_B_ASSETS_AFFIX();
cause.SetCustomCondition(" and MCE_B_ASSETS_AFFIX.CODE like '" + strCode + "%'");
var list = BizLogicObject_MCE_B_ASSETS_AFFIX.Proxy.Query(cause);
if (list != null && list.Length > 0)
{
var s_code = list.Max(p => p.CODE);
var rightCode = s_code.Replace(strCode, "").TrimStart('0');
code = int.Parse(rightCode) + 1;
}
strAffixCode = strCode + (code).ToString().PadLeft(3, '0');
return(strAffixCode);
}
public EntityObject_MCE_B_ASSETS_DEPR_ALLOT Load(IDbTransaction transaction, string id, out EntityObject_COM_DEPART dept_id, out EntityObject_MCE_B_ASSETS assets_id, out EntityObject_MCE_D_DEPR_TYPE depr_id)
{
if (LocalMode)
{
EntityObject_MCE_B_ASSETS_DEPR_ALLOT obj = new EntityObject_MCE_B_ASSETS_DEPR_ALLOT();
//平台自动生成代码
dept_id = new EntityObject_COM_DEPART();
assets_id = new EntityObject_MCE_B_ASSETS();
depr_id = new EntityObject_MCE_D_DEPR_TYPE();
obj.ID = id;
obj = HelperObject_MCE_B_ASSETS_DEPR_ALLOT.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.ASSETS_ID))
{
assets_id.ID = obj.ASSETS_ID;
assets_id = HelperObject_MCE_B_ASSETS.Get(assets_id, transaction);
}
if (!string.IsNullOrEmpty(obj.DEPR_ID))
{
depr_id.ID = obj.DEPR_ID;
depr_id = HelperObject_MCE_D_DEPR_TYPE.Get(depr_id, transaction);
}
return(obj);
}
else
{
throw new InvalidConstraintException();
}
}
public EntityObject_MCE_B_ASSETS_DEPR_D Load(IDbTransaction transaction, string id, out EntityObject_MCE_B_ASSETS_DEPR base_id, out EntityObject_COM_TYPE currency_id, out EntityObject_MCE_B_ASSETS assets_id)
{
if (LocalMode)
{
EntityObject_MCE_B_ASSETS_DEPR_D obj = new EntityObject_MCE_B_ASSETS_DEPR_D();
//平台自动生成代码
base_id = new EntityObject_MCE_B_ASSETS_DEPR();
currency_id = new EntityObject_COM_TYPE();
assets_id = new EntityObject_MCE_B_ASSETS();
obj.ID = id;
obj = HelperObject_MCE_B_ASSETS_DEPR_D.Get(obj, transaction);
if (!string.IsNullOrEmpty(obj.BASE_ID))
{
base_id.ID = obj.BASE_ID;
base_id = HelperObject_MCE_B_ASSETS_DEPR.Get(base_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.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 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_SALES_RETURN obj = new EntityObject_MCE_B_SALES_RETURN();
obj.ID = strID;
obj = HelperObject_MCE_B_SALES_RETURN.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_SALES_RETURN.Update(obj, transaction);
DisplayObject_MCE_B_SALES_RETURN_D[] disBack = BizLogicObject_MCE_B_SALES_RETURN_D.Proxy.Query(new CauseObject_MCE_B_SALES_RETURN_D()
{
BASE_ID = obj.ID
});
if (disBack.Length > 0)
{
for (int i = 0; i < disBack.Length; i++)
{
if (string.IsNullOrEmpty(disBack[i].ASSETS_ID))
{
continue;
}
//资产卡片更新
EntityObject_MCE_B_ASSETS entAssets = BizLogicObject_MCE_B_ASSETS.Proxy.Get(new EntityObject_MCE_B_ASSETS()
{
ID = disBack[i].ASSETS_ID
});
if (entAssets != null)
{
entAssets.ASSETS_STATE = "00530004"; //退货
BizLogicObject_MCE_B_ASSETS.Proxy.UpdateByTrans(entAssets, transaction);
/*
* if (!string.IsNullOrEmpty(disBack[i].REF_TAB_ID))
* {
* EntityObject_MCE_B_ASSETS_OUTSTOCK_D oUTSTOCK_D = BizLogicObject_MCE_B_ASSETS_OUTSTOCK_D.Proxy.Get(new EntityObject_MCE_B_ASSETS_OUTSTOCK_D() { ID = disBack[i].REF_TAB_ID });
*
* if (oUTSTOCK_D != null)
* {
* oUTSTOCK_D.IS_RETURN = 1;
* }
* BizLogicObject_MCE_B_ASSETS_OUTSTOCK_D.Proxy.UpdateByTrans(oUTSTOCK_D, 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_SALES_RETURN> smgr = new ServiceManager <ServiceContract_MCE_B_SALES_RETURN>(ServiceUri))
{
return(smgr.Service.Audit_Ext(listID));
}
}
}
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 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_OUTSTOCK obj = new EntityObject_MCE_B_ASSETS_OUTSTOCK();
obj.ID = strID;
obj = HelperObject_MCE_B_ASSETS_OUTSTOCK.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_OUTSTOCK.Update(obj, transaction);
#region 资产卡片更新
DisplayObject_MCE_B_ASSETS_OUTSTOCK_D[] disOutstock = BizLogicObject_MCE_B_ASSETS_OUTSTOCK_D.Proxy.Query(new CauseObject_MCE_B_ASSETS_OUTSTOCK_D()
{
BASE_ID = obj.ID
});
if (disOutstock.Length > 0)
{
for (int i = 0; i < disOutstock.Length; i++)
{
if (string.IsNullOrEmpty(disOutstock[i].REF_TAB_ID) || string.IsNullOrEmpty(disOutstock[i].REF_TAB_NAME))
{
continue;
}
if (disOutstock[i].REF_TAB_NAME == "MCE_B_ASSETS")
{
EntityObject_MCE_B_ASSETS entAssets = BizLogicObject_MCE_B_ASSETS.Proxy.Get(new EntityObject_MCE_B_ASSETS()
{
ID = disOutstock[i].REF_TAB_ID
});
if (entAssets != null)
{
entAssets.CUSTODY_DEPT_ID = obj.USING_DEPT_ID;
entAssets.CUSTODY_USER_ID = obj.USING_USER_ID;
entAssets.SUBJECTION_DEPT_ID = obj.USING_DEPT_ID;
entAssets.USING_DEPT_ID = obj.USING_DEPT_ID;
entAssets.USING_USER_ID = obj.USING_USER_ID;
entAssets.CUSTODY_DEPT_ID = obj.USING_DEPT_ID;
entAssets.ENABLE_DATE = obj.CREATE_DATE;
entAssets.USE_STATE = "00540001"; //在用
entAssets.ASSETS_STATE = "00530002"; //资产状态(启用).
entAssets.CARD_TYPE_ID = "00680002";
entAssets.ECONOMIC_USE_TYPE_ID = disOutstock[0].ECONOMIC_USE_TYPE_ID; //hsc 如果出库是多个设备 则会出错
BizLogicObject_MCE_B_ASSETS.Proxy.UpdateByTrans(entAssets, transaction);
}
}
else
{
//因为这个方法取出的值只有ID跟状态.所以必须重新取值.
DisplayObject_MCE_B_ASSETS[] disAssets = HelperObject_MCE_B_ASSETS.QueryIdState(disOutstock[i].REF_TAB_ID, disOutstock[i].REF_TAB_NAME);
foreach (DisplayObject_MCE_B_ASSETS item in disAssets)
{
EntityObject_MCE_B_ASSETS entAssets = BizLogicObject_MCE_B_ASSETS.Proxy.Get(new EntityObject_MCE_B_ASSETS()
{
ID = item.ID
});
if (entAssets != null)
{
entAssets.CUSTODY_DEPT_ID = obj.USING_DEPT_ID;
entAssets.CUSTODY_USER_ID = obj.USING_USER_ID;
entAssets.SUBJECTION_DEPT_ID = obj.USING_DEPT_ID;
entAssets.USING_DEPT_ID = obj.USING_DEPT_ID;
entAssets.USING_USER_ID = obj.USING_USER_ID;
entAssets.CUSTODY_DEPT_ID = obj.USING_DEPT_ID;
entAssets.ENABLE_DATE = obj.CREATE_DATE;
entAssets.USE_STATE = "00540001"; //在用
entAssets.ASSETS_STATE = "00530002"; //资产状态(启用).
entAssets.CARD_TYPE_ID = "00680002";
entAssets.ECONOMIC_USE_TYPE_ID = disOutstock[0].ECONOMIC_USE_TYPE_ID; //hsc 如果出库是多个设备 则会出错
BizLogicObject_MCE_B_ASSETS.Proxy.UpdateByTrans(entAssets, transaction);
}
}
}
}
}
#endregion
}
}
//平台自动生成代码
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_OUTSTOCK> smgr = new ServiceManager <ServiceContract_MCE_B_ASSETS_OUTSTOCK>(ServiceUri))
{
return(smgr.Service.Audit_Ext(listID));
}
}
}
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_CHECK obj = new EntityObject_MCE_B_ASSETS_CHECK();
obj.ID = strID;
obj = HelperObject_MCE_B_ASSETS_CHECK.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_CHECK.Update(obj, transaction);
CauseObject_MCE_B_ASSETS_CHECK_D pDetail = new CauseObject_MCE_B_ASSETS_CHECK_D();
pDetail.BASE_ID = strID;
EntityObject_MCE_B_ASSETS_CHECK_D[] deprDetails = HelperObject_MCE_B_ASSETS_CHECK_D.Query(pDetail, transaction);
//更新资产卡片记录
foreach (EntityObject_MCE_B_ASSETS_CHECK_D dDetail in deprDetails)
{
string strOldState = dDetail.OLD_ASSETS_STATE ?? "";
string strNewState = dDetail.NEW_ASSETS_STATE ?? "";
if (strOldState != strNewState && !string.IsNullOrEmpty(strNewState))
{
EntityObject_MCE_B_ASSETS assets = new EntityObject_MCE_B_ASSETS();
assets.ID = dDetail.ASSETS_ID;
assets.ASSETS_STATE = dDetail.NEW_ASSETS_STATE;//净值
assets.SetUpdate("ASSETS_STATE");
HelperObject_MCE_B_ASSETS.Update(assets, 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_CHECK> smgr = new ServiceManager <ServiceContract_MCE_B_ASSETS_CHECK>(ServiceUri))
{
return(smgr.Service.Audit_Ext(listID));
}
}
}
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_DEPR obj = new EntityObject_MCE_B_ASSETS_DEPR();
obj.ID = strID;
obj = HelperObject_MCE_B_ASSETS_DEPR.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_DEPR.Update(obj, transaction);
CauseObject_MCE_B_ASSETS_DEPR_D pDeprDetail = new CauseObject_MCE_B_ASSETS_DEPR_D();
pDeprDetail.BASE_ID = strID;
EntityObject_MCE_B_ASSETS_DEPR_D[] deprDetails = HelperObject_MCE_B_ASSETS_DEPR_D.Query(pDeprDetail, transaction);
//更新资产卡片记录
foreach (EntityObject_MCE_B_ASSETS_DEPR_D deprDetail in deprDetails)
{
EntityObject_MCE_B_ASSETS assets = new EntityObject_MCE_B_ASSETS();
assets.ID = deprDetail.ASSETS_ID;
assets.NET_VALUE = deprDetail.NEW_NET_VALUE; //净值
assets.DEPR_MONTH_AMOUNT += 1; //累计折旧月份
assets.ACCUMULATED_DEPRECIATION += deprDetail.MONEY; //累计折旧金额
assets.SetUpdate("NET_VALUE", "DEPR_MONTH_AMOUNT", "ACCUMULATED_DEPRECIATION");
HelperObject_MCE_B_ASSETS.Update(assets, 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_DEPR> smgr = new ServiceManager <ServiceContract_MCE_B_ASSETS_DEPR>(ServiceUri))
{
return(smgr.Service.Audit_Ext(listID));
}
}
}
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_TRANSFER obj = new EntityObject_MCE_B_ASSETS_TRANSFER();
obj.ID = strID;
obj = HelperObject_MCE_B_ASSETS_TRANSFER.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_TRANSFER.Update(obj, transaction);
DisplayObject_MCE_B_ASSETS_TRANSFER_D[] disTransfer = BizLogicObject_MCE_B_ASSETS_TRANSFER_D.Proxy.Query(new CauseObject_MCE_B_ASSETS_TRANSFER_D()
{
BASE_ID = obj.ID
});
if (disTransfer.Length > 0)
{
for (int i = 0; i < disTransfer.Length; i++)
{
if (string.IsNullOrEmpty(disTransfer[i].ASSETS_ID))
{
continue;
}
//资产卡片更新
EntityObject_MCE_B_ASSETS entAssets = BizLogicObject_MCE_B_ASSETS.Proxy.Get(new EntityObject_MCE_B_ASSETS()
{
ID = disTransfer[i].ASSETS_ID
});
if (entAssets != null)
{
entAssets.CUSTODY_DEPT_ID = obj.DEPT_ID;
entAssets.CUSTODY_USER_ID = obj.USER_ID;
entAssets.SUBJECTION_DEPT_ID = obj.DEPT_ID;
entAssets.USING_DEPT_ID = obj.DEPT_ID;
entAssets.USING_USER_ID = obj.USER_ID;
entAssets.USE_STATE = "00540001"; //在用
BizLogicObject_MCE_B_ASSETS.Proxy.UpdateByTrans(entAssets, 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_TRANSFER> smgr = new ServiceManager <ServiceContract_MCE_B_ASSETS_TRANSFER>(ServiceUri))
{
return(smgr.Service.Audit_Ext(listID));
}
}
}
