//代码组管理删除操作 modi by chao.pang
public override bool Delete()
{
if (_codeCategoryKey != string.Empty)
{
//Call Remoting Service
try
{
IServerObjFactory factor = CallRemotingService.GetRemoteObject();
if (null != factor)
{
string msg = string.Empty;
DataSet dsReturn = factor.CreateIReasonCodeEngine().DeleteReasonCodeCategory(_codeCategoryKey);
msg = FanHai.Hemera.Share.Common.ReturnMessageUtils.GetServerReturnMessage(dsReturn);
if (msg != string.Empty)
{
MessageService.ShowError(msg);
return(false);
}
else
{
MessageService.ShowMessage("${res:Global.SuccessMessage}", "${res:Global.SystemInfo}");
}
}
}
catch (Exception)
{
}
finally
{
CallRemotingService.UnregisterChannel();
}
}
return(true);
}
/// <summary>
/// 获取原因代码类别。
/// </summary>
/// <param name="dtParam">
/// 包含查询参数的数据集对象。REASON_CODE_CATEGORY_NAME和REASON_CODE_CATEGORY_TYPE。
/// </param>
/// <returns>包含原因代码类别信息的数据集对象。</returns>
public DataTable GetReasonCodeCategory(DataTable dtParam)
{
DataSet dsReturn = new DataSet();
try
{
IServerObjFactory factor = CallRemotingService.GetRemoteObject();
dsReturn = factor.CreateIReasonCodeEngine().GetReasonCodeCategory(dtParam);
string msg = FanHai.Hemera.Share.Common.ReturnMessageUtils.GetServerReturnMessage(dsReturn);
if (msg != string.Empty)
{
_errorMsg = msg;
return(null);
}
}
catch (Exception ex)
{
_errorMsg = ex.Message;
return(null);
}
finally
{
CallRemotingService.UnregisterChannel();
}
return(dsReturn.Tables[0]);
}
/// <summary>
/// Send update data to server
/// </summary>
/// <returns>bool</returns>
public override bool Update()
{
if (IsDirty)
{
DataSet dataSet = new DataSet();
DataTable codeCategoryTable = DataTableHelper.CreateDataTableForUpdateBasicData(FMM_REASON_CODE_CATEGORY_FIELDS.DATABASE_TABLE_NAME);
foreach (string Key in this.DirtyList.Keys)
{
Dictionary <string, string> rowData = new Dictionary <string, string>()
{
{ COMMON_FIELDS.FIELD_COMMON_UPDATE_KEY, _codeCategoryKey },
{ COMMON_FIELDS.FIELD_COMMON_UPDATE_NAME, Key },
{ COMMON_FIELDS.FIELD_COMMON_UPDATE_OLD_VALUE, this.DirtyList[Key].FieldOriginalValue },
{ COMMON_FIELDS.FIELD_COMMON_UPDATE_NEW_VALUE, this.DirtyList[Key].FieldNewValue }
};
FanHai.Hemera.Utils.Common.Utils.AddRowDataToDataTable(ref codeCategoryTable, rowData);
}
if (codeCategoryTable.Rows.Count > 0)
{
dataSet.Tables.Add(codeCategoryTable);
}
try
{
string msg = string.Empty;
DataSet dsReturn = null;
IServerObjFactory factor = CallRemotingService.GetRemoteObject();
if (null != factor)
{
dsReturn = factor.CreateIReasonCodeEngine().ReasonCodeCategoryUpdate(dataSet);
msg = FanHai.Hemera.Share.Common.ReturnMessageUtils.GetServerReturnMessage(dsReturn);
if (msg != string.Empty)
{
MessageService.ShowError(msg);
return(false);
}
this.ResetDirtyList();
MessageService.ShowMessage("${res:Global.SuccessMessage}", "${res:Global.SystemInfo}");
}
}
catch (Exception ex)
{
MessageService.ShowError(ex);
}
finally
{
CallRemotingService.UnregisterChannel();
}
}
else
{
MessageService.ShowMessage("${res:Global.UpdateItemDataMessage}", "${res:Global.SystemInfo}");
}
return(true);
}
/// <summary>
/// 原因代码名称验证。
/// </summary>
/// <returns>true：通过；否则失败。</returns>
public bool ReasonCodeNameValidate()
{
try
{
IServerObjFactory factor = CallRemotingService.GetRemoteObject();
DataSet dsReturn = factor.CreateIReasonCodeEngine().GetReasonCode(this._codeType, this._codeName, this._codeClass);
string msg = ReturnMessageUtils.GetServerReturnMessage(dsReturn);
if (!string.IsNullOrEmpty(msg))
{
MessageService.ShowError(msg);
return(false);
}
if (dsReturn != null &&
dsReturn.Tables.Count > 0 &&
dsReturn.Tables[0].Rows.Count > 0)
{
return(false);
}
}
catch (Exception ex)
{
MessageService.ShowError(ex);
return(false);
}
finally
{
CallRemotingService.UnregisterChannel();
}
return(true);
}
/// <summary>
/// 保存按钮事件。
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btnSave_Click(object sender, EventArgs e)
{
if (MessageService.AskQuestion("${res:Global.EnsureSaveCurrentData}", "${res:Global.SystemInfo}"))
{//提示确定要保存吗
string msg = string.Empty;
DataSet dsReturn = new DataSet();
IServerObjFactory serverFactory = CallRemotingService.GetRemoteObject();
if (serverFactory != null)
{
if (categoryInsertTable.Rows.Count > 0)
{//存在数据
DataSet dsInsertData = new DataSet();
dsInsertData.Tables.Add(categoryInsertTable);
//添加操作
dsReturn = serverFactory.CreateIReasonCodeEngine().AddReasonCategory(dsInsertData);
msg = FanHai.Hemera.Share.Common.ReturnMessageUtils.GetServerReturnMessage(dsReturn);
if (msg != string.Empty)
{
MessageService.ShowError(msg);
}
}
if (categoryDeleteTable.Rows.Count > 0)
{//categoryDeleteTable存在数据
DataSet dsDeleteData = new DataSet();
dsDeleteData.Tables.Add(categoryDeleteTable);
//删除操作
dsReturn = serverFactory.CreateIReasonCodeEngine().DeleteReasonCategory(dsDeleteData);
msg = FanHai.Hemera.Share.Common.ReturnMessageUtils.GetServerReturnMessage(dsReturn);
if (msg != string.Empty)
{
MessageService.ShowError(msg);
}
}
if (msg == string.Empty)
{
//保存成功
MessageService.ShowMessage("${res:Global.SuccessMessage}", "${res:Global.SystemInfo}");
}
}
CallRemotingService.UnregisterChannel();
}
}
/// <summary>
/// Send insert data to server 新增代码组
/// </summary>
/// <returns>bool</returns>
public override bool Insert()
{
DataSet dataSet = new DataSet();
//Add basic data
DataTable codeCategoryTable = DataTableHelper.CreateDataTableForInsertCodeCategory();
//为新增数据做准备
Dictionary <string, string> dataRow = new Dictionary <string, string>()
{
{ FMM_REASON_CODE_CATEGORY_FIELDS.FIELD_REASON_CODE_CATEGORY_KEY, _codeCategoryKey },
{ FMM_REASON_CODE_CATEGORY_FIELDS.FIELD_REASON_CODE_CATEGORY_NAME, _codeCategoryName },
{ FMM_REASON_CODE_CATEGORY_FIELDS.FIELD_DESCRIPTIONS, _codeCategoryDescriptions },
{ FMM_REASON_CODE_CATEGORY_FIELDS.FIELD_REASON_CODE_CATEGORY_TYPE, _codeCategoryType },
{ FMM_REASON_CODE_CATEGORY_FIELDS.FIELD_EDITOR, PropertyService.Get(PROPERTY_FIELDS.USER_NAME) }
};
FanHai.Hemera.Utils.Common.Utils.AddRowDataToDataTable(ref codeCategoryTable, dataRow);
//将数据表添加到数据集中
dataSet.Tables.Add(codeCategoryTable);
try
{
int code = 0;
string msg = string.Empty;
DataSet dsReturn = null;
IServerObjFactory factor = CallRemotingService.GetRemoteObject();
if (null != factor)
{
//调用新增方法返回数据集
dsReturn = factor.CreateIReasonCodeEngine().ReasonCodeCategoryInsert(dataSet);
msg = FanHai.Hemera.Share.Common.ReturnMessageUtils.GetServerReturnMessage(dsReturn, ref code);
if (code == -1)
{
MessageService.ShowError(msg);
return(false);
}
this.ResetDirtyList();
//系统提示保存成功
MessageService.ShowMessage("${res:Global.SuccessMessage}", "${res:Global.SystemInfo}");
}
}
catch (Exception ex)
{
MessageService.ShowError(ex);
}
finally
{
CallRemotingService.UnregisterChannel();
}
return(true);
}
/// <summary>
/// 新增原因代码记录。
/// </summary>
/// <returns>true：成功；否则失败。</returns>
public override bool Insert()
{
DataSet dsParams = new DataSet();
DataTable dtCode = CommonUtils.CreateDataTable(new FMM_REASON_CODE_FIELDS());
DataRow drCode = dtCode.NewRow();
dtCode.Rows.Add(drCode);
drCode[FMM_REASON_CODE_FIELDS.FIELD_DESCRIPTIONS] = this._codeDescriptions;
drCode[FMM_REASON_CODE_FIELDS.FIELD_EDIT_TIME] = DBNull.Value;
drCode[FMM_REASON_CODE_FIELDS.FIELD_EDIT_TIMEZONE] = this.EditTimeZone;
drCode[FMM_REASON_CODE_FIELDS.FIELD_EDITOR] = this.Editor;
drCode[FMM_REASON_CODE_FIELDS.FIELD_REASON_CODE_CLASS] = this._codeClass;
drCode[FMM_REASON_CODE_FIELDS.FIELD_REASON_CODE_KEY] = this._codeKey;
drCode[FMM_REASON_CODE_FIELDS.FIELD_REASON_CODE_NAME] = this._codeName;
drCode[FMM_REASON_CODE_FIELDS.FIELD_REASON_CODE_TYPE] = this._codeType;
dsParams.Tables.Add(dtCode);
try
{
int code = 0;
string msg = string.Empty;
DataSet dsReturn = null;
IServerObjFactory factor = CallRemotingService.GetRemoteObject();
dsReturn = factor.CreateIReasonCodeEngine().ReasonCodeInsert(dsParams);
msg = FanHai.Hemera.Share.Common.ReturnMessageUtils.GetServerReturnMessage(dsReturn, ref code);
if (code == -1)
{
MessageService.ShowError(msg);
return(false);
}
this.ResetDirtyList();
}
catch (Exception ex)
{
MessageService.ShowError(ex);
}
finally
{
CallRemotingService.UnregisterChannel();
}
return(true);
}
/// <summary>
/// 绑定原因代码。
/// </summary>
public void ListCodeBind()
{
string msg = string.Empty;
DataSet dsReturn = new DataSet();
IServerObjFactory serverFactory = CallRemotingService.GetRemoteObject();
if (serverFactory != null)
{
dsReturn = serverFactory.CreateIReasonCodeEngine().GetReasonCodeNotExistCategory(categoryKey, categoryType);
msg = FanHai.Hemera.Share.Common.ReturnMessageUtils.GetServerReturnMessage(dsReturn);
if (msg != string.Empty)
{
MessageService.ShowError(msg);
}
else
{
lbxCode.DataSource = dsReturn.Tables[FMM_REASON_CODE_FIELDS.DATABASE_TABLE_NAME];
}
}
CallRemotingService.UnregisterChannel();
}
/// <summary>
/// Validate reason code category name exist or not
/// </summary>
public bool CodeCategoryNameValidate()
{
try
{
string msg = string.Empty;
DataSet dsReturn = null;
IServerObjFactory factor = CallRemotingService.GetRemoteObject();
if (null != factor)
{
dsReturn = factor.CreateIReasonCodeEngine().GetDistinctReasonCodeCategoryName();
msg = FanHai.Hemera.Share.Common.ReturnMessageUtils.GetServerReturnMessage(dsReturn);
if (msg != string.Empty)
{
MessageService.ShowError(msg);
}
else
{
foreach (DataRow dataRow in dsReturn.Tables[0].Rows)
{
if (_codeCategoryName == dataRow[FMM_REASON_CODE_CATEGORY_FIELDS.FIELD_REASON_CODE_CATEGORY_NAME].ToString())
{
return(false);
}
}
}
}
}
catch (Exception ex)
{
MessageService.ShowError(ex);
}
finally
{
CallRemotingService.UnregisterChannel();
}
return(true);
}
/// <summary>
/// gvUdaList_CustomRowCellEdit
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void gvUdaList_CustomRowCellEdit(object sender, DevExpress.XtraGrid.Views.Grid.CustomRowCellEditEventArgs e)
{
if (e.RowHandle >= 0)
{
string attributeDataType = gridUDAsView.GetRowCellValue(e.RowHandle, COLUMN_ATTRIBUTE_DATA_TYPE).ToString();
string attributeName = gridUDAsView.GetRowCellValue(e.RowHandle, COLUMN_ATTRIBUTE_NAME).ToString();
if (attributeDataType == string.Empty)
{
return;
}
AttributeDataType dateType = (AttributeDataType)Convert.ToInt32(attributeDataType);
switch (dateType)
{
case AttributeDataType.DATE:
RepositoryItemDateEdit dateEdit = new RepositoryItemDateEdit();
dateEdit.DisplayFormat.FormatString = "yyyy-MM-dd";
dateEdit.EditMask = "yyyy-MM-dd";
e.RepositoryItem = dateEdit;
break;
case AttributeDataType.DATETIME:
RepositoryItemDateEdit dateEditTime = new RepositoryItemDateEdit();
dateEditTime.Properties.VistaDisplayMode = DevExpress.Utils.DefaultBoolean.True;
dateEditTime.Properties.VistaEditTime = DevExpress.Utils.DefaultBoolean.True;
dateEditTime.VistaTimeProperties.DisplayFormat.FormatString = "yyyy-MM-dd HH:mm:ss";
dateEditTime.VistaTimeProperties.DisplayFormat.FormatType = DevExpress.Utils.FormatType.DateTime;
dateEditTime.VistaTimeProperties.EditFormat.FormatString = "yyyy-MM-dd HH:mm:ss";
dateEditTime.VistaTimeProperties.EditFormat.FormatType = DevExpress.Utils.FormatType.DateTime;
e.RepositoryItem = dateEditTime;
break;
case AttributeDataType.BOOLEAN:
RepositoryItemComboBox cmbBoolean = new RepositoryItemComboBox();
cmbBoolean.Items.Add("true");
cmbBoolean.Items.Add("false");
cmbBoolean.TextEditStyle = TextEditStyles.DisableTextEditor;
e.RepositoryItem = cmbBoolean;
break;
case AttributeDataType.LINKED:
if (attributeName == "OnLineStore")
{
RepositoryItemCheckedComboBoxEdit cmbLinked = new RepositoryItemCheckedComboBoxEdit();
DataTable storeTable = _crmAttr.GetStoreName();
storeTable.DefaultView.RowFilter = "STORE_TYPE=0"; //只保留返工类型的线上仓。
foreach (DataRowView dataRow in storeTable.DefaultView)
{
cmbLinked.Items.Add(dataRow[WST_STORE_FIELDS.FIELD_STORE_NAME]);
}
cmbLinked.TextEditStyle = TextEditStyles.DisableTextEditor;
e.RepositoryItem = cmbLinked;
}
else if (attributeName == COMMON_NAMES.LINKED_ITEM_EDC)
{
RepositoryItemComboBox comboBox = new RepositoryItemComboBox();
DataTable edcTable = _crmAttr.GetEDC();
foreach (DataRow dataRow in edcTable.Rows)
{
comboBox.Items.Add(dataRow[EDC_MAIN_FIELDS.FIELD_EDC_NAME]);
}
comboBox.TextEditStyle = TextEditStyles.DisableTextEditor;
e.RepositoryItem = comboBox;
}
else if (attributeName == "FutureHold" || attributeName == "DependSampStep")
{
try
{
RepositoryItemComboBox cbFutureHold = new RepositoryItemComboBox();
IServerObjFactory factor = CallRemotingService.GetRemoteObject();
DataSet dsReturn = factor.CreateIOperationEngine().GetMaxVerOperation(null);
string msg = FanHai.Hemera.Share.Common.ReturnMessageUtils.GetServerReturnMessage(dsReturn);
if (msg == string.Empty)
{
if (dsReturn != null && dsReturn.Tables.Count > 0 && dsReturn.Tables.Contains(POR_ROUTE_OPERATION_VER_FIELDS.DATABASE_TABLE_NAME))
{
DataTable operationTable = dsReturn.Tables[POR_ROUTE_OPERATION_VER_FIELDS.DATABASE_TABLE_NAME];
foreach (DataRow dataRow in operationTable.Rows)
{
cbFutureHold.Items.Add(dataRow[POR_ROUTE_OPERATION_VER_FIELDS.FIELD_ROUTE_OPERATION_NAME].ToString());
}
cbFutureHold.TextEditStyle = TextEditStyles.DisableTextEditor;
e.RepositoryItem = cbFutureHold;
}
}
else
{
throw new Exception(msg);
}
}
catch (Exception ex)
{
MessageService.ShowError(ex.Message);
}
finally
{
CallRemotingService.UnregisterChannel();
}
}
else if (attributeName == "ReturnCode")
{
try
{
RepositoryItemComboBox cbResonCode = new RepositoryItemComboBox();
IServerObjFactory factor = CallRemotingService.GetRemoteObject();
DataSet _dataDsFrom = new DataSet();
Hashtable _hsTable = new Hashtable();
_hsTable.Add("REASON_CODE_CATEGORY_TYPE", "TK");
DataTable _dtTable = FanHai.Hemera.Share.Common.CommonUtils.ParseToDataTable(_hsTable);
_dtTable.TableName = TRANS_TABLES.TABLE_MAIN_DATA;
_dataDsFrom.Tables.Add(_dtTable);
//get return dataset
DataSet dsReturn = factor.CreateIReasonCodeEngine().GetReasonCodeByNameAndType(_dataDsFrom);
string msg = FanHai.Hemera.Share.Common.ReturnMessageUtils.GetServerReturnMessage(dsReturn);
if (msg == string.Empty)
{
if (dsReturn != null && dsReturn.Tables.Count > 0 && dsReturn.Tables.Contains(FMM_REASON_CODE_CATEGORY_FIELDS.DATABASE_TABLE_NAME))
{
DataTable operationTable = dsReturn.Tables[FMM_REASON_CODE_CATEGORY_FIELDS.DATABASE_TABLE_NAME];
foreach (DataRow dataRow in operationTable.Rows)
{
cbResonCode.Items.Add(dataRow[FMM_REASON_CODE_CATEGORY_FIELDS.FIELD_REASON_CODE_CATEGORY_NAME].ToString());
}
cbResonCode.TextEditStyle = TextEditStyles.DisableTextEditor;
e.RepositoryItem = cbResonCode;
}
}
else
{
throw new Exception(msg);
}
}
catch (Exception ex)
{
MessageService.ShowError(ex.Message);
}
finally
{
CallRemotingService.UnregisterChannel();
}
}
break;
default:
break;
}
}
}
