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_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_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_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_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_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 Save_Prd_Ext(string strJson)
{
if (LocalMode)
{
string strUserID = Ipedf.Web.BizLogic.SystemLogic.Proxy.CurrentUser.ID;
string strUserName = Ipedf.Web.BizLogic.SystemLogic.Proxy.CurrentUser.NAME;
BizLogicMsg msg = new BizLogicMsg();
using (IDbConnection connection = IDALProvider.IDAL.PopConnection())
{
using (IDbTransaction transaction = connection.BeginTransaction())
{
try
{
DateTime dtCur = DateTime.Now;
List <EntityObject_PRV_D_DEPT> listPrd = JsonConvert.DeserializeObject <List <EntityObject_PRV_D_DEPT> >(strJson);
List <string> listPrdId = new List <string>();
foreach (EntityObject_PRV_D_DEPT entityObject_PRV_D_DEPT in listPrd)
{
CauseObject_MDM_D_DEPT pMDM_D_DEPT = new CauseObject_MDM_D_DEPT();
pMDM_D_DEPT.CODE = entityObject_PRV_D_DEPT.CODE;
pMDM_D_DEPT.AUDIT_STATE = "COM_1002_01";
pMDM_D_DEPT.DEPT_TYPE_ID = "00340003";
DisplayObject_MDM_D_DEPT[] listMDM_D_DEPT = BizLogicObject_MDM_D_DEPT.Proxy.Query(pMDM_D_DEPT);
if (listMDM_D_DEPT != null && listMDM_D_DEPT.Length > 0)
{
continue;
}
if (!listPrdId.Contains(entityObject_PRV_D_DEPT.ID))
{
listPrdId.Add(entityObject_PRV_D_DEPT.ID);
}
else
{
continue;
}
EntityObject_MDM_D_DEPT entityPrd = new Entity.EntityObject_MDM_D_DEPT();
entityPrd.CODE = entityObject_PRV_D_DEPT.CODE;
entityPrd.NAME = entityObject_PRV_D_DEPT.NAME;
entityPrd.SHORT_NAME = Ipedf.Core.ChineseHelper.GetChineseSpell(entityObject_PRV_D_DEPT.NAME);
entityPrd.BALANCE_TYPE_ID = entityObject_PRV_D_DEPT.BALANCE_TYPE_ID;
entityPrd.ADDRESS = entityObject_PRV_D_DEPT.ADDRESS;
entityPrd.LINK_PERSON = entityObject_PRV_D_DEPT.LINK_PERSON;
entityPrd.LAW_PERSON = entityObject_PRV_D_DEPT.LAW_PERSON;
entityPrd.SERVICES = entityObject_PRV_D_DEPT.SERVICES;
entityPrd.PHONE = entityObject_PRV_D_DEPT.PHONE;
entityPrd.EMAIL = entityObject_PRV_D_DEPT.EMAIL;
entityPrd.REGISTER_FUND = entityObject_PRV_D_DEPT.REGISTER_FUND;
entityPrd.CREATE_USER_ID = strUserID;
entityPrd.CREATE_TIME = dtCur;
entityPrd.STATE = 1;
entityPrd.DEPT_TYPE_ID = "00340003";
entityPrd.AUDIT_STATE = "COM_1002_01";
entityPrd.AUDIT_USER_ID = strUserID;
entityPrd.AUDIT_TIME = dtCur;
entityPrd.REF_ID = entityObject_PRV_D_DEPT.ID;
HelperObject_MDM_D_DEPT.Save(entityPrd, 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_D_MCE_TYPE> smgr = new ServiceManager <ServiceContract_MCE_D_MCE_TYPE>(ServiceUri))
{
return(smgr.Service.Save_Prd_Ext(strJson));
}
}
}
public BizLogicMsg Save_Dept_Ext(List <string> idList)
{
if (LocalMode)
{
string strUserID = Ipedf.Web.BizLogic.SystemLogic.Proxy.CurrentUser.ID;
string strUserName = Ipedf.Web.BizLogic.SystemLogic.Proxy.CurrentUser.NAME;
BizLogicMsg msg = new BizLogicMsg();
using (IDbConnection connection = IDALProvider.IDAL.PopConnection())
{
using (IDbTransaction transaction = connection.BeginTransaction())
{
try
{
DateTime dtCur = DateTime.Now;
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;
}
foreach (string strID in idList)
{
string strRegionAccount = service.GetAccountInfo(strID);
JsonRegionAccount regionAccount = (JsonConvert.DeserializeObject <JsonRegionAccount>(strRegionAccount));
CauseObject_MDM_D_DEPT pMDM_D_DEPT = new CauseObject_MDM_D_DEPT();
pMDM_D_DEPT.CODE = regionAccount.code;
pMDM_D_DEPT.AUDIT_STATE = "COM_1002_01";
DisplayObject_MDM_D_DEPT[] listMDM_D_DEPT = BizLogicObject_MDM_D_DEPT.Proxy.Query(pMDM_D_DEPT);
if (listMDM_D_DEPT != null && listMDM_D_DEPT.Length > 0)
{
throw new Exception("企业代码" + pMDM_D_DEPT.CODE + "已经存在.");
}
string strEnterPriseInfo = service.GetEnterPriseInfo(strID);
JsonRegionEnterPrise regionEnterPrise = (JsonConvert.DeserializeObject <JsonRegionEnterPrise>(strEnterPriseInfo));
string strPrvCertList = service.GetPrvCertList(strID);
List <DisplayObject_V_PRV_PRVCERT_INFO> listRegionCert = JsonConvert.DeserializeObject <List <DisplayObject_V_PRV_PRVCERT_INFO> >(strPrvCertList);
EntityObject_MDM_D_DEPT entityObject_PRV_D_DEPT = new Entity.EntityObject_MDM_D_DEPT();
entityObject_PRV_D_DEPT.CODE = regionAccount.code;
entityObject_PRV_D_DEPT.NAME = regionEnterPrise.name;
entityObject_PRV_D_DEPT.SHORT_NAME = Ipedf.Core.ChineseHelper.GetChineseSpell(regionEnterPrise.name);
entityObject_PRV_D_DEPT.BALANCE_TYPE_ID = regionEnterPrise.balance_type_id;
entityObject_PRV_D_DEPT.ADDRESS = regionEnterPrise.address;
entityObject_PRV_D_DEPT.LINK_PERSON = regionEnterPrise.link_Person;
entityObject_PRV_D_DEPT.LAW_PERSON = regionEnterPrise.law_Person;
entityObject_PRV_D_DEPT.SERVICES = regionEnterPrise.services;
entityObject_PRV_D_DEPT.PHONE = regionAccount.phone;
entityObject_PRV_D_DEPT.EMAIL = regionAccount.email;
entityObject_PRV_D_DEPT.REGISTER_FUND = regionEnterPrise.register_fund;
entityObject_PRV_D_DEPT.CREATE_USER_ID = strUserID;
entityObject_PRV_D_DEPT.CREATE_TIME = dtCur;
entityObject_PRV_D_DEPT.STATE = 1;
entityObject_PRV_D_DEPT.DEPT_TYPE_ID = "00340005";
entityObject_PRV_D_DEPT.AUDIT_STATE = "COM_1002_01";
entityObject_PRV_D_DEPT.AUDIT_USER_ID = strUserID;
entityObject_PRV_D_DEPT.AUDIT_TIME = dtCur;
entityObject_PRV_D_DEPT.REF_ID = strID;
HelperObject_MDM_D_DEPT.Save(entityObject_PRV_D_DEPT, transaction);
if (listRegionCert != null && listRegionCert.Count > 0)
{
foreach (DisplayObject_V_PRV_PRVCERT_INFO regionCert in listRegionCert)
{
if (!string.IsNullOrEmpty(regionCert.SAVE_NAME))
{
EntityObject_MTR_B_PRV_CERT pRV_B_PRV_CERT = new EntityObject_MTR_B_PRV_CERT();
pRV_B_PRV_CERT.NATURE_ID = "MTR_20010001";
pRV_B_PRV_CERT.TYPE_ID = regionCert.TYPE_ID;
pRV_B_PRV_CERT.NAME = regionCert.NAME;
pRV_B_PRV_CERT.BEGIN_DATE = regionCert.BEGIN_DATE;
pRV_B_PRV_CERT.END_DATE = regionCert.END_DATE;
pRV_B_PRV_CERT.USER_ID = strUserID;
pRV_B_PRV_CERT.CREATE_DATE = dtCur;
pRV_B_PRV_CERT.PRV_ID = entityObject_PRV_D_DEPT.ID;
pRV_B_PRV_CERT.REF_ID = regionCert.ID;
HelperObject_MTR_B_PRV_CERT.Save(pRV_B_PRV_CERT, transaction);
if (!string.IsNullOrEmpty(regionCert.SAVE_NAME))
{
string aLastName = System.IO.Path.GetExtension(regionCert.SAVE_NAME).ToLower();
try
{
WebClient client = new WebClient();
string strNetaddress = regionCert.SAVE_NAME;
byte[] bytes = client.DownloadData(new Uri(strNetaddress));
MemoryStream ms = new MemoryStream(bytes);
ms.Seek(0, SeekOrigin.Begin);
// string strFileExt = c.PICFILENAME.Substring(1 + c.PICFILENAME.LastIndexOf("."));
string strPicName = Guid.NewGuid().ToString() + aLastName;
string folder = "mce\\";
string uploadPath = HttpRuntime.AppDomainAppPath.ToString();
if (uploadPath.EndsWith("\\"))
{
uploadPath = uploadPath + "upload\\" + folder;
}
else
{
uploadPath = uploadPath + "\\upload\\" + folder;
}
uploadPath = uploadPath + strPicName;
FileStream fs = new FileStream(uploadPath, FileMode.Create);
//将byte数组写入文件中
fs.Write(bytes, 0, bytes.Length);
//所有流类型都要关闭流，否则会出现内存泄露问题
fs.Close();
byte[] photo = new byte[] { }; //原图
byte[] thumbPhoto = new byte[] { }; //缩略图
EntityObject_MTR_FILE prv_File = new EntityObject_MTR_FILE();
prv_File.SAVE_NAME = strPicName;
prv_File.FILE_NAME = strPicName;
prv_File.REF_TAB_NAME = "MTR_B_PRV_CERT";
prv_File.REF_TAB_ID = pRV_B_PRV_CERT.ID;
prv_File.SUFFIX = aLastName;
prv_File.THUMB_BINARY = thumbPhoto;
prv_File.FILE_BINARY = photo;
HelperObject_MTR_FILE.Save(prv_File, transaction);
}
catch
{
}
}
}
}
}
}
string strJson = JsonConvert.SerializeObject(idList);
int intRet = service.SetPrvAuditStatus(strJson, "COM_1002_01", strUserID, strUserName);
if (intRet == 0)
{
throw new Exception("更新供应商端状态错误.");
}
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_D_MCE_TYPE> smgr = new ServiceManager <ServiceContract_MCE_D_MCE_TYPE>(ServiceUri))
{
return(smgr.Service.Save_Dept_Ext(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 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();
}
}
public BizLogicMsg Save_Ext(JsonMCE_PURCHASE_PLAN json)
{
if (LocalMode)
{
BizLogicMsg msg = new BizLogicMsg();
using (IDbConnection connection = IDALProvider.IDAL.PopConnection())
{
using (IDbTransaction transaction = connection.BeginTransaction())
{
try
{
EntityObject_MCE_B_ASSETS_PURCHASE_PLAN entity = new EntityObject_MCE_B_ASSETS_PURCHASE_PLAN();
if (!string.IsNullOrEmpty(json.ID))
{
entity.ID = json.ID;
entity = HelperObject_MCE_B_ASSETS_PURCHASE_PLAN.Get(entity);
if (entity == null)
{
throw new Exception("获取数据出错.");
}
}
entity.CODE = json.CODE;
entity.APPLY_DEPT_ID = json.APPLY_DEPT_ID;
entity.APPLY_USER_ID = json.APPLY_USER_ID;
entity.PRV_ID = json.PRV_ID;
entity.PRV_NAME = json.PRV_NAME;
if (!string.IsNullOrEmpty(json.CREATE_DATE))
{
entity.CREATE_DATE = DateTime.Parse(json.CREATE_DATE);
}
entity.PURCHASE_DEPT_ID = json.PURCHASE_DEPT_ID;
entity.APPLY_USER_ID = json.APPLY_USER_ID;
entity.COMMENTS = json.COMMENTS;
entity.STATE = 1;
if (string.IsNullOrEmpty(json.ID))
{
entity.CREATE_TIME = DateTime.Now;
entity.CREATE_USER_ID = Ipedf.Web.BizLogic.SystemLogic.Proxy.CurrentUser.ID;
entity.CREATE_DEPT_ID = Ipedf.Web.BizLogic.SystemLogic.Proxy.CurrentUser.DEPART_ID;
int amount = HelperObject_MCE_B_ASSETS_PURCHASE_PLAN.Save(entity, transaction);
}
else
{
entity.MODIFY_USER_ID = Ipedf.Web.BizLogic.SystemLogic.Proxy.CurrentUser.ID;
entity.MODIFY_DEPT_ID = Ipedf.Web.BizLogic.SystemLogic.Proxy.CurrentUser.DEPART_ID;
int amount = HelperObject_MCE_B_ASSETS_PURCHASE_PLAN.Update(entity, transaction);
}
if (json.DELETEIDS != null && json.DELETEIDS.Count > 0)
{
foreach (string strID in json.DELETEIDS)
{
EntityObject_MCE_B_ASSETS_PURCHASE_PLAN_D entity_D = new EntityObject_MCE_B_ASSETS_PURCHASE_PLAN_D();
if (!string.IsNullOrEmpty(strID))
{
entity_D.ID = strID;
entity_D = HelperObject_MCE_B_ASSETS_PURCHASE_PLAN_D.Get(entity_D);
if (entity_D == null)
{
throw new Exception("获取数据出错.");
}
else
{
HelperObject_MCE_B_ASSETS_PURCHASE_PLAN_D.Delete(entity_D, transaction);
}
}
}
}
if (json.children != null && json.children.Count > 0)
{
decimal decTotMoney = 0;
foreach (JsonMCE_PURCHASE_PLAN_D item in json.children)
{
EntityObject_MCE_B_ASSETS_PURCHASE_PLAN_D entity_D = new EntityObject_MCE_B_ASSETS_PURCHASE_PLAN_D();
if (!string.IsNullOrEmpty(item.ID))
{
entity_D.ID = item.ID;
entity_D = HelperObject_MCE_B_ASSETS_PURCHASE_PLAN_D.Get(entity_D);
if (entity_D == null)
{
throw new Exception("获取数据出错.");
}
}
entity_D.BASE_ID = entity.ID;
entity_D.TYPE_ID = item.TYPE_ID;
entity_D.ASSETS_ID = item.ASSETS_ID;
entity_D.ASSET_NAME = item.ASSET_NAME;
entity_D.SPEC = item.SPEC;
if (string.IsNullOrEmpty(item.ID))
{
if (!string.IsNullOrEmpty(item.PRD_ID))
{
string strPrdID = "";
CauseObject_MDM_D_DEPT p = new CauseObject_MDM_D_DEPT();
p.REF_ID = item.PRD_ID;
DisplayObject_MDM_D_DEPT[] listPrd = HelperObject_MDM_D_DEPT.Query(p);
if (listPrd != null && listPrd.Length > 0)
{
strPrdID = listPrd[0].ID;
}
entity_D.PRD_ID = strPrdID;
}
entity_D.REF_PRD_ID = item.PRD_ID;
}
entity_D.PRD_NAME = item.PRD_NAME;
entity_D.PRICE = item.PRICE;
entity_D.AMOUNT = item.AMOUNT;
entity_D.UNIT_ID = item.UNIT_ID;
entity_D.REF_TAB_ID = item.REF_TAB_ID;
entity_D.REF_TAB_NAME = item.REF_TAB_NAME;
entity_D.MONEY = item.AMOUNT * item.PRICE;
decTotMoney = decTotMoney + entity_D.MONEY;
if (string.IsNullOrEmpty(item.ID))
{
HelperObject_MCE_B_ASSETS_PURCHASE_PLAN_D.Save(entity_D, transaction);
}
else
{
HelperObject_MCE_B_ASSETS_PURCHASE_PLAN_D.Update(entity_D, transaction);
}
}
entity.APPLY_MONEY = decTotMoney;
HelperObject_MCE_B_ASSETS_PURCHASE_PLAN.Update(entity, transaction);
}
msg.Message = entity.ID;
transaction.Commit();
}
catch (Exception expt)
{
transaction.Rollback();
msg = new BizLogicMsg(false, expt.Message);
Error(expt);
}
finally
{
IDALProvider.IDAL.PushConnection(connection);
}
}
}
return(msg);
}
else
{
using (ServiceManager <ServiceContract_MCE_B_ASSETS_PURCHASE_PLAN> smgr = new ServiceManager <ServiceContract_MCE_B_ASSETS_PURCHASE_PLAN>(ServiceUri))
{
return(smgr.Service.Save_Ext(json));
}
}
}
