public new bool Find(String ImageID)
{
this.ID = 0;
if (CompanyID == "" || CustomerID == "")
{
return(false);
}
DataRow Row = this.oMySql.GetDataRow("Select * From OrderScannedDetail Where ImageID='" + ImageID + "'", "scanned");
if (Row == null)
{
this.ID = 0;
return(false);
}
ID = (int)Row["ImageID"];
CompanyID = Row["CompanyID"].ToString();
CustomerID = Row["CustomerID"].ToString();
Teacher = Row["Teacher"].ToString();
ImagePath = Row["ImagePath"].ToString();
Status = Global.ToEnum <ScannedOrderStatus>((int)Row["Status"]);
OrderID = (Int32)Row["OrderID"];
return(true);
}
public void Load(String CompanyID, String CustomerID, String Teacher, ScannedOrderStatus Status)
{
this.Clear();
this.Index = -1;
this.CompanyID = CompanyID;
this.CustomerID = CustomerID;
this.Teacher = Teacher;
DataTable table;
if (Teacher != "")
{
table = oMySql.GetDataTable(String.Format("Select * From OrderScannedDetail Where CompanyID='{0}' And CustomerID='{1}' And Teacher=\"{2}\" And Status='{3}'", CompanyID, CustomerID, Teacher, (int)Status));
}
else
{
table = oMySql.GetDataTable(String.Format("Select * From OrderScannedDetail Where CompanyID='{0}' And CustomerID='{1}' And Status='{2}'", CompanyID, CustomerID, (int)Status));
}
if (table == null)
{
return;
}
foreach (DataRow row in table.Rows)
{
ScannedImage _Image = new ScannedImage();
_Image.CompanyID = CompanyID;
_Image.CustomerID = CustomerID;
_Image.Date = (DateTime)row["Date"];
_Image.Teacher = row["Teacher"].ToString();
_Image.ImagePath = row["ImagePath"].ToString();
_Image.ID = (Int32)row["ImageID"];
_Image.Status = Global.ToEnum <ScannedOrderStatus>((int)row["Status"]);
_Image.OrderID = (Int32)row["OrderID"];
this.Add(row["ImageID"].ToString(), _Image);
}
}
public void Load(ScannedOrderStatus Status)
{
Load(this.CompanyID, this.CustomerID, this.Teacher, Status);
}
public void LoadImages(ScannedOrderStatus Status)
{
this.Images.Load(this.CompanyID, this.CustomerID, this.Name, Status);
}
