public C_PACKING GetDataObject()
{
C_PACKING DataObject = new C_PACKING();
DataObject.ID = this.ID;
DataObject.SKUNO = this.SKUNO;
DataObject.PACK_TYPE = this.PACK_TYPE;
DataObject.TRANSPORT_TYPE = this.TRANSPORT_TYPE;
DataObject.INSIDE_PACK_TYPE = this.INSIDE_PACK_TYPE;
DataObject.MAX_QTY = this.MAX_QTY;
DataObject.DESCRIPTION = this.DESCRIPTION;
DataObject.EDIT_TIME = this.EDIT_TIME;
DataObject.EDIT_EMP = this.EDIT_EMP;
DataObject.SN_RULE = this.SN_RULE;
return(DataObject);
}
public C_PACKING GetPackingBySkuAndType(string SkuNo, string PackType, OleExec DB)
{
string sql = string.Empty;
DataTable dt = new DataTable();
C_PACKING Packing = new C_PACKING();
if (DBType.Equals(DB_TYPE_ENUM.Oracle))
{
sql = $@"SELECT * FROM C_PACKING WHERE SKUNO='{SkuNo}' AND PACK_TYPE='{PackType}' AND ROWNUM=1";
dt = DB.ExecSelect(sql).Tables[0];
Row_C_PACKING row = (Row_C_PACKING)NewRow();
if (dt.Rows.Count > 0)
{
row.loadData(dt.Rows[0]);
Packing = row.GetDataObject();
}
}
return(Packing);
}