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 DisplayObject_MCE_B_ASSETS_ROLL Get(DisplayObject_MCE_B_ASSETS_ROLL obj)
{
if (LocalMode)
{
//平台自动生成代码
return(HelperObject_MCE_B_ASSETS_ROLL.Get(obj));
}
else
{
using (ServiceManager <ServiceContract_MCE_B_ASSETS_ROLL> smgr = new ServiceManager <ServiceContract_MCE_B_ASSETS_ROLL>(ServiceUri))
{
return(smgr.Service.Get(obj));
}
}
}
public EntityObject_MCE_B_ASSETS_ROLL Load(IDbTransaction transaction, string id, out EntityObject_COM_TYPE roll_property, out EntityObject_COM_USER create_user_id, out EntityObject_COM_TYPE savelimit, out EntityObject_COM_TYPE roll_type, out EntityObject_COM_TYPE plan_type)
{
if (LocalMode)
{
EntityObject_MCE_B_ASSETS_ROLL obj = new EntityObject_MCE_B_ASSETS_ROLL();
//平台自动生成代码
roll_property = new EntityObject_COM_TYPE();
create_user_id = new EntityObject_COM_USER();
savelimit = new EntityObject_COM_TYPE();
roll_type = new EntityObject_COM_TYPE();
plan_type = new EntityObject_COM_TYPE();
obj.ID = id;
obj = HelperObject_MCE_B_ASSETS_ROLL.Get(obj, transaction);
if (!string.IsNullOrEmpty(obj.ROLL_PROPERTY))
{
roll_property.ID = obj.ROLL_PROPERTY;
roll_property = HelperObject_COM_TYPE.Get(roll_property, transaction);
}
if (!string.IsNullOrEmpty(obj.CREATE_USER_ID))
{
create_user_id.ID = obj.CREATE_USER_ID;
create_user_id = HelperObject_COM_USER.Get(create_user_id, transaction);
}
if (!string.IsNullOrEmpty(obj.SAVELIMIT))
{
savelimit.ID = obj.SAVELIMIT;
savelimit = HelperObject_COM_TYPE.Get(savelimit, transaction);
}
if (!string.IsNullOrEmpty(obj.ROLL_TYPE))
{
roll_type.ID = obj.ROLL_TYPE;
roll_type = HelperObject_COM_TYPE.Get(roll_type, transaction);
}
if (!string.IsNullOrEmpty(obj.PLAN_TYPE))
{
plan_type.ID = obj.PLAN_TYPE;
plan_type = HelperObject_COM_TYPE.Get(plan_type, transaction);
}
return(obj);
}
else
{
throw new InvalidConstraintException();
}
}
public EntityObject_MCE_B_ASSETS_ROLLFILE Load(IDbTransaction transaction, string id, out EntityObject_MCE_B_ASSETS_ROLL base_id)
{
if (LocalMode)
{
EntityObject_MCE_B_ASSETS_ROLLFILE obj = new EntityObject_MCE_B_ASSETS_ROLLFILE();
//平台自动生成代码
base_id = new EntityObject_MCE_B_ASSETS_ROLL();
obj.ID = id;
obj = HelperObject_MCE_B_ASSETS_ROLLFILE.Get(obj, transaction);
if (!string.IsNullOrEmpty(obj.BASE_ID))
{
base_id.ID = obj.BASE_ID;
base_id = HelperObject_MCE_B_ASSETS_ROLL.Get(base_id, transaction);
}
return(obj);
}
else
{
throw new InvalidConstraintException();
}
}
public BizLogicMsg Delete_RollEquip(string strID)
{
if (LocalMode)
{
BizLogicMsg msg = new BizLogicMsg();
using (IDbConnection connection = IDALProvider.IDAL.PopConnection())
{
using (IDbTransaction transaction = connection.BeginTransaction())
{
try
{
EntityObject_MCE_B_ASSETS_ROLLEQUIP objMCE_B_ASSETS_ROLLEQUIP = new EntityObject_MCE_B_ASSETS_ROLLEQUIP();
objMCE_B_ASSETS_ROLLEQUIP.ID = strID;
objMCE_B_ASSETS_ROLLEQUIP = HelperObject_MCE_B_ASSETS_ROLLEQUIP.Get(objMCE_B_ASSETS_ROLLEQUIP);
if (objMCE_B_ASSETS_ROLLEQUIP == null)
{
throw new Exception("获取数据出错.");
}
EntityObject_MCE_B_ASSETS_ROLL objRoll = new EntityObject_MCE_B_ASSETS_ROLL();
objRoll.ID = objMCE_B_ASSETS_ROLLEQUIP.ROLL_ID;
objRoll = HelperObject_MCE_B_ASSETS_ROLL.Get(objRoll);
if (objRoll == null)
{
throw new Exception("获取数据出错.");
}
if (objRoll.AUDIT_STATE == 3 || objRoll.AUDIT_STATE == 4)
{
throw new Exception("已经审核的案卷信息不能再删除关联设备.");
}
HelperObject_MCE_B_ASSETS_ROLLEQUIP.Delete(objMCE_B_ASSETS_ROLLEQUIP, 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_ROLL> smgr = new ServiceManager <ServiceContract_MCE_B_ASSETS_ROLL>(ServiceUri))
{
return(smgr.Service.Delete_RollEquip(strID));
}
}
}
public BizLogicMsg Save_RollEquip(JsonMceAssetsRollEquip item)
{
if (LocalMode)
{
BizLogicMsg msg = new BizLogicMsg();
using (IDbConnection connection = IDALProvider.IDAL.PopConnection())
{
using (IDbTransaction transaction = connection.BeginTransaction())
{
try
{
EntityObject_MCE_B_ASSETS_ROLL objRoll = new EntityObject_MCE_B_ASSETS_ROLL();
objRoll.ID = item.rollid;
objRoll = HelperObject_MCE_B_ASSETS_ROLL.Get(objRoll);
if (objRoll == null)
{
throw new Exception("获取数据出错.");
}
if (objRoll.AUDIT_STATE == 3 || objRoll.AUDIT_STATE == 4)
{
throw new Exception("已经审核的案卷信息不能再添加关联设备.");
}
CauseObject_MCE_B_ASSETS_ROLLEQUIP pMCE_B_ASSETS_ROLLEQUIP = new CauseObject_MCE_B_ASSETS_ROLLEQUIP();
pMCE_B_ASSETS_ROLLEQUIP.ROLL_ID = item.rollid;
pMCE_B_ASSETS_ROLLEQUIP.ASSETS_ID = item.assetsid;
DisplayObject_MCE_B_ASSETS_ROLLEQUIP[] listMCE_B_ASSETS_ROLLEQUIP = BizLogicObject_MCE_B_ASSETS_ROLLEQUIP.Proxy.Query(pMCE_B_ASSETS_ROLLEQUIP);
if (listMCE_B_ASSETS_ROLLEQUIP == null || listMCE_B_ASSETS_ROLLEQUIP.Length == 0)
{
EntityObject_MCE_B_ASSETS_ROLLEQUIP objEquip = new EntityObject_MCE_B_ASSETS_ROLLEQUIP();
objEquip.ASSETS_ID = item.assetsid;
objEquip.ROLL_ID = item.rollid;
HelperObject_MCE_B_ASSETS_ROLLEQUIP.Save(objEquip, transaction);
}
else
{
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_B_ASSETS_ROLL> smgr = new ServiceManager <ServiceContract_MCE_B_ASSETS_ROLL>(ServiceUri))
{
return(smgr.Service.Save_RollEquip(item));
}
}
}
public BizLogicMsg Delete_RollFiles(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)
{
if (string.IsNullOrEmpty(strID))
{
continue;
}
EntityObject_MCE_B_ASSETS_ROLLFILE obj = new EntityObject_MCE_B_ASSETS_ROLLFILE();
obj.ID = strID;
obj = HelperObject_MCE_B_ASSETS_ROLLFILE.Get(obj);
if (obj != null)
{
EntityObject_MCE_B_ASSETS_ROLL objRoll = new EntityObject_MCE_B_ASSETS_ROLL();
objRoll.ID = obj.BASE_ID;
objRoll = HelperObject_MCE_B_ASSETS_ROLL.Get(objRoll);
if (objRoll == null)
{
throw new Exception("获取数据出错.");
}
if (objRoll.AUDIT_STATE == 3 || objRoll.AUDIT_STATE == 4)
{
throw new Exception("已经审核的案卷信息文件不能删除.");
}
CauseObject_COM_FILE pCOM_FILE = new CauseObject_COM_FILE();
pCOM_FILE.REF_TAB_ID = obj.ID;
pCOM_FILE.REF_TAB_NAME = "MCE_B_ASSETS_ROLLFILE";
DisplayObject_COM_FILE[] listCOM_FILE = BizLogicObject_COM_FILE.Proxy.Query(pCOM_FILE);
if (listCOM_FILE != null && listCOM_FILE.Length > 0)
{
foreach (DisplayObject_COM_FILE item in listCOM_FILE)
{
if (!string.IsNullOrEmpty(item.SERVER_NAME))
{
string strFileURL = System.Web.HttpContext.Current.Server.MapPath("~/upload/mce/" + item.SERVER_NAME);//路径
if (File.Exists(strFileURL))
{
File.Delete(strFileURL);
}
}
}
}
HelperObject_COM_FILE.Delete(pCOM_FILE, transaction);
HelperObject_MCE_B_ASSETS_ROLLFILE.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_ROLL> smgr = new ServiceManager <ServiceContract_MCE_B_ASSETS_ROLL>(ServiceUri))
{
return(smgr.Service.Delete_RollFiles(listID));
}
}
}
public BizLogicMsg Save_RollFiles(List <JsonMceAssetsRollFile> listItem)
{
if (LocalMode)
{
BizLogicMsg msg = new BizLogicMsg();
using (IDbConnection connection = IDALProvider.IDAL.PopConnection())
{
using (IDbTransaction transaction = connection.BeginTransaction())
{
try
{
if (listItem != null && listItem.Count > 0)
{
EntityObject_MCE_B_ASSETS_ROLL objRoll = new EntityObject_MCE_B_ASSETS_ROLL();
objRoll.ID = listItem[0].base_id;
objRoll = HelperObject_MCE_B_ASSETS_ROLL.Get(objRoll);
if (objRoll == null)
{
throw new Exception("获取数据出错.");
}
if (objRoll.AUDIT_STATE == 3 || objRoll.AUDIT_STATE == 4)
{
throw new Exception("已经审核的案卷信息文件不能保存.");
}
foreach (JsonMceAssetsRollFile item in listItem)
{
EntityObject_MCE_B_ASSETS_ROLLFILE obj = new EntityObject_MCE_B_ASSETS_ROLLFILE();
if (!string.IsNullOrEmpty(item.id))
{
obj.ID = item.id;
obj = HelperObject_MCE_B_ASSETS_ROLLFILE.Get(obj);
if (obj == null)
{
throw new Exception("获取数据出错.");
}
}
obj.BASE_ID = item.base_id;
obj.CODE = item.code;
obj.NAME = item.name;
if (!string.IsNullOrEmpty(item.create_date))
{
obj.CREATE_DATE = DateTime.Parse(item.create_date);
}
if (!string.IsNullOrEmpty(item.page_num))
{
obj.PAGE_NUM = decimal.Parse(item.page_num);
}
obj.SUMMARYS = item.summarys;
obj.COMMENTS = item.comments;
if (string.IsNullOrEmpty(item.id))
{
HelperObject_MCE_B_ASSETS_ROLLFILE.Save(obj, transaction);
}
else
{
obj.ID = item.id;
HelperObject_MCE_B_ASSETS_ROLLFILE.Update(obj, transaction);
}
if (!string.IsNullOrEmpty(item.filename))
{
try
{
string strFileURL = System.Web.HttpContext.Current.Server.MapPath("~/upload/mce/" + item.filename);//路径
if (File.Exists(strFileURL))
{
CauseObject_COM_FILE pCOM_FILE = new CauseObject_COM_FILE();
pCOM_FILE.REF_TAB_ID = obj.ID;
pCOM_FILE.REF_TAB_NAME = "MCE_B_ASSETS_ROLLFILE";
pCOM_FILE.SERVER_NAME = item.filename;
DisplayObject_COM_FILE[] listCOM_FILE = BizLogicObject_COM_FILE.Proxy.Query(pCOM_FILE);
if (listCOM_FILE == null || listCOM_FILE.Length == 0)
{
Ipedf.Web.Entity.EntityObject_COM_FILE entityPicFile = new Ipedf.Web.Entity.EntityObject_COM_FILE();
entityPicFile.REF_TAB_NAME = "MCE_B_ASSETS_ROLLFILE";
entityPicFile.CLIENT_NAME = item.filename;
entityPicFile.STATE = 1;
entityPicFile.CREATE_TIME = DateTime.Now;
entityPicFile.CREATE_USER_ID = Ipedf.Web.BizLogic.SystemLogic.Proxy.CurrentUser.ID;
entityPicFile.REF_TAB_ID = obj.ID;
entityPicFile.SERVER_NAME = item.filename;
entityPicFile.IS_IMPORT = 0;
Ipedf.Web.DataAccess.HelperObject_COM_FILE.Save(entityPicFile, transaction);
}
}
}
catch { }
}
}
}
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_ROLL> smgr = new ServiceManager <ServiceContract_MCE_B_ASSETS_ROLL>(ServiceUri))
{
return(smgr.Service.Save_RollFiles(listItem));
}
}
}
public BizLogicMsg Save_Ext(JsonMceAssetsRoll item)
{
if (LocalMode)
{
BizLogicMsg msg = new BizLogicMsg();
using (IDbConnection connection = IDALProvider.IDAL.PopConnection())
{
using (IDbTransaction transaction = connection.BeginTransaction())
{
try
{
EntityObject_MCE_B_ASSETS_ROLL obj = new EntityObject_MCE_B_ASSETS_ROLL();
if (!string.IsNullOrEmpty(item.id))
{
obj.ID = item.id;
obj = HelperObject_MCE_B_ASSETS_ROLL.Get(obj);
if (obj == null)
{
throw new Exception("获取数据出错.");
}
}
// obj.ASSETS_ID = item.assets_id;
// obj.CODE = item.code;
obj.NAME = item.name;
obj.SAVELIMIT = item.savelimit;
obj.CREATE_USER_ID = item.create_user_id;
if (!string.IsNullOrEmpty(item.create_time))
{
obj.CREATE_TIME = DateTime.Parse(item.create_time);
}
obj.PLAN_TYPE = item.plan_type;
obj.ROLL_TYPE = item.roll_type;
obj.ROLL_PROPERTY = item.roll_property;
obj.COMMENTS = item.comments;
if (string.IsNullOrEmpty(item.id))
{
obj.CODE = GetRollCode();
obj.AUDIT_STATE = 1;
obj.CREATE_USER_ID = Ipedf.Web.BizLogic.SystemLogic.Proxy.CurrentUser.ID;
HelperObject_MCE_B_ASSETS_ROLL.Save(obj, transaction);
EntityObject_MCE_B_ASSETS_ROLLEQUIP objEquip = new EntityObject_MCE_B_ASSETS_ROLLEQUIP();
objEquip.ASSETS_ID = item.assets_id;
objEquip.ROLL_ID = obj.ID;
HelperObject_MCE_B_ASSETS_ROLLEQUIP.Save(objEquip, transaction);
}
else
{
obj.ID = item.id;
HelperObject_MCE_B_ASSETS_ROLL.Update(obj, transaction);
CauseObject_MCE_B_ASSETS_ROLLEQUIP pMCE_B_ASSETS_ROLLEQUIP = new CauseObject_MCE_B_ASSETS_ROLLEQUIP();
pMCE_B_ASSETS_ROLLEQUIP.ROLL_ID = obj.ID;
pMCE_B_ASSETS_ROLLEQUIP.ASSETS_ID = item.assets_id;
DisplayObject_MCE_B_ASSETS_ROLLEQUIP[] listMCE_B_ASSETS_ROLLEQUIP = BizLogicObject_MCE_B_ASSETS_ROLLEQUIP.Proxy.Query(pMCE_B_ASSETS_ROLLEQUIP);
if (listMCE_B_ASSETS_ROLLEQUIP == null || listMCE_B_ASSETS_ROLLEQUIP.Length == 0)
{
EntityObject_MCE_B_ASSETS_ROLLEQUIP objEquip = new EntityObject_MCE_B_ASSETS_ROLLEQUIP();
objEquip.ASSETS_ID = item.assets_id;
objEquip.ROLL_ID = obj.ID;
HelperObject_MCE_B_ASSETS_ROLLEQUIP.Save(objEquip, transaction);
}
}
msg.Message = obj.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_ROLL> smgr = new ServiceManager <ServiceContract_MCE_B_ASSETS_ROLL>(ServiceUri))
{
return(smgr.Service.Save_Ext(item));
}
}
}
public BizLogicMsg Audit_Ext(JsonMceAssetsRoll item)
{
if (LocalMode)
{
BizLogicMsg msg = new BizLogicMsg();
using (IDbConnection connection = IDALProvider.IDAL.PopConnection())
{
using (IDbTransaction transaction = connection.BeginTransaction())
{
try
{
EntityObject_MCE_B_ASSETS_ROLL obj = new EntityObject_MCE_B_ASSETS_ROLL();
obj.ID = item.id;
obj = HelperObject_MCE_B_ASSETS_ROLL.Get(obj);
if (obj != null)
{
if (obj.AUDIT_STATE == 3 || obj.AUDIT_STATE == 4)
{
throw new Exception("已经审核的案卷信息不能再审核.");
}
obj.AUDIT_STATE = 3;
obj.AUDIT_TIME = DateTime.Now;
obj.AUDIT_USER_ID = Ipedf.Web.BizLogic.SystemLogic.Proxy.CurrentUser.ID;
HelperObject_MCE_B_ASSETS_ROLL.Update(obj, transaction);
EntityObject_MCE_B_ASSETS objMCE_B_ASSETS = new EntityObject_MCE_B_ASSETS();
objMCE_B_ASSETS.ID = item.assets_id;
objMCE_B_ASSETS = HelperObject_MCE_B_ASSETS.Get(objMCE_B_ASSETS);
if (obj != null)
{
objMCE_B_ASSETS.FILE_CODE = obj.CODE;
HelperObject_MCE_B_ASSETS.Update(objMCE_B_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_ROLL> smgr = new ServiceManager <ServiceContract_MCE_B_ASSETS_ROLL>(ServiceUri))
{
return(smgr.Service.Audit_Ext(item));
}
}
}