/// <summary> /// 更新实体 /// </summary> /// <param name="cUSTOMERCHANCEEntity">实体</param> public int UpdateEntity(CUSTOMERCHANCEEntity cUSTOMERCHANCEEntity) { SQLBuilder sqlBuilder = new SQLBuilder(DBProvider); sqlBuilder.BeginUpdate(this.CurrentTableName); this.SetEntity(sqlBuilder, cUSTOMERCHANCEEntity); sqlBuilder.SetWhere(CUSTOMERCHANCETable.FieldId, cUSTOMERCHANCEEntity.Id); return(sqlBuilder.EndUpdate()); }
/// <summary> /// 更新实体 /// </summary> /// <param name="userInfo">用户</param> /// <param name="entity">实体</param> /// <param name="statusCode">返回状态码</param> /// <param name="statusMessage">返回状态信息</param> /// <returns>影响行数</returns> public int Update(UserInfo userInfo, CUSTOMERCHANCEEntity entity, out string statusCode, out string statusMessage) { int returnValue = 0; statusCode = string.Empty; using (IDbProvider frameworkDbProvider = DbFactoryProvider.GetProvider(SystemInfo.RDIFrameworkDbType)) { try { frameworkDbProvider.Open(RDIFrameworkDbConection); LogManager.Instance.Add(frameworkDbProvider, userInfo, this.serviceName, "更新实体", MethodBase.GetCurrentMethod()); using (IDbProvider dbProvider = DbFactoryProvider.GetProvider(BusinessDbType)) { try { dbProvider.Open(BusinessDbConnection); CUSTOMERCHANCEManager manager = new CUSTOMERCHANCEManager(dbProvider, userInfo); returnValue = manager.UpdateEntity(entity); // returnValue = manager.Update(entity, out statusCode); statusMessage = manager.GetStateMessage(statusCode); } catch (Exception ex) { CiExceptionManager.LogException(frameworkDbProvider, userInfo, ex); throw ex; } finally { dbProvider.Close(); } } } catch (Exception ex) { CiExceptionManager.LogException(frameworkDbProvider, userInfo, ex); throw ex; } finally { frameworkDbProvider.Close(); } } return(returnValue); }
/// <summary> /// 取得实体 /// </summary> /// <param name="userInfo">用户</param> /// <param name="id">主鍵</param> /// <returns>实体</returns> public CUSTOMERCHANCEEntity GetEntity(UserInfo userInfo, string id) { CUSTOMERCHANCEEntity entity = null; using (IDbProvider frameworkDbProvider = DbFactoryProvider.GetProvider(SystemInfo.RDIFrameworkDbType)) { try { frameworkDbProvider.Open(RDIFrameworkDbConection); LogManager.Instance.Add(frameworkDbProvider, userInfo, this.serviceName, "取得实体", MethodBase.GetCurrentMethod()); using (IDbProvider dbProvider = DbFactoryProvider.GetProvider(BusinessDbType)) { try { dbProvider.Open(BusinessDbConnection); CUSTOMERCHANCEManager manager = new CUSTOMERCHANCEManager(dbProvider, userInfo); entity = manager.GetEntity(id); } catch (Exception ex) { CiExceptionManager.LogException(frameworkDbProvider, userInfo, ex); throw ex; } finally { dbProvider.Close(); } } } catch (Exception ex) { CiExceptionManager.LogException(frameworkDbProvider, userInfo, ex); throw ex; } finally { frameworkDbProvider.Close(); } } return(entity); }
/// <summary> /// 设置实体 /// </summary> /// <param name="cUSTOMERCHANCEEntity">实体</param> private void SetEntity(SQLBuilder sqlBuilder, CUSTOMERCHANCEEntity cUSTOMERCHANCEEntity) { sqlBuilder.SetValue(CUSTOMERCHANCETable.FieldCUSTOMERID, cUSTOMERCHANCEEntity.CUSTOMERID); sqlBuilder.SetValue(CUSTOMERCHANCETable.FieldCUSTOMERNAME, cUSTOMERCHANCEEntity.CUSTOMERNAME); sqlBuilder.SetValue(CUSTOMERCHANCETable.FieldTHEME, cUSTOMERCHANCEEntity.THEME); sqlBuilder.SetValue(CUSTOMERCHANCETable.FieldFZR, cUSTOMERCHANCEEntity.FZR); sqlBuilder.SetValue(CUSTOMERCHANCETable.FieldSTATE, cUSTOMERCHANCEEntity.STATE); sqlBuilder.SetValue(CUSTOMERCHANCETable.FieldMOMENT, cUSTOMERCHANCEEntity.MOMENT); sqlBuilder.SetValue(CUSTOMERCHANCETable.FieldSOURCE, cUSTOMERCHANCEEntity.SOURCE); sqlBuilder.SetValue(CUSTOMERCHANCETable.FieldINTENDPRICE, cUSTOMERCHANCEEntity.INTENDPRICE); sqlBuilder.SetValue(CUSTOMERCHANCETable.FieldPOSSIBILITY, cUSTOMERCHANCEEntity.POSSIBILITY); sqlBuilder.SetValue(CUSTOMERCHANCETable.FieldSTARTDATE, cUSTOMERCHANCEEntity.STARTDATE); sqlBuilder.SetValue(CUSTOMERCHANCETable.FieldENDDATE, cUSTOMERCHANCEEntity.ENDDATE); sqlBuilder.SetValue(CUSTOMERCHANCETable.FieldREALENDDATE, cUSTOMERCHANCEEntity.REALENDDATE); sqlBuilder.SetValue(CUSTOMERCHANCETable.FieldDESCRIPTION, cUSTOMERCHANCEEntity.DESCRIPTION); sqlBuilder.SetValue(CUSTOMERCHANCETable.FieldSORTCODE, cUSTOMERCHANCEEntity.SORTCODE); sqlBuilder.SetValue(CUSTOMERCHANCETable.FieldDELETEMARK, cUSTOMERCHANCEEntity.DELETEMARK); sqlBuilder.SetValue(CUSTOMERCHANCETable.FieldENABLE, cUSTOMERCHANCEEntity.ENABLE); sqlBuilder.SetValue(CUSTOMERCHANCETable.FieldCREATEUSER, cUSTOMERCHANCEEntity.CREATEUSER); sqlBuilder.SetValue(CUSTOMERCHANCETable.FieldMODIFYON, cUSTOMERCHANCEEntity.MODIFYON); sqlBuilder.SetValue(CUSTOMERCHANCETable.FieldMODIFIEDUSERID, cUSTOMERCHANCEEntity.MODIFIEDUSERID); sqlBuilder.SetValue(CUSTOMERCHANCETable.FieldMODIFYUSER, cUSTOMERCHANCEEntity.MODIFYUSER); }
/// <summary> /// 添加实体 /// </summary> /// <param name="cUSTOMERCHANCEEntity">实体</param> public string AddEntity(CUSTOMERCHANCEEntity cUSTOMERCHANCEEntity) { string sequence = string.Empty; if (cUSTOMERCHANCEEntity.SORTCODE == null || cUSTOMERCHANCEEntity.SORTCODE == 0) { CiSequenceManager sequenceManager = new CiSequenceManager(DBProvider, this.Identity); sequence = sequenceManager.GetSequence(this.CurrentTableName); cUSTOMERCHANCEEntity.SORTCODE = int.Parse(sequence); } SQLBuilder sqlBuilder = new SQLBuilder(DBProvider, this.Identity, this.ReturnId); sqlBuilder.BeginInsert(this.CurrentTableName, CUSTOMERCHANCETable.FieldId); if (!this.Identity) { sqlBuilder.SetValue(CUSTOMERCHANCETable.FieldId, cUSTOMERCHANCEEntity.Id); } else { if (!this.ReturnId && (DBProvider.CurrentDbType == CurrentDbType.Oracle || DBProvider.CurrentDbType == CurrentDbType.DB2)) { if (DBProvider.CurrentDbType == CurrentDbType.Oracle) { sqlBuilder.SetFormula(CUSTOMERCHANCETable.FieldId, "SEQ_" + this.CurrentTableName.ToUpper() + ".NEXTVAL "); } if (DBProvider.CurrentDbType == CurrentDbType.DB2) { sqlBuilder.SetFormula(CUSTOMERCHANCETable.FieldId, "NEXT VALUE FOR SEQ_" + this.CurrentTableName.ToUpper()); } } else { if (this.Identity && (DBProvider.CurrentDbType == CurrentDbType.Oracle || DBProvider.CurrentDbType == CurrentDbType.DB2)) { if (cUSTOMERCHANCEEntity.Id == null) { if (string.IsNullOrEmpty(sequence)) { CiSequenceManager sequenceManager = new CiSequenceManager(DBProvider, this.Identity); sequence = sequenceManager.GetSequence(this.CurrentTableName); } cUSTOMERCHANCEEntity.Id = int.Parse(sequence); } sqlBuilder.SetValue(CUSTOMERCHANCETable.FieldId, cUSTOMERCHANCEEntity.Id); } } } this.SetEntity(sqlBuilder, cUSTOMERCHANCEEntity); if (UserInfo != null) { sqlBuilder.SetValue(CUSTOMERCHANCETable.FieldCreateUserId, UserInfo.Id); } sqlBuilder.SetDBNow(CUSTOMERCHANCETable.FieldCreateOn); if (this.Identity && (DBProvider.CurrentDbType == CurrentDbType.SqlServer || DBProvider.CurrentDbType == CurrentDbType.Access)) { sequence = sqlBuilder.EndInsert().ToString(); } else { sqlBuilder.EndInsert(); } return(sequence); }
public CUSTOMERCHANCEEntity GetEntity(int id) { CUSTOMERCHANCEEntity cUSTOMERCHANCEEntity = new CUSTOMERCHANCEEntity(this.GetDT(new KeyValuePair <string, object>(CUSTOMERCHANCETable.FieldId, id))); return(cUSTOMERCHANCEEntity); }
/// <summary> /// 更新 /// </summary> /// <param name="cUSTOMERCHANCEEntity">实体</param> public int Update(CUSTOMERCHANCEEntity cUSTOMERCHANCEEntity) { return(this.UpdateEntity(cUSTOMERCHANCEEntity)); }
/// <summary> /// 添加 /// </summary> /// <param name="cUSTOMERCHANCEEntity">实体</param> /// <param name="identity">自增量方式</param> /// <param name="returnId">返回主键</param> /// <returns>主键</returns> public string Add(CUSTOMERCHANCEEntity cUSTOMERCHANCEEntity, bool identity, bool returnId) { this.Identity = identity; this.ReturnId = returnId; return(this.AddEntity(cUSTOMERCHANCEEntity)); }
/// <summary> /// 添加 /// </summary> /// <param name="cUSTOMERCHANCEEntity">实体</param> /// <returns>主键</returns> public string Add(CUSTOMERCHANCEEntity cUSTOMERCHANCEEntity) { return(this.AddEntity(cUSTOMERCHANCEEntity)); }