public static int Save(EntityObject_MCE_B_ASSETS_WRITE_OFF_D obj, IDbTransaction trans)
{
//平台自动生成代码
obj.ID = Guid.NewGuid().ToString();
string sSql = "insert into MCE_B_ASSETS_WRITE_OFF_D( ASSET_ID, BASE_ID, ID) values ( :ASSET_ID, :BASE_ID, :ID)";
#region Parameters Block
OracleParameter[] parameters = new OracleParameter[3];
parameters[0] = new OracleParameter();
parameters[0].ParameterName = ":ASSET_ID";
parameters[0].Size = 36;
parameters[0].OracleType = System.Data.OracleClient.OracleType.Char;
parameters[0].Value = obj.ASSET_ID == null ? String.Empty:obj.ASSET_ID;
parameters[1] = new OracleParameter();
parameters[1].ParameterName = ":BASE_ID";
parameters[1].Size = 36;
parameters[1].OracleType = System.Data.OracleClient.OracleType.Char;
parameters[1].Value = obj.BASE_ID == null ? String.Empty:obj.BASE_ID;
parameters[2] = new OracleParameter();
parameters[2].ParameterName = ":ID";
parameters[2].Size = 36;
parameters[2].OracleType = System.Data.OracleClient.OracleType.Char;
parameters[2].Value = obj.ID == null ? String.Empty:obj.ID;
#endregion
return(IDALProvider.IDAL.ExecuteNonQuery(sSql, parameters, trans));
}
public static int Update(EntityObject_MCE_B_ASSETS_WRITE_OFF_D obj, IDbTransaction trans)
{
//平台自动生成代码
#region Parameters Block
OracleParameter[] parameters = null;
#endregion
string sSql = "update MCE_B_ASSETS_WRITE_OFF_D set ";
sSql += PrepareUpdate(obj, out parameters, true);
sSql += " where ID = :U_ID ";
return(IDALProvider.IDAL.ExecuteNonQuery(sSql, parameters, trans));
}
public static int Delete(EntityObject_MCE_B_ASSETS_WRITE_OFF_D obj, IDbTransaction trans)
{
//平台自动生成代码
string sSql = "delete from MCE_B_ASSETS_WRITE_OFF_D where ID = :ID ";
#region Parameters Block
OracleParameter[] parameters = new OracleParameter[1];
parameters[0] = new OracleParameter();
parameters[0].ParameterName = ":ID";
parameters[0].Size = 36;
parameters[0].OracleType = System.Data.OracleClient.OracleType.Char;
parameters[0].Value = obj.ID;
#endregion
return(IDALProvider.IDAL.ExecuteNonQuery(sSql, parameters, trans));
}
public static int Update(EntityObject_MCE_B_ASSETS_WRITE_OFF_D obj, CauseObject_MCE_B_ASSETS_WRITE_OFF_D cause, IDbTransaction trans)
{
//平台自动生成代码
#region Parameters Block
List <OracleParameter> list = new List <OracleParameter>();
OracleParameter[] parameters = null;
#endregion
string sSql = "update MCE_B_ASSETS_WRITE_OFF_D 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 static string PrepareUpdate(EntityObject_MCE_B_ASSETS_WRITE_OFF_D obj, out OracleParameter[] parameters, bool appendpk)
{
//平台自动生成代码
List <string> strBuf = new List <string>();
ArrayList paramList = new ArrayList();
OracleParameter param = null;
#region Push Block
if (!obj.IsNotUpdate("ASSET_ID"))
{
strBuf.Add(" MCE_B_ASSETS_WRITE_OFF_D.ASSET_ID = :U_ASSET_ID");
param = new OracleParameter();
param.ParameterName = ":U_ASSET_ID";
param.OracleType = System.Data.OracleClient.OracleType.Char;
param.Size = 36;
param.Value = string.IsNullOrEmpty(obj.ASSET_ID) ? string.Empty : obj.ASSET_ID;
paramList.Add(param);
}
if (!obj.IsNotUpdate("BASE_ID"))
{
strBuf.Add(" MCE_B_ASSETS_WRITE_OFF_D.BASE_ID = :U_BASE_ID");
param = new OracleParameter();
param.ParameterName = ":U_BASE_ID";
param.OracleType = System.Data.OracleClient.OracleType.Char;
param.Size = 36;
param.Value = string.IsNullOrEmpty(obj.BASE_ID) ? string.Empty : obj.BASE_ID;
paramList.Add(param);
}
//pk here
if (appendpk)
{
param = new OracleParameter();
param.ParameterName = ":U_ID";
param.OracleType = System.Data.OracleClient.OracleType.Char;
param.Size = 36;
param.Value = obj.ID;
paramList.Add(param);
}
#endregion
parameters = new OracleParameter[paramList.Count];
paramList.CopyTo(parameters);
return(string.Join(", ", strBuf.ToArray()));
}
public static EntityObject_MCE_B_ASSETS_WRITE_OFF_D Get(EntityObject_MCE_B_ASSETS_WRITE_OFF_D obj)
{
//平台自动生成代码
string sSql = "select ASSET_ID, BASE_ID, ID from MCE_B_ASSETS_WRITE_OFF_D where ID = :ID ";
#region Parameters Block
OracleParameter[] parameters = new OracleParameter[1];
parameters[0] = new OracleParameter();
parameters[0].ParameterName = ":ID";
parameters[0].Size = 36;
parameters[0].OracleType = System.Data.OracleClient.OracleType.Char;
parameters[0].Value = obj.ID;
#endregion
#region Push Block
EntityObject_MCE_B_ASSETS_WRITE_OFF_D dataObj = null;
ArrayList objArray = new ArrayList();
IDbConnection connection = IDALProvider.IDAL.PopConnection();
IDataReader sqlReader = IDALProvider.IDAL.ExecuteReader(sSql, parameters, connection);
while (sqlReader.Read())
{
dataObj = new EntityObject_MCE_B_ASSETS_WRITE_OFF_D();
if (!sqlReader.IsDBNull(0))
{
dataObj.ASSET_ID = sqlReader.GetString(0);
}
if (!sqlReader.IsDBNull(1))
{
dataObj.BASE_ID = sqlReader.GetString(1);
}
if (!sqlReader.IsDBNull(2))
{
dataObj.ID = sqlReader.GetString(2);
}
objArray.Add(dataObj);
}
sqlReader.Close();
IDALProvider.IDAL.PushConnection(connection);
#endregion
EntityObject_MCE_B_ASSETS_WRITE_OFF_D[] objs = new EntityObject_MCE_B_ASSETS_WRITE_OFF_D[objArray.Count];
objArray.CopyTo(0, objs, 0, objs.Length);
return(objs.Length == 0 ? null:objs[0]);
}
public BizLogicMsg Save_Ext2(JsonMCE_Write_Off json_Write_Off)
{
if (LocalMode)
{
BizLogicMsg msg = new BizLogicMsg();
using (IDbConnection connection = IDALProvider.IDAL.PopConnection())
{
using (IDbTransaction transaction = connection.BeginTransaction())
{
try
{
EntityObject_MCE_B_ASSETS_WRITE_OFF entity = new EntityObject_MCE_B_ASSETS_WRITE_OFF();
if (!string.IsNullOrEmpty(json_Write_Off.ID))
{
entity.ID = json_Write_Off.ID;
entity = HelperObject_MCE_B_ASSETS_WRITE_OFF.Get(entity);
if (entity == null)
{
throw new Exception("获取数据出错.");
}
}
entity.CODE = json_Write_Off.CODE;
if (!string.IsNullOrEmpty(json_Write_Off.CREATE_DATE))
{
entity.CREATE_DATE = DateTime.Parse(json_Write_Off.CREATE_DATE);
}
entity.DEPT_ID = json_Write_Off.DEPT_ID;
entity.USER_ID = json_Write_Off.USER_ID;
entity.FINANCE_CYCLE = json_Write_Off.FINANCE_CYCLE;
entity.WRITE_OFF_TYPE_ID = json_Write_Off.WRITE_OFF_TYPE_ID;
entity.WRITE_OFF_CAUSE_ID = json_Write_Off.WRITE_OFF_CAUSE_ID;
entity.INCOME = json_Write_Off.INCOME;
entity.USAGE = json_Write_Off.USAGE;
entity.COMMENTS = json_Write_Off.COMMENTS;
entity.STATE = 1;
if (string.IsNullOrEmpty(json_Write_Off.ID))
{
entity.CREATE_TIME = DateTime.Now;
entity.CREATE_USER_ID = Ipedf.Web.BizLogic.SystemLogic.Proxy.CurrentUser.ID;
int amount = HelperObject_MCE_B_ASSETS_WRITE_OFF.Save(entity, transaction);
}
else
{
entity.MODIFY_TIME = DateTime.Now;
entity.MODIFY_USER_ID = Ipedf.Web.BizLogic.SystemLogic.Proxy.CurrentUser.ID;
int amount = HelperObject_MCE_B_ASSETS_WRITE_OFF.Update(entity, transaction);
CauseObject_MCE_B_ASSETS_WRITE_OFF_D pWriteOffDetail = new CauseObject_MCE_B_ASSETS_WRITE_OFF_D();
pWriteOffDetail.BASE_ID = json_Write_Off.ID;
HelperObject_MCE_B_ASSETS_WRITE_OFF_D.Delete(pWriteOffDetail, transaction);
CauseObject_MCE_B_ASSETS_WRITE_OFF_ATTACH pWriteOffAttach = new CauseObject_MCE_B_ASSETS_WRITE_OFF_ATTACH();
pWriteOffAttach.BASE_ID = json_Write_Off.ID;
HelperObject_MCE_B_ASSETS_WRITE_OFF_ATTACH.Delete(pWriteOffAttach, transaction);
}
if (json_Write_Off.children != null && json_Write_Off.children.Count > 0)
{
foreach (JsonMCE_Write_Off_D item in json_Write_Off.children)
{
EntityObject_MCE_B_ASSETS_WRITE_OFF_D entity_D = new EntityObject_MCE_B_ASSETS_WRITE_OFF_D();
entity_D.BASE_ID = entity.ID;
entity_D.ASSET_ID = item.ASSET_ID;
HelperObject_MCE_B_ASSETS_WRITE_OFF_D.Save(entity_D, transaction);
}
}
if (json_Write_Off.listAttach != null && json_Write_Off.listAttach.Count > 0)
{
foreach (JsonMCE_Write_Off__ATTACH item in json_Write_Off.listAttach)
{
EntityObject_MCE_B_ASSETS_WRITE_OFF_ATTACH entity_D = new EntityObject_MCE_B_ASSETS_WRITE_OFF_ATTACH();
entity_D.BASE_ID = entity.ID;
entity_D.FILE_NAME = item.FILE_NAME;
entity_D.SAVENAME = item.SAVENAME;
entity_D.USER_ID = item.USER_ID;
entity_D.CREATE_DATE = item.CREATE_DATE;
HelperObject_MCE_B_ASSETS_WRITE_OFF_ATTACH.Save(entity_D, 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_WRITE_OFF> smgr = new ServiceManager <ServiceContract_MCE_B_ASSETS_WRITE_OFF>(ServiceUri))
{
return(smgr.Service.Save_Ext2(json_Write_Off));
}
}
}
