public static string PrepareCause(CauseObject_MCE_B_ASSETS_ROLLEQUIP cause, out OracleParameter[] parameters)
{
//平台自动生成代码
System.Text.StringBuilder strBuf = new System.Text.StringBuilder();
ArrayList paramList = new ArrayList();
OracleParameter param = null;
#region Push Block
if (!string.IsNullOrEmpty(cause.ROLL_ID))
{
strBuf.Append(" And MCE_B_ASSETS_ROLLEQUIP.ROLL_ID ").Append((cause.ROLL_ID.StartsWith("%") || cause.ROLL_ID.EndsWith("%")) ? " like " : " = ").Append(" :C_ROLL_ID");
param = new OracleParameter();
param.ParameterName = ":C_ROLL_ID";
param.OracleType = System.Data.OracleClient.OracleType.Char;
param.Size = 36;
param.Value = cause.ROLL_ID;
paramList.Add(param);
}
if (cause.HasINValue("ROLL_ID"))
{
strBuf.Append(cause.GetINSQL("MCE_B_ASSETS_ROLLEQUIP", "ROLL_ID"));
}
if (!string.IsNullOrEmpty(cause.ID))
{
strBuf.Append(" And MCE_B_ASSETS_ROLLEQUIP.ID ").Append((cause.ID.StartsWith("%") || cause.ID.EndsWith("%")) ? " like " : " = ").Append(" :C_ID");
param = new OracleParameter();
param.ParameterName = ":C_ID";
param.OracleType = System.Data.OracleClient.OracleType.Char;
param.Size = 36;
param.Value = cause.ID;
paramList.Add(param);
}
if (cause.HasINValue("ID"))
{
strBuf.Append(cause.GetINSQL("MCE_B_ASSETS_ROLLEQUIP", "ID"));
}
if (!string.IsNullOrEmpty(cause.ASSETS_ID))
{
strBuf.Append(" And MCE_B_ASSETS_ROLLEQUIP.ASSETS_ID ").Append((cause.ASSETS_ID.StartsWith("%") || cause.ASSETS_ID.EndsWith("%")) ? " like " : " = ").Append(" :C_ASSETS_ID");
param = new OracleParameter();
param.ParameterName = ":C_ASSETS_ID";
param.OracleType = System.Data.OracleClient.OracleType.Char;
param.Size = 36;
param.Value = cause.ASSETS_ID;
paramList.Add(param);
}
if (cause.HasINValue("ASSETS_ID"))
{
strBuf.Append(cause.GetINSQL("MCE_B_ASSETS_ROLLEQUIP", "ASSETS_ID"));
}
if (!string.IsNullOrEmpty(cause.GetCustomCondition()))
{
strBuf.Append(cause.GetCustomCondition());
}
#endregion
parameters = new OracleParameter[paramList.Count];
paramList.CopyTo(parameters);
return(strBuf.ToString());
}
public static int Delete(CauseObject_MCE_B_ASSETS_ROLLEQUIP cause, IDbTransaction trans)
{
//平台自动生成代码
#region Parameters Block
OracleParameter[] parameters = null;
#endregion
string sSql = "delete from MCE_B_ASSETS_ROLLEQUIP where (1=1)";
sSql += PrepareCause(cause, out parameters);
return(IDALProvider.IDAL.ExecuteNonQuery(sSql, parameters, trans));
}
public int DeleteByTrans2(CauseObject_MCE_B_ASSETS_ROLLEQUIP cause, IDbTransaction transaction)
{
if (LocalMode)
{
return(HelperObject_MCE_B_ASSETS_ROLLEQUIP.Delete(cause, transaction));
//平台自动生成代码
}
else
{
throw new InvalidConstraintException();
}
}
public static DisplayObject_MCE_B_ASSETS_ROLLEQUIP[] Query(CauseObject_MCE_B_ASSETS_ROLLEQUIP cause)
{
//平台自动生成代码
#region Parameters Block
OracleParameter[] parameters = null;
#endregion
string sSql = " select MCE_B_ASSETS_ROLLEQUIP.ROLL_ID, MCE_B_ASSETS_ROLLEQUIP.ID, MCE_B_ASSETS_ROLLEQUIP.ASSETS_ID, MCE_B_ASSETS_ROLL_ROLL_ID.NAME as ROLL_ID_NAME, MCE_B_ASSETS_ASSETS_ID.ASSETS_NAME as ASSETS_ID_NAME from MCE_B_ASSETS_ROLLEQUIP left join MCE_B_ASSETS_ROLL MCE_B_ASSETS_ROLL_ROLL_ID on MCE_B_ASSETS_ROLLEQUIP.ROLL_ID = MCE_B_ASSETS_ROLL_ROLL_ID.ID left join MCE_B_ASSETS MCE_B_ASSETS_ASSETS_ID on MCE_B_ASSETS_ROLLEQUIP.ASSETS_ID = MCE_B_ASSETS_ASSETS_ID.ID where (1=1)";
sSql += PrepareCause(cause, out parameters);
if (cause.Recursion != null && !string.IsNullOrEmpty(cause.Recursion.RecursionFieldValue))
{
sSql = "select t.* from (" + sSql + ") t,( select t." + cause.Recursion.TargetKeyFieldName + " from " + cause.Recursion.TargetDataObjectName + " t start with t." + cause.Recursion.TargetKeyFieldName + " = '" + cause.Recursion.RecursionFieldValue + "' connect by t." + cause.Recursion.TargetLevelFieldName + " = PRIOR t." + cause.Recursion.TargetKeyFieldName + " ) t1 where t." + cause.Recursion.RecursionFieldName + " = t1." + cause.Recursion.TargetKeyFieldName;
}
#region Push Block
DisplayObject_MCE_B_ASSETS_ROLLEQUIP dataObj = null;
ArrayList objArray = new ArrayList();
IDbConnection connection = IDALProvider.IDAL.PopConnection();
IDataReader sqlReader = IDALProvider.IDAL.ExecuteReader(sSql, parameters, connection);
while (sqlReader.Read())
{
dataObj = new DisplayObject_MCE_B_ASSETS_ROLLEQUIP();
if (!sqlReader.IsDBNull(0))
{
dataObj.ROLL_ID = sqlReader.GetString(0);
}
if (!sqlReader.IsDBNull(1))
{
dataObj.ID = sqlReader.GetString(1);
}
if (!sqlReader.IsDBNull(2))
{
dataObj.ASSETS_ID = sqlReader.GetString(2);
}
if (!sqlReader.IsDBNull(3))
{
dataObj.ROLL_ID_NAME = sqlReader.GetString(3);
}
if (!sqlReader.IsDBNull(4))
{
dataObj.ASSETS_ID_NAME = sqlReader.GetString(4);
}
objArray.Add(dataObj);
}
sqlReader.Close();
IDALProvider.IDAL.PushConnection(connection);
#endregion
DisplayObject_MCE_B_ASSETS_ROLLEQUIP[] objs = new DisplayObject_MCE_B_ASSETS_ROLLEQUIP[objArray.Count];
objArray.CopyTo(0, objs, 0, objs.Length);
return(objs);
}
public static int Update(EntityObject_MCE_B_ASSETS_ROLLEQUIP obj, CauseObject_MCE_B_ASSETS_ROLLEQUIP cause, IDbTransaction trans)
{
//平台自动生成代码
#region Parameters Block
List <OracleParameter> list = new List <OracleParameter>();
OracleParameter[] parameters = null;
#endregion
string sSql = "update MCE_B_ASSETS_ROLLEQUIP set ";
sSql += PrepareUpdate(obj, out parameters, false);
list.AddRange(parameters);
sSql += " where 1=1 ";
sSql += PrepareCause(cause, out parameters);
list.AddRange(parameters);
parameters = list.ToArray();
return(IDALProvider.IDAL.ExecuteNonQuery(sSql, parameters, trans));
}
public DisplayObject_MCE_B_ASSETS_ROLLEQUIP[] Query(CauseObject_MCE_B_ASSETS_ROLLEQUIP cause, PagingParamter paging, OrderByParameter order)
{
if (LocalMode)
{
SystemLogic.Proxy.AuditQuery(cause);
//平台自动生成代码
return(HelperObject_MCE_B_ASSETS_ROLLEQUIP.Query(cause, paging, order));
}
else
{
using (ServiceManager <ServiceContract_MCE_B_ASSETS_ROLLEQUIP> smgr = new ServiceManager <ServiceContract_MCE_B_ASSETS_ROLLEQUIP>(ServiceUri))
{
return(smgr.Service.Query(cause, paging, order));
}
}
}
public BizLogicMsg Delete(CauseObject_MCE_B_ASSETS_ROLLEQUIP cause)
{
if (LocalMode)
{
BizLogicMsg msg = new BizLogicMsg();
using (IDbConnection connection = IDALProvider.IDAL.PopConnection())
{
using (IDbTransaction transaction = connection.BeginTransaction())
{
try
{
int amount = HelperObject_MCE_B_ASSETS_ROLLEQUIP.Delete(cause, 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_ROLLEQUIP> smgr = new ServiceManager <ServiceContract_MCE_B_ASSETS_ROLLEQUIP>(ServiceUri))
{
return(smgr.Service.Delete(cause));
}
}
}
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_Ext(string strID)
{
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 = strID;
obj = HelperObject_MCE_B_ASSETS_ROLL.Get(obj);
if (obj != null)
{
if (obj.AUDIT_STATE == 3 || obj.AUDIT_STATE == 4)
{
throw new Exception("已经审核的案卷信息不能删除.");
}
CauseObject_MCE_B_ASSETS_ROLLFILE pMCE_B_ASSETS_ROLLFILE = new CauseObject_MCE_B_ASSETS_ROLLFILE();
pMCE_B_ASSETS_ROLLFILE.BASE_ID = obj.ID;
DisplayObject_MCE_B_ASSETS_ROLLFILE[] listMCE_B_ASSETS_ROLLFILE = BizLogicObject_MCE_B_ASSETS_ROLLFILE.Proxy.Query(pMCE_B_ASSETS_ROLLFILE);
if (listMCE_B_ASSETS_ROLLFILE != null && listMCE_B_ASSETS_ROLLFILE.Length > 0)
{
foreach (DisplayObject_MCE_B_ASSETS_ROLLFILE displayObject_MCE_B_ASSETS_ROLLFILE in listMCE_B_ASSETS_ROLLFILE)
{
CauseObject_COM_FILE pCOM_FILE = new CauseObject_COM_FILE();
pCOM_FILE.REF_TAB_ID = displayObject_MCE_B_ASSETS_ROLLFILE.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(displayObject_MCE_B_ASSETS_ROLLFILE, transaction);
}
}
CauseObject_MCE_B_ASSETS_ROLLEQUIP pMCE_B_ASSETS_ROLLEQUIP = new CauseObject_MCE_B_ASSETS_ROLLEQUIP();
pMCE_B_ASSETS_ROLLEQUIP.ROLL_ID = obj.ID;
HelperObject_MCE_B_ASSETS_ROLLEQUIP.Delete(pMCE_B_ASSETS_ROLLEQUIP, transaction);
HelperObject_MCE_B_ASSETS_ROLL.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_Ext(strID));
}
}
}
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 static DisplayObject_MCE_B_ASSETS_ROLLEQUIP[] Query(CauseObject_MCE_B_ASSETS_ROLLEQUIP cause, PagingParamter paging, OrderByParameter order, IDbTransaction trans)
{
//平台自动生成代码
#region Parameters Block
OracleParameter[] parameters = null;
IDataReader sqlReader = null;
#endregion
string sSql = " select MCE_B_ASSETS_ROLLEQUIP.ROLL_ID, MCE_B_ASSETS_ROLLEQUIP.ID, MCE_B_ASSETS_ROLLEQUIP.ASSETS_ID, MCE_B_ASSETS_ROLL_ROLL_ID.NAME as ROLL_ID_NAME, MCE_B_ASSETS_ASSETS_ID.ASSETS_NAME as ASSETS_ID_NAME from MCE_B_ASSETS_ROLLEQUIP left join MCE_B_ASSETS_ROLL MCE_B_ASSETS_ROLL_ROLL_ID on MCE_B_ASSETS_ROLLEQUIP.ROLL_ID = MCE_B_ASSETS_ROLL_ROLL_ID.ID left join MCE_B_ASSETS MCE_B_ASSETS_ASSETS_ID on MCE_B_ASSETS_ROLLEQUIP.ASSETS_ID = MCE_B_ASSETS_ASSETS_ID.ID where (1=1)";
string sCauseSql = PrepareCause(cause, out parameters);
sSql += sCauseSql;
if (cause.Recursion != null && !string.IsNullOrEmpty(cause.Recursion.RecursionFieldValue))
{
sSql = "select t.* from (" + sSql + ") t,( select t." + cause.Recursion.TargetKeyFieldName + " from " + cause.Recursion.TargetDataObjectName + " t start with t." + cause.Recursion.TargetKeyFieldName + " = '" + cause.Recursion.RecursionFieldValue + "' connect by t." + cause.Recursion.TargetLevelFieldName + " = PRIOR t." + cause.Recursion.TargetKeyFieldName + " ) t1 where t." + cause.Recursion.RecursionFieldName + " = t1." + cause.Recursion.TargetKeyFieldName;
}
#region Push Block
if (paging != null)
{
string countSql = string.Empty;
if (cause.Recursion != null && !string.IsNullOrEmpty(cause.Recursion.RecursionFieldValue))
{
countSql = "Select Count(*) From (" + sSql + ") t";
}
else
{
countSql = "Select Count(*) From (" + sSql + ") t";
}
if (paging.TotalRecords == 0)
{
paging.TotalRecords = IDALProvider.IDAL.DatabaseType == Ipedf.Common.DatabaseType.SqlServer || IDALProvider.IDAL.DatabaseType == Ipedf.Common.DatabaseType.Db2? (int)IDALProvider.IDAL.ExecuteScalar(countSql, parameters, trans) : (int)(decimal)IDALProvider.IDAL.ExecuteScalar(countSql, parameters, trans);
}
sqlReader = IDALProvider.IDAL.ExecutePagingReader("MCE_B_ASSETS_ROLLEQUIP", paging, order, sSql, parameters, trans);
}
else if (order != null)
{
sSql += order.ToString();
sqlReader = IDALProvider.IDAL.ExecuteReader(sSql, parameters, trans);
}
else
{
sqlReader = IDALProvider.IDAL.ExecuteReader(sSql, parameters, trans);
}
DisplayObject_MCE_B_ASSETS_ROLLEQUIP dataObj = null;
ArrayList objArray = new ArrayList();
while (sqlReader.Read())
{
dataObj = new DisplayObject_MCE_B_ASSETS_ROLLEQUIP();
if (!sqlReader.IsDBNull(0))
{
dataObj.ROLL_ID = sqlReader.GetString(0);
}
if (!sqlReader.IsDBNull(1))
{
dataObj.ID = sqlReader.GetString(1);
}
if (!sqlReader.IsDBNull(2))
{
dataObj.ASSETS_ID = sqlReader.GetString(2);
}
if (!sqlReader.IsDBNull(3))
{
dataObj.ROLL_ID_NAME = sqlReader.GetString(3);
}
if (!sqlReader.IsDBNull(4))
{
dataObj.ASSETS_ID_NAME = sqlReader.GetString(4);
}
objArray.Add(dataObj);
}
sqlReader.Close();
#endregion
DisplayObject_MCE_B_ASSETS_ROLLEQUIP[] objs = new DisplayObject_MCE_B_ASSETS_ROLLEQUIP[objArray.Count];
objArray.CopyTo(0, objs, 0, objs.Length);
return(objs);
}
