public void validation()
{
string partID = this.txt_partID_input.Text;
if (string.IsNullOrEmpty(partID))
{
MessageBox.Show("Part ID can not be empty!");
this.txt_partID.Focus();
return;
}
//查询tracking
BLL.Tracking trackBLL = new BLL.Tracking();
Model.Tracking trackModel = trackBLL.GetModel(partID);
if (trackModel == null || trackModel.STATUS != StaticRes.Global.Status.PendingMix)
{
MessageBoxResult result = MessageBox.Show("This epoxy is not got from EMS, are you still need to mix?", "Warning", MessageBoxButton.YesNo, MessageBoxImage.Question);
if (result == MessageBoxResult.No || result == MessageBoxResult.Cancel || result == MessageBoxResult.None)
{
return;
}
}
else
{
this.txt_partID.Text = trackModel.PART_ID;
this.txt_description.Text = trackModel.DEPARTMENT;
this.txt_thawingTime.Text = trackModel.THAWING_DATETIME.Value.ToString("yyyy-MM-dd HH:mm:ss");
this.txt_readyTime.Text = trackModel.READY_DATETIME.Value.ToString("yyyy-MM-dd HH:mm:ss");
this.txt_expiryTime.Text = trackModel.EXPIRY_DATETIME.Value.ToString("yyyy-MM-dd HH:mm:ss");
this.txt_currentWeight.Text = trackModel.CURRENT_WEIGHT.ToString();
this.txt_capacity.Text = trackModel.CAPACITY.ToString();
this.txt_emptySyringeWeight.Text = trackModel.EMPTY_SYRINGE_WEIGHT.ToString();
}
this.txt_partID_input.Background = System.Windows.Media.Brushes.White;
this.btn_startMix.IsEnabled = true;
this.btn_startMix.Focus();
}
private bool Update(Model.Tracking trackModel, Model.History hisModel, Model.MixHistory mixModel)
{
BLL.MixHistory mixBLL = new BLL.MixHistory();
BLL.Tracking trackBLL = new BLL.Tracking();
BLL.History hisBLL = new BLL.History();
List <SqlCommand> cmdList = new List <SqlCommand>();
if (trackModel != null)
{
cmdList.Add(trackBLL.UpdateCommand(trackModel));
}
if (hisModel != null)
{
cmdList.Add(hisBLL.AddCommand(hisModel));
}
cmdList.Add(mixBLL.AddCommand(mixModel));
return(Common.DB.SqlDB.SetData_Rollback(cmdList, Common.DB.Connection.SqlServer.EMS));
}
private void BackgroundWorker_RunWorkerCompleted(object sender, RunWorkerCompletedEventArgs e)
{
//检测 是否把epoxy拿了出来.
//bool isMaterialIn = Hardware.IO_LIST.Input.X207_Mix_Material_In();
//while (isMaterialIn)
//{
// MessageBox.Show("Mixing complete, please open door and take out epoxy!");
// //重新检下测感应器状态.
// isMaterialIn = Hardware.IO_LIST.Input.X207_Mix_Material_In();
//}
//更新数据库
Model.MixHistory mixModel = new Model.MixHistory();
mixModel.PART_ID = this.txt_partID_input.Text;
mixModel.MIX_TIME = decimal.Parse(mixTime.ToString());
mixModel.MIX_DATETIME = DateTime.Now;
mixModel.MIX_BY = this.txt_userID.Text;
mixModel.REMARK = "";
BLL.Tracking trackBLL = new BLL.Tracking();
Model.Tracking trackModel = trackBLL.GetModel(this.txt_partID.Text);
if (trackModel != null)
{
trackModel.STATUS = StaticRes.Global.Status.Unload;
trackModel.UPDATED_TIME = DateTime.Now;
trackModel.ACTION = "Mix";
}
BLL.History hisBLL = new BLL.History();
Model.History hisModel = hisBLL.CopyTrackModel(trackModel);
if (!Update(trackModel, hisModel, mixModel))
{
MessageBox.Show("Update database fail!");
Common.Reports.LogFile.Log("[Mix] [BackgroundWorker_RunWorkerCompleted] - Update database fail partID:" + this.txt_partID.Text);
}
//init 变量
onGoing = false;
runningTime = 0;
this.pb.Value = 0;
//init ui
InitMaterialInfo();
this.txt_partID_input.Text = "";
this.txt_partID_input.IsEnabled = true;
this.txt_partID_input.Focus();
this.txt_partID_input.Background = StaticRes.ColorBrushes.Linear_Green;
ShowWindow();
this.txt_Msg.Text = "搅拌完成, 请取出后关闭或继续搅拌.";
}
