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