/// <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));
}
