/// <summary>
/// 分页获取数据列表
/// </summary>
//public DataSet GetList(int PageSize,int PageIndex,string strWhere)
//{
//return dal.GetList(PageSize,PageIndex,strWhere);
//}
/// <summary>
/// 获得前几行数据
/// </summary>
public Common.Model.MouldingViDefectTracking_Model CopyObj(Common.Model.MouldingViDefectTracking_Model objModel)
{
Common.Model.MouldingViDefectTracking_Model model;
model = new Common.Model.MouldingViDefectTracking_Model();
model.id = objModel.id;
model.trackingID = objModel.trackingID;
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.userName = objModel.userName;
model.userID = objModel.userID;
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.defectCodeID = objModel.defectCodeID;
model.defectCode = objModel.defectCode;
model.rejectQty = objModel.rejectQty;
model.rejectQtyHour01 = objModel.rejectQtyHour01;
model.rejectQtyHour02 = objModel.rejectQtyHour02;
model.rejectQtyHour03 = objModel.rejectQtyHour03;
model.rejectQtyHour04 = objModel.rejectQtyHour04;
model.rejectQtyHour05 = objModel.rejectQtyHour05;
model.rejectQtyHour06 = objModel.rejectQtyHour06;
model.rejectQtyHour07 = objModel.rejectQtyHour07;
model.rejectQtyHour08 = objModel.rejectQtyHour08;
model.rejectQtyHour09 = objModel.rejectQtyHour09;
model.rejectQtyHour10 = objModel.rejectQtyHour10;
model.rejectQtyHour11 = objModel.rejectQtyHour11;
model.rejectQtyHour12 = objModel.rejectQtyHour12;
model.lastUpdatedTime = objModel.lastUpdatedTime;
model.remarks = objModel.remarks;
model.QCNGQTY = objModel.QCNGQTY;
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;
return(model);
}
public SqlCommand UpdateCommandbypartNubmer(Common.Model.MouldingViDefectTracking_Model model, string sPartNumber)
{
return(dal.UpdateCommandbypartNubmer(model, sPartNumber));
}
/// <summary>
/// 更新一条数据
/// </summary>
public SqlCommand UpdateCommand(Common.Model.MouldingViDefectTracking_Model model)
{
return(dal.UpdateCommand(model));
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(Common.Model.MouldingViDefectTracking_Model model)
{
return(dal.Update(model));
}
/// <summary>
/// 增加一条数据
/// </summary>
public void Add(Common.Model.MouldingViDefectTracking_Model model)
{
dal.Add(model);
}
/// <summary>
/// 获得数据列表
/// </summary>
public List <Common.Model.MouldingViDefectTracking_Model> DataTableToList(DataTable dt)
{
List <Common.Model.MouldingViDefectTracking_Model> modelList = new List <Common.Model.MouldingViDefectTracking_Model>();
int rowsCount = dt.Rows.Count;
if (rowsCount > 0)
{
Common.Model.MouldingViDefectTracking_Model model;
for (int n = 0; n < rowsCount; n++)
{
model = new Common.Model.MouldingViDefectTracking_Model();
if (dt.Rows[n]["id"].ToString() != "")
{
model.id = int.Parse(dt.Rows[n]["id"].ToString());
}
model.trackingID = dt.Rows[n]["trackingID"].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());
}
model.userName = dt.Rows[n]["userName"].ToString();
model.userID = dt.Rows[n]["userID"].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.defectCodeID = dt.Rows[n]["defectCodeID"].ToString();
model.defectCode = dt.Rows[n]["defectCode"].ToString();
if (dt.Rows[n]["rejectQty"].ToString() != "")
{
model.rejectQty = decimal.Parse(dt.Rows[n]["rejectQty"].ToString());
}
model.rejectQtyHour01 = dt.Rows[n]["rejectQtyHour01"].ToString();
model.rejectQtyHour02 = dt.Rows[n]["rejectQtyHour02"].ToString();
model.rejectQtyHour03 = dt.Rows[n]["rejectQtyHour03"].ToString();
model.rejectQtyHour04 = dt.Rows[n]["rejectQtyHour04"].ToString();
model.rejectQtyHour05 = dt.Rows[n]["rejectQtyHour05"].ToString();
model.rejectQtyHour06 = dt.Rows[n]["rejectQtyHour06"].ToString();
model.rejectQtyHour07 = dt.Rows[n]["rejectQtyHour07"].ToString();
model.rejectQtyHour08 = dt.Rows[n]["rejectQtyHour08"].ToString();
model.rejectQtyHour09 = dt.Rows[n]["rejectQtyHour09"].ToString();
model.rejectQtyHour10 = dt.Rows[n]["rejectQtyHour10"].ToString();
model.rejectQtyHour11 = dt.Rows[n]["rejectQtyHour11"].ToString();
model.rejectQtyHour12 = dt.Rows[n]["rejectQtyHour12"].ToString();
if (dt.Rows[n]["lastUpdatedTime"].ToString() != "")
{
model.lastUpdatedTime = DateTime.Parse(dt.Rows[n]["lastUpdatedTime"].ToString());
}
model.remarks = dt.Rows[n]["remarks"].ToString();
if (dt.Rows[n]["QCNGQTY"].ToString() != "")
{
model.QCNGQTY = decimal.Parse(dt.Rows[n]["QCNGQTY"].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();
modelList.Add(model);
}
}
return(modelList);
}