public static DTRecord GetObject(UInt64 refid)
{
DTRecord data = new DTRecord();
DataTable dt = DTRecord.QueryDataByRefID(refid);
if (dt == null || dt.Rows.Count == 0)
{
return(null);
}
else
{
data.refid = Convert.ToUInt64(dt.Rows[0]["refid"]);
data.PDate = Convert.ToDateTime(dt.Rows[0]["PDate"].ToString());
data.LineID = dt.Rows[0]["LineID"].ToString();
data.DeviceID = dt.Rows[0]["DeviceID"].ToString();
data.IsDown = dt.Rows[0]["IsDown"].ToString();
data.Shift = dt.Rows[0]["Shift"].ToString();
data.Model = dt.Rows[0]["Model"].ToString();
if (dt.Rows[0]["Start_time"] != System.DBNull.Value)
{
data.Start_time = Convert.ToDateTime(dt.Rows[0]["Start_time"].ToString());
}
if (dt.Rows[0]["End_time"] != System.DBNull.Value)
{
data.End_time = Convert.ToDateTime(dt.Rows[0]["End_time"].ToString());
}
data.Duration = Convert.ToInt32(dt.Rows[0]["Duration"].ToString());
data.Category = dt.Rows[0]["Category"].ToString();
data.Lev1 = dt.Rows[0]["Lev1"].ToString();
data.Lev2 = dt.Rows[0]["Lev2"].ToString();
data.Brand = dt.Rows[0]["Brand"].ToString();
data.CBrand = dt.Rows[0]["CBrand"].ToString();
data.Ctype = dt.Rows[0]["Ctype"].ToString();
data.stand_time = dt.Rows[0]["stand_time"].ToString();
data.Reason = dt.Rows[0]["Reason"].ToString();
data.Memo = dt.Rows[0]["Memo"].ToString();
data.status = dt.Rows[0]["status"].ToString();
data.create_by = dt.Rows[0]["create_by"].ToString();
data.update_by = dt.Rows[0]["update_by"].ToString();
DateTime time;
if (dt.Rows[0]["create_time"] != System.DBNull.Value)
{
if (DateTime.TryParse(dt.Rows[0]["create_time"].ToString(), out time))
{
data.create_time = time;
}
}
else
{
data.create_time = null;
}
return(data);
}
}
