private bool UpdateDatabasebyChange(Common.Model.MouldingViDefectTracking_Model objViDef)
{
bool result = false;
try
{
string txt = this.Name.Replace("ubct123", "-").Replace("ubct1680", " ");;
string[] _partNumber = txt.Split('_');
DateTime dTime = DateTime.Now;
List <System.Data.SqlClient.SqlCommand> lSqlCmd = new List <System.Data.SqlClient.SqlCommand>();
//database update
Common.BLL.MouldingViDefectTracking_BLL bllViDef = new Common.BLL.MouldingViDefectTracking_BLL();
objViDef.lastUpdatedTime = dTime;
objViDef.stopTime = dTime;
lSqlCmd.Add(bllViDef.UpdateCommandbypartNubmer(objViDef, _partNumber[2].ToString())); // by trackingID + DefectCodeID
objViDef = bllViDef.GetModelList_ByDayShiftPartMachineForDefectTracking(objViDef.day, objViDef.shift, _partNumber[2].ToString(), objViDef.machineID, objViDef.defectCode, objViDef);
Common.BLL.MouldingViDefectHistory_BLL bllViDefHis = new Common.BLL.MouldingViDefectHistory_BLL();
lSqlCmd.Add(bllViDefHis.AddCommand(bllViDefHis.CopyObj(objViDef)));
int TotalRejQty = bllViDef.getTotalRejQty_By_TrackingID(objViDef.trackingID) + _Count; // must add 1 bucause the defect record is not updated
Common.BLL.MouldingViTracking_BLL bllViTrk = new Common.BLL.MouldingViTracking_BLL();
Common.Model.MouldingViTracking_Model objViTck = new Common.Model.MouldingViTracking_Model();
objViTck = bllViTrk.GetModel_ByTrackingID(objViDef.trackingID);
if (objViTck == null)
{
return(false);
}
objViTck.lastUpdatedTime = dTime;
objViTck.rejectQty = TotalRejQty;
objViTck.acceptQty = objViTck.acceptQty - _Count;
lSqlCmd.Add(bllViTrk.UpdateCommandbyTrackingID(objViTck)); //note: update data base on ID
Common.BLL.MouldingViHistory_BLL bllViHis = new Common.BLL.MouldingViHistory_BLL();
lSqlCmd.Add(bllViHis.AddCommand(bllViHis.CopyObj(objViTck)));
result = DBHelp.SqlDB.SetData_Rollback(lSqlCmd);
_Count = 0;
StaticRes.Global._isUsingObjCurVi = false;
}
catch (Exception ex)
{
StaticRes.Global._isUsingObjCurVi = false;
throw;
}
return(result);
}
public bool refreshShiftData(Common.Model.MouldingViDefectTracking_Model objViDef)
{
bool result = false;
try
{
string txt = this.Name.Replace("ubct123", "-").Replace("ubct1680", " ");
string[] _partNumber = txt.Split('_');
Common.BLL.MouldingViDefectTracking_BLL bllViDef = new Common.BLL.MouldingViDefectTracking_BLL();
Common.Model.MouldingViDefectTracking_Model _flagobjViDef = new Common.Model.MouldingViDefectTracking_Model();
_flagobjViDef = bllViDef.GetModelList_ByDayShiftPartMachineForDefectTracking(objViDef.day, objViDef.shift, _partNumber[2].ToString(), objViDef.machineID, objViDef.defectCode, objViDef);
this.DefectQTY01 = int.Parse((_flagobjViDef.rejectQtyHour01 == null || _flagobjViDef.rejectQtyHour01 == "") ? "0" : _flagobjViDef.rejectQtyHour01);
this.DefectQTY02 = int.Parse((_flagobjViDef.rejectQtyHour02 == null || _flagobjViDef.rejectQtyHour02 == "") ? "0" : _flagobjViDef.rejectQtyHour02);
this.DefectQTY03 = int.Parse((_flagobjViDef.rejectQtyHour03 == null || _flagobjViDef.rejectQtyHour03 == "") ? "0" : _flagobjViDef.rejectQtyHour03);
this.DefectQTY04 = int.Parse((_flagobjViDef.rejectQtyHour04 == null || _flagobjViDef.rejectQtyHour04 == "") ? "0" : _flagobjViDef.rejectQtyHour04);
this.DefectQTY05 = int.Parse((_flagobjViDef.rejectQtyHour05 == null || _flagobjViDef.rejectQtyHour05 == "") ? "0" : _flagobjViDef.rejectQtyHour05);
this.DefectQTY06 = int.Parse((_flagobjViDef.rejectQtyHour06 == null || _flagobjViDef.rejectQtyHour06 == "") ? "0" : _flagobjViDef.rejectQtyHour06);
this.DefectQTY07 = int.Parse((_flagobjViDef.rejectQtyHour07 == null || _flagobjViDef.rejectQtyHour07 == "") ? "0" : _flagobjViDef.rejectQtyHour07);
this.DefectQTY08 = int.Parse((_flagobjViDef.rejectQtyHour08 == null || _flagobjViDef.rejectQtyHour08 == "") ? "0" : _flagobjViDef.rejectQtyHour08);
this.DefectQTY09 = int.Parse((_flagobjViDef.rejectQtyHour09 == null || _flagobjViDef.rejectQtyHour09 == "") ? "0" : _flagobjViDef.rejectQtyHour09);
this.DefectQTY10 = int.Parse((_flagobjViDef.rejectQtyHour10 == null || _flagobjViDef.rejectQtyHour10 == "") ? "0" : _flagobjViDef.rejectQtyHour10);
this.DefectQTY11 = int.Parse((_flagobjViDef.rejectQtyHour11 == null || _flagobjViDef.rejectQtyHour11 == "") ? "0" : _flagobjViDef.rejectQtyHour11);
this.DefectQTY12 = int.Parse((_flagobjViDef.rejectQtyHour12 == null || _flagobjViDef.rejectQtyHour12 == "") ? "0" : _flagobjViDef.rejectQtyHour12);
//this.DefectQTY01 = int.Parse((objViDef.rejectQtyHour01 == null || objViDef.rejectQtyHour01 == "") ? "0" : objViDef.rejectQtyHour01);
//this.DefectQTY02 = int.Parse((objViDef.rejectQtyHour02 == null || objViDef.rejectQtyHour02 == "") ? "0" : objViDef.rejectQtyHour02);
//this.DefectQTY03 = int.Parse((objViDef.rejectQtyHour03 == null || objViDef.rejectQtyHour03 == "") ? "0" : objViDef.rejectQtyHour03);
//this.DefectQTY04 = int.Parse((objViDef.rejectQtyHour04 == null || objViDef.rejectQtyHour04 == "") ? "0" : objViDef.rejectQtyHour04);
//this.DefectQTY05 = int.Parse((objViDef.rejectQtyHour05 == null || objViDef.rejectQtyHour05 == "") ? "0" : objViDef.rejectQtyHour05);
//this.DefectQTY06 = int.Parse((objViDef.rejectQtyHour06 == null || objViDef.rejectQtyHour06 == "") ? "0" : objViDef.rejectQtyHour06);
//this.DefectQTY07 = int.Parse((objViDef.rejectQtyHour07 == null || objViDef.rejectQtyHour07 == "") ? "0" : objViDef.rejectQtyHour07);
//this.DefectQTY08 = int.Parse((objViDef.rejectQtyHour08 == null || objViDef.rejectQtyHour08 == "") ? "0" : objViDef.rejectQtyHour08);
//this.DefectQTY09 = int.Parse((objViDef.rejectQtyHour09 == null || objViDef.rejectQtyHour09 == "") ? "0" : objViDef.rejectQtyHour09);
//this.DefectQTY10 = int.Parse((objViDef.rejectQtyHour10 == null || objViDef.rejectQtyHour10 == "") ? "0" : objViDef.rejectQtyHour10);
//this.DefectQTY11 = int.Parse((objViDef.rejectQtyHour11 == null || objViDef.rejectQtyHour11 == "") ? "0" : objViDef.rejectQtyHour11);
//this.DefectQTY12 = int.Parse((objViDef.rejectQtyHour12 == null || objViDef.rejectQtyHour12 == "") ? "0" : objViDef.rejectQtyHour12);
this.txtDefectQty.Text = _flagobjViDef.rejectQty.ToString();
//this.TotalDefectQTY = int.Parse(_flagobjViDef.rejectQty.ToString());
//this.TotalDefectQTY = int.Parse(objViDef.rejectQty.ToString());
}
catch (Exception ex)
{
throw;
}
return(result);
}
