private void InitBindings(SFITrackNum track, CBXAgent agent)
{
mvvmContext1.ViewModelType = typeof(CheckPointLogViewModel);
var fluentAPI = mvvmContext1.OfType <CheckPointLogViewModel>();
fluentAPI.ViewModel.SFITrackNum = track;
fluentAPI.ViewModel.CBXAgent = agent;
fluentAPI.SetBinding(lblMapId, lbl => lbl.Text, x => x.SFITrackNum.int_Mappingid, x => { return($"数据编号：{x}"); });
fluentAPI.SetBinding(lblOrderNo, lbl => lbl.Text, x => x.SFITrackNum.vchar_SFInum, x => { return($"SFI单号：{x}"); });
fluentAPI.SetBinding(lblAgentNo, lbl => lbl.Text, x => x.SFITrackNum.vchar_AGnum, x => { return($"供应商单号：{x}"); });
fluentAPI.SetBinding(lblAgentName, lbl => lbl.Text, x => x.CBXAgent.Agname, x => { return($"供应商：{x}"); });
fluentAPI.SetBinding(txtRecordStr, x => x.EditValue, x => x.RecordStr);
fluentAPI.SetBinding(gridControl1, gv => gv.DataSource, x => x.TrackRecords);
fluentAPI.SetBinding(gridControl2, gv => gv.DataSource, x => x.TrackRecordLogs);
fluentAPI.WithEvent <ColumnView, FocusedRowObjectChangedEventArgs>(gridView1, "FocusedRowObjectChanged")
.SetBinding(x => x.SelectedTrackRecord,
args => args.Row as TrackRecord,
(gView, entity) => gView.FocusedRowHandle = gView.FindRow(entity));
fluentAPI.BindCommand(btnDelete, x => x.DeleteTrackRecord());
fluentAPI.BindCommand(btnSubmit, x => x.AddTrackRecord());
fluentAPI.BindCommand(btnRefresh, x => x.RefreshLogs(null), x => splashScreenManager1);
}
public CheckPointLog(SFITrackNum track, CBXAgent agent)
{
InitializeComponent();
if (!DesignMode)
{
splashScreenManager1.ShowWaitForm();
InitBindings(track, agent);
splashScreenManager1.CloseWaitForm();
}
}
private string WriteServerLog(SFITrackNum track, string result, string error)
{
DynamicParameters p = new DynamicParameters();
p.Add("@type", "G", DbType.String);
p.Add("@MappingID", track.int_Mappingid, DbType.Int32);
p.Add("@result", result, DbType.String);
if (!string.IsNullOrWhiteSpace(error))
{
p.Add("@error", error, DbType.String);
}
p.Add("@message", null, DbType.String, ParameterDirection.ReturnValue);
return(SQLHelper.ExecuteStoredProcedure <string>(Constants.sp_Logupdate, p, "@message"));
}
private string UpdateTrackRecord(SFITrackNum track, TrackRecord record)
{
DynamicParameters p = new DynamicParameters();
p.Add("@MappingID", track.int_Mappingid, DbType.Int32);
p.Add("@AGid", track.int_AGid, DbType.Int32);
p.Add("@SFInumber", track.vchar_SFInum, DbType.String);
p.Add("@AGnumber", track.vchar_AGnum, DbType.String);
p.Add("@dttm", record.dttm_Record_Dttm, DbType.DateTime);
p.Add("@Description", record.nvchar_Description, DbType.String);
p.Add("@DescriptionLocal", record.nvchar_Description_Local, DbType.String);
p.Add("@city", record.nvchar_City, DbType.String);
p.Add("@code", $"{record.dttm_Record_Dttm.ToString("yyyyMMddhhmmss")}_{track.int_Mappingid}", DbType.String);
p.Add("@message", null, DbType.String, ParameterDirection.ReturnValue);
return(SQLHelper.ExecuteStoredProcedure <string>(Constants.sp_RecordUpdate, p, "@message"));
}
