public C_ROUTE_DETAIL_RETURN GetDataObject() { C_ROUTE_DETAIL_RETURN DataObject = new C_ROUTE_DETAIL_RETURN(); DataObject.ID = this.ID; DataObject.ROUTE_DETAIL_ID = this.ROUTE_DETAIL_ID; DataObject.RETURN_ROUTE_DETAIL_ID = this.RETURN_ROUTE_DETAIL_ID; return(DataObject); }
public int Add(C_ROUTE_DETAIL_RETURN newdetailreturn, OleExec DB) { string strSql = $@"insert into c_route_detail_return(id,route_detail_id,return_route_detail_id)"; strSql = strSql + $@" values(:id,:route_detail_id,:return_route_detail_id)"; OleDbParameter[] paramet = new OleDbParameter[3]; paramet[0] = new OleDbParameter(":id", newdetailreturn.ID); paramet[1] = new OleDbParameter(":route_detail_id", newdetailreturn.ROUTE_DETAIL_ID); paramet[2] = new OleDbParameter(":return_route_detail_id", newdetailreturn.RETURN_ROUTE_DETAIL_ID); int result = DB.ExecuteNonQuery(strSql, CommandType.Text, paramet); return(result); }