/// <summary>
/// 绑定数据到年份和月份控件
/// </summary>
private void BindDataToControl()
{
//获取年份
#region get years
DataSet dataSetBackAll = new DataSet(); //all data to receive
//UnregisterChannel
CallRemotingService.UnregisterChannel();
//get server object factory 远程调用技术
IServerObjFactory iServerObjFactory = CallRemotingService.GetRemoteObject();
//get result of excute sql 获取年份的数据参数值为basic_year
dataSetBackAll = iServerObjFactory.CreateIShift().GetLookUpEditData("Basic_Year");
lueYear.Properties.DisplayMember = "CODE";
lueYear.Properties.ValueMember = "CODE";
//返回的第一张数据表绑定
lueYear.Properties.DataSource = dataSetBackAll.Tables[0];
#endregion
//获取月份
#region get basic shift
//远程调用技术传入参数basic_shift
dataSetBackAll = iServerObjFactory.CreateIShift().GetLookUpEditData("Basic_Shift");
//返回的表的行数为大于0表示存在数据
if (dataSetBackAll.Tables.Count > 0)
{
for (int i = 0; i < dataSetBackAll.Tables[0].Rows.Count; i++)
{
//数据绑定到下拉列表中
cbShift.Items.Add(dataSetBackAll.Tables[0].Rows[i]["CODE"].ToString());
}
}
this.cbShift.Properties.TextEditStyle = DevExpress.XtraEditors.Controls.TextEditStyles.Standard;
#endregion
//获取排班计划
#region get Schedules
DataSet dsSchedule = new DataSet();
_schedule = new Schedule();
//调用SearchSchedule方法获取排班计划
dsSchedule = _schedule.SearchSchedule();
if (dsSchedule.Tables.Count > 0)
{
//数据绑定 到下拉列表中
lueSchedule.Properties.DataSource = dsSchedule.Tables[0];
lueSchedule.Properties.DisplayMember = CAL_SCHEDULE.FIELD_SCHEDULE_NAME;
lueSchedule.Properties.ValueMember = CAL_SCHEDULE.FIELD_SCHEDULE_KEY;
}
#endregion
}
public override bool Update()
{
//if (IsDirty)
//{
DataSet dataSet = new DataSet();
if (this.DirtyList.Count > 1)
{
DataTable shiftTable = DataTableHelper.CreateDataTableForUpdateBasicData(CAL_SHIFT.DATABASE_TABLE_NAME);
foreach (string Key in this.DirtyList.Keys)
{
Dictionary <string, string> rowData = new Dictionary <string, string>()
{
{ COMMON_FIELDS.FIELD_COMMON_UPDATE_KEY, _shiftKey },
{ 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 shiftTable, rowData);
}
if (shiftTable.Rows.Count > 0)
{
dataSet.Tables.Add(shiftTable);
}
try
{
DataSet dsReturn = null;
IServerObjFactory serverFactory = CallRemotingService.GetRemoteObject();
if (null != serverFactory)
{
dsReturn = serverFactory.CreateIShift().UpdateShift(dataSet);
_errorMsg = FanHai.Hemera.Share.Common.ReturnMessageUtils.GetServerReturnMessage(dsReturn);
if (_errorMsg != "")
{
return(false);
}
}
}
catch (Exception ex)
{
_errorMsg = ex.Message;
}
finally
{
CallRemotingService.UnregisterChannel();
}
}
else
{
_errorMsg = "${res:FanHai.Hemera.Addins.FMM.Msg.UpdateError}";
}
//}
//else
//{
// _errorMsg = "${res:FanHai.Hemera.Addins.FMM.Msg.UpdateError}";
//}
return(true);
}
public override bool Insert()
{
DataSet dataSet = new DataSet();
DataTable shiftTable = CAL_SHIFT.CreateDataTable();
//准备插入到数据库中的数据。 modi by chao.pang
Dictionary <string, string> dataRow = new Dictionary <string, string>()
{
{ CAL_SHIFT.FIELD_SHIFT_KEY, _shiftKey },
{ CAL_SHIFT.FIELD_SHIFT_NAME, _shiftName },
{ CAL_SHIFT.FIELD_DESCRIPTIONS, _descriptions },
{ CAL_SHIFT.FIELD_START_TIME, _starTime },
{ CAL_SHIFT.FIELD_END_TIME, _endTime },
{ CAL_SHIFT.FIELD_OVER_DAY, _overDay },
{ CAL_SHIFT.FIELD_CREATOR, Creator },
{ CAL_SHIFT.FIELD_CREATE_TIMEZONE, CreateTimeZone },
{ CAL_SHIFT.FIELD_EDITOR, Creator },
{ CAL_SHIFT.FIELD_EDIT_TIMEZONE, CreateTimeZone },
{ CAL_SCHEDULE.FIELD_SCHEDULE_KEY, _scheduleKey }
};
FanHai.Hemera.Utils.Common.Utils.AddRowDataToDataTable(ref shiftTable, dataRow);
//为远程调用函数准备参数。 modi by chao.Pang
dataSet.Tables.Add(shiftTable);
try
{
DataSet dsReturn = null;
IServerObjFactory serverFactory = CallRemotingService.GetRemoteObject();
if (null != serverFactory)
{
//远程调用进行添加操作 modi by chao.pang
dsReturn = serverFactory.CreateIShift().AddShift(dataSet);
_errorMsg = FanHai.Hemera.Share.Common.ReturnMessageUtils.GetServerReturnMessage(dsReturn);
if (_errorMsg != "")
{
return(false);
}
else
{
this.ResetDirtyList();
}
}
}
catch (Exception ex)
{
_errorMsg = ex.Message;
}
finally
{
CallRemotingService.UnregisterChannel();
}
return(true);
}
/// <summary>
/// Bind data to LookUpEdit
/// </summary>
private void BindDataToLookUpEdit()
{
DataSet dataSetBackAll = new DataSet(); //all data to receive
//UnregisterChannel
CallRemotingService.UnregisterChannel();
//get server object factory
IServerObjFactory iServerObjFactory = CallRemotingService.GetRemoteObject();
//get result of excute sql
dataSetBackAll = iServerObjFactory.CreateIShift().GetLookUpEditData("Shift_Time_Type");
lueStartTime.Properties.DisplayMember = "CODE";
lueStartTime.Properties.ValueMember = "CODE";
lueStartTime.Properties.DataSource = dataSetBackAll.Tables[0];
//lueStartTime.ItemIndex = 0;
lueEndTime.Properties.DisplayMember = "CODE";
lueEndTime.Properties.ValueMember = "CODE";
lueEndTime.Properties.DataSource = dataSetBackAll.Tables[0];
//lueEndTime.ItemIndex = 0;
}
public void DeleteShift()
{
DataSet dsReturn = new DataSet();
try
{
IServerObjFactory serverFactory = CallRemotingService.GetRemoteObject();
if (null != serverFactory)
{
dsReturn = serverFactory.CreateIShift().DeleteShift(_scheduleKey, _shiftKey);
_errorMsg = FanHai.Hemera.Share.Common.ReturnMessageUtils.GetServerReturnMessage(dsReturn);
}
}
catch (Exception ex)
{
_errorMsg = ex.Message;
}
finally
{
CallRemotingService.UnregisterChannel();
}
}
