/// <summary> /// 更新 /// </summary> /// <param name="incomingCallEntity">实体</param> /// <param name="statusCode">状态码</param> /// <returns>影响行数</returns> public int Update(IncomingCallEntity incomingCallEntity, out string statusCode) { int returnValue = 0; returnValue = this.UpdateEntity(incomingCallEntity); statusCode = returnValue == 0 ? StatusCode.ErrorDeleted.ToString() : StatusCode.OKUpdate.ToString(); return(returnValue); }
/// <summary> /// 设置实体 /// </summary> /// <param name="sqlBuilder"></param> /// <param name="incomingCallEntity">实体</param> private void SetEntity(SQLBuilder sqlBuilder, IncomingCallEntity incomingCallEntity) { sqlBuilder.SetValue(IncomingCallTable.FieldCustomerId, incomingCallEntity.CustomerId); sqlBuilder.SetValue(IncomingCallTable.FieldCustomerName, incomingCallEntity.CustomerName); sqlBuilder.SetValue(IncomingCallTable.FieldCallType, incomingCallEntity.CallType); sqlBuilder.SetValue(IncomingCallTable.FieldCallRecord, incomingCallEntity.CallRecord); sqlBuilder.SetValue(IncomingCallTable.FieldCallNumber, incomingCallEntity.CallNumber); sqlBuilder.SetValue(IncomingCallTable.FieldCallDate, incomingCallEntity.CallDate); sqlBuilder.SetValue(IncomingCallTable.FieldHandled, incomingCallEntity.Handled); sqlBuilder.SetValue(IncomingCallTable.FieldDescription, incomingCallEntity.Description); sqlBuilder.SetValue(IncomingCallTable.FieldDeleteMark, incomingCallEntity.DeleteMark); sqlBuilder.SetValue(IncomingCallTable.FieldEnabled, incomingCallEntity.Enabled); sqlBuilder.SetValue(IncomingCallTable.FieldSortCode, incomingCallEntity.SortCode); }
/// <summary> /// 更新实体 /// </summary> /// <param name="incomingCallEntity">实体</param> public int UpdateEntity(IncomingCallEntity incomingCallEntity) { SQLBuilder sqlBuilder = new SQLBuilder(DBProvider); sqlBuilder.BeginUpdate(this.CurrentTableName); this.SetEntity(sqlBuilder, incomingCallEntity); if (UserInfo != null) { sqlBuilder.SetValue(IncomingCallTable.FieldModifiedBy, UserInfo.RealName); sqlBuilder.SetValue(IncomingCallTable.FieldModifiedUserId, UserInfo.Id); } sqlBuilder.SetDBNow(IncomingCallTable.FieldModifiedOn); sqlBuilder.SetWhere(IncomingCallTable.FieldId, incomingCallEntity.Id); return(sqlBuilder.EndUpdate()); }
/// <summary> /// 绑定修改的数据 /// </summary> private void BindEditData() { if (!string.IsNullOrEmpty(this.EntityId)) { currentIncomingCallEntity = incomingCallService.GetEntity(base.UserInfo, this.EntityId); if (currentIncomingCallEntity == null) { return; } this.txtCallRecord.Text = currentIncomingCallEntity.CallRecord; this.txtCallNumber.Text = currentIncomingCallEntity.CallNumber; this.txtCustomerName.Text = currentIncomingCallEntity.CustomerName; this.txtCustomerName.SelectedValue = currentIncomingCallEntity.CustomerId; if (!string.IsNullOrEmpty(currentIncomingCallEntity.CallType.Trim())) { switch (currentIncomingCallEntity.CallType.Trim()) { case "销售机会": rbCallType1.Checked = true; break; case "售后服务": rbCallType2.Checked = true; break; case "投诉": rbCallType3.Checked = true; break; case "合作": rbCallType4.Checked = true; break; case "其他": rbCallType5.Checked = true; break; } } rbNotHandled.Checked = true; if (BusinessLogic.ConvertIntToBoolean(currentIncomingCallEntity.Handled)) { rbHandled.Checked = true; } this.dtCallDate.Text = BusinessLogic.ConvertToDateToString(currentIncomingCallEntity.CallDate == null ? string.Empty : currentIncomingCallEntity.CallDate.ToString()); this.txtDescription.Text = currentIncomingCallEntity.Description; } }
/// <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, IncomingCallEntity entity, out string statusCode, out string statusMessage) { int returnValue = 0; statusCode = string.Empty; using (IDbProvider rdiDbProvider = DbFactoryProvider.GetProvider(SystemInfo.RDIFrameworkDbType)) { try { rdiDbProvider.Open(RDIFrameworkDbConection); LogManager.Instance.Add(rdiDbProvider, userInfo, this.serviceName, "更新实体", MethodBase.GetCurrentMethod()); using (IDbProvider dbProvider = DbFactoryProvider.GetProvider(BusinessDbType)) { try { dbProvider.Open(BusinessDbConnection); IncomingCallManager manager = new IncomingCallManager(dbProvider, userInfo); returnValue = manager.Update(entity, out statusCode); statusMessage = manager.GetStateMessage(statusCode); } catch (Exception ex) { CiExceptionManager.LogException(rdiDbProvider, userInfo, ex); throw ex; } finally { dbProvider.Close(); } } } catch (Exception ex) { CiExceptionManager.LogException(rdiDbProvider, userInfo, ex); throw ex; } finally { rdiDbProvider.Close(); } } return(returnValue); }
/// <summary> /// 新增实体 /// </summary> /// <param name="userInfo">用户</param> /// <param name="entity">实体</param> /// <returns>主鍵</returns> public string Add(UserInfo userInfo, IncomingCallEntity entity) { string returnValue = string.Empty; using (IDbProvider rdiDbProvider = DbFactoryProvider.GetProvider(SystemInfo.RDIFrameworkDbType)) { try { rdiDbProvider.Open(RDIFrameworkDbConection); LogManager.Instance.Add(rdiDbProvider, userInfo, this.serviceName, "新增实体", MethodBase.GetCurrentMethod()); using (IDbProvider dbProvider = DbFactoryProvider.GetProvider(BusinessDbType)) { try { dbProvider.Open(BusinessDbConnection); IncomingCallManager manager = new IncomingCallManager(dbProvider, userInfo); returnValue = manager.AddEntity(entity); } catch (Exception ex) { CiExceptionManager.LogException(rdiDbProvider, userInfo, ex); throw ex; } finally { dbProvider.Close(); } } } catch (Exception ex) { CiExceptionManager.LogException(rdiDbProvider, userInfo, ex); throw ex; } finally { rdiDbProvider.Close(); } } return(returnValue); }
public override bool SaveEntity() { IncomingCallEntity entity = new IncomingCallEntity { CallRecord = this.txtCallRecord.Text.Trim(), CallNumber = this.txtCallNumber.Text.Trim(), CustomerName = this.txtCustomerName.Text.Trim(), CustomerId = BusinessLogic.ConvertToInt32(this.txtCustomerName.SelectedValue) }; string callType = string.Empty; callType = rbCallType1.Checked ? rbCallType1.Text : callType; callType = rbCallType2.Checked ? rbCallType2.Text : callType; callType = rbCallType3.Checked ? rbCallType3.Text : callType; callType = rbCallType4.Checked ? rbCallType4.Text : callType; callType = rbCallType5.Checked ? rbCallType5.Text : callType; entity.CallType = callType; entity.Handled = 0; if (rbHandled.Checked) { entity.Handled = 1; } entity.CallDate = BusinessLogic.ConvertToDateTime(dtCallDate.Text); entity.Description = this.txtDescription.Text.Trim(); string objectId = incomingCallService.Add(base.UserInfo, entity); if (objectId.Length > 0) { this.Changed = true; if (SystemInfo.ShowSuccessMsg) { MessageBoxHelper.ShowSuccessMsg("新增成功!"); return(true); } } else { MessageBoxHelper.ShowErrorMsg("新增失败!"); return(false); } return(true); }
/// <summary> /// 取得实体 /// </summary> /// <param name="userInfo">用户</param> /// <param name="id">主鍵</param> /// <returns>实体</returns> public IncomingCallEntity GetEntity(UserInfo userInfo, string id) { IncomingCallEntity entity = null; using (IDbProvider dbProvider = DbFactoryProvider.GetProvider(BusinessDbType)) { try { dbProvider.Open(BusinessDbConnection); IncomingCallManager manager = new IncomingCallManager(dbProvider, userInfo); entity = manager.GetEntity(id); } catch (Exception ex) { throw ex; } finally { dbProvider.Close(); } } return(entity); }
/// <summary> /// 添加 /// </summary> /// <param name="incomingCallEntity">实体</param> /// <returns>主键</returns> public string Add(IncomingCallEntity incomingCallEntity) { return(this.AddEntity(incomingCallEntity)); }
/// <summary> /// 添加实体 /// </summary> /// <param name="incomingCallEntity">实体</param> public string AddEntity(IncomingCallEntity incomingCallEntity) { string sequence = string.Empty; if (incomingCallEntity.SortCode == null || incomingCallEntity.SortCode == 0) { CiSequenceManager sequenceManager = new CiSequenceManager(DBProvider, this.Identity); sequence = sequenceManager.GetSequence(this.CurrentTableName); incomingCallEntity.SortCode = int.Parse(sequence); } SQLBuilder sqlBuilder = new SQLBuilder(DBProvider, this.Identity, this.ReturnId); sqlBuilder.BeginInsert(this.CurrentTableName, IncomingCallTable.FieldId); if (!this.Identity) { sqlBuilder.SetValue(IncomingCallTable.FieldId, incomingCallEntity.Id); } else { if (!this.ReturnId && (DBProvider.CurrentDbType == CurrentDbType.Oracle || DBProvider.CurrentDbType == CurrentDbType.DB2)) { if (DBProvider.CurrentDbType == CurrentDbType.Oracle) { sqlBuilder.SetFormula(IncomingCallTable.FieldId, "SEQ_" + this.CurrentTableName.ToUpper() + ".NEXTVAL "); } if (DBProvider.CurrentDbType == CurrentDbType.DB2) { sqlBuilder.SetFormula(IncomingCallTable.FieldId, "NEXT VALUE FOR SEQ_" + this.CurrentTableName.ToUpper()); } } else { if (this.Identity && (DBProvider.CurrentDbType == CurrentDbType.Oracle || DBProvider.CurrentDbType == CurrentDbType.DB2)) { if (incomingCallEntity.Id == null) { if (string.IsNullOrEmpty(sequence)) { CiSequenceManager sequenceManager = new CiSequenceManager(DBProvider, this.Identity); sequence = sequenceManager.GetSequence(this.CurrentTableName); } incomingCallEntity.Id = int.Parse(sequence); } sqlBuilder.SetValue(IncomingCallTable.FieldId, incomingCallEntity.Id); } } } this.SetEntity(sqlBuilder, incomingCallEntity); if (UserInfo != null) { sqlBuilder.SetValue(IncomingCallTable.FieldCreateUserId, UserInfo.Id); sqlBuilder.SetValue(IncomingCallTable.FieldCreateBy, UserInfo.RealName); } sqlBuilder.SetDBNow(IncomingCallTable.FieldCreateOn); if (UserInfo != null) { sqlBuilder.SetValue(IncomingCallTable.FieldModifiedBy, UserInfo.RealName); sqlBuilder.SetValue(IncomingCallTable.FieldModifiedUserId, UserInfo.Id); } sqlBuilder.SetDBNow(IncomingCallTable.FieldModifiedOn); if (this.Identity && (DBProvider.CurrentDbType == CurrentDbType.SqlServer || DBProvider.CurrentDbType == CurrentDbType.Access)) { sequence = sqlBuilder.EndInsert().ToString(); } else { sqlBuilder.EndInsert(); } return(sequence); }
/// <summary> /// 更新 /// </summary> /// <param name="incomingCallEntity">实体</param> public int Update(IncomingCallEntity incomingCallEntity) { return(this.UpdateEntity(incomingCallEntity)); }
/// <summary> /// 添加 /// </summary> /// <param name="incomingCallEntity">实体</param> /// <param name="identity">自增量方式</param> /// <param name="returnId">返回主键</param> /// <returns>主键</returns> public string Add(IncomingCallEntity incomingCallEntity, bool identity, bool returnId) { this.Identity = identity; this.ReturnId = returnId; return(this.AddEntity(incomingCallEntity)); }