/// <summary>
/// 添加
/// </summary>
/// <param name="addressBookEntity">实体</param>
/// <returns>代码</returns>
public String Add(BaseAddressBookEntity addressBookEntity)
{
String returnValue = String.Empty;
String sequence = BaseSequenceDao.Instance.GetSequence(this.DbHelper, BaseAddressBookTable.TableName);
SQLBuilder mySQLBuilder = new SQLBuilder(this.DbHelper);
int enabled = addressBookEntity.Enabled ? 1 : 0;
mySQLBuilder.BeginInsert(BaseAddressBookTable.TableName);
mySQLBuilder.SetValue(BaseAddressBookTable.FieldID, sequence);
mySQLBuilder.SetValue(BaseAddressBookTable.FieldFullName, addressBookEntity.FullName);
mySQLBuilder.SetValue(BaseAddressBookTable.FieldCompanyName, addressBookEntity.CompanyName);
mySQLBuilder.SetValue(BaseAddressBookTable.FieldAdress, addressBookEntity.Adress);
mySQLBuilder.SetValue(BaseAddressBookTable.FieldDuty, addressBookEntity.Duty);
mySQLBuilder.SetValue(BaseAddressBookTable.FieldTelephone, addressBookEntity.Telephone);
mySQLBuilder.SetValue(BaseAddressBookTable.FieldMobile, addressBookEntity.Mobile);
mySQLBuilder.SetValue(BaseAddressBookTable.FieldMail, addressBookEntity.Mail);
mySQLBuilder.SetValue(BaseAddressBookTable.FieldRelation, addressBookEntity.Relation);
mySQLBuilder.SetValue(BaseAddressBookTable.FieldEnabled, enabled);
mySQLBuilder.SetValue(BaseAddressBookTable.FieldDescription, addressBookEntity.Description);
mySQLBuilder.SetValue(BaseAddressBookTable.FieldSortCode, sequence);
mySQLBuilder.SetValue(BaseAddressBookTable.FieldCreateUserID, this.UserInfo.ID);
mySQLBuilder.SetDBNow(BaseAddressBookTable.FieldCreateDate);
returnValue = mySQLBuilder.EndInsert() > 0 ? sequence : String.Empty;
return(returnValue);
}
/// <summary>
/// 清空内容
/// </summary>
public void ClearProperty(BaseAddressBookEntity addressBookEntity)
{
addressBookEntity.FullName = String.Empty;
addressBookEntity.CompanyName = String.Empty;
addressBookEntity.Adress = String.Empty;
addressBookEntity.Duty = String.Empty;
addressBookEntity.Telephone = String.Empty;
addressBookEntity.Mobile = String.Empty;
addressBookEntity.Mail = String.Empty;
addressBookEntity.Relation = String.Empty;
}
/// <summary>
/// 从数据行读取
/// </summary>
/// <param name="myDataRow">数据行</param>
/// <returns>通讯录的基类表结构定义</returns>
public BaseAddressBookEntity GetFrom(DataRow myDataRow, BaseAddressBookEntity addressBookEntity)
{
addressBookEntity.ID = myDataRow[BaseAddressBookTable.FieldID].ToString(); // 代码
addressBookEntity.FullName = myDataRow[BaseAddressBookTable.FieldFullName].ToString(); // 联系人
addressBookEntity.CompanyName = myDataRow[BaseAddressBookTable.FieldCompanyName].ToString(); // 公司名称
addressBookEntity.Adress = myDataRow[BaseAddressBookTable.FieldAdress].ToString(); // 地址
addressBookEntity.Duty = myDataRow[BaseAddressBookTable.FieldDuty].ToString(); // 职务
addressBookEntity.Telephone = myDataRow[BaseAddressBookTable.FieldTelephone].ToString(); // 电话
addressBookEntity.Mobile = myDataRow[BaseAddressBookTable.FieldMobile].ToString(); // 手机
addressBookEntity.Mail = myDataRow[BaseAddressBookTable.FieldMail].ToString(); // 邮件
addressBookEntity.Relation = myDataRow[BaseAddressBookTable.FieldRelation].ToString(); // 关系
addressBookEntity.Enabled = myDataRow[BaseAddressBookTable.FieldEnabled].ToString().Equals("1"); // 有效性
addressBookEntity.Description = myDataRow[BaseAddressBookTable.FieldDescription].ToString(); // 排序
addressBookEntity.SortCode = myDataRow[BaseAddressBookTable.FieldSortCode].ToString(); // 备注
addressBookEntity.CreateUserID = myDataRow[BaseAddressBookTable.FieldCreateUserID].ToString(); // 创建者
addressBookEntity.CreateDate = myDataRow[BaseAddressBookTable.FieldCreateDate].ToString(); // 创建时间
addressBookEntity.ModifyUserID = myDataRow[BaseAddressBookTable.FieldModifyUserID].ToString(); // 最后修改者
addressBookEntity.ModifyDate = myDataRow[BaseAddressBookTable.FieldModifyDate].ToString(); // 最后修改时间
return(addressBookEntity);
}
/// <summary>
/// 更新
/// </summary>
/// <param name="addressBookEntity">实体</param>
/// <returns>影响行数</returns>
public int Update(BaseAddressBookEntity addressBookEntity)
{
int returnValue = 0;
SQLBuilder mySQLBuilder = new SQLBuilder(this.DbHelper);
mySQLBuilder.BeginUpdate(BaseAddressBookTable.TableName);
mySQLBuilder.SetValue(BaseAddressBookTable.FieldFullName, addressBookEntity.FullName);
mySQLBuilder.SetValue(BaseAddressBookTable.FieldCompanyName, addressBookEntity.CompanyName);
mySQLBuilder.SetValue(BaseAddressBookTable.FieldAdress, addressBookEntity.Adress);
mySQLBuilder.SetValue(BaseAddressBookTable.FieldDuty, addressBookEntity.Duty);
mySQLBuilder.SetValue(BaseAddressBookTable.FieldTelephone, addressBookEntity.Telephone);
mySQLBuilder.SetValue(BaseAddressBookTable.FieldMobile, addressBookEntity.Mobile);
mySQLBuilder.SetValue(BaseAddressBookTable.FieldMail, addressBookEntity.Mail);
mySQLBuilder.SetValue(BaseAddressBookTable.FieldRelation, addressBookEntity.Relation);
mySQLBuilder.SetValue(BaseAddressBookTable.FieldEnabled, addressBookEntity.Enabled);
mySQLBuilder.SetValue(BaseAddressBookTable.FieldDescription, addressBookEntity.Description);
mySQLBuilder.SetValue(BaseAddressBookTable.FieldModifyUserID, this.UserInfo.ID);
mySQLBuilder.SetDBNow(BaseAddressBookTable.FieldModifyDate);
mySQLBuilder.SetWhere(BaseAddressBookTable.FieldID, addressBookEntity.ID);
returnValue = mySQLBuilder.EndUpdate();
return(returnValue);
}
