public OsPayOffNoteData SelectPayOffNote(DateTime reportDate, string officeCode, string itemCode)
{
SqlHandling sh = new SqlHandling("D_OsPayOffNote");
DataTable dt = sh.SelectAllData("WHERE OfficeCode = '" + officeCode + "' AND ItemCode = '" + itemCode + "' AND ReportDate = '" + reportDate + "'");
if (dt == null || dt.Rows.Count < 1)
{
return(null);
}
OsPayOffNoteData pod = new OsPayOffNoteData(dt.Rows[0]);
return(pod);
}
//--------------------------------------------------------//
// Method
//--------------------------------------------------------//
public object Clone()
{
OsPayOffNoteData cloneData = new OsPayOffNoteData();
cloneData.OsPayOffNoteID = this.OsPayOffNoteID;
cloneData.ReportDate = this.ReportDate;
cloneData.OfficeCode = this.OfficeCode;
cloneData.Department = this.Department;
cloneData.ItemCode = this.ItemCode;
cloneData.Note = this.Note;
return(cloneData);
}