/// <summary>
/// 获取输入的信息
/// </summary>
/// <returns>名片类</returns>
private BaseBusinessCardEntity GetEntity()
{
BaseBusinessCardEntity businessCardEntity = new BaseBusinessCardEntity();
// 这里提高主键产生速度
businessCardEntity.Id = System.Guid.NewGuid().ToString();
businessCardEntity.FullName = this.txtFullName.Text;
businessCardEntity.Title = this.txtTitle.Text;
businessCardEntity.Company = this.ucCompany.SelectedFullName;
businessCardEntity.Phone = this.txtPhone.Text;
businessCardEntity.Postalcode = this.txtPostalcode.Text;
businessCardEntity.Mobile = this.txtMobile.Text;
businessCardEntity.Address = this.txtAddress.Text;
businessCardEntity.Email = this.txtEmail.Text;
businessCardEntity.OfficePhone = this.txtOfficePhone.Text;
businessCardEntity.QQ = this.txtQQ.Text;
businessCardEntity.Fax = this.txtFax.Text;
businessCardEntity.Web = this.txtWeb.Text;
businessCardEntity.BankName = this.txtBankName.Text;
businessCardEntity.BankAccount = this.txtBankAccount.Text;
businessCardEntity.TaxAccount = this.txtTaxAccount.Text;
businessCardEntity.Personal = this.chkPersonal.Checked;
businessCardEntity.Description = this.txtDescription.Text;
return(businessCardEntity);
}
/// <summary>
/// 添加实体
/// </summary>
/// <param name="businessCardEntity">实体</param>
public string AddEntity(BaseBusinessCardEntity businessCardEntity)
{
string returnValue = string.Empty;
if (String.IsNullOrEmpty(businessCardEntity.Id) || String.IsNullOrEmpty(businessCardEntity.SortCode))
{
BaseSequenceManager sequenceManager = new BaseSequenceManager(DbHelper);
string sequence = sequenceManager.GetSequence(BaseBusinessCardTable.TableName);
if (String.IsNullOrEmpty(businessCardEntity.Id))
{
businessCardEntity.Id = sequence;
}
if (String.IsNullOrEmpty(businessCardEntity.SortCode))
{
businessCardEntity.SortCode = sequence;
}
}
SQLBuilder sqlBuilder = new SQLBuilder(DbHelper);
sqlBuilder.BeginInsert(this.CurrentTableName);
sqlBuilder.SetValue(BaseBusinessCardTable.FieldId, businessCardEntity.Id);
this.SetEntity(sqlBuilder, businessCardEntity);
sqlBuilder.SetValue(BaseBusinessCardTable.FieldCreateBy, UserInfo.RealName);
sqlBuilder.SetValue(BaseBusinessCardTable.FieldCreateUserId, UserInfo.Id);
sqlBuilder.SetDBNow(BaseBusinessCardTable.FieldCreateOn);
return(sqlBuilder.EndInsert() > 0 ? businessCardEntity.Id : string.Empty);
}
/// <summary>
/// 检查批量删除的输入的有效性
/// </summary>
/// <returns>允许批量删除</returns>
private bool CheckInputBatchDelete()
{
bool returnValue = false;
int selectedCount = 0;
BaseBusinessCardEntity businessCardEntity = new BaseBusinessCardEntity();
foreach (DataRowView DataRowView in this.DTBusinessCard.DefaultView)
{
DataRow dataRow = DataRowView.Row;
if (dataRow.RowState != DataRowState.Deleted)
{
if (dataRow[BaseBusinessLogic.SelectedColumn].ToString() == true.ToString())
{
businessCardEntity = new BaseBusinessCardEntity(dataRow);
// 有权限删除
if (this.permissionEditPublic || businessCardEntity.CreateUserId.Equals(UserInfo.Id))
{
selectedCount++;
}
else
{
// MessageBox.Show(AppMessage.MSG0024, AppMessage.MSG0000, MessageBoxButtons.OK, MessageBoxIcon.Information);
return(returnValue);
}
}
}
}
// 有记录被选中了
returnValue = selectedCount > 0;
if (!returnValue)
{
MessageBox.Show(AppMessage.MSG0024, AppMessage.MSG0000, MessageBoxButtons.OK, MessageBoxIcon.Information);
}
return(returnValue);
}
/// <summary>
/// 获取实体
/// </summary>
/// <param name="userInfo">用户</param>
/// <param name="id">主键</param>
/// <returns>数据表</returns>
public BaseBusinessCardEntity GetEntity(BaseUserInfo userInfo, string id)
{
DataTable dataTable = this.Get(userInfo, id);
BaseBusinessCardEntity businessCardEntity = new BaseBusinessCardEntity(dataTable);
return(businessCardEntity);
}
/// <summary>
/// 获取实体
/// </summary>
/// <param name="id">主键</param>
public BaseBusinessCardEntity GetEntity(string id)
{
DataTable dataTable = this.GetDataTableById(id);
BaseBusinessCardEntity businessCardEntity = new BaseBusinessCardEntity(dataTable);
return(businessCardEntity);
}
private void btnLikeAdd_Click(object sender, EventArgs e)
{
BaseBusinessCardEntity entity = GetEntity();
entity.Id = null;
FrmBusinessCardAdd frmBusinessCardAdd = new FrmBusinessCardAdd(entity);
frmBusinessCardAdd.ShowDialog();
}
/// <summary>
/// 加载窗体
/// </summary>
public override void FormOnLoad()
{
BusinessCardService businessCardService = new BusinessCardService();
this.BusinessCardEntity = businessCardService.GetEntity(UserInfo, this.EntityId);
// 显示内容
this.ShowEntity(this.BusinessCardEntity);
// 设置焦点
this.ActiveControl = this.txtFullName;
this.txtFullName.Focus();
}
/// <summary>
/// 更新实体
/// </summary>
/// <param name="businessCardEntity">实体</param>
public int UpdateEntity(BaseBusinessCardEntity businessCardEntity)
{
SQLBuilder sqlBuilder = new SQLBuilder(DbHelper);
sqlBuilder.BeginUpdate(this.CurrentTableName);
this.SetEntity(sqlBuilder, businessCardEntity);
sqlBuilder.SetValue(BaseBusinessCardTable.FieldModifiedBy, UserInfo.RealName);
sqlBuilder.SetValue(BaseBusinessCardTable.FieldModifiedUserId, UserInfo.Id);
sqlBuilder.SetDBNow(BaseBusinessCardTable.FieldModifiedOn);
sqlBuilder.SetWhere(BaseBusinessCardTable.FieldId, businessCardEntity.Id);
return(sqlBuilder.EndUpdate());
}
/// <summary>
/// 更新
/// </summary>
/// <param name="userInfo">用户</param>
/// <param name="businessCardEntity">实体</param>
/// <param name="statusCode">返回状态码</param>
/// <param name="statusMessage">返回状态信息</param>
/// <returns>影响行数</returns>
public int UpdateEntity(BaseUserInfo userInfo, BaseBusinessCardEntity businessCardEntity, out string statusCode, out string statusMessage)
{
// 写入调试信息
#if (DEBUG)
int milliStart = BaseBusinessLogic.StartDebug(userInfo, MethodBase.GetCurrentMethod());
#endif
statusCode = string.Empty;
statusMessage = string.Empty;
int returnValue = 0;
// 使用工厂模式 传入 数据库类型
IDbHelper dbHelper = null;
if (DbHelper.DbType == CurrentDbType.Access)
{
dbHelper = DbHelperFactory.GetHelper(DbHelper.DbType);
}
else
{
dbHelper = DbHelperFactory.GetHelper();
}
// IDbHelper dbHelper = DbHelperFactory.GetHelper();
try
{
dbHelper.Open(UserCenterDbConnection);
BaseBusinessCardManager businessCardManager = new BaseBusinessCardManager(dbHelper, userInfo);
// 编辑数据
returnValue = businessCardManager.Update(businessCardEntity);
// returnValue = businessCardManager.Update(businessCardEntity, out statusCode);
statusMessage = businessCardManager.GetStateMessage(statusCode);
BaseLogManager.Instance.Add(dbHelper, userInfo, MethodBase.GetCurrentMethod());
}
catch (Exception ex)
{
BaseExceptionManager.LogException(dbHelper, userInfo, ex);
throw ex;
}
finally
{
dbHelper.Close();
}
// 写入调试信息
#if (DEBUG)
BaseBusinessLogic.EndDebug(MethodBase.GetCurrentMethod(), milliStart);
#endif
return(returnValue);
}
/// <summary>
/// 批量保存
/// </summary>
/// <param name="userInfo">用户</param>
/// <param name="dataTable">数据表</param>
/// <returns>影响行数</returns>
public int BatchSave(BaseUserInfo userInfo, DataTable dataTable)
{
// 写入调试信息
#if (DEBUG)
int milliStart = BaseBusinessLogic.StartDebug(userInfo, MethodBase.GetCurrentMethod());
#endif
int returnValue = 0;
// 使用工厂模式 传入 数据库类型
IDbHelper dbHelper = null;
if (DbHelper.DbType == CurrentDbType.Access)
{
dbHelper = DbHelperFactory.GetHelper(DbHelper.DbType);
}
else
{
dbHelper = DbHelperFactory.GetHelper();
}
// IDbHelper dbHelper = DbHelperFactory.GetHelper();
try
{
dbHelper.Open(UserCenterDbConnection);
BaseBusinessCardManager businessCardManager = new BaseBusinessCardManager(dbHelper, userInfo);
BaseBusinessCardEntity businessCardEntity = null;
foreach (DataRow dataRow in dataTable.Rows)
{
businessCardEntity = new BaseBusinessCardEntity(dataRow);
returnValue += businessCardManager.Update(businessCardEntity);
}
BaseLogManager.Instance.Add(dbHelper, userInfo, MethodBase.GetCurrentMethod());
}
catch (Exception ex)
{
BaseExceptionManager.LogException(dbHelper, userInfo, ex);
throw ex;
}
finally
{
dbHelper.Close();
}
// 写入调试信息
#if (DEBUG)
BaseBusinessLogic.EndDebug(MethodBase.GetCurrentMethod(), milliStart);
#endif
return(returnValue);
}
/// <summary>
/// 显示内容
/// </summary>
private void ShowEntity(BaseBusinessCardEntity businessCardEntity)
{
this.txtFullName.Text = businessCardEntity.FullName;
this.txtTitle.Text = businessCardEntity.Title;
this.ucCompany.SelectedFullName = businessCardEntity.Company;
this.txtPhone.Text = businessCardEntity.Phone;
this.txtPostalcode.Text = businessCardEntity.Postalcode;
this.txtMobile.Text = businessCardEntity.Mobile;
this.txtAddress.Text = businessCardEntity.Address;
this.txtEmail.Text = businessCardEntity.Email;
this.txtOfficePhone.Text = businessCardEntity.OfficePhone;
this.txtQQ.Text = businessCardEntity.QQ;
this.txtFax.Text = businessCardEntity.Fax;
this.txtWeb.Text = businessCardEntity.Web;
this.txtBankName.Text = businessCardEntity.BankName;
this.txtBankAccount.Text = businessCardEntity.BankAccount;
this.txtTaxAccount.Text = businessCardEntity.TaxAccount;
this.chkPersonal.Checked = businessCardEntity.Personal;
this.txtDescription.Text = businessCardEntity.Description;
}
/// <summary>
/// 编辑
/// </summary>
public void Edit()
{
DataRow dataRow = BaseInterfaceLogic.GetDataGridViewEntity(this.grdBusinessCard);
BaseBusinessCardEntity businessCardEntity = new BaseBusinessCardEntity(dataRow);
// 有权限编辑
if (this.permissionEditPublic || businessCardEntity.CreateUserId.Equals(UserInfo.Id))
{
string id = BaseInterfaceLogic.GetDataGridViewEntityId(this.grdBusinessCard, BaseItemDetailsEntity.FieldId);
FrmBusinessCardEdit frmBusinessCardEdit = new FrmBusinessCardEdit(id);
if (frmBusinessCardEdit.ShowDialog() == DialogResult.OK)
{
// 获取列表
this.Search();
}
}
else
{
// 没有权限编辑公开的名片
}
}
/// <summary>
/// 设置实体
/// </summary>
/// <param name="businessCardEntity">实体</param>
private void SetEntity(SQLBuilder sqlBuilder, BaseBusinessCardEntity businessCardEntity)
{
sqlBuilder.SetValue(BaseBusinessCardTable.FieldFullName, businessCardEntity.FullName);
sqlBuilder.SetValue(BaseBusinessCardTable.FieldTitle, businessCardEntity.Title);
sqlBuilder.SetValue(BaseBusinessCardTable.FieldCompany, businessCardEntity.Company);
sqlBuilder.SetValue(BaseBusinessCardTable.FieldPhone, businessCardEntity.Phone);
sqlBuilder.SetValue(BaseBusinessCardTable.FieldPostalcode, businessCardEntity.Postalcode);
sqlBuilder.SetValue(BaseBusinessCardTable.FieldMobile, businessCardEntity.Mobile);
sqlBuilder.SetValue(BaseBusinessCardTable.FieldAddress, businessCardEntity.Address);
sqlBuilder.SetValue(BaseBusinessCardTable.FieldEmail, businessCardEntity.Email);
sqlBuilder.SetValue(BaseBusinessCardTable.FieldOfficePhone, businessCardEntity.OfficePhone);
sqlBuilder.SetValue(BaseBusinessCardTable.FieldQQ, businessCardEntity.QQ);
sqlBuilder.SetValue(BaseBusinessCardTable.FieldFax, businessCardEntity.Fax);
sqlBuilder.SetValue(BaseBusinessCardTable.FieldWeb, businessCardEntity.Web);
sqlBuilder.SetValue(BaseBusinessCardTable.FieldBankName, businessCardEntity.BankName);
sqlBuilder.SetValue(BaseBusinessCardTable.FieldBankAccount, businessCardEntity.BankAccount);
sqlBuilder.SetValue(BaseBusinessCardTable.FieldTaxAccount, businessCardEntity.TaxAccount);
sqlBuilder.SetValue(BaseBusinessCardTable.FieldPersonal, businessCardEntity.Personal ? 1:0);
sqlBuilder.SetValue(BaseBusinessCardTable.FieldSortCode, businessCardEntity.SortCode);
sqlBuilder.SetValue(BaseBusinessCardTable.FieldDescription, businessCardEntity.Description);
}
/// <summary>
/// 更新
/// </summary>
/// <param name="userInfo">用户</param>
/// <param name="dataTable">数据表</param>
/// <param name="statusCode">返回状态码</param>
/// <param name="statusMessage">返回状态信息</param>
/// <returns>影响行数</returns>
public int Update(BaseUserInfo userInfo, DataTable dataTable, out string statusCode, out string statusMessage)
{
BaseBusinessCardEntity businessCardEntity = new BaseBusinessCardEntity(dataTable);
return(this.UpdateEntity(userInfo, businessCardEntity, out statusCode, out statusMessage));
}
public FrmBusinessCardAdd(BaseBusinessCardEntity entity)
: this()
{
this.businessCardEntity = entity;
}
/// <summary>
/// 更新
/// </summary>
/// <param name="businessCardEntity">实体</param>
public int Update(BaseBusinessCardEntity businessCardEntity)
{
return(this.UpdateEntity(businessCardEntity));
}
/// <summary>
/// 添加
/// </summary>
/// <param name="businessCardEntity">实体</param>
public string Add(BaseBusinessCardEntity businessCardEntity)
{
return(this.AddEntity(businessCardEntity));
}