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); } }