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