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(); } }