/// <summary>
/// 更新实体
/// </summary>
/// <param name="addressBookEntity">实体对象</param>
/// <returns>影响行数</returns>
public int UpdateEntity(BaseAdviceEntity myAdviceEntity)
{
SQLBuilder sqlBuilder = new SQLBuilder(this.DbHelper);
sqlBuilder.BeginUpdate(BaseAdviceTable.TableName);
this.SetEntity(sqlBuilder, myAdviceEntity);
sqlBuilder.SetValue(BaseAdviceTable.FieldModifyUserID, this.UserInfo.ID);
sqlBuilder.SetDBNow(BaseAdviceTable.FieldModifyDate);
sqlBuilder.SetWhere(BaseAdviceTable.FieldID, myAdviceEntity.ID);
return(sqlBuilder.EndUpdate());
}
/// <summary>
/// 添加实体
/// </summary>
/// <param name="addressBookEntity">实体对象</param>
/// <returns>代码</returns>
public String AddEntity(BaseAdviceEntity myAdviceEntity)
{
String id = BaseSequenceDao.Instance.NewGuid();
SQLBuilder sqlBuilder = new SQLBuilder(this.DbHelper);
sqlBuilder.BeginInsert(BaseAdviceTable.TableName);
sqlBuilder.SetValue(BaseAdviceTable.FieldID, id);
this.SetEntity(sqlBuilder, myAdviceEntity);
if (this.UserInfo != null)
{
sqlBuilder.SetValue(BaseAdviceTable.FieldCreateUserID, this.UserInfo.ID);
}
sqlBuilder.SetDBNow(BaseAdviceTable.FieldCreateDate);
return sqlBuilder.EndInsert() > 0 ? id : String.Empty;
}
/// <summary>
/// 添加实体
/// </summary>
/// <param name="addressBookEntity">实体对象</param>
/// <returns>代码</returns>
public String AddEntity(BaseAdviceEntity myAdviceEntity)
{
String id = BaseSequenceDao.Instance.NewGuid();
SQLBuilder sqlBuilder = new SQLBuilder(this.DbHelper);
sqlBuilder.BeginInsert(BaseAdviceTable.TableName);
sqlBuilder.SetValue(BaseAdviceTable.FieldID, id);
this.SetEntity(sqlBuilder, myAdviceEntity);
if (this.UserInfo != null)
{
sqlBuilder.SetValue(BaseAdviceTable.FieldCreateUserID, this.UserInfo.ID);
}
sqlBuilder.SetDBNow(BaseAdviceTable.FieldCreateDate);
return(sqlBuilder.EndInsert() > 0 ? id : String.Empty);
}
/// <summary>
/// 设置实体
/// </summary>
/// <param name="sqlBuilder">SQL生成器</param>
/// <param name="myAdviceEntity">实体对象</param>
private void SetEntity(SQLBuilder sqlBuilder, BaseAdviceEntity myAdviceEntity)
{
sqlBuilder.SetValue(BaseAdviceTable.FieldTitle, myAdviceEntity.Title);
sqlBuilder.SetValue(BaseAdviceTable.FieldContent, myAdviceEntity.Content);
sqlBuilder.SetValue(BaseAdviceTable.FieldPhone, myAdviceEntity.Phone);
sqlBuilder.SetValue(BaseAdviceTable.FieldEmail, myAdviceEntity.Email);
sqlBuilder.SetValue(BaseAdviceTable.FieldOICQ, myAdviceEntity.OICQ);
sqlBuilder.SetValue(BaseAdviceTable.FieldMSN, myAdviceEntity.MSN);
sqlBuilder.SetValue(BaseAdviceTable.FieldIPAddress, myAdviceEntity.IPAddress);
sqlBuilder.SetValue(BaseAdviceTable.FieldPublicState, myAdviceEntity.PublicState);
sqlBuilder.SetValue(BaseAdviceTable.FieldPriorityID, myAdviceEntity.PriorityID);
sqlBuilder.SetValue(BaseAdviceTable.FieldDisposeStateID, myAdviceEntity.DisposeStateID);
sqlBuilder.SetValue(BaseAdviceTable.FieldSendTo, myAdviceEntity.SendTo);
sqlBuilder.SetValue(BaseAdviceTable.FieldSortCode, myAdviceEntity.SortCode);
sqlBuilder.SetValue(BaseAdviceTable.FieldDescription, myAdviceEntity.Description);
sqlBuilder.SetValue(BaseAdviceTable.FieldEnabled, myAdviceEntity.Enabled);
}
/// <summary>
/// 设置实体
/// </summary>
/// <param name="sqlBuilder">SQL生成器</param>
/// <param name="myAdviceEntity">实体对象</param>
private void SetEntity(SQLBuilder sqlBuilder, BaseAdviceEntity myAdviceEntity)
{
sqlBuilder.SetValue(BaseAdviceTable.FieldTitle, myAdviceEntity.Title);
sqlBuilder.SetValue(BaseAdviceTable.FieldContent, myAdviceEntity.Content);
sqlBuilder.SetValue(BaseAdviceTable.FieldPhone, myAdviceEntity.Phone);
sqlBuilder.SetValue(BaseAdviceTable.FieldEmail, myAdviceEntity.Email);
sqlBuilder.SetValue(BaseAdviceTable.FieldOICQ, myAdviceEntity.OICQ);
sqlBuilder.SetValue(BaseAdviceTable.FieldMSN, myAdviceEntity.MSN);
sqlBuilder.SetValue(BaseAdviceTable.FieldIPAddress, myAdviceEntity.IPAddress);
sqlBuilder.SetValue(BaseAdviceTable.FieldPublicState, myAdviceEntity.PublicState);
sqlBuilder.SetValue(BaseAdviceTable.FieldPriorityID, myAdviceEntity.PriorityID);
sqlBuilder.SetValue(BaseAdviceTable.FieldDisposeStateID, myAdviceEntity.DisposeStateID);
sqlBuilder.SetValue(BaseAdviceTable.FieldSendTo, myAdviceEntity.SendTo);
sqlBuilder.SetValue(BaseAdviceTable.FieldSortCode, myAdviceEntity.SortCode);
sqlBuilder.SetValue(BaseAdviceTable.FieldDescription, myAdviceEntity.Description);
sqlBuilder.SetValue(BaseAdviceTable.FieldEnabled, myAdviceEntity.Enabled);
}
/// <summary>
/// 更新实体
/// </summary>
/// <param name="addressBookEntity">实体对象</param>
/// <returns>影响行数</returns>
public int UpdateEntity(BaseAdviceEntity myAdviceEntity)
{
SQLBuilder sqlBuilder = new SQLBuilder(this.DbHelper);
sqlBuilder.BeginUpdate(BaseAdviceTable.TableName);
this.SetEntity(sqlBuilder, myAdviceEntity);
sqlBuilder.SetValue(BaseAdviceTable.FieldModifyUserID, this.UserInfo.ID);
sqlBuilder.SetDBNow(BaseAdviceTable.FieldModifyDate);
sqlBuilder.SetWhere(BaseAdviceTable.FieldID, myAdviceEntity.ID);
return sqlBuilder.EndUpdate();
}
