public SqlCommand UpdateCommandbyTrackingID(Common.Model.MouldingViTracking_Model model)
{
return(dal.UpdateCommandbyTrackingID(model));
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(Common.Model.MouldingViTracking_Model model)
{
return(dal.Update(model));
}
public SqlCommand UpdateCommandbypartnumber(Common.Model.MouldingViTracking_Model model)
{
return(dal.UpdateCommandbypartnumber(model));
}
/// <summary>
/// 增加一条数据
/// </summary>
public SqlCommand AddCommand(Common.Model.MouldingViTracking_Model model)
{
return(dal.AddCommand(model));
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(Common.Model.MouldingViTracking_Model model)
{
return(dal.Add(model));
}
/// <summary>
/// 分页获取数据列表
/// </summary>
//public DataSet GetList(int PageSize,int PageIndex,string strWhere)
//{
//return dal.GetList(PageSize,PageIndex,strWhere);
//}
/// <summary>
/// 获得前几行数据
/// </summary>
public Common.Model.MouldingViTracking_Model CopyObj(Common.Model.MouldingViTracking_Model objModel)
{
Common.Model.MouldingViTracking_Model model;
model = new Common.Model.MouldingViTracking_Model();
model.id = objModel.id;
model.machineID = objModel.machineID;
model.dateTime = objModel.dateTime;
model.partNumber = objModel.partNumber;
model.jigNo = objModel.jigNo;
model.model = objModel.model;
model.cavityCount = objModel.cavityCount;
model.partsWeight = objModel.partsWeight;
model.cycleTime = objModel.cycleTime;
model.targetQty = objModel.targetQty;
model.userName = objModel.userName;
model.userID = objModel.userID;
model.acountReading = objModel.acountReading;
model.rejectQty = objModel.rejectQty;
model.QCNGQTY = objModel.QCNGQTY;
model.acceptQty = objModel.acceptQty;
model.startTime = objModel.startTime;
model.stopTime = objModel.stopTime;
model.day = objModel.day;
model.shift = objModel.shift;
model.status = objModel.status;
model.matPart01 = objModel.matPart01;
model.matPart02 = objModel.matPart02;
model.matLot01 = objModel.matLot01;
model.matLot02 = objModel.matLot02;
model.opSign01 = objModel.opSign01;
model.opSign02 = objModel.opSign02;
model.opSign03 = objModel.opSign03;
model.opSign04 = objModel.opSign04;
model.opSign05 = objModel.opSign05;
model.opSign06 = objModel.opSign06;
model.opSign07 = objModel.opSign07;
model.opSign08 = objModel.opSign08;
model.opSign09 = objModel.opSign09;
model.opSign10 = objModel.opSign10;
model.opSign11 = objModel.opSign11;
model.opSign12 = objModel.opSign12;
model.qaSign01 = objModel.qaSign01;
model.qaSign02 = objModel.qaSign02;
model.qaSign03 = objModel.qaSign03;
model.qaSign04 = objModel.qaSign04;
model.qaSign05 = objModel.qaSign05;
model.qaSign06 = objModel.qaSign06;
model.qaSign07 = objModel.qaSign07;
model.qaSign08 = objModel.qaSign08;
model.qaSign09 = objModel.qaSign09;
model.qaSign10 = objModel.qaSign10;
model.qaSign11 = objModel.qaSign11;
model.qaSign12 = objModel.qaSign12;
model.customer = objModel.customer;
model.lastUpdatedTime = objModel.lastUpdatedTime;
model.trackingID = objModel.trackingID;
model.remarks = objModel.remarks;
model.Material_LeaderCheck = objModel.Material_LeaderCheck;
model.Material_LeaderCheckTime = objModel.Material_LeaderCheckTime;
model.Material_MHCheck = objModel.Material_MHCheck;
model.Material_MHCheckTime = objModel.Material_MHCheckTime;
model.Material_Opcheck = objModel.Material_Opcheck;
model.Material_OpCheckTime = objModel.Material_OpCheckTime;
model.LeaderCheck = objModel.LeaderCheck;
model.LeaderCheckTime = objModel.LeaderCheckTime;
model.SupervisorCheck = objModel.SupervisorCheck;
model.SupervisorCheckTime = objModel.SupervisorCheckTime;
model.partnumberall = objModel.partnumberall;
model.parts2Weight = objModel.parts2Weight;
model.lastQty = objModel.lastQty;
model.OkAccumulation = objModel.OkAccumulation;
return(model);
}
/// <summary>
/// 获得数据列表
/// </summary>
public List <Common.Model.MouldingViTracking_Model> DataTableToList(DataTable dt)
{
List <Common.Model.MouldingViTracking_Model> modelList = new List <Common.Model.MouldingViTracking_Model>();
int rowsCount = dt.Rows.Count;
if (rowsCount > 0)
{
Common.Model.MouldingViTracking_Model model;
for (int n = 0; n < rowsCount; n++)
{
model = new Common.Model.MouldingViTracking_Model();
if (dt.Rows[n]["id"].ToString() != "")
{
model.id = int.Parse(dt.Rows[n]["id"].ToString());
}
model.machineID = dt.Rows[n]["machineID"].ToString();
if (dt.Rows[n]["dateTime"].ToString() != "")
{
model.dateTime = DateTime.Parse(dt.Rows[n]["dateTime"].ToString());
}
model.partNumber = dt.Rows[n]["partNumber"].ToString();
model.jigNo = dt.Rows[n]["jigNo"].ToString();
model.model = dt.Rows[n]["model"].ToString();
if (dt.Rows[n]["cavityCount"].ToString() != "")
{
model.cavityCount = decimal.Parse(dt.Rows[n]["cavityCount"].ToString());
}
if (dt.Rows[n]["partsWeight"].ToString() != "")
{
model.partsWeight = decimal.Parse(dt.Rows[n]["partsWeight"].ToString());
}
if (dt.Rows[n]["cycleTime"].ToString() != "")
{
model.cycleTime = decimal.Parse(dt.Rows[n]["cycleTime"].ToString());
}
if (dt.Rows[n]["targetQty"].ToString() != "")
{
model.targetQty = decimal.Parse(dt.Rows[n]["targetQty"].ToString());
}
model.userName = dt.Rows[n]["userName"].ToString();
model.userID = dt.Rows[n]["userID"].ToString();
if (dt.Rows[n]["acountReading"].ToString() != "")
{
model.acountReading = decimal.Parse(dt.Rows[n]["acountReading"].ToString());
}
if (dt.Rows[n]["rejectQty"].ToString() != "")
{
model.rejectQty = decimal.Parse(dt.Rows[n]["rejectQty"].ToString());
}
if (dt.Rows[n]["QCNGQTY"].ToString() != "")
{
model.QCNGQTY = decimal.Parse(dt.Rows[n]["QCNGQTY"].ToString());
}
if (dt.Rows[n]["acceptQty"].ToString() != "")
{
model.acceptQty = decimal.Parse(dt.Rows[n]["acceptQty"].ToString());
}
if (dt.Rows[n]["startTime"].ToString() != "")
{
model.startTime = DateTime.Parse(dt.Rows[n]["startTime"].ToString());
}
if (dt.Rows[n]["stopTime"].ToString() != "")
{
model.stopTime = DateTime.Parse(dt.Rows[n]["stopTime"].ToString());
}
if (dt.Rows[n]["day"].ToString() != "")
{
model.day = DateTime.Parse(dt.Rows[n]["day"].ToString());
}
model.shift = dt.Rows[n]["shift"].ToString();
model.status = dt.Rows[n]["status"].ToString();
model.matPart01 = dt.Rows[n]["matPart01"].ToString();
model.matPart02 = dt.Rows[n]["matPart02"].ToString();
model.matLot01 = dt.Rows[n]["matLot01"].ToString();
model.matLot02 = dt.Rows[n]["matLot02"].ToString();
model.opSign01 = dt.Rows[n]["opSign01"].ToString();
model.opSign02 = dt.Rows[n]["opSign02"].ToString();
model.opSign03 = dt.Rows[n]["opSign03"].ToString();
model.opSign04 = dt.Rows[n]["opSign04"].ToString();
model.opSign05 = dt.Rows[n]["opSign05"].ToString();
model.opSign06 = dt.Rows[n]["opSign06"].ToString();
model.opSign07 = dt.Rows[n]["opSign07"].ToString();
model.opSign08 = dt.Rows[n]["opSign08"].ToString();
model.opSign09 = dt.Rows[n]["opSign09"].ToString();
model.opSign10 = dt.Rows[n]["opSign10"].ToString();
model.opSign11 = dt.Rows[n]["opSign11"].ToString();
model.opSign12 = dt.Rows[n]["opSign12"].ToString();
model.qaSign01 = dt.Rows[n]["qaSign01"].ToString();
model.qaSign02 = dt.Rows[n]["qaSign02"].ToString();
model.qaSign03 = dt.Rows[n]["qaSign03"].ToString();
model.qaSign04 = dt.Rows[n]["qaSign04"].ToString();
model.qaSign05 = dt.Rows[n]["qaSign05"].ToString();
model.qaSign06 = dt.Rows[n]["qaSign06"].ToString();
model.qaSign07 = dt.Rows[n]["qaSign07"].ToString();
model.qaSign08 = dt.Rows[n]["qaSign08"].ToString();
model.qaSign09 = dt.Rows[n]["qaSign09"].ToString();
model.qaSign10 = dt.Rows[n]["qaSign10"].ToString();
model.qaSign11 = dt.Rows[n]["qaSign11"].ToString();
model.qaSign12 = dt.Rows[n]["qaSign12"].ToString();
model.customer = dt.Rows[n]["customer"].ToString();
if (dt.Rows[n]["lastUpdatedTime"].ToString() != "")
{
model.lastUpdatedTime = DateTime.Parse(dt.Rows[n]["lastUpdatedTime"].ToString());
}
model.trackingID = dt.Rows[n]["trackingID"].ToString();
model.remarks = dt.Rows[n]["remarks"].ToString();
model.Material_MHCheck = dt.Rows[n]["Material_MHCheck"].ToString();
if (dt.Rows[n]["Material_MHCheckTime"].ToString() != "")
{
model.Material_MHCheckTime = DateTime.Parse(dt.Rows[n]["Material_MHCheckTime"].ToString());
}
model.Material_Opcheck = dt.Rows[n]["Material_Opcheck"].ToString();
if (dt.Rows[n]["Material_OpCheckTime"].ToString() != "")
{
model.Material_OpCheckTime = DateTime.Parse(dt.Rows[n]["Material_OpCheckTime"].ToString());
}
model.Material_LeaderCheck = dt.Rows[n]["Material_LeaderCheck"].ToString();
if (dt.Rows[n]["Material_LeaderCheckTime"].ToString() != "")
{
model.Material_LeaderCheckTime = DateTime.Parse(dt.Rows[n]["Material_LeaderCheckTime"].ToString());
}
model.LeaderCheck = dt.Rows[n]["LeaderCheck"].ToString();
if (dt.Rows[n]["LeaderCheckTime"].ToString() != "")
{
model.LeaderCheckTime = DateTime.Parse(dt.Rows[n]["LeaderCheckTime"].ToString());
}
model.SupervisorCheck = dt.Rows[n]["SupervisorCheck"].ToString();
if (dt.Rows[n]["SupervisorCheckTime"].ToString() != "")
{
model.SupervisorCheckTime = DateTime.Parse(dt.Rows[n]["SupervisorCheckTime"].ToString());
}
model.partnumberall = dt.Rows[n]["partNumberAll"].ToString();
if (dt.Rows[n]["parts2Weight"].ToString() != "")
{
model.parts2Weight = decimal.Parse(dt.Rows[n]["parts2Weight"].ToString());
}
if (dt.Rows[n]["lastQty"].ToString() != "")
{
model.lastQty = decimal.Parse(dt.Rows[n]["lastQty"].ToString());
}
model.OkAccumulation = dt.Rows[n]["OkAccumulation"].ToString();
modelList.Add(model);
}
}
return(modelList);
}
public SqlCommand UpdatebyDayMachineShifPartNumberAll(Common.Model.MouldingViTracking_Model model)
{
return(dal.UpdatebyDayMachineShifPartNumberAll(model));
}