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(); }
public Model.History CopyTrackModel(Model.Tracking trackModel) { if (trackModel == null) { return(null); } Model.History model = new Model.History(); model.PART_ID = trackModel.PART_ID; model.SAPCODE = trackModel.SAPCODE; model.BATCH_NO = trackModel.BATCH_NO; model.DESCRIPTION = trackModel.DESCRIPTION; model.DEPARTMENT = trackModel.DEPARTMENT; model.START_WEIGHT = trackModel.START_WEIGHT; model.CURRENT_WEIGHT = trackModel.CURRENT_WEIGHT; model.CAPACITY = trackModel.CAPACITY; model.STATUS = trackModel.STATUS; model.EQUIP_ID = trackModel.EQUIP_ID; model.THAWING_DATETIME = trackModel.THAWING_DATETIME; model.READY_DATETIME = trackModel.READY_DATETIME; model.EXPIRY_DATETIME = trackModel.EXPIRY_DATETIME; model.MF_EXPIRY_DATE = trackModel.MF_EXPIRY_DATE; model.LOT_ID = trackModel.LOT_ID; model.DEVICE = trackModel.DEVICE; model.EMPTY_SYRINGE_WEIGHT = trackModel.EMPTY_SYRINGE_WEIGHT; model.USER_ID = trackModel.USER_ID; model.USER_NAME = trackModel.USER_NAME; model.ACTION = trackModel.ACTION; model.REMARKS = trackModel.REMARKS; model.UPDATED_TIME = trackModel.UPDATED_TIME; model.WEEK = trackModel.WEEK; model.MONTH = trackModel.MONTH; model.YEAR = trackModel.YEAR; model.LOCID = trackModel.LOCID; return(model); }
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 = "搅拌完成, 请取出后关闭或继续搅拌."; }
public SqlCommand UpdateCommand(Model.Tracking model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update Tracking set "); strSql.Append("SAPCODE=@SAPCODE,"); strSql.Append("BATCH_NO=@BATCH_NO,"); strSql.Append("DESCRIPTION=@DESCRIPTION,"); strSql.Append("DEPARTMENT=@DEPARTMENT,"); strSql.Append("START_WEIGHT=@START_WEIGHT,"); strSql.Append("CURRENT_WEIGHT=@CURRENT_WEIGHT,"); strSql.Append("CAPACITY=@CAPACITY,"); strSql.Append("STATUS=@STATUS,"); strSql.Append("EQUIP_ID=@EQUIP_ID,"); strSql.Append("LOCID=@LOCID,"); strSql.Append("THAWING_DATETIME=@THAWING_DATETIME,"); strSql.Append("READY_DATETIME=@READY_DATETIME,"); strSql.Append("EXPIRY_DATETIME=@EXPIRY_DATETIME,"); strSql.Append("MF_EXPIRY_DATE=@MF_EXPIRY_DATE,"); strSql.Append("LOT_ID=@LOT_ID,"); strSql.Append("DEVICE=@DEVICE,"); strSql.Append("EMPTY_SYRINGE_WEIGHT=@EMPTY_SYRINGE_WEIGHT,"); strSql.Append("USER_ID=@USER_ID,"); strSql.Append("USER_NAME=@USER_NAME,"); strSql.Append("ACTION=@ACTION,"); strSql.Append("REMARKS=@REMARKS,"); strSql.Append("UPDATED_TIME=@UPDATED_TIME,"); strSql.Append("WEEK=@WEEK,"); strSql.Append("MONTH=@MONTH,"); strSql.Append("YEAR=@YEAR"); strSql.Append(" where PART_ID=@PART_ID "); SqlParameter[] parameters = { new SqlParameter("@PART_ID", SqlDbType.VarChar, 50), new SqlParameter("@SAPCODE", SqlDbType.VarChar, 50), new SqlParameter("@BATCH_NO", SqlDbType.VarChar, 50), new SqlParameter("@DESCRIPTION", SqlDbType.VarChar, 100), new SqlParameter("@DEPARTMENT", SqlDbType.VarChar, 50), new SqlParameter("@START_WEIGHT", SqlDbType.Decimal, 5), new SqlParameter("@CURRENT_WEIGHT", SqlDbType.Decimal, 5), new SqlParameter("@CAPACITY", SqlDbType.Int, 4), new SqlParameter("@STATUS", SqlDbType.VarChar, 20), new SqlParameter("@EQUIP_ID", SqlDbType.VarChar, 20), new SqlParameter("@LOCID", SqlDbType.VarChar, 50), new SqlParameter("@THAWING_DATETIME", SqlDbType.DateTime), new SqlParameter("@READY_DATETIME", SqlDbType.DateTime), new SqlParameter("@EXPIRY_DATETIME", SqlDbType.DateTime), new SqlParameter("@MF_EXPIRY_DATE", SqlDbType.DateTime), new SqlParameter("@LOT_ID", SqlDbType.VarChar, 50), new SqlParameter("@DEVICE", SqlDbType.VarChar, 100), new SqlParameter("@EMPTY_SYRINGE_WEIGHT", SqlDbType.Decimal, 5), new SqlParameter("@USER_ID", SqlDbType.VarChar, 50), new SqlParameter("@USER_NAME", SqlDbType.VarChar, 50), new SqlParameter("@ACTION", SqlDbType.VarChar, 50), new SqlParameter("@REMARKS", SqlDbType.VarChar, 100), new SqlParameter("@UPDATED_TIME", SqlDbType.DateTime), new SqlParameter("@WEEK", SqlDbType.Int, 4), new SqlParameter("@MONTH", SqlDbType.Int, 4), new SqlParameter("@YEAR", SqlDbType.Int, 4) }; parameters[0].Value = model.PART_ID; parameters[1].Value = model.SAPCODE; parameters[2].Value = model.BATCH_NO; parameters[3].Value = model.DESCRIPTION; parameters[4].Value = model.DEPARTMENT; parameters[5].Value = model.START_WEIGHT; parameters[6].Value = model.CURRENT_WEIGHT; parameters[7].Value = model.CAPACITY; parameters[8].Value = model.STATUS; parameters[9].Value = model.EQUIP_ID; parameters[10].Value = model.LOCID; parameters[11].Value = model.THAWING_DATETIME; parameters[12].Value = model.READY_DATETIME; parameters[13].Value = model.EXPIRY_DATETIME; parameters[14].Value = model.MF_EXPIRY_DATE; parameters[15].Value = model.LOT_ID; parameters[16].Value = model.DEVICE; parameters[17].Value = model.EMPTY_SYRINGE_WEIGHT; parameters[18].Value = model.USER_ID; parameters[19].Value = model.USER_NAME; parameters[20].Value = model.ACTION; parameters[21].Value = model.REMARKS; parameters[22].Value = model.UPDATED_TIME; parameters[23].Value = model.WEEK; parameters[24].Value = model.MONTH; parameters[25].Value = model.YEAR; return(Common.DB.SqlDB.GenerateCommand(strSql.ToString(), parameters)); }
public SqlCommand AddCommand(Model.Tracking model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into Tracking("); strSql.Append("PART_ID,SAPCODE,BATCH_NO,DESCRIPTION,DEPARTMENT,START_WEIGHT,CURRENT_WEIGHT,CAPACITY,STATUS,EQUIP_ID,LOCID,THAWING_DATETIME,READY_DATETIME,EXPIRY_DATETIME,MF_EXPIRY_DATE,LOT_ID,DEVICE,EMPTY_SYRINGE_WEIGHT,USER_ID,USER_NAME,ACTION,REMARKS,UPDATED_TIME,WEEK,MONTH,YEAR)"); strSql.Append(" values ("); strSql.Append("@PART_ID,@SAPCODE,@BATCH_NO,@DESCRIPTION,@DEPARTMENT,@START_WEIGHT,@CURRENT_WEIGHT,@CAPACITY,@STATUS,@EQUIP_ID,@LOCID,@THAWING_DATETIME,@READY_DATETIME,@EXPIRY_DATETIME,@MF_EXPIRY_DATE,@LOT_ID,@DEVICE,@EMPTY_SYRINGE_WEIGHT,@USER_ID,@USER_NAME,@ACTION,@REMARKS,@UPDATED_TIME,@WEEK,@MONTH,@YEAR)"); SqlParameter[] parameters = { new SqlParameter("@PART_ID", SqlDbType.VarChar, 50), new SqlParameter("@SAPCODE", SqlDbType.VarChar, 50), new SqlParameter("@BATCH_NO", SqlDbType.VarChar, 50), new SqlParameter("@DESCRIPTION", SqlDbType.VarChar, 100), new SqlParameter("@DEPARTMENT", SqlDbType.VarChar, 50), new SqlParameter("@START_WEIGHT", SqlDbType.Decimal, 5), new SqlParameter("@CURRENT_WEIGHT", SqlDbType.Decimal, 5), new SqlParameter("@CAPACITY", SqlDbType.Int, 4), new SqlParameter("@STATUS", SqlDbType.VarChar, 20), new SqlParameter("@EQUIP_ID", SqlDbType.VarChar, 20), new SqlParameter("@LOCID", SqlDbType.VarChar, 50), new SqlParameter("@THAWING_DATETIME", SqlDbType.DateTime), new SqlParameter("@READY_DATETIME", SqlDbType.DateTime), new SqlParameter("@EXPIRY_DATETIME", SqlDbType.DateTime), new SqlParameter("@MF_EXPIRY_DATE", SqlDbType.DateTime), new SqlParameter("@LOT_ID", SqlDbType.VarChar, 50), new SqlParameter("@DEVICE", SqlDbType.VarChar, 100), new SqlParameter("@EMPTY_SYRINGE_WEIGHT", SqlDbType.Decimal, 5), new SqlParameter("@USER_ID", SqlDbType.VarChar, 50), new SqlParameter("@USER_NAME", SqlDbType.VarChar, 50), new SqlParameter("@ACTION", SqlDbType.VarChar, 50), new SqlParameter("@REMARKS", SqlDbType.VarChar, 100), new SqlParameter("@UPDATED_TIME", SqlDbType.DateTime), new SqlParameter("@WEEK", SqlDbType.Int, 4), new SqlParameter("@MONTH", SqlDbType.Int, 4), new SqlParameter("@YEAR", SqlDbType.Int, 4) }; parameters[0].Value = model.PART_ID; parameters[1].Value = model.SAPCODE; parameters[2].Value = model.BATCH_NO; parameters[3].Value = model.DESCRIPTION; parameters[4].Value = model.DEPARTMENT; parameters[5].Value = model.START_WEIGHT; parameters[6].Value = model.CURRENT_WEIGHT; parameters[7].Value = model.CAPACITY; parameters[8].Value = model.STATUS; parameters[9].Value = model.EQUIP_ID; parameters[10].Value = model.LOCID; parameters[11].Value = model.THAWING_DATETIME; parameters[12].Value = model.READY_DATETIME; parameters[13].Value = model.EXPIRY_DATETIME; parameters[14].Value = model.MF_EXPIRY_DATE; parameters[15].Value = model.LOT_ID; parameters[16].Value = model.DEVICE; parameters[17].Value = model.EMPTY_SYRINGE_WEIGHT; parameters[18].Value = model.USER_ID; parameters[19].Value = model.USER_NAME; parameters[20].Value = model.ACTION; parameters[21].Value = model.REMARKS; parameters[22].Value = model.UPDATED_TIME; parameters[23].Value = model.WEEK; parameters[24].Value = model.MONTH; parameters[25].Value = model.YEAR; return(Common.DB.SqlDB.GenerateCommand(strSql.ToString(), parameters)); }
/// <summary> /// 得到一个对象实体 /// </summary> public Model.Tracking DataRowToModel(DataRow row) { Model.Tracking model = new Model.Tracking(); if (row != null) { if (row["PART_ID"] != null) { model.PART_ID = row["PART_ID"].ToString(); } if (row["SAPCODE"] != null) { model.SAPCODE = row["SAPCODE"].ToString(); } if (row["BATCH_NO"] != null) { model.BATCH_NO = row["BATCH_NO"].ToString(); } if (row["DESCRIPTION"] != null) { model.DESCRIPTION = row["DESCRIPTION"].ToString(); } if (row["DEPARTMENT"] != null) { model.DEPARTMENT = row["DEPARTMENT"].ToString(); } if (row["START_WEIGHT"] != null && row["START_WEIGHT"].ToString() != "") { model.START_WEIGHT = decimal.Parse(row["START_WEIGHT"].ToString()); } if (row["CURRENT_WEIGHT"] != null && row["CURRENT_WEIGHT"].ToString() != "") { model.CURRENT_WEIGHT = decimal.Parse(row["CURRENT_WEIGHT"].ToString()); } if (row["CAPACITY"] != null && row["CAPACITY"].ToString() != "") { model.CAPACITY = int.Parse(row["CAPACITY"].ToString()); } if (row["STATUS"] != null) { model.STATUS = row["STATUS"].ToString(); } if (row["EQUIP_ID"] != null) { model.EQUIP_ID = row["EQUIP_ID"].ToString(); } if (row["LOCID"] != null) { model.LOCID = row["LOCID"].ToString(); } if (row["THAWING_DATETIME"] != null && row["THAWING_DATETIME"].ToString() != "") { model.THAWING_DATETIME = DateTime.Parse(row["THAWING_DATETIME"].ToString()); } if (row["READY_DATETIME"] != null && row["READY_DATETIME"].ToString() != "") { model.READY_DATETIME = DateTime.Parse(row["READY_DATETIME"].ToString()); } if (row["EXPIRY_DATETIME"] != null && row["EXPIRY_DATETIME"].ToString() != "") { model.EXPIRY_DATETIME = DateTime.Parse(row["EXPIRY_DATETIME"].ToString()); } if (row["MF_EXPIRY_DATE"] != null && row["MF_EXPIRY_DATE"].ToString() != "") { model.MF_EXPIRY_DATE = DateTime.Parse(row["MF_EXPIRY_DATE"].ToString()); } if (row["LOT_ID"] != null) { model.LOT_ID = row["LOT_ID"].ToString(); } if (row["DEVICE"] != null) { model.DEVICE = row["DEVICE"].ToString(); } if (row["EMPTY_SYRINGE_WEIGHT"] != null && row["EMPTY_SYRINGE_WEIGHT"].ToString() != "") { model.EMPTY_SYRINGE_WEIGHT = decimal.Parse(row["EMPTY_SYRINGE_WEIGHT"].ToString()); } if (row["USER_ID"] != null) { model.USER_ID = row["USER_ID"].ToString(); } if (row["USER_NAME"] != null) { model.USER_NAME = row["USER_NAME"].ToString(); } if (row["ACTION"] != null) { model.ACTION = row["ACTION"].ToString(); } if (row["REMARKS"] != null) { model.REMARKS = row["REMARKS"].ToString(); } if (row["UPDATED_TIME"] != null && row["UPDATED_TIME"].ToString() != "") { model.UPDATED_TIME = DateTime.Parse(row["UPDATED_TIME"].ToString()); } if (row["WEEK"] != null && row["WEEK"].ToString() != "") { model.WEEK = int.Parse(row["WEEK"].ToString()); } if (row["MONTH"] != null && row["MONTH"].ToString() != "") { model.MONTH = int.Parse(row["MONTH"].ToString()); } if (row["YEAR"] != null && row["YEAR"].ToString() != "") { model.YEAR = int.Parse(row["YEAR"].ToString()); } } return(model); }