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